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

Reply via email to