Please, disregard Apr. 4th document on labs for now. It turned to have errors due to wrong application of sorting command. Earlier next week we will provide corrected version.
Apologies. On Fri, Apr 7, 2017 at 11:14 AM, GPC Informatics <d...@madmode.com> wrote: > #551: next-D labs for cohort selection: fasting glucose, HbA1c > --------------------------+------------------------ > Reporter: afurmanchuck | Owner: gkowalski > Type: design-issue | Status: assigned > Priority: major | Milestone: next-d > Component: data-stds | Resolution: > Keywords: | Blocked By: > Blocking: 545 | > --------------------------+------------------------ > > Comment (by dconnolly): > > George, I'm not surprised you get no results for fasting; I don't think I > get any either. But babel shows 6777-7 is much used at MCW; that's in the > list of codes for random glucose, yes? Do you not get any results there > either? > > Meanwhile, note the work on `lab_review.csv`.... I haven't integrated it > into the query yet; i.e. replaced the hard-coded list of LOINC codes with > a join on a table built from `lab_review.csv`. > > Meanwhile, Dr. Kho is refining the lab spreadsheet. 5792-7 seems to be the > most recorded glucose lab at MCW (based on c_totalnum from Babel). That > row in Dr. Kho's Apr 4 spreadsheet says "No". I'm not sure why; he plans > to include rationale in his next revision. 5792-7 is also not in the SQL > code. For 6777-7, which is also much recorded, I see "allowable for now" > and it is in the SQL code. > > -- > Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ > ticket/551#comment:17> > gpc-informatics <http://informatics.gpcnetwork.org/> > Greater Plains Network - Informatics > -- Al’ona Furmanchuk, Ph.D. Research Associate Center for Health Information Partnerships, Northwestern University, Feinberg School of Medicine 633 N. Saint Clair Street, 20th floor, Chicago, IL 60611 Web: http://furmanchuk.com/ E-mail: alona.furmanc...@northwestern.edu <furmanc...@icnanotox.org> Phone: 312-503-34281
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
