ID

19182

Description

PCORnet Common Data Model (CDM) Diagnosis 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/1/19 7/1/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) Diagnosis

English

PCORnet Common Data Model (CDM) Diagnosis

1 forms  
Diagnosis
Description

Diagnosis

Alias
UMLS CUI-1
C0011900
Diagnosis 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]
C0011900
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 the ENCOUNTER table for definitions.

Data type

date

Alias
UMLS CUI [1,1]
C0030673
UMLS CUI [1,2]
C0011008
Provider ID
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]
C0807500
UMLS CUI [1,2]
C1300638
DX
Description

Diagnosis code. Some codes will contain leading zeroes, and different levels of decimal precision may also be present. This field is a character field, not numeric, to accommodate these coding conventions. (Description updated in v3.1.)

Data type

text

Alias
UMLS CUI [1]
C1550350
DX Type
Description

Diagnosis code type. We provide values for ICD and SNOMED code types. Other code types will be added as new terminologies are more widely used. Please note: The “Other” category is meant to identify internal use ontologies and codes.

Data type

text

Alias
UMLS CUI [1,1]
C1550350
UMLS CUI [1,2]
C0332307
UMLS CUI [2]
C2598420
UMLS CUI [3]
C1136257
DX Source
Description

Classification of diagnosis source. We include these categories to allow some flexibility in implementation. The context is to capture available diagnoses recorded during a specific encounter.

Data type

text

Alias
UMLS CUI [1,1]
C1550350
UMLS CUI [1,2]
C0449416
DX Origin
Description

Source of the diagnosis information. Billing pertains 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. New field added in v3.1.

Data type

text

Alias
UMLS CUI [1,1]
C1550350
UMLS CUI [1,2]
C0449689
PDX
Description

Principal discharge diagnosis flag.

Data type

text

Alias
UMLS CUI [1,1]
C0030685
UMLS CUI [1,2]
C0011900
RAW DX
Description

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

Data type

text

Alias
UMLS CUI [1]
C1550350
RAW DX 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]
C1550350
UMLS CUI [1,2]
C0332307
UMLS CUI [2]
C2598420
UMLS CUI [3]
C1136257
RAW DX Source
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]
C1550350
UMLS CUI [1,2]
C0449416
RAW PDX
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]
C0030685
UMLS CUI [1,2]
C0011900
Back to the top of the page

Similar models

PCORnet Common Data Model (CDM) Diagnosis

1 forms
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Diagnosis
C0011900 (UMLS CUI-1)
Diagnosis ID
Item
Diagnosis ID
integer
C0011900 (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
C0030673 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
Provider ID
Item
Provider ID
text
C0807500 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
DX
Item
DX
text
C1550350 (UMLS CUI [1])
Item
DX Type
text
C1550350 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C2598420 (UMLS CUI [2])
C1136257 (UMLS CUI [3])
DX Type
Code List
DX Type
CL Item
ICD-9-CM (09)
CL Item
ICD-10-CM  (10)
CL Item
ICD-11-CM (11)
CL Item
SNOMED CT  (SM)
CL Item
No information  (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
DX Source
text
C1550350 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
DX Source
Code List
DX Source
CL Item
Admitting  (AD)
CL Item
Discharge  (DI)
CL Item
Final (FI)
CL Item
Interim  (IN)
CL Item
No information  (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
DX Origin
text
C1550350 (UMLS CUI [1,1])
C0449689 (UMLS CUI [1,2])
DX Origin
Code List
DX Origin
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)
Item
PDX
text
C0030685 (UMLS CUI [1,1])
C0011900 (UMLS CUI [1,2])
PDX
Code List
PDX
CL Item
Principal (P)
CL Item
Secondary (S)
CL Item
Unable to Classify (X)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
RAW DX
Item
RAW DX
text
C1550350 (UMLS CUI [1])
RAW DX Type
Item
RAW DX Type
text
C1550350 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C2598420 (UMLS CUI [2])
C1136257 (UMLS CUI [3])
RAW DX Source
Item
RAW DX Source
text
C1550350 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
RAW PDX
Item
RAW PDX
text
C0030685 (UMLS CUI [1,1])
C0011900 (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