Hi Jay,
The files are in a google drive. The link is on ticket 350.
-----Original Message-----
From: Gpc-dev [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Wednesday, January 18, 2017 3:33 PM
To: [email protected]
Subject: Gpc-dev Digest, Vol 35, Issue 38
Send Gpc-dev mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific than "Re:
Contents of Gpc-dev digest..."
Today's Topics:
1. UNMC -- wondering about geocoding information data source
(Pedersen, Jay G)
2. Re: Gpc-dev Digest, Vol 35, Issue 37 (Pedersen, Jay G)
----------------------------------------------------------------------
Message: 1
Date: Wed, 18 Jan 2017 21:25:53 +0000
From: "Pedersen, Jay G" <[email protected]>
To: "[email protected]" <[email protected]>
Subject: UNMC -- wondering about geocoding information data source
Message-ID:
<by1pr0501mb1351a43cd3909f5eaeb502d4f7...@by1pr0501mb1351.namprd05.prod.outlook.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi,
Can anyone explain where the geocoding data that has been used in the GPC for
various projects is obtained from? If there is information in a ticket, that
would be all I would need.
Jay Pedersen, M.A.
Department of Pathology/Microbiology
University of Nebraska Medical Center
985900 Nebraska Medical Center
Omaha NE 68198-5900
402-559-9487<tel:402-559-9593> (office)
402-739-3496<tel:402-350-7851> (mobile)
The information in this e-mail may be privileged and confidential, intended
only for the use of the addressee(s) above. Any unauthorized use or disclosure
of this information is prohibited. If you have received this e-mail by mistake,
please delete it and immediately contact the sender.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://listserv.kumc.edu/pipermail/gpc-dev/attachments/20170118/43750f72/attachment-0001.html>
------------------------------
Message: 2
Date: Wed, 18 Jan 2017 21:33:06 +0000
From: "Pedersen, Jay G" <[email protected]>
To: "[email protected]" <[email protected]>
Subject: Re: Gpc-dev Digest, Vol 35, Issue 37
Message-ID:
<by1pr0501mb135112bc5e91d6ccc26523b7f7...@by1pr0501mb1351.namprd05.prod.outlook.com>
Content-Type: text/plain; charset="us-ascii"
I have found that watching the JBOSS log file is useful to help debug client
messages like "ERROR: ERROR" or "Database error".
In our case, the log file is on the CENTOS machine that the i2b2 Java code runs
on in the following location:
/var/log/jboss-as/server.log
tail -f /var/log/jboss-as/server.log
I have seen the failing SQL displayed in the output on multiple occasions.
Jay Pedersen, M.A.
Department of Pathology/Microbiology
UNMC
________________________________
From: Gpc-dev <[email protected]> on behalf of
[email protected] <[email protected]>
Sent: Wednesday, January 18, 2017 3:02:42 PM
To: [email protected]
Subject: Gpc-dev Digest, Vol 35, Issue 37
Send Gpc-dev mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific than "Re:
Contents of Gpc-dev digest..."
Today's Topics:
1. How to debug i2b2 queries that fail due to missing concepts
(Nathan Graham)
----------------------------------------------------------------------
Message: 1
Date: Wed, 18 Jan 2017 21:02:37 +0000
From: Nathan Graham <[email protected]>
To: "'[email protected]'" <[email protected]>
Subject: How to debug i2b2 queries that fail due to missing concepts
Message-ID:
<[email protected]>
Content-Type: text/plain; charset="us-ascii"
All,
We have noticed that sometimes after our monthly i2b2 refresh past user queries
don't run anymore - instead, the webclient displays "ERROR: ERROR". Sometimes
(but not always) this error message is because concepts that used to be in the
concept dimension are now missing. At KUMC, our monthly refresh can change
parts of the concept hierarchy from month to month.
During the Hackathon, Eric Larose showed me that you can see which concepts
were missing in a particular query by looking in the QT tables - see below (I
verified with him that it's ok to forward to GPC-dev).
Thanks Eric!
--
Nathan
From: Larose, Eric R [mailto:[email protected]]
Sent: Wednesday, January 18, 2017 8:26 AM
To: Nathan Graham
Subject: Missing concept codes in QT tables
Importance: High
Let me know if this isn't what you were talking about last night. This is what
I ran into when I restructured some of our ontology paths.
SELECT TOP 1000 [RESULT_INSTANCE_ID]
,[QUERY_INSTANCE_ID]
,[RESULT_TYPE_ID]
,[SET_SIZE]
,[START_DATE]
,[END_DATE]
,[STATUS_TYPE_ID]
,[delete_flag]
,[message] -- Contains Text when concept is missing from the ontology
,[description]
,[REAL_SET_SIZE]
,[OBFUSC_METHOD]
FROM [vdw_i2b2data_2].[dbo].[QT_QUERY_RESULT_INSTANCE]
WHERE DATALENGTH(message) <> 0 -- This is a text datatype and not varchar so
I can't just compare to <> ''
EXAMPLE VALUE:
Missing Concept in Ontology Cell :
[\\i2b2\i2b2\LP29693-6\LP29697-7\LP71800-4\54050-0\54051-8\24321-2\2160-0\<file://\\i2b2\i2b2\LP29693-6\LP29697-7\LP71800-4\54050-0\54051-8\24321-2\2160-0\>]
panel#-1
[<file://>\\i2b2\i2b2\Cohort\Phenotype\T2 Diabetes\] panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A12973319\A8340125\A8358103\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A12973319\A8340125\A8358103\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A12973319\A8341296\443.9\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A12973319\A8341296\443.9\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\430\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\430\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\431\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\431\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345436\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345436\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345439\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A835
2249\A8345439\>] panel#-1 [<file://>\\i2b2\i2b2\Demographics\Age
Static\60-69\65\] panel#-1 [<file://>\\i2b2\i2b2\Demographics\Age
Static\60-69\66\] panel#-1 [<file://>\\i2b2\i2b2\Demographics\Age
Static\60-69\67\] panel#-1 [<file://>\\i2b2\i2b2\Demographics\Age
Static\60-69\68\] panel#-1 [<file://>\\i2b2\i2b2\Demographics\Age
Static\60-69\69\] panel#-1 [<file://>\\i2b2\i2b2\Demographics\Age
Static\70-79\] panel#-1 [<file://>\\i2b2\i2b2\Demographics\Age Static\80-89\]
panel#-1 [<file://>\\i2b2\i2b2\Demographics\Age Static\>89\] panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340910\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340910\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340911\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340911\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8359116\<file://\\
i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8359116\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340912\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340912\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340913\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340913\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340914\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340914\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340915\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340915\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340916\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8340916\>]
panel#-1 [\\i2b2\i2b2\Diagn
oses\A18090800\A8359006\A8359307\A15573936\A8352361\A8343926\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8343926\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8343927\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359307\A15573936\A8352361\A8343927\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8341282\A8352272\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8341282\A8352272\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8341282\A8352270\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8341282\A8352270\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8341282\A8358497\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8341282\A8358497\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8341283\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A835
2249\A8341283\>] panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\436\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\436\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.0\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.0\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.1\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.1\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.3\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.3\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.4\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.4\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.5\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\
A8345446\437.5\>] panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.6\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.6\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.7\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.7\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.8\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.8\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.9\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345446\437.9\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345450\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352249\A8345450\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8360933\A8339687\A8377811\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A835
9014\A8360933\A8339687\A8377811\>] panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8360933\A8339687\A8377603\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8360933\A8339687\A8377603\>]
panel#-1 [<file://>\\i2b2\i2b2\Vital Signs\TOBACCO\SMOKING\YES\] panel#-1
[<file://>\\i2b2\i2b2\Demographics\Age Static\0-9\] panel#-1
[<file://>\\i2b2\i2b2\Demographics\Age Static\10-19\10\] panel#-1
[<file://>\\i2b2\i2b2\Demographics\Age Static\10-19\11\] panel#-1
[<file://>\\i2b2\i2b2\Demographics\Age Static\10-19\12\] panel#-1
[<file://>\\i2b2\i2b2\Demographics\Age Static\10-19\13\] panel#-1
[<file://>\\i2b2\i2b2\Demographics\Age Static\10-19\14\] panel#-1
[<file://>\\i2b2\i2b2\Demographics\Age Static\10-19\15\] panel#-1
[<file://>\\i2b2\i2b2\Demographics\Age Static\10-19\16\] panel#-1
[<file://>\\i2b2\i2b2\Demographics\Age Static\10-19\17\] panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A8360925\A8352460\578.9\<file://\\i2b2\i2b2\Diagnoses\A180908
00\A8359006\A8354356\A8360925\A8352460\578.9\>] panel#-1
[<file://>\\i2b2\i2b2\Demographics\Vital Status\Deceased\] panel#-1
[\\i2b2\i2b2\3149154\3257551\3257552\1579227\<file://\\i2b2\i2b2\3149154\3257551\3257552\1579227\>]
panel#-1
[\\i2b2\i2b2\3149154\3257551\3257552\1579228\<file://\\i2b2\i2b2\3149154\3257551\3257552\1579228\>]
panel#-1
[\\i2b2\i2b2\3149154\3257551\3257552\3502247\<file://\\i2b2\i2b2\3149154\3257551\3257552\3502247\>]
panel#-1
[\\i2b2\i2b2\3149154\3257551\3257552\3744385\<file://\\i2b2\i2b2\3149154\3257551\3257552\3744385\>]
panel#-1
[\\i2b2\i2b2\3149154\3257551\3257552\5042890\<file://\\i2b2\i2b2\3149154\3257551\3257552\5042890\>]
panel#-1
[\\i2b2\i2b2\3149154\3257551\3257555\3749712\<file://\\i2b2\i2b2\3149154\3257551\3257555\3749712\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8339819\A8345671\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8339819\A8345671\>]
panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800
\A8359006\A8354356\A19384330\A8339819\A8345677\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8339819\A8345677\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8339819\A8345683\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8339819\A8345683\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8339819\A8345689\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8339819\A8345689\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8352379\A8345696\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8352379\A8345696\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8352379\A8345702\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8352379\A8345702\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8352379\A8345708\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A1
9384330\A8352379\A8345708\>] panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8352379\A8345714\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8352379\A8345714\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.0\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.0\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.1\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.1\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.2\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.2\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.3\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.3\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.4\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.4\>]
panel#-1 [\\i2b2\i2b2\Diagnos
es\A18090800\A8359006\A8359013\A8341002\A19383974\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\A19383974\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.6\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.6\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.7\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.7\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.9\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359013\A8341002\286.9\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8362390\A8345721\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8362390\A8345721\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8362390\A8345727\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8362390\A8345727\>]
panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A83
54356\A19384330\A8362390\A8345733\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8362390\A8345733\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8362390\A8345739\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8362390\A8345739\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345746\A8345747\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345746\A8345747\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345746\A8345753\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345746\A8345753\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345746\A8345759\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345746\A8345759\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345746\A8345765\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8345
746\A8345765\>] panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8341434\530.7\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8341434\530.7\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8359020\A8341316\456.0\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8359020\A8341316\456.0\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8359020\A8341316\A8345503\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8359020\A8341316\A8345503\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8341434\A8341440\530.82\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A19384330\A8341434\A8341440\530.82\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A8360926\A8345881\569.3\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A8360926\A8345881\569.3\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A8360925\A8352460\578.0\<file://\\i2b2\i
2b2\Diagnoses\A18090800\A8359006\A8354356\A8360925\A8352460\578.0\>] panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A8360925\A8352460\578.9\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8354356\A8360925\A8352460\578.9\>]
panel#-1
[\\i2b2\i2b2\Allergies\Aspirin\<file://\\i2b2\i2b2\Allergies\Aspirin\>]
panel#-1 [<file://>\\i2b2\i2b2\Visit Details\Other Details\Pregnant\] panel#-1
[\\i2b2\i2b2\3149154\3257551\3257555\2979279\855812\<file://\\i2b2\i2b2\3149154\3257551\3257555\2979279\855812\>]
panel#-1
[\\i2b2\i2b2\3149154\3257551\3257555\2979279\855818\<file://\\i2b2\i2b2\3149154\3257551\3257555\2979279\855818\>]
panel#-1
[\\i2b2\i2b2\3149154\3257551\3257555\2979279\<file://\\i2b2\i2b2\3149154\3257551\3257555\2979279\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A18090759\A8362297\A8365778\A8378078\V45.82\<file://\\i2b2\i2b2\Diagnoses\A18090800\A18090759\A8362297\A8365778\A8378078\V45.82\>]
panel#-1 [\\i2b2\i2b2\Diagnoses\A18090800\A18090759\A8362297\A8365778\A8
378078\V45.81\<file://\\i2b2\i2b2\Diagnoses\A18090800\A18090759\A8362297\A8365778\A8378078\V45.81\>]
panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352547\A8345341\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352547\A8345341\>]
panel#-1 [<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92920)\]
panel#-1 [<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92921)\]
panel#-1 [<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92924)Prq
Trluml Coronary Angio/Atherect One Art/Brnch\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92925)Prq Trluml
Coronary Angio/Atherec Addl Art/Brnch\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92928)\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92929)\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92933)\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92934)\] panel#-1
[<file://>\\i2b2\i2b2\Pr
ocedures\Medicine (90281-99199)\(92937)\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92938)\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92941)\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92943)\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92944)\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92980)Tcat Plmt
Intracoronary Stent Prq 1 Vessel\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92981)Tcat Plmt
Intracoronary Stent Prq Ea Vessel\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92982)Prq Trluml
Coronary Balloon Angioplasty 1 Vsl\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92984)Prq Trluml
Coronary Balloon Angioplasty Ea Vsl\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medicine (90281-99199)\(92995)Prq Trluml Coron
Atherect W/Wo Angiop 1 Vessel\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Medici
ne (90281-99199)\(92996)Prq Trluml Coron Atherect W/Wo Angiop Ea Vessel\]
panel#-1
[\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9600\<file://\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9600\>]
panel#-1
[\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9601\<file://\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9601\>]
panel#-1
[\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9602\<file://\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9602\>]
panel#-1
[\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9603\<file://\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9603\>]
panel#-1
[\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9604\<file://\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9604\>]
panel#-1
[\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9605\<file://\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9605\>]
panel#-1 [\\i2b2\i2b2\Procedures\C
PT\A13475665\A13296622\A17274387\C9606\<file://\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9606\>]
panel#-1
[\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9607\<file://\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9607\>]
panel#-1
[\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9608\<file://\\i2b2\i2b2\Procedures\CPT\A13475665\A13296622\A17274387\C9608\>]
panel#-1
[\\i2b2\i2b2\Procedures\CPT\A13475665\A13299386\G0290\<file://\\i2b2\i2b2\Procedures\CPT\A13475665\A13299386\G0290\>]
panel#-1 [<file://>\\i2b2\i2b2\Procedures\Surgery Cardiovascular System
(33010-395\(33510)Coronary Artery Bypass 1 Coronary Venous Graft\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Surgery Cardiovascular System
(33010-395\(33511)Coronary Artery Bypass 2 Coronary Venous Grafts\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Surgery Cardiovascular System
(33010-395\(33512)Coronary Artery Bypass 3 Coronary Venous Grafts\] panel#-1
[<file://>\\i2b2\i2b2\Proced
ures\Surgery Cardiovascular System (33010-395\(33513)Coronary Artery Bypass 4
Coronary Venous Grafts\] panel#-1 [<file://>\\i2b2\i2b2\Procedures\Surgery
Cardiovascular System (33010-395\(33514)Coronary Artery Bypass 5 Coronary
Venous Grafts\] panel#-1 [<file://>\\i2b2\i2b2\Procedures\Surgery
Cardiovascular System (33010-395\(33516)Coronary Artery Bypass 6/+ Coronary
Venous Graft\] panel#-1 [<file://>\\i2b2\i2b2\Procedures\Surgery
Cardiovascular System (33010-395\(33517)Coronary Artery Byp W Vein & Artery
Graft 1 Vei\] panel#-1 [<file://>\\i2b2\i2b2\Procedures\Surgery Cardiovascular
System (33010-395\(33518)Coronary Artery Byp W Vein & Artery Graft 2 Vei\]
panel#-1 [<file://>\\i2b2\i2b2\Procedures\Surgery Cardiovascular System
(33010-395\(33519)Coronary Artery Byp W Vein & Artery Graft 3 Vei\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Surgery Cardiovascular System
(33010-395\(33521)Coronary Artery Byp W Vein & Artery Graft 4 Vei\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Surg
ery Cardiovascular System (33010-395\(33522)Coronary Artery Byp W Vein &
Artery Graft 5 Vei\] panel#-1 [<file://>\\i2b2\i2b2\Procedures\Surgery
Cardiovascular System (33010-395\(33523)Coronary Artery Byp W Vein &Artery
Graft 6 Vei\] panel#-1 [<file://>\\i2b2\i2b2\Procedures\Surgery Cardiovascular
System (33010-395\(33533)Cabg W/Arterial Graft Single Arterial Graft\]
panel#-1 [<file://>\\i2b2\i2b2\Procedures\Surgery Cardiovascular System
(33010-395\(33534)Cabg W/Arterial Graft Two Arterial Grafts\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Surgery Cardiovascular System
(33010-395\(33535)Cabg W/Arterial Graft Three Arterial Grafts\] panel#-1
[<file://>\\i2b2\i2b2\Procedures\Surgery Cardiovascular System
(33010-395\(33536)Cabg W/Arterial Graft Four/>Arterial Grafts\] panel#-1
[\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352547\412\<file://\\i2b2\i2b2\Diagnoses\A18090800\A8359006\A8359014\A8352547\412\>]
panel#-1
[<file://>\\i2b2\i2b2\Procedures\PRC\ICD9 (Inpatient)\(35-39) Operations on
cardiovascular system\(p36) Operations on vessels of he~\(p36-1) Bypass
anastomosis for he~\(p3\] panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062801\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062801\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062859\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062859\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062801\308297\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062801\308297\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062859\432638\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\2062859\432638\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257563\1579690\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257563\1579690\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\1579687\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\1579687\>]
panel#-1 [\\i2b2\i2b2\3149154\3257561\3
257562\3257565\1579689\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\1579689\>]
panel#-1
[\\i2b2\i2b2\3149154\3257818\3257827\1579692\<file://\\i2b2\i2b2\3149154\3257818\3257827\1579692\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\1575581\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\1575581\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257563\1579694\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257563\1579694\>]
panel#-1
[\\i2b2\i2b2\3149154\3257818\3257827\1939210\<file://\\i2b2\i2b2\3149154\3257818\3257827\1939210\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257563\1575907\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257563\1575907\>]
panel#-1
[\\i2b2\i2b2\3149154\3257551\3257555\1576856\<file://\\i2b2\i2b2\3149154\3257551\3257555\1576856\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\1577710\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\1577710\>]
panel#-1 [\\i2b2\i2b2\3149154\3257561\3257562\3257565\1575580\<file://\\i2b2
\i2b2\3149154\3257561\3257562\3257565\1575580\>] panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\1575906\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\1575906\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\6337484\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\6337484\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\6346118\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\6346118\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\6349829\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\6349829\>]
panel#-1
[\\i2b2\i2b2\3149154\3257561\3257562\3257565\1575577\<file://\\i2b2\i2b2\3149154\3257561\3257562\3257565\1575577\>]
panel#-1 [<file://>\\i2b2\i2b2\Visit Details\Encounter Type\AV\] panel#-1
[<file://>\\i2b2\i2b2\Visit Details\Encounter Type\IP\] panel#-1
Thanks,
Eric LaRose
x93591
________________________________
The contents of this message may contain private, protected and/or privileged
information. If you received this message in error, you should destroy the
e-mail message and any attachments or copies, and you are prohibited from
retaining, distributing, disclosing or using any information contained within.
Please contact the sender and advise of the erroneous delivery by return e-mail
or telephone. Thank you for your cooperation.
________________________________
The contents of this message may contain private, protected and/or privileged
information. If you received this message in error, you should destroy the
e-mail message and any attachments or copies, and you are prohibited from
retaining, distributing, disclosing or using any information contained within.
Please contact the sender and advise of the erroneous delivery by return e-mail
or telephone. Thank you for your cooperation.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://listserv.kumc.edu/pipermail/gpc-dev/attachments/20170118/9526ea16/attachment.html>
------------------------------
Subject: Digest Footer
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
------------------------------
End of Gpc-dev Digest, Vol 35, Issue 37
***************************************
The information in this e-mail may be privileged and confidential, intended
only for the use of the addressee(s) above. Any unauthorized use or disclosure
of this information is prohibited. If you have received this e-mail by mistake,
please delete it and immediately contact the sender.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://listserv.kumc.edu/pipermail/gpc-dev/attachments/20170118/d149834d/attachment.html>
------------------------------
Subject: Digest Footer
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
------------------------------
End of Gpc-dev Digest, Vol 35, Issue 38
***************************************
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
