Re: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c

2017-01-24 Thread Campbell, James R
I agree with Phillip. Clinically, the date/time reported for a lab test is always when the patient had blood drawn or gave the sample. THAT is when the patient was 'tested'. Nebraska records all lab test observation_facts with START_DATE as date/time specimen was taken. We record order time

Re: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c

2017-01-24 Thread Al'ona Furmanchuk
*Dan:* It is important to be clear what each site use under "start_date". Especially for cases when ORDER_DATE is different from SPECIMEN_TAKEN_DATE. I appreciate, Dan if you could gather this info. It is important to be on the same terms when collecting data to the table 1. *Phillip:* I agree that

Re: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c

2017-01-24 Thread Phillip Reeder
I'd recommend using the SPECIMEN_TAKEN_DATE/TIME for the start_date of a lab. I believe it is the more clinically correct time as the results of labs can sometimes take days to return. We use the specimen time, followed by the result time, I believe. For the PCORI CDM, I plan on putting all

RE: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c

2017-01-24 Thread Dan Connolly
Reviewing the HERON ETL code, I see it does populate the i2b2 start_date for labs from Epic's result_time, which looks more like RESULT_DATE. I see that our code to build the PCORNet LAB_RESULT_CM.LAB_ORDER_DATE (PCORNetLoader_ora.sql#L1407

Re: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c

2017-01-24 Thread Al'ona Furmanchuk
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

Re: Where are UTSW Glucose labs? (#551)

2017-01-24 Thread Al'ona Furmanchuk
Awesome! Thank you Phillip. On Tue, Jan 24, 2017 at 1:14 PM, Phillip Reeder < phillip.ree...@utsouthwestern.edu> wrote: > Our hierarchies, including our deployment of LOINC, are updated and on > babel now. > > Phillip > > From: on behalf of Al'ona Furmanchuk < > alona.furmanc...@northwestern.edu

Share CDM Data Characterization (EDC) report with GPC customers such as Next-D

2017-01-24 Thread Dan Connolly
Please use this redcap survey to submit them: https://redcap.gpcnetwork.org/surveys/?s=9LT4KE8NFD We are collecting EDC reports from GPC sites to share with prospective GPC customers; for example, the Next-D researchers. These reports will not be shared publicly. For context, see #571 character

Re: Where are UTSW Glucose labs? (#551)

2017-01-24 Thread Phillip Reeder
Our hierarchies, including our deployment of LOINC, are updated and on babel now. Phillip From: mailto:furmanc...@icnanotox.org>> on behalf of Al'ona Furmanchuk mailto:alona.furmanc...@northwestern.edu>> Date: Monday, January 23, 2017 at 3:28 PM To: Phillip Reeder mailto:phillip.ree...@utsout