This was one of the longest running for Marshfield as well. Thanks, Laurel
From: Gpc-dev [mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Debbie Yoshihara Sent: Thursday, November 02, 2017 8:47 AM To: Phillip Reeder; Hillary Sandoval; 'Brittany Zschoche'; gpc-dev@listserv.kumc.edu Subject: Re: [PCORnet CDRN PMs] Fwd: PCORnet Front Door HFpEF (FD0053) PMP2 Request Distribution Hi Phillip, Yeah, just for reference, we run SAS against our Netezza files. It took 21 hours clock time. Since we have a hard reboot every 24 hours, this query just made it. And I agree, it's one of the longest running queries. --- Debbie Debbie Yoshihara Informatics Specialist Biomedical Informatics Services - SMPH-IT Institute for Clinical and Translational Research (ICTR) School of Medicine and Public Health, UW-Madison matrixed employee of UW Health ________________________________ From: Gpc-dev <gpc-dev-boun...@listserv.kumc.edu<mailto:gpc-dev-boun...@listserv.kumc.edu>> on behalf of Phillip Reeder <phillip.ree...@utsouthwestern.edu<mailto:phillip.ree...@utsouthwestern.edu>> Sent: Thursday, November 2, 2017 8:33:11 AM To: Hillary Sandoval; 'Brittany Zschoche'; gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu> Subject: Re: [PCORnet CDRN PMs] Fwd: PCORnet Front Door HFpEF (FD0053) PMP2 Request Distribution For those who have successfully completed this query, how long did SAS take to complete? Its been running for 24 hours here at UTSW and seems to be making progress so I don't want to kill the process. There were files created at 5:00AM and log entries at 8:30, so I know it's still alive. But this is by far the longest running SAS query I've run. Phillip From: Gpc-dev <gpc-dev-boun...@listserv.kumc.edu<mailto:gpc-dev-boun...@listserv.kumc.edu>> on behalf of Hillary Sandoval <hsando...@kumc.edu<mailto:hsando...@kumc.edu>> Date: Wednesday, November 1, 2017 at 9:36 AM To: 'Brittany Zschoche' <gpc-site...@listserv.kumc.edu<mailto:gpc-site...@listserv.kumc.edu>>, "gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>" <gpc-dev@listserv.kumc.edu<mailto:gpc-dev@listserv.kumc.edu>>, "'gpc...@listserv.kumc.edu<mailto:'gpc...@listserv.kumc.edu>'" <gpc...@listserv.kumc.edu<mailto:gpc...@listserv.kumc.edu>> Subject: FW: [PCORnet CDRN PMs] Fwd: PCORnet Front Door HFpEF (FD0053) PMP2 Request Distribution Hello everyone, Just a reminder that if you received a request to complete query fd0053_pmp2_wp003 and have not responded yet, please respond by COB tomorrow. If you are unable to do this you can still respond up until 11/10, but your data will not be included in the report provided to the requestor. Please see below for details. From my records, I believe Marshfield, Iowa and MU have already completed this. Thank you, Hillary From: PCORnet DRN OC [mailto:dr...@pcornet.org] Sent: Wednesday, November 1, 2017 9:11 AM To: PCORnet Query Fulfillment <q...@pcornet.org<mailto:q...@pcornet.org>> Subject: [PCORnet CDRN PMs] Fwd: PCORnet Front Door HFpEF (FD0053) PMP2 Request Distribution Dear PCORnet colleagues, As a reminder, we are requesting responses to the Front Door Heart Failure with Preserved Ejection Fraction (HFpEF) query (fd0053_pmp2_wp003) by COB Tomorrow, November 2nd in order to be included in the report. Sites that are unable to respond by November 2nd will still have until Friday, November 10th to respond to the query, however their data will not be included in the report that will be provided to the requester. Many thanks to the sites that have already submitted their responses. For general questions, please contact the DRN OC at dr...@pcornet.org<mailto:dr...@pcornet.org>. For questions specific to the query, please contact the Query Fulfillment team at q...@pcornet.org<mailto:q...@pcornet.org>. Best wishes, The PCORnet DRNOC and Query Fulfillment Teams ---------- Forwarded message ---------- From: PCORnet DRN OC <dr...@pcornet.org<mailto:dr...@pcornet.org>> Date: Fri, Oct 27, 2017 at 10:32 AM Subject: PCORnet Front Door HFpEF (FD0053) PMP2 Request Distribution To: Cc: PCORnet Query Fulfillment <q...@pcornet.org<mailto:q...@pcornet.org>> Dear PCORnet colleagues, The Query Fulfillment team is pleased to announce the distribution of the Front Door Heart Failure with Preserved Ejection Fraction (HFpEF) (FD0053) query request. For specific details about this request, please see the Request Details section below. This query request will be distributed as a PCORnet Modular Program 2 (PMP2) package on October 27, 2017. The full workplan and metadata are available here: https://pcornet.imeetcentral.com/p/ZgAAAAAAkfHa<https://urldefense.proofpoint.com/v2/url?u=https-3A__pcornet.imeetcentral.com_p_ZgAAAAAAkfHa&d=DwMFaQ&c=imBPVzF25OnBgGmVOlcsiEgHoG1i6YHLR0Sj_gZ4adc&r=XNXVzdAKFbVvmixJkc4Uon8-2xZmQNDn2dtO-RyxD38&m=AMnaUtz3GYBCuhcu_QS0jHQd2yGAht_8lBUvo-BSmH0&s=bLWe5Mgupljm-NKd1mPYdRXnGJNrtyFmNFamkpAym2s&e=> A response to this request will count as 17 queries. Who is the requester? Adam Devore, Duke University and AstraZeneca How will the results be used? AstraZeneca is considering the development of a Pragmatic Clinical Trial (PCT) among Heart Failure patients and is interested in the feasibility of using PCORnet for this future study. The results of this query will be provided to the requester at the PCORnet level (i.e. aggregated across all DataMarts). The number and names of responding DataMarts will be included in the report. If the requester develops future plans for a PCT and would like DataMart-level data to aid in site identification, the Coordinating Center will contact each DataMart for approval prior to sharing their data. DataMarts will have 10 business days to respond, but the Coordinating Center requests responses by November 2, 2017, as the report for this query will be generated at that time due to requester deadlines. The Coordinating Center may reuse Network & CDRN-level aggregate data for internal planning & to inform potential funding/research opportunities. Has this request gone through the Network collaboration Request process? No (for more information on request designations see Front Door Queries document here<https://urldefense.proofpoint.com/v2/url?u=https-3A__pcornet.imeetcentral.com_p_aQAAAAAC-2D20J&d=DwMGaQ&c=imBPVzF25OnBgGmVOlcsiEgHoG1i6YHLR0Sj_gZ4adc&r=XNXVzdAKFbVvmixJkc4Uon8-2xZmQNDn2dtO-RyxD38&m=r776hHyivvC0iJAFp3PQL2YEGxlKzYB_pw0SSNXkAJ0&s=eFbDClza7wMB75ZGqEz7VSA6tcIZhcQ1neCyLCIWMEM&e=>) Who is eligible to receive the query? All DataMarts that have been approved on either Cycle 1, 2, or 3 of Data Curation (full tracker available here<https://urldefense.proofpoint.com/v2/url?u=https-3A__pcornet.imeetcentral.com_p_aQAAAAAC5cuA&d=DwMGaQ&c=imBPVzF25OnBgGmVOlcsiEgHoG1i6YHLR0Sj_gZ4adc&r=XNXVzdAKFbVvmixJkc4Uon8-2xZmQNDn2dtO-RyxD38&m=r776hHyivvC0iJAFp3PQL2YEGxlKzYB_pw0SSNXkAJ0&s=ldntwPI0bbgDxpLxswkFQsEgLD84nitJd-UM1qPkQhE&e=>) will receive the query for the opportunity to respond. What is the timeframe? Eligible DataMarts will receive the query on October 27, 2017 and responses will be due on November 10, 2017. Please note that although DataMarts will have 10 business days to respond, the Coordinating Center urges Network Partners to respond by November 2, 2017, as the report for this query will be generated at that time due to requester deadlines. Query distribution The query will be distributed to eligible DataMarts via the PopMedNet Query Tool. An email notification via the tool will be sent to the DataMart Administrator and any other users with enabled notifications when the query is distributed. Detailed instructions for query execution can be found in the workplan document here: https://pcornet.imeetcentral.com/p/ZgAAAAAAkfHa<https://urldefense.proofpoint.com/v2/url?u=https-3A__pcornet.imeetcentral.com_p_ZgAAAAAAkfHa&d=DwMFaQ&c=imBPVzF25OnBgGmVOlcsiEgHoG1i6YHLR0Sj_gZ4adc&r=XNXVzdAKFbVvmixJkc4Uon8-2xZmQNDn2dtO-RyxD38&m=AMnaUtz3GYBCuhcu_QS0jHQd2yGAht_8lBUvo-BSmH0&s=bLWe5Mgupljm-NKd1mPYdRXnGJNrtyFmNFamkpAym2s&e=> Request Details The Front Door HFpEF (FD0053) query request will examine counts of unique patients age 0-89+ with: * HF_ONLY: A diagnosis code for heart failure with preserved ejection fraction (HFpEF) * A diagnosis code for HFpEF AND * HF_DIAB: A diagnosis code of diabetes in the five years prior to the index event, including same-day diagnoses * HF_HYP: A diagnosis code of Hypertension in in the five years prior to the index event, including same-day diagnoses * HF_MI: A diagnosis code of myocardial infarction in the 1825 days prior to the index event * HF_CABGPCI: A diagnosis code of either coronary artery bypass grafting OR percutaneous coronary intervention in the 1825 days prior to the index event * HF_STRKTIA: A diagnosis code of either stroke OR transient ischemic attack in the 1825 days prior to the index event * HF_AFIB: A diagnosis code of either atrial fibrillation OR flutter in the five years prior to the index event, including same-day diagnoses * HF_HF1IP: A diagnosis code of heart failure with an encounter type of IP in the 180 days prior to the index event * HF_HF1ED: A diagnosis code of heart failure with an encounter type of ED in the 180 days prior to the index event * HF_HF1EI: A diagnosis code of heart failure with an encounter type of EI in the 180 days prior to the index event * HF_HF1OS: A diagnosis code of heart failure with an encounter type of OS in the 180 days prior to the index event * HF_HF2IP: A diagnosis code of heart failure with an encounter type of IP in the 365 days prior to the index event * HF_HF2ED: A diagnosis code of heart failure with an encounter type of ED in the 365 days prior to the index event * HF_HF2EI: A diagnosis code of heart failure with an encounter type of EI in the 365 days prior to the index event * HF_HF2OS: A diagnosis code of heart failure with an encounter type of OS in the 365 days prior to the index event * HF_HF3IP: A diagnosis code of heart failure with an encounter type of IP in the 1825 days prior to the index event * HF_HF3ED: A diagnosis code of heart failure with an encounter type of ED in the 1825 days prior to the index event * HF_HF3EI: A diagnosis code of heart failure with an encounter type of EI in the 1825 days prior to the index event * HF_HF3OS: A diagnosis code of heart failure with an encounter type of OS in the 1825 days prior to the index event * HF_HF4IP: A diagnosis code of heart failure with an encounter type of IP in the 365 days after the index event * HF_HF4ED: A diagnosis code of heart failure with an encounter type of ED in the 365 days after the index event * HF_HF4EI: A diagnosis code of heart failure with an encounter type of EI in the 365 days after the index event * HF_HF4OS: A diagnosis code of heart failure with an encounter type of OS in the 365 days after the index event * HF_ACE: An RxNorm_CUI code for ACE Inhibitors within the day before or after the index event * HF_ARB: An RxNorm_CUI code for Angiotensin Receptor Blockers within the day before or after the index event * HF_SV: An RxNorm_CUI code for Sacubitril-valsartan within the day before or after the index event * HF_SPIRO: An RxNorm_CUI code for spironolactone in within the day before or after the index event * HF_BB: An RxNorm_CUI code for beta blockers within the day before or after the index event * HF_LOOP: An RxNorm_CUI code for loop diuretics within the day before or after the index event * HF_DIGO: An RxNorm_CUI code for digoxin within the day before or after the index event * HF_INS: An RxNorm_CUI code for insulin within the day before or after the index event * HF_SGLT: An RxNorm_CUI code for SGLT2 inhibitors within the day before or after the index event All codes for this request were defined by the Front Door team in collaboration with the PI. The query period for this request is 1/1/2014-12/31/2016. All counts will be stratified by age, sex, race, and Hispanic. For general questions, please contact the DRN OC at dr...@pcornet.org<mailto:dr...@pcornet.org>. For questions specific to the query, please contact the Query Fulfillment team at q...@pcornet.org<mailto:q...@pcornet.org>. Best wishes, The PCORnet DRN OC and Query Fulfillment teams -------------------------------------------------------------------------- Query Fulfillment for the PCORnet Distributed Research Network Operations Center QF Email: q...@pcornet.org<mailto:q...@pcornet.org> QF Wiki: https://pcornet.imeetcentral.com/p/aQAAAAAClFkW<https://urldefense.proofpoint.com/v2/url?u=https-3A__pcornet.imeetcentral.com_p_aQAAAAAClFkW&d=DwMF-g&c=KNVzINr6WAqWApikNSnyDeOu0ck0iFwcrMz92MxUhIs&r=A2PXk2ZGVGBzoEOQMwrrboZc0kb2NWGliRjTa4b3xxXo7HiAVoZaxWlIgfPM_ia9&m=KtxOjIES0qtVE7j-1oNWKkz8VYo0eCdYYe8aKaVM6ng&s=WKPflD5AGtz3ZC7ybBA4Kq0tBYHd48Zkgmmi_wOf_rQ&e=> -- You received this message because you are subscribed to the Google Groups "PM_CDRN" group. To unsubscribe from this group and stop receiving emails from it, send an email to pm_cdrn+unsubscr...@pcornet.org<mailto:pm_cdrn+unsubscr...@pcornet.org>. ________________________________ UT Southwestern Medical Center The future of medicine, today. ______________________________________________________________________ The contents of this message may contain private, protected and/or privileged information. If you received this message in error, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained within. Please contact the sender and advise of the erroneous delivery by return e-mail or telephone. Thank you for your cooperation.
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
