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\A8352249\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\Diagnoses\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\A8352249\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\A8359014\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\A18090800\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\A19384330\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\Diagnoses\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\A8354356\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\A8345746\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\i2b2\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\A8378078\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\Procedures\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\Medicine (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\CPT\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\Procedures\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\Surgery 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\3257562\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.
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
