Hello everyone, As a reminder, the query below is due tomorrow. So far, we are still missing responses from:
* MCRI * UNMC * UTHSCSA Please make sure this gets completed by the due date. Thank you, Hillary From: PCORnet Query Tool [mailto:queryt...@pcornet.org] Sent: Monday, April 23, 2018 3:07 PM To: Hillary Sandoval <hsando...@kumc.edu> Subject: New Request Submitted Notification Dear Hillary Sandoval, 4/23/2018 4:06:43 PM EST Here are your most recent New Request Submitted notifications from PCORnet DRN Query Tool. Kshema Nagavedu has submitted a new QE File Distribution request ec_pmp2_wp001_nsd2_v01_2018 in project PCORnet. Description Requester: PCORnet Executive Committee Confidentiality: Treat request topic as confidential until final release of public report. Request Designation: See FD Queries document: https://pcornet.imeetcentral.com/p/aQAAAAAC-20J Query Distribution Recipients: Query is sent to DMs approved on DC Cycle 3 or 4. See QF Tracker for # of DMs receiving/responding to queries: http://tinyurl.com/kxlscfv Planned Use: As shared in the December CDRN PI call, the PCORnet EC is interested in describing a population of interest within PCORnet and agreed to first study those with a diagnosis of Heart Failure (HF). This query will describe a cohort of HF patients and examine comorbid conditions, prescribed medications and events of interest as determined by the Cohort Workgroup. A second query will be distributed to examine labs that are commonly ordered among this cohort. PCORnet Network and DataMart-level data will be shared with the requester. Only PCORnet-level aggregated data may be presented or published on public-facing websites (e.g. PCORnet.org<https://urldefense.proofpoint.com/v2/url?u=http-3A__pcornet.org_&d=DwMGaQ&c=imBPVzF25OnBgGmVOlcsiEgHoG1i6YHLR0Sj_gZ4adc&r=Yhxq2QVRhU_FsX7kuV6epIuuKWfqpfLV04MDc4021bs&m=IGPMqKJqpbyrLdKCf2NFgp5z_prGxV-dXJM3rQntDsk&s=HyREIfSMtbVDpmlJwcR4itsuuVUBAlXjBYzHkWuCsWw&e=>), in a manuscript, or marketing materials describing this cohort of interest in PCORnet. Responding to this query is acknowledgement that your data can be aggregated into a PCORnet-level report for public-facing venues. CC may reuse Network and CDRN level aggregate data for internal planning and to inform potential funding and research opportunities. Package Contents: 1 work plan and 4 folders serving to organize program inputs and outputs. Program folder structure described in work plan Section 5. Instructions to execute master.sas program described in workplan Section 6. SITES SHOULD ONLY RETURN THE FOLDER LABELED 'DRN OC' TO THE CC. Query Request: The request will identify counts of unique patients age 0-77+ (calculated at date of index event) with: - DX code for Heart Failure (HF) during query period - DX code for HF during query period AND a code for a comorbidity/procedure/medication during specified look-back or look-forward period (see tech specs for add'l. info) Comorbidity/Procedure/Meds: Atrial Fibrilation, Chronic Kidney Disease, Congenital Heart Disease, Chronic Obstructive Pulmonary Disease, Coronary Arterial Disease, Hyperlipidemia, Hypertension, Obesity, Peripheral Arterial Disease, Stroke/TIA, Diabetes, Any Hospitalization, Dialysis, Heart Failure Hospitalization(multiple care settings), Renal Transplant, MI, Revascularization, ACE inhibitors, Aldosterone Antagonist Angiotensin receptor blockers, Beta blockers, Calcium channel blockers, Carvedilol, Coumadin, Loop diuretics, Digoxin, GLP-1 inhibitors, NOACs, RAS blockade, Statins, SGLT2 inhibitors, Spironolactone, Thiazide diuretics Query Period: 1/1/2015-12/31/2016 Counts will be stratified by age, sex, race, and Hispanic. Query will execute against SAS tables (demographic, encounter, diagnosis, procedure, prescribing) in PCORnet CDM v3.0 or v3.1 format. Scenarios will produce aggregate output. Query Count=17 DataMarts should choose to either (1) return output; (2) hold the query and enter a note as to why the query is on hold; or (3) reject the query and enter a note as to why the query is rejected. Follow internal governance/policy for returning query output to CC. Output: 1 SAS program will process 3 runs & generate a total of 40-43 output files (16-19 files in 'drnoc' & 24 files in 'dmlocal' folder). The request will output the denominator file. See technical specifications for DX/PX codes: https://pcornet.imeetcentral.com/p/ZgAAAAAAnCmn Information on data flow/storage: https://tinyurl.com/kan25q9 Query adheres to minimum bin size policy; described in Section 3.6 of https://tinyurl.com/my45df3 Questions about query purpose or for the requestor, please contact frontd...@pcornet.org<mailto:frontd...@pcornet.org> With technical questions, please contact q...@pcornet.org<mailto:q...@pcornet.org> Request Details Request type: QE File Distribution Request Name: ec_pmp2_wp001_nsd2_v01_2018 Request ID: Request 2867 Project: PCORnet Budget Item: Source Item: Request Due Date: 5/8/2018 Contact Person: Kshema Nagavedu (kshema_nagav...@harvardpilgrim.org<mailto:kshema_nagav...@harvardpilgrim.org>) Priority: Medium Purpose of Use: Healthcare Research Level of PHI Disclosure: Aggregated Level of Report Aggregation: Requester Center: Workplan Type: Additional Instructions DataMarts C6 - Ochsner Health System DataMart NEW, C4 - Marshfield Clinic DataMart NEW, C13 - OneFlorida DataMart NEW, C10 - ADVANCE DataMart NEW, C5 - Kaiser Permanente Northwest DataMart NEW, C2 - University of North Carolina DataMart NEW, C7 - PEDSnet DataMart NEW, C1 - Beth Israel Deaconess DataMart NEW, C1 - Boston Children's Hospital DataMart NEW, C1 - Boston Health Net/BMC DataMart NEW, C1 - Grady DataMart NEW, C1 - Morehouse DataMart NEW, C1 - Partners HealthCare DataMart NEW, C1 - UT Health Sciences Center DataMart NEW, C1 - Washington University DataMart NEW, C11 - Geisinger DataMart NEW, C11 - Johns Hopkins DataMart NEW, C11 - Penn State Hershey Medical Center DataMart NEW, C11 - Temple University DataMart NEW, C11 - University of Pittsburgh Medical Center DataMart NEW, C11 - University of Utah DataMart NEW, C11 - UPMC Claims DataMart NEW, C12 - Allina Health Systems DataMart NEW, C12 - Arizona State University DataMart NEW, C12 - Essentia Health DataMart NEW, C12 - Intermountain Healthcare DataMart NEW, C12 - Ohio State University DataMart NEW, C12 - University of Michigan DataMart NEW, C12- Mayo Clinic DataMart NEW, C2 - Duke University DataMart NEW, C2 - Greenway PrimeRESEARCH DataMart NEW, C2 - Health Sciences South Carolina DataMart NEW, C2 - Meharry Medical College DataMart NEW, C2 - Vanderbilt Health Afilliate Network DataMart NEW, C2 - Vanderbilt University Medical Center DataMart NEW, C3 - Cedars Sinai Medical Center DataMart NEW, C3 - University of California Irvine DataMart NEW, C3 - University of California San Diego DataMart NEW, C3 - University of California San Francisco DataMart NEW, C3 - University of Southern California- Partner Clinics DataMart NEW, C3 - VA Informatics and Computing Infrastructure DataMart NEW, C3- University of California Davis DataMart NEW, C3- University of California Los Angeles DataMart NEW, C4 - Children's Mercy Hospital DataMart NEW, C4 - Indiana University Regenstrief DataMart NEW, C4 - University of Iowa Healthcare DataMart NEW, C4 - University of Kansas Medical Center DataMart NEW, C4 - University of Minnesota Academic Health Center DataMart NEW, C4 - University of Missouri DataMart NEW, C4 - University of Nebraska Medical Center DataMart NEW, C4 - University of Texas Health Sciences Center at San Antonio DataMart NEW, C4 - University of Texas Southwestern Medical Center DataMart NEW, C4 - University of Wisconsin Madison DataMart NEW, C5 - Denver Health DataMart NEW, C5 - Group Health Research Institute DataMart NEW, C5 - Health Partners Research Foundation DataMart NEW, C5 - Kaiser Permanente Colorado DataMart NEW, C5 - Kaiser Permanente Hawaii DataMart NEW, C5 - Kaiser Permanente Mid-Atlantic DataMart NEW, C6 - Baylor Scott White North DataMart NEW, C6 - Pennington LSU Health System DataMart NEW, C6 - Tulane University DataMart NEW, C7 - Cincinnati Children's Hospital DataMart NEW, C9 - Alliance CHS DataMart NEW, C9 - Cook County HHS DataMart NEW, C9 - Loyola Medicine DataMart NEW, C9 - Lurie Children's Hospital DataMart NEW, C9 - NorthShore DataMart NEW, C9 - Rush University Medical Center DataMart NEW, C9 - University of Chicago Medical Center DataMart NEW, C9 - University of Illinois HHS DataMart NEW We are notifying you of this change because you have subscribed to this notification. If you do not wish to receive this notification again, please login and change your subscription settings in your profile.
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
