Phillip, while you're in the Next-D neighborhood... Where are your glucose labs? i.e. what LOINC codes and/or i2b2 paths do you use?
We looked on babel and couldn't find any UTSW labs. -- Dan ________________________________ From: [email protected] [[email protected]] on behalf of Al'ona Furmanchuk [[email protected]] Sent: Wednesday, January 18, 2017 7:40 AM To: Nathan Graham Cc: [email protected]; Dan Connolly; Lindsey Lynne Cook Subject: Re: Phillip's e-mail copied for Al'ona Hello, Phillip. Dan Connolly suggested you might be the right person to ask about location of lab information in utsw_terms schema or elsewhere else in i2b2 database on babel. Recently I was doing initial assessment of data from different GPC sides participating in the Next-D project. I was trying to extract information on labs from i2b2metadata schemas by using sql. Here is an example of commands I tried: select c_name, c_totalnum, c_basecode from utsw_terms where c_basecode like 'LOINC:%' and UPPER(c_name) like '%GLUCOSE%' order by c_basecode or select c_name, c_totalnum, c_basecode from utsw_terms where UPPER(c_name) like '%LOINC:%' and UPPER(c_name) like '%GLUCOSE%' order by c_basecode Dan’s search with the i2b2 web UI also ended up with no information on labs for this side. I wonder if you could help us or suggested right person to ask about how to find labs’ information (names and LOINC codes) for UTSW side. With respect, Alona. On Tue, Jan 17, 2017 at 4:28 PM, Nathan Graham <[email protected]<mailto:[email protected]>> wrote: Al’ona, Phillip is copied ([email protected]). -- Nathan -- Al’ona Furmanchuk, Ph.D. Research Associate Department of Electrical Engineering and Computer Science Northwestern University 2145 Sheridan Road, Tech L359 Evanston, IL 60208 Web: http://furmanchuk.com/ E-mail: [email protected]<mailto:[email protected]> Phone: 847-467-2299
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
