ID

19183

Description

PCORnet Common Data Model (CDM) Procedures 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/10/16 12/10/16 -
  2. 7/2/19 7/2/19 -
  3. 3/30/20 3/30/20 -
Uploaded on

December 10, 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) Procedures

English

PCORnet Common Data Model (CDM) Procedures

1 forms  
Procedures
Description

Procedures

Alias
UMLS CUI-1
C2700391
Procedures ID
Description

Arbitrary identifier for each unique record. Does not need to be persistent across refreshes, and may be created by methods such as sequence or GUID.

Data type

integer

Alias
UMLS CUI [1,1]
C2700391
UMLS CUI [1,2]
C1300638
Patient ID
Description

Arbitrary person-level identifier. Used to link across tables.

Data type

integer

Alias
UMLS CUI [1]
C2348585
Encounter ID
Description

Arbitrary encounter-level identifier. Used to link across tables.

Data type

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1300638
Encounter Type
Description

Please note: This is a field replicated from the ENCOUNTER table. See the ENCOUNTER table for definitions.

Data type

text

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C0332307
Admit Date
Description

Please note: This is a field replicated from the ENCOUNTER table. See ENCOUNTER table for definitions.

Data type

date

Alias
UMLS CUI [1]
C0011008
Provider ID
Description

Please note: This is a field replicated from the ENCOUNTER table. See ENCOUNTER table for definitions.

Data type

text

Alias
UMLS CUI [1,1]
C0807500
UMLS CUI [1,2]
C1300638
PX Date
Description

Date the procedure was performed.

Data type

date

Alias
UMLS CUI [1,1]
C2700391
UMLS CUI [1,2]
C0011008
PX
Description

Procedure code.

Data type

integer

Alias
UMLS CUI [1]
C1550373
PX Type
Description

Procedure code type. We include a number of code types for flexibility, but the basic requirement that the code refer to a medical procedure remains. Revenue codes are a standard concept in Medicare billing and can be useful for defining care settings. If those codes are available they can be included. Medications administered by clinicians can be captured in billing data and Electronic Health Records (EHRs) as HCPCS procedure codes. Administration (infusion) of chemotherapy is an example. We are now seeing NDCs captured as part of procedures because payers are demanding it for payment authorization. Inclusion of this code type enables those data partners that capture the NDC along with the procedure to include the data. Please note: The “Other” category is meant to identify internal use ontologies and codes. Value set modified in v3.1 to combine CPT and HCPCS codes into one category; also, ICD-9 value set item typo corrected to ICD-9-PCS.

Data type

text

Alias
UMLS CUI [1,1]
C1550373
UMLS CUI [1,2]
C0332307
PX Source
Description

Source of the procedure information. Order and billing pertain to internal healthcare processes and data sources. Claim pertains to data from the bill fulfillment, generally data sources held by insurers and other health plans. Length of data types updated in v3.1.

Data type

text

Alias
UMLS CUI [1,1]
C1550373
UMLS CUI [1,2]
C0449416
RAW PX
Description

Optional field for originating value of field, prior to mapping into the PCORnet CDM value set.

Data type

text

Alias
UMLS CUI [1]
C1550373
RAW PX Type
Description

Optional field for originating value of field, prior to mapping into the PCORnet CDM value set.

Data type

text

Alias
UMLS CUI [1,1]
C1550373
UMLS CUI [1,2]
C0332307
Back to the top of the page

Similar models

PCORnet Common Data Model (CDM) Procedures

1 forms
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Procedures
C2700391 (UMLS CUI-1)
Procedures ID
Item
Procedures ID
integer
C2700391 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Patient ID
Item
Patient ID
integer
C2348585 (UMLS CUI [1])
Encounter ID
Item
Encounter ID
integer
C1512346 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Item
Encounter Type
text
C1512346 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
Encounter Type
Code List
Encounter Type
CL Item
Ambulatory Visit (AV)
CL Item
Emergency Department  (ED)
CL Item
Emergency Department Admit to Inpatient Hospital Stay (permissible substitution)  (EI)
CL Item
Inpatient Hospital Stay  (IP)
CL Item
Non-Acute Institutional Stay  (IS)
CL Item
Observation Stay (OS)
CL Item
Institutional Professional Consult (permissible substitution) (IC)
CL Item
Other Ambulatory Visit  (OA)
CL Item
No information  (NI)
CL Item
Unknown  (UN)
CL Item
Other (OT)
Admit Date
Item
Admit Date
date
C0011008 (UMLS CUI [1])
Provider ID
Item
Provider ID
text
C0807500 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
PX Date
Item
PX Date
date
C2700391 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
PX
Item
PX
integer
C1550373 (UMLS CUI [1])
Item
PX Type
text
C1550373 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
PX Type
Code List
PX Type
CL Item
ICD-9-PCS (09)
CL Item
ICD-10-PCS (10)
CL Item
ICD-11-PCS (11)
CL Item
CPT or HCPCS (CH)
CL Item
LOINC; ND=NDC (LC)
CL Item
Revenue (RE)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
PX Source
text
C1550373 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
PX Source
Code List
PX Source
CL Item
Order (OD)
CL Item
Billing (BI)
CL Item
Claim (CL)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
RAW PX
Item
RAW PX
text
C1550373 (UMLS CUI [1])
RAW PX Type
Item
RAW PX Type
text
C1550373 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
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