I appreciate your efforts On Mon, Jan 23, 2017 at 1:44 PM, Phillip Reeder < [email protected]> wrote:
> I’m actively working to re-load the UTSW hierarchies onto babel. We’re > using the GPC loinc hierarchy with our local terms under the mapped loinc > term. Hope to have everything imported today. > > Phillip > > From: Dan Connolly <[email protected]> > Date: Friday, January 20, 2017 at 2:21 PM > To: Al'ona Furmanchuk <[email protected]>, Nathan Graham < > [email protected]> > Cc: Phillip Reeder <[email protected]>, Lindsey Lynne > Cook <[email protected]>, "<[email protected]>" < > [email protected]> > Subject: Where are UTSW Glucose labs? (#551) > > 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]> 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/ > <https://urldefense.proofpoint.com/v2/url?u=http-3A__furmanchuk.com_&d=CwMFAw&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=-aRkmw3Ob1oZRrrYmR1wHysw9FWMRlmk_CMIVWKi32KhS_EbXW7cMBGcBAmqh95W&m=DXEAQVuOfuwsEaLXAr8SVnMub78oQOtJ5rHUmVgdo5I&s=AGRUZSFuQrUF6kCnAhGB6W_UQ6u2Rl4t1R4yR5NM53I&e=> > E-mail: [email protected] <[email protected]> > Phone: 847-467-2299 <(847)%20467-2299> > > ------------------------------ > > UT Southwestern > > Medical Center > > The future of medicine, today. > -- 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] <[email protected]> Phone: 847-467-2299
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
