ID

19274

Description

PCORnet Common Data Model (CDM) Harvest PCORnet Common Data Model (CDM) A patient-centered approach to building an agile research platform is at the heart of PCORnet, and data serves as the backbone. Considering the large number and diverse types of organizations that are part of PCORnet, we all benefit from having a streamlined, efficient way to use the data produced by these organizations. Enter the PCORnet Common Data Model. The Common Data Model (or CDM) is a way of organizing data into a standard structure. The approach PCORnet is using to do this mirrors the approaches used by other large national research consortia. Each PCORnet partner network maps data to the same consistent format (i.e., with the same variable name, attributes, and other metadata). By undertaking this step, we create a platform that enables much more rapid responses to research-related questions. Contrast this with having to transform and prepare data each time we want to ask a new research question, and the efficiencies become clear. The PCORnet CDM is based on the FDA Sentinel Initiative Common Data Model (www.sentinelsystem.org) and has been informed by other distributed initiatives such as the Health Care Systems Research Network, the Vaccine Safety Datalink, various AHRQ Distributed Research Network projects, and the ONC Standards & Interoperability Framework Query Health Initiative. The PCORnet CDM leverages standard terminologies and coding systems for healthcare (including ICD, SNOMED, CPT, HCPSC, and LOINC) to enable interoperability with and responsiveness to evolving data standards. The PCORnet CDM (like other parts of PCORnet) will grow and evolve. Version 1.0 focused on a set of data items that are frequently available. Subsequent versions build in additional data elements which are analytically important for patient-centered outcomes research and feasible to standardize across sites.

Link

www.sentinelsystem.org

Keywords

Versions (3)
  1. 12/17/16 12/17/16 -
  2. 7/17/19 7/17/19 -
  3. 3/30/20 3/30/20 -
Uploaded on

December 17, 2016

DOI

To request one please log in.

License

Creative Commons BY-NC 3.0
Model comments :

You can comment on the data model here. Via the speech bubbles at the itemgroups and items you can add comments to those specificially.

Back to model comments
Itemgroup comments for :

Item comments for :

In order to download data models you must be logged in. Please log in or register for free.

PCORnet Common Data Model (CDM) Harvest

English

PCORnet Common Data Model (CDM) Harvest

1 forms  
Harvest
Description

Harvest

Alias
UMLS CUI-1
C0596404
Network ID
Description

This identifier is assigned by the PCORnet Distributed Research Network Operations Center (DRN OC) (description updated in v3.1)

Data type

text

Alias
UMLS CUI [1]
C0596404
Network Name
Description

Descriptive name of the network. This identifier is assigned by the PCORnet Distributed Research Network Operations Center (DRN OC) (description updated in v3.1)

Data type

text

Alias
UMLS CUI [1]
C0596404
Datamart ID
Description

This identifier is assigned by the PCORnet Distributed Research Network Operations Center (DRN OC) (description updated in v3.1)

Data type

text

Alias
UMLS CUI [1]
C0596404
Datamart Name
Description

Descriptive name of the datamart. This identifier is assigned by the PCORnet Distributed Research Network Operations Center (DRN OC) (description updated in v3.1)

Data type

text

Alias
UMLS CUI [1]
C0596404
Datamart Platform
Description

Datamart Platform

Data type

text

Alias
UMLS CUI [1]
C0596404
CDM Version
Description

Version currently implemented within this datamart (for example, 1.0, 2.0, 3.0). Number precision and scale updated in v3.1.

Data type

float

Alias
UMLS CUI [1]
C0596404
Datamart Claims
Description

Datamart includes claims data source(s)

Data type

text

Alias
UMLS CUI [1]
C0596404
Datamart EHR
Description

Datamart includes EHR data source(s)

Data type

text

Alias
UMLS CUI [1]
C0596404
Birth Date MGMT
Description

Data management strategy currently present in the BIRTH_DATE field on the DEMOGRAPHIC table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Enr Start Date MGMT
Description

Data management strategy currently present in the ENR_START_DATE field on the ENROLLMENT table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Enr End Date MGMT
Description

Data management strategy currently present in the ENR_END_DATE field on the ENROLLMENT table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Admit Date MGMT
Description

Data management strategy currently present in the ADMIT_DATE field on the ENCOUNTER table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Discharge Date MGMT
Description

