Hello everyone,
As a reminder, the attached queries are due Monday. So far, we are still
missing the following responses:
* PROD_P02_DQA_FDPRO_DCQ_NSD1_c005_r010_q412
* KUMC
* MU
* PROD_P02_DQA_FDPRO_DCQ_NSD1_c005_r011_q412
* IU
* PROD_P02_DQA_FDPRO_DCQ_NSD1_c005_r013_q412
* UTSW
* rcr_pmp3_wp003_nsd2_v01_2018
* MU
* UTHSCSA
Please let me know if you anticipate any trouble with getting these completed
by the due date.
Thank you,
Hillary Sandoval
Project Manager, Center for Medical Informatics and Enterprise Analytics
University of Kansas Medical Center
hsando...@kumc.edu<mailto:hsando...@kumc.edu>
913-588-7205
Request Help Here<https://redcap.kumc.edu/surveys/?s=qYxMmb>
www.kumc.edu/ea-mi<http://www.kumc.edu/ea-mi>
www.gpcnetwork.org<http://www.gpcnetwork.org/>
--- Begin Message ---
Dear Hillary Sandoval,
10/8/2018 12:05:26 PM EST
Here are your most recent New Request Submitted notifications from PCORnet DRN
Query Tool.
Allison Haufler has submitted a new QE File Distribution request
PROD_P02_DQA_FDPRO_DCQ_NSD1_c005_r010_q412 in project PCORnet.
Description
The purpose of the Data Curation Query Package v4.12 is to characterize the
data in 17 of the PCORnet Common Data Model (CDM) v4.1 tables, and to partially
characterize the data in the OBS_GEN and OBS_CLIN tables. The package consists
of a code errors query, a data curation query and an Empirical Data Curation
Report which summarizes key information from the query output and evaluates the
results against PCORnet’s Data Check v5. Output tables will be produced by
running SAS programs against static local DataMarts in PCORnet CDM v4.1 with
SAS data types.
Request Details
Request type: QE File Distribution
Request Name: PROD_P02_DQA_FDPRO_DCQ_NSD1_c005_r010_q412
Request ID: Request 3101
Project: PCORnet
Budget Item:
Source Item: P02
Request Due Date: 10/29/2018
Contact Person: Allison Haufler (allison.hauf...@duke.edu)
Priority: Medium
Purpose of Use:
Level of PHI Disclosure: Aggregated
Level of Report Aggregation:
Requester Center:
Workplan Type:
Additional Instructions
NOTE: A DataMart refresh must include at least 1 modification to the
previously approved data. If you have not made any changes, please decline
this query and specify why you are unable to respond in the comments field
This package incorporates the changes described on page 94 of the Work Plan.
The only significant change was splitting the data curation program apart into
3 programs (main, lab, and cross-table). Please note that users who choose to
run the data curation programs in a stepwise fashion will have more output
files than those who do not (16 vs. 10, see page 20 of the Work Plan). All
users may experience a slight increase in the total elapsed time to run the
package since the cross-table queries were separated out. We encourage you to
run this package as soon as possible and contact us at dr...@pcornet.org if you
have any questions about the new design.
Responses that do not contain all of the above necessary files plus the signed
and dated checklist will not be reviewed.
Information about how to respond to file distribution queries can be found
here:
https://popmednet.atlassian.net/wiki/display/DOC/Executing+and+Responding+to+Requests#ExecutingandRespondingtoRequests-res_filemp
DataMarts
C11 - UPMC Claims DataMart NEW,
C12 - Allina Health Systems DataMart NEW,
C12 - Intermountain Healthcare DataMart NEW,
C12 - University of Michigan DataMart NEW,
C3 - University of Southern California- Partner Clinics DataMart NEW,
C3 - VA Informatics and Computing Infrastructure DataMart NEW,
C4 - University of Kansas Medical Center DataMart NEW,
C4 - University of Missouri DataMart NEW,
C5 - Kaiser Permanente Mid-Atlantic DataMart NEW,
C9 - Alliance CHS DataMart NEW,
C9 - NorthShore DataMart NEW,
C9 - University of Chicago Medical Center 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.
--- End Message ---
--- Begin Message ---
Dear Hillary Sandoval,
10/8/2018 12:08:48 PM EST
Here are your most recent New Request Submitted notifications from PCORnet DRN
Query Tool.
Allison Haufler has submitted a new QE File Distribution request
PROD_P02_DQA_FDPRO_DCQ_NSD1_c005_r011_q412 in project PCORnet.
Description
The purpose of the Data Curation Query Package v4.12 is to characterize the
data in 17 of the PCORnet Common Data Model (CDM) v4.1 tables, and to partially
characterize the data in the OBS_GEN and OBS_CLIN tables. The package consists
of a code errors query, a data curation query and an Empirical Data Curation
Report which summarizes key information from the query output and evaluates the
results against PCORnet’s Data Check v5. Output tables will be produced by
running SAS programs against static local DataMarts in PCORnet CDM v4.1 with
SAS data types.
Request Details
Request type: QE File Distribution
Request Name: PROD_P02_DQA_FDPRO_DCQ_NSD1_c005_r011_q412
Request ID: Request 3102
Project: PCORnet
Budget Item:
Source Item: P02
Request Due Date: 10/29/2018
Contact Person: Allison Haufler (allison.hauf...@duke.edu)
Priority: Medium
Purpose of Use:
Level of PHI Disclosure: Aggregated
Level of Report Aggregation:
Requester Center:
Workplan Type:
Additional Instructions
NOTE: A DataMart refresh must include at least 1 modification to the
previously approved data. If you have not made any changes, please decline
this query and specify why you are unable to respond in the comments field
This package incorporates the changes described on page 94 of the Work Plan.
The only significant change was splitting the data curation program apart into
3 programs (main, lab, and cross-table). Please note that users who choose to
run the data curation programs in a stepwise fashion will have more output
files than those who do not (16 vs. 10, see page 20 of the Work Plan). All
users may experience a slight increase in the total elapsed time to run the
package since the cross-table queries were separated out. We encourage you to
run this package as soon as possible and contact us at dr...@pcornet.org if you
have any questions about the new design.
Responses that do not contain all of the above necessary files plus the signed
and dated checklist will not be reviewed.
Information about how to respond to file distribution queries can be found
here:
https://popmednet.atlassian.net/wiki/display/DOC/Executing+and+Responding+to+Requests#ExecutingandRespondingtoRequests-res_filemp
DataMarts
C10 - ADVANCE DataMart NEW,
C7 - PEDSnet DataMart NEW,
C11 - Penn State Hershey Medical Center DataMart NEW,
C12 - Essentia Health DataMart NEW,
C2 - Health Sciences South Carolina DataMart NEW,
C3 - University of California San Diego DataMart NEW,
C4 - Indiana University Regenstrief DataMart NEW,
C4 - University of Nebraska Medical Center DataMart NEW,
C9 - Cook County 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.
--- End Message ---
--- Begin Message ---
Dear Hillary Sandoval,
10/8/2018 12:15:50 PM EST
Here are your most recent New Request Submitted notifications from PCORnet DRN
Query Tool.
Allison Haufler has submitted a new QE File Distribution request
PROD_P02_DQA_FDPRO_DCQ_NSD1_c005_r013_q412 in project PCORnet.
Description
The purpose of the Data Curation Query Package v4.12 is to characterize the
data in 17 of the PCORnet Common Data Model (CDM) v4.1 tables, and to partially
characterize the data in the OBS_GEN and OBS_CLIN tables. The package consists
of a code errors query, a data curation query and an Empirical Data Curation
Report which summarizes key information from the query output and evaluates the
results against PCORnet’s Data Check v5. Output tables will be produced by
running SAS programs against static local DataMarts in PCORnet CDM v4.1 with
SAS data types.
Request Details
Request type: QE File Distribution
Request Name: PROD_P02_DQA_FDPRO_DCQ_NSD1_c005_r013_q412
Request ID: Request 3104
Project: PCORnet
Budget Item:
Source Item: P02
Request Due Date: 10/29/2018
Contact Person: Allison Haufler (allison.hauf...@duke.edu)
Priority: Medium
Purpose of Use:
Level of PHI Disclosure: Aggregated
Level of Report Aggregation:
Requester Center:
Workplan Type:
Additional Instructions
NOTE: A DataMart refresh must include at least 1 modification to the
previously approved data. If you have not made any changes, please decline
this query and specify why you are unable to respond in the comments field
This package incorporates the changes described on page 94 of the Work Plan.
The only significant change was splitting the data curation program apart into
3 programs (main, lab, and cross-table). Please note that users who choose to
run the data curation programs in a stepwise fashion will have more output
files than those who do not (16 vs. 10, see page 20 of the Work Plan). All
users may experience a slight increase in the total elapsed time to run the
package since the cross-table queries were separated out. We encourage you to
run this package as soon as possible and contact us at dr...@pcornet.org if you
have any questions about the new design.
Responses that do not contain all of the above necessary files plus the signed
and dated checklist will not be reviewed.
Information about how to respond to file distribution queries can be found
here:
https://popmednet.atlassian.net/wiki/display/DOC/Executing+and+Responding+to+Requests#ExecutingandRespondingtoRequests-res_filemp
DataMarts
C13 - OneFlorida DataMart NEW,
C11 - Temple University DataMart NEW,
C3 - San Mateo DataMart NEW,
C3- University of California Los Angeles DataMart NEW,
C4 - University of Texas Health Sciences Center at San Antonio DataMart NEW,
C4 - University of Texas Southwestern Medical Center DataMart NEW,
C9 - Lurie Children's Hospital DataMart NEW,
C9 - Northwestern Medical 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.
--- End Message ---
--- Begin Message ---
Dear Hillary Sandoval,
10/15/2018 12:46:37 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
rcr_pmp3_wp003_nsd2_v01_2018 in project PCORnet.
Description
This query was requested by the Hepatitis C RCR and will identify a cohort of
patients with a diagnosis code for hepatitis C and examine lab tests of
interest including HCV genotype, HCV VL, and HCV antibody. The Cohort Quality
Assessment module will be used to examine lab values and variable population in
the defined hepatitis C cohort.
Requester: Hepatitis C RCR and PCORnet Coordinating Center
Recipients: DMs that have been approved on Data Curation Cycle 4 or 5 will
receive queries using PMP3 and/or CQA program packages moving forward. To see
the DMs receiving and responding to all queries, see Queries Tracker:
https://pcornet.imeetcentral.com/p/aQAAAAACxN3h
* Please note: This query is being issued to all PCORnet DataMarts, not
only those participating in the Hepatitis C RCR .
Planned Use:
Results will be provided to the Hepatitis C RCR to identify a cohort of
patients with a diagnosis code for hepatitis C and examine lab tests of
interest including HCV genotype, HCV VL, and HCV antibody. The Cohort Quality
Assessment module will be used to examine lab values and variable population in
the defined hepatitis C 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), 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: This request will identify counts of unique patients ages 18-88+
with:
• HCV_ONLY*: a hepatitis C diagnosis code in the query period of 1/1/2017 to
12/31/2017
All counts will be stratified by age, sex, race, and Hispanic.
*Cohort Quality Assessment will be conducted on HCV_ONLY.
Query Period: 1/1/2017 – 12/31/2017
Counts will be stratified by age group, sex, race, Hispanic. Query will execute
against SAS tables (Demographic, Encounter, Diagnosis, Lab_Result_CM) in
PCORnet CDM v 3.1 or v 4.1 format.
The cohort will then undergo characterization using the Cohort Quality
Assessment (CQA) reusable tool to assess lab variables of interest. Detailed
account of the checks to be performed by CQA can be found in the query’s
technical specifications located here:
https://pcornet.imeetcentral.com/p/ZgAAAAAApnlQ
Output: 1 SAS program will process 1 run & generate a total of 11 output files
(10 files in ‘drnoc’ & 1 file in ‘dmlocal’ folder).
Please note that PCORnet protocol is changing so that requests will no longer
default to saving the intermediary files needed to recreate the request in the
dmlocal folder; only the log file will be saved to the dmlocal folder. Moving
forward, queries which require data retention for future use will be indicated
in the workplan.
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.
Technical questions, contact q...@pcornet.org<mailto:q...@pcornet.org>.
Medical terminology code list questions, contact dr...@pcornet.org
Request Details
Request type: QE File Distribution
Request Name: rcr_pmp3_wp003_nsd2_v01_2018
Request ID: Request 3118
Project: PCORnet
Budget Item:
Source Item:
Request Due Date: 10/29/2018
Contact Person: Kshema Nagavedu (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 - 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 - 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 - 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 - 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 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,
C5 - Kaiser Permanente Northern California DataMart NEW,
C5 - Kaiser Permanente Southern California DataMart NEW,
C6 - Baylor Scott White North 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 - 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,
C8 - New York Genome Center DataMart Claims,
C6 - LSU DataMart
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.
--- End Message ---
_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
