Hello everyone, Just a reminder that the query below is due tomorrow. At this point, we are still missing responses from:
* CMH * UNMC * UTSW Please make sure this gets completed by the due date. Thank you, Hillary From: PCORnet Query Tool [mailto:queryt...@pcornet.org] Sent: Monday, May 7, 2018 2:59 PM To: Hillary Sandoval <hsando...@kumc.edu> Subject: New Request Submitted Notification Dear Hillary Sandoval, 5/7/2018 3:59:16 PM EST Here are your most recent New Request Submitted notifications from PCORnet DRN Query Tool. Shaila Murji has submitted a new QE File Distribution request fd1122_pmp2_wp009_nsd2_v01 in project PCORnet. Description Note: the following log warning may be encountered upon query execution: WARNING: Variable FIncDt has different lengths on BASE and DATA files (BASE 4 DATA 8) as a result of recent data updates. Please note that this log warning does not impact the validity of query results. This warning will be addressed in future versions of the program. Summary: his query was requested by Roche Pharmaceuticals and will answer the question of how many people with viral hepatitis develop liver fibrosis, cirrhosis, or hepatocellular carcinoma. The results from this query will help plan future studies about viral hepatitis. Requester: Farnaz Vahidnia, Roche 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: Roche Pharmaceuticals is interested in determining the feasibility of PCORnet for retrospective and prospective studies among Hepatitis B/C cohorts without hepatic fibrosis, cirrhosis or HCC. Results of this PTR query will return aggregate data at DM level; final report will be provided to the requester at an aggregate level & by DM for all responding DMs. Only PCORnet-level aggregated data may be presented or published on public-facing websites (e.g. PCORnet.org) and in a manuscript describing Viral Hepatitis cohorts in PCORnet. Responding to this query is acknowledgement that a) you are interested in potentially collaborating in future studies and would like to be engaged further in development, and b) 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: This query request will identify the following counts of unique patients age 18+ with: * HepBC: a diagnosis code for Hepatitis B or C in the query period * HepBC_ex_prior: a diagnosis code for Hepatitis B or C in the query period AND NO diagnosis code for liver fibrosis or Cirrhosis or HCC 1 to 730 days prior to index date * HepBC_inc_post: a diagnosis code for Hepatitis B or C in the query period AND NO diagnosis code for liver fibrosis or Cirrhosis or HCC 1 to 730 days prior to index date AND include a diagnosis code for liver fibrosis or Cirrhosis or HCC 1 to 730 days post index date Query Period: 1/1/2013 -12/31/2015 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=1 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 1 run & generate a total of 14-15 output files (6-7 files in 'drnoc' & 8 files in 'dmlocal' folder) See technical specifications for DX/CUI codes: https://pcornet.imeetcentral.com/p/aQAAAAADkOvm 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: fd1122_pmp2_wp009_nsd2_v01 Request ID: Request 2888 Project: PCORnet Budget Item: Source Item: Request Due Date: 5/22/2018 Contact Person: Shaila Murji (shaila_mu...@harvardpilgrim.org<mailto:shaila_mu...@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, 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 - Wake Forest Baptist Hospital 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 - 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 - San Mateo 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 - Medical College of Wisconsin 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 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, C5 - Kaiser Permanente Northern California DataMart NEW, C5 - Kaiser Permanente Southern California 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, C8 - New York Genome Center 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 - Northwestern Medical 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
