Switching the date would be a major burden and would not be doable here at UTSW. We previously used result date, but found a large number of older result dates were off by months. I believe it was due to some IT process,like an import or something, but it was significant. And when researchers would try to find a lab by result date, the date shown in the EMR was different making it hard to locate.
With order date, in the outpatient setting, sometimes a doctor may order a lab and the patient may not have it done for days. With the PCORI CDM, we are currently only using have the specimen date, however we plan to add the other dates. Phillip From: Gpc-dev <gpc-dev-boun...@listserv.kumc.edu<mailto:gpc-dev-boun...@listserv.kumc.edu>> on behalf of Al'ona Furmanchuk <furmanc...@icnanotox.org<mailto:furmanc...@icnanotox.org>> Date: Wednesday, January 25, 2017 at 8:29 AM To: Dan Connolly <dconno...@kumc.edu<mailto:dconno...@kumc.edu>> Cc: Bernard Black <bbl...@kellogg.northwestern.edu<mailto:bbl...@kellogg.northwestern.edu>>, "<gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>>" <gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>> Subject: Re: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c Before we go toward changes, lets just see if we need to. I would appreciate if each site could fill up attached form and send back to me. I filled some sites based on this discussion. Please, check and correct if I got it wrong. Alona. On Wed, Jan 25, 2017 at 8:23 AM, Dan Connolly <dconno...@kumc.edu<mailto:dconno...@kumc.edu>> wrote: Changes in HERON ETL from result date to order date or specimen date would take a month or two, depending on priorities. I suspect likewise at other sites. If that sort of delay is acceptable, then I can proceed to get all 8 sites to resolve this deference. On Jan 25, 2017 7:44 AM, Bernard Black <bbl...@kellogg.northwestern.edu<mailto:bbl...@kellogg.northwestern.edu>> wrote: Let me chime in, as project PI. This was a very helpful discussion. For this study, exact dates are not important. If blood was drawn on Tuesday, and results available on Friday, If as I suspect (but we can check) generally order date, specimen date, and results date are all close, we can go with order date Bernie Black ************************************************************* Bernard S. Black Chabraja Professor, Northwestern University Pritzker Law School and Kellogg School of Management 375 East Chicago Ave., Chicago IL 60611 bbl...@northwestern.edu<mailto:bbl...@northwestern.edu> tel: law: 312-503-2784<tel:312-503-2784>; Kellogg 847-491-5049<tel:847-491-5049>; cell: 847-807-9599<tel:847-807-9599> papers on SSRN at: http://ssrn.com/author=16042 ************************************************************ From: Al'ona Furmanchuk [mailto:furmanc...@icnanotox.org<mailto:furmanc...@icnanotox.org>] Sent: Wednesday, January 25, 2017 7:31 AM To: Campbell, James R <campb...@unmc.edu<mailto:campb...@unmc.edu>> Cc: Phillip Reeder <phillip.ree...@utsouthwestern.edu<mailto:phillip.ree...@utsouthwestern.edu>>; <gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>> <gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>>; Bernard Black <bbl...@kellogg.northwestern.edu<mailto:bbl...@kellogg.northwestern.edu>> Subject: Re: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c Guys, Order date is important for defining study sample and DM sample. specimen date is important for "adherence to Treatment" variable. If difference in dates is minor, we could uniformly switch to specimen date. But first we have to know what is available in each site and ( if both dates are available) how large is difference between dates? Sent from my iPhone On Jan 24, 2017, at 10:40 PM, Campbell, James R <campb...@unmc.edu<mailto:campb...@unmc.edu>> wrote: 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 and result reported time separately. Jim James R. Campbell MD campb...@unmc.edu<mailto:campb...@unmc.edu> Office: 402-559-7505<tel:(402)%20559-7505> Secretary: 402-559-7299<tel:(402)%20559-7299> Pager: 402-888-1230<tel:(402)%20888-1230> On Jan 24, 2017, at 6:07 PM, Al'ona Furmanchuk <furmanc...@icnanotox.org<mailto:furmanc...@icnanotox.org>> wrote: 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 having order, specimen and result dates is good practice. This is what we have here at NU as well. Alona. On Tue, Jan 24, 2017 at 5:49 PM, Phillip Reeder <phillip.ree...@utsouthwestern.edu<mailto:phillip.ree...@utsouthwestern.edu>> wrote: 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 of the needed date/times, (specimen, order, and result) into a small XML block in the observation_blob column so that I can have all the times when I ETL the data to the CDM schema. Phillip From: Gpc-dev <gpc-dev-boun...@listserv.kumc.edu<mailto:gpc-dev-boun...@listserv.kumc.edu>> on behalf of Dan Connolly <dconno...@kumc.edu<mailto:dconno...@kumc.edu>> Date: Tuesday, January 24, 2017 at 5:09 PM To: Al'ona Furmanchuk <furmanc...@icnanotox.org<mailto:furmanc...@icnanotox.org>>, "<gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>>" <gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>> Cc: Bernard Black <bbl...@northwestern.edu<mailto:bbl...@northwestern.edu>> Subject: RE: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c 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<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_kumc-2Dbmi_i2p-2Dtransform_blob_cycle-5F2_Oracle_PCORNetLoader-5Fora.sql-23L1407&d=CwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=yqG12qsoyrBif-jILwubW8btm4qM0DM258CMGa2kQBI&s=B7cCQmEWUNYYqTWtUNzSvO_w9AgOsBJBy3wEyxt_Bms&e=>) uses this start_date that came from result_time, so we're fudging things a bit there. The HERON ETL code is used at KUMC and was the basis of work at UTHSCSA and UNMC. If the difference between LAB_ORDER_DATE and RESULT_DATE is significant for Next-D, I can find out how the other participating GPC sites do start_date for labs. ref: * heron_load/epic_labs_transform.sql<https://urldefense.proofpoint.com/v2/url?u=https-3A__informatics.kumc.edu_work_browser_heron-5Fload_epic-5Flabs-5Ftransform.sql&d=CwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=yqG12qsoyrBif-jILwubW8btm4qM0DM258CMGa2kQBI&s=pGsz33DfC6KcCqKPa98qqkrDL6z3BB6KNoYcWjFZ0F0&e=> -- Dan ________________________________ From: Al'ona Furmanchuk [furmanc...@icnanotox.org<mailto:furmanc...@icnanotox.org>] Sent: Tuesday, January 24, 2017 4:35 PM To: <gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>> Cc: Mei Liu; Dan Connolly; Taylor, Bradley; Bernard Black Subject: Re: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c 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 <d...@madmode.com<mailto:d...@madmode.com>> 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-<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_dckc_nextd-2Dstudy-2D&d=CwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=yqG12qsoyrBif-jILwubW8btm4qM0DM258CMGa2kQBI&s=pJR2npMPImLderrOyYqj8y314rhl5bxh_TdkjIazisA&e=> 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<https://urldefense.proofpoint.com/v2/url?u=http-3A__informatics.gpcnetwork.org_trac_Project_ticket_551-23comment-3A8&d=CwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=yqG12qsoyrBif-jILwubW8btm4qM0DM258CMGa2kQBI&s=3Jny2FAhAcvq_hCSSoufzQEnkPPqO44JMAU_Zi_XbQs&e=>> gpc-informatics <http://informatics.gpcnetwork.org/<https://urldefense.proofpoint.com/v2/url?u=http-3A__informatics.gpcnetwork.org_&d=CwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=yqG12qsoyrBif-jILwubW8btm4qM0DM258CMGa2kQBI&s=b8Ln6oogSoCgdKEAkaGuJNxyO_HhjpaET5QTlwV-1gE&e=>> 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/<https://urldefense.proofpoint.com/v2/url?u=http-3A__furmanchuk.com_&d=CwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=yqG12qsoyrBif-jILwubW8btm4qM0DM258CMGa2kQBI&s=VNFtxnmsnEgN7YNkkxnbm6_yI2aPx3BrxZLIEe8cUYc&e=> E-mail: alona.furmanc...@northwestern.edu<mailto:furmanc...@icnanotox.org> Phone: 312-503-34281 ________________________________ UT Southwestern Medical Center The future of medicine, today. -- 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/<https://urldefense.proofpoint.com/v2/url?u=http-3A__furmanchuk.com_&d=CwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=yqG12qsoyrBif-jILwubW8btm4qM0DM258CMGa2kQBI&s=VNFtxnmsnEgN7YNkkxnbm6_yI2aPx3BrxZLIEe8cUYc&e=> E-mail: alona.furmanc...@northwestern.edu<mailto:furmanc...@icnanotox.org> Phone: 312-503-34281 _______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu<mailto:Gpc-dev@listserv.kumc.edu> http://listserv.kumc.edu/mailman/listinfo/gpc-dev<https://urldefense.proofpoint.com/v2/url?u=http-3A__listserv.kumc.edu_mailman_listinfo_gpc-2Ddev&d=CwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=CqPxCu-EywA2wo4iO-6BFqfwPQ2roHdsnjQi7SSLgLE&m=yqG12qsoyrBif-jILwubW8btm4qM0DM258CMGa2kQBI&s=LiXNBizvgplZo4N_Bky-K6CsYVFaXT_dY3I6HIMrdCU&e=> The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender. -- 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<mailto:furmanc...@icnanotox.org> Phone: 312-503-34281
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
