Dan, great job! Meanwhile, could you please clarify actual meaning of "start_date" in i2b2? Is it more like "LAB_OERDER_DATE" (when lab was ordered), "SPECIMEN_DATE" (when specimen was taken), "RESULT_DATE" (when results became available)?
Alona. On Tue, Jan 24, 2017 at 4:06 PM, GPC Informatics <[email protected]> wrote: > #551: next-D labs for cohort selection: fasting glucose, HbA1c > --------------------------+----------------------- > Reporter: afurmanchuk | Owner: meiliu > Type: design-issue | Status: accepted > Priority: major | Milestone: next-d > Component: data-stds | Resolution: > Keywords: | Blocked By: > Blocking: 545 | > --------------------------+----------------------- > > Comment (by dconnolly): > > Alona, Mei, > > I managed to prototype using i2b2 and LOINC codes: > > - 8f27bee get FG_Intial, RG_Initial from i2b2 star schema > \\[https://github.com/dckc/nextd-study- > support/blob/master/NextDvariableExtractionOracleTable1GPC.sql#L138-L221 > NextDvariableExtractionOracleTable1GPC.sql lines 138-221] > > At KUMC, this results in ~500K rows in RG_Intial but 0 in FG_Intial: > as I noted in comment:1, the LOINC code KU Hospital maps to (`Glucose > SerPl-mCnc (2345-7)`) doesn't > distinguish fasting from eating. > > Some changes were perhaps substantive, so I need you to evaluate the > impact: > - LAB_ORDER_DATE became start_date, > which is more likely result date than order date > - i2b2 start_date includes time > > Brad, I think this approach should work at other GPC sites. I'd appreciate > if you'd (have George) take a look. > > -- > Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ > ticket/551#comment:8> > 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: [email protected] <[email protected]> Phone: 312-503-34281
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