Data management strategy currently present in the DISCHARGE_DATE field on the ENCOUNTER table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
PX Date MGMT
Description

Data management strategy currently present in the PX_DATE field on the PROCEDURES table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
RX Order Date MGMT
Description

Data management strategy currently present in the RX_ORDER_DATE field on the PRESCRIBING table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
RX Start Date MGMT
Description

Data management strategy currently present in the RX_START_DATE field on the PRESCRIBING table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
RX End Date MGMT
Description

Data management strategy currently present in the RX_END_DATE field on the PRESCRIBING table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Dispense Date MGMT
Description

Data management strategy currently present in the DISPENSE_DATE field on the DISPENSING table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Lab Order Date MGMT
Description

Data management strategy currently present in the LAB_ORDER_DATE field on the LAB_RESULT_CM table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Specimen Date MGMT
Description

Data management strategy currently present in the SPECIMEN_DATE field on the LAB_RESULT_CM table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Result Date MGMT
Description

Data management strategy currently present in the RESULT_DATE field on the LAB_RESULT_CM table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Measure Date MGMT
Description

Data management strategy currently present in the MEASURE_DATE field on the VITAL table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Onset Date MGMT
Description

Data management strategy currently present in the ONSET_DATE field on the CONDITION table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Report Date MGMT
Description

Data management strategy currently present in the REPORT_DATE field on the CONDITION table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
Resolve Date MGMT
Description

Data management strategy currently present in the RESOLVE_DATE field on the CONDITION table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
PRO Date MGMT
Description

Data management strategy currently present in the PRO_DATE field on the PRO_CM table. Please see notes for additional definitions.

Data type

text

Alias
UMLS CUI [1]
C0596404
REFRESH Demographic Date
Description

Most recent date on which the present data were loaded into the DEMOGRAPHIC table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH Enrollment Date
Description

Most recent date on which the present data were loaded into the ENROLLMENT table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH Encounter Date
Description

Most recent date on which the present data were loaded into the ENCOUNTER table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH Diagnosis Date
Description

Most recent date on which the present data were loaded into the DIAGNOSIS table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH Procedures Date
Description

Most recent date on which the present data were loaded into the PROCEDURES table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH Vital Date
Description

Most recent date on which the present data were loaded into the VITAL table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH Dispensing Date
Description

Most recent date on which the present data were loaded into the DISPENSING table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH Lab Result CM Date
Description

Most recent date on which the present data were loaded into the LAB_RESULT_CM table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH Condition Date
Description

Most recent date on which the present data were loaded into the CONDITION table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH PRO CM Date
Description

Most recent date on which the present data were loaded into the PRO_CM table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH Prescribing Date
Description

Most recent date on which the present data were loaded into the PRESCRIBING table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH PCORNET Trial Date
Description

Most recent date on which the present data were loaded into the PCORNET_TRIAL table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH Death Date
Description

Most recent date on which the present data were loaded into the DEATH table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
REFRESH Death Cause Date
Description

Most recent date on which the present data were loaded into the DEATH_CAUSE table. This date should be null if the table does not have records.

Data type

date

Alias
UMLS CUI [1]
C0596404
Back to the top of the page

Similar models

PCORnet Common Data Model (CDM) Harvest

1 forms
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Harvest
C0596404 (UMLS CUI-1)
Network ID
Item
Network ID
text
C0596404 (UMLS CUI [1])
Network Name
Item
Network Name
text
C0596404 (UMLS CUI [1])
Datamart ID
Item
Datamart ID
text
C0596404 (UMLS CUI [1])
Datamart Name
Item
Datamart Name
text
C0596404 (UMLS CUI [1])
Item
Datamart Platform
text
C0596404 (UMLS CUI [1])
Datamart Platform
Code List
Datamart Platform
CL Item
SQL Server (01)
CL Item
Oracle (02)
CL Item
PostgreSQL (03)
CL Item
MySQL (04)
CL Item
SAS (05)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
CDM Version
Item
CDM Version
float
C0596404 (UMLS CUI [1])
Item
Datamart Claims
text
C0596404 (UMLS CUI [1])
Datamart Claims
Code List
Datamart Claims
CL Item
Not present (01)
CL Item
Present (02)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Datamart EHR
text
C0596404 (UMLS CUI [1])
Datamart EHR
Code List
Datamart EHR
CL Item
Not present (01)
CL Item
Present (02)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Birth Date MGMT
text
C0596404 (UMLS CUI [1])
Birth Date MGMT
Code List
Birth Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Enr Start Date MGMT
text
C0596404 (UMLS CUI [1])
Enr Start Date MGMT
Code List
Enr Start Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Enr End Date MGMT
text
C0596404 (UMLS CUI [1])
Enr End Date MGMT
Code List
Enr End Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Admit Date MGMT
text
C0596404 (UMLS CUI [1])
Admit Date MGMT
Code List
Admit Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Discharge Date MGMT
text
C0596404 (UMLS CUI [1])
Discharge Date MGMT
Code List
Discharge Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
PX Date MGMT
text
C0596404 (UMLS CUI [1])
PX Date MGMT
Code List
PX Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
RX Order Date MGMT
text
C0596404 (UMLS CUI [1])
RX Order Date MGMT
Code List
RX Order Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
RX Start Date MGMT
text
C0596404 (UMLS CUI [1])
RX Start Date MGMT
Code List
RX Start Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
RX End Date MGMT
text
C0596404 (UMLS CUI [1])
RX End Date MGMT
Code List
RX End Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Dispense Date MGMT
text
C0596404 (UMLS CUI [1])
Dispense Date MGMT
Code List
Dispense Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Lab Order Date MGMT
text
C0596404 (UMLS CUI [1])
Lab Order Date MGMT
Code List
Lab Order Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Specimen Date MGMT
text
C0596404 (UMLS CUI [1])
Specimen Date MGMT
Code List
Specimen Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Result Date MGMT
text
C0596404 (UMLS CUI [1])
Result Date MGMT
Code List
Result Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Measure Date MGMT
text
C0596404 (UMLS CUI [1])
Measure Date MGMT
Code List
Measure Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Onset Date MGMT
text
C0596404 (UMLS CUI [1])
Onset Date MGMT
Code List
Onset Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Report Date MGMT
text
C0596404 (UMLS CUI [1])
Report Date MGMT
Code List
Report Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Resolve Date MGMT
text
C0596404 (UMLS CUI [1])
Resolve Date MGMT
Code List
Resolve Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
PRO Date MGMT
text
C0596404 (UMLS CUI [1])
PRO Date MGMT
Code List
PRO Date MGMT
CL Item
No imputation or obfuscation (01)
CL Item
Imputation for incomplete dates (02)
CL Item
Date obfuscation (03)
CL Item
Both imputation and obfuscation (04)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
REFRESH Demographic Date
Item
REFRESH Demographic Date
date
C0596404 (UMLS CUI [1])
REFRESH Enrollment Date
Item
REFRESH Enrollment Date
date
C0596404 (UMLS CUI [1])
REFRESH Encounter Date
Item
REFRESH Encounter Date
date
C0596404 (UMLS CUI [1])
REFRESH Diagnosis Date
Item
REFRESH Diagnosis Date
date
C0596404 (UMLS CUI [1])
REFRESH Procedures Date
Item
REFRESH Procedures Date
date
C0596404 (UMLS CUI [1])
REFRESH Vital Date
Item
REFRESH Vital Date
date
C0596404 (UMLS CUI [1])
REFRESH Dispensing Date
Item
REFRESH Dispensing Date
date
C0596404 (UMLS CUI [1])
REFRESH Lab Result CM Date
Item
REFRESH Lab Result CM Date
date
C0596404 (UMLS CUI [1])
REFRESH Condition Date
Item
REFRESH Condition Date
date
C0596404 (UMLS CUI [1])
REFRESH PRO CM Date
Item
REFRESH PRO CM Date
date
C0596404 (UMLS CUI [1])
REFRESH Prescribing Date
Item
REFRESH Prescribing Date
date
C0596404 (UMLS CUI [1])
REFRESH PCORNET Trial Date
Item
REFRESH PCORNET Trial Date
date
C0596404 (UMLS CUI [1])
REFRESH Death Date
Item
REFRESH Death Date
date
C0596404 (UMLS CUI [1])
REFRESH Death Cause Date
Item
REFRESH Death Cause Date
date
C0596404 (UMLS CUI [1])
Back to the top of the page 

Contact

Please use this form for feedback, questions and suggestions for improvements.

Fields marked with * are required.

Help

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial