Dan: I suspect we will want to go this route. But first, let me untangle the “date shifting” question, I’m working on that one. I need to figure out that one, and then propose a solution that works both for GPC and for the Capricorn sites. Then hopefully we can address both at the same time.
Bernie ************************************************************* 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: Dan Connolly [mailto:dconno...@kumc.edu] Sent: Wednesday, January 25, 2017 8:24 AM To: Bernard Black <bbl...@kellogg.northwestern.edu> Cc: <gpc-dev@listserv.kumc.edu> <gpc-dev@listserv.kumc.edu>; James R. Campbell, MD, FACP, FACMI <campb...@unmc.edu>; Al'ona Furmanchuk <furmanc...@icnanotox.org> Subject: RE: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c 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<https://urldefense.proofpoint.com/v2/url?u=http-3A__ssrn.com_author-3D16042&d=CwMGaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=UogPJ7VYoAeiC8NNwyY5AxLx8QgaRiMcicgAv7oi3tc&m=cBFbqGsVFjMaA8Xlvw8fG6NReCVYD0sj40E8CU41mrg&s=Z8ZHMwKZx1domZrD9bKgQQKR99-uQydJDOBUMC2CCUA&e=> ************************************************************ From: Al'ona Furmanchuk [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 Secretary: 402-559-7299 Pager: 402-888-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.
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev