ID

19200

Description

PCORnet Common Data Model (CDM) Condition 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

  1. 12/12/16 12/12/16 -
  2. 7/1/19 7/1/19 -
  3. 3/30/20 3/30/20 -
Uploaded on

December 12, 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.

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) Condition

PCORnet Common Data Model (CDM) Condition

Condition
Description

Condition

Alias
UMLS CUI-1
C0012634
UMLS CUI-2
C0011900
UMLS CUI-3
C0348080
Condition 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]
C0012634
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. This is an optional field, and should only be populated if the lab was collected as part of a healthcare encounter.

Data type

text

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1300638
Report Date
Description

Date condition was noted, which may be the date when it was recorded by a provider or nurse, or the date on which the patient reported it. Please note that this date may not correspond to onset date.

Data type

date

Alias
UMLS CUI [1,1]
C0011008
UMLS CUI [1,2]
C0012634
UMLS CUI [1,3]
C0011900
Resolve Date
Description

Date condition was resolved, if resolution of a transient condition has been achieved. A resolution date is not generally expected for chronic conditions, even if the condition is managed.

Data type

date

Alias
UMLS CUI [1,1]
C1709863
UMLS CUI [1,2]
C0011008
UMLS CUI [1,3]
C0012634
Onset Date
Description

The onset date concept here refers to "the date and time when problem (illness, disorder, or symptom) started" (ONC:MU Clinical Data Set, caDSR 4973971). This is a different concept than report date, which is the date on which the medical status was collected. An onset date should generally be considered independently of the observer or provider. However, the judgment of when a condition "started" depends on the disease, the frequency of visits, and many other factors. It is not clear that any facility or physician employs this field in a manner which can be trusted without validation during analysis. (New definition added in v3.1.)

Data type

date

Alias
UMLS CUI [1]
C0574845
UMLS CUI [2,1]
C0011008
UMLS CUI [2,2]
C0012634
Condition Status
Description

Condition status corresponding with REPORT_DATE.

Data type

text

Alias
UMLS CUI [1,1]
C0012634
UMLS CUI [1,2]
C0449438
UMLS CUI [2]
C3176928
Condition
Description

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. Please populate the exact value of this diagnosis code, but remove any source-specific suffixes and prefixes. (Description updated in v3.1.)

Data type

text

Alias
UMLS CUI [1,1]
C0012634
UMLS CUI [1,2]
C0805701
UMLS CUI [2,1]
C0348080
UMLS CUI [2,2]
C0805701
Condition Type
Description

Condition code type. Please note: The “Other” category is meant to identify internal use ontologies and codes. Value set items updated to reference both the Clinical Modification (CM) and the Procedure Coding (PCS) context for ICD-9, ICD-10, and ICD-11 (update made in v3.1).

Data type

text

Alias
UMLS CUI [1,1]
C0012634
UMLS CUI [1,2]
C0805701
UMLS CUI [1,3]
C0332307
UMLS CUI [2]
C2598420
Condition Source
Description

Please note: The “Patient-reported” category can include reporting by a proxy, such as patient’s family or guardian.

Data type

text

Alias
UMLS CUI [1,1]
C0449416
UMLS CUI [1,2]
C0012634
Raw Condition Status
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]
C0012634
UMLS CUI [1,2]
C0449438
Raw Condition
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]
C0012634
UMLS CUI [1,2]
C0805701
Raw Condition 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]
C0012634
UMLS CUI [1,2]
C0805701
UMLS CUI [1,3]
C0332307
Raw Condition 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]
C0449416
UMLS CUI [1,2]
C0012634

Similar models

PCORnet Common Data Model (CDM) Condition

Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Condition
C0012634 (UMLS CUI-1)
C0011900 (UMLS CUI-2)
C0348080 (UMLS CUI-3)
Condition ID
Item
Condition ID
integer
C0012634 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Patient ID
Item
Patient ID
integer
C2348585 (UMLS CUI [1])
Encounter ID
Item
Encounter ID
text
C1512346 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Report Date
Item
Report Date
date
C0011008 (UMLS CUI [1,1])
C0012634 (UMLS CUI [1,2])
C0011900 (UMLS CUI [1,3])
Resolve Date
Item
Resolve Date
date
C1709863 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
C0012634 (UMLS CUI [1,3])
Onset Date
Item
Onset Date
date
C0574845 (UMLS CUI [1])
C0011008 (UMLS CUI [2,1])
C0012634 (UMLS CUI [2,2])
Item
Condition Status
text
C0012634 (UMLS CUI [1,1])
C0449438 (UMLS CUI [1,2])
C3176928 (UMLS CUI [2])
Code List
Condition Status
CL Item
Active (AC)
CL Item
Resolved (RS)
CL Item
Inactive (IN)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Condition
Item
Condition
text
C0012634 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
C0348080 (UMLS CUI [2,1])
C0805701 (UMLS CUI [2,2])
Item
Condition Type
text
C0012634 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
C0332307 (UMLS CUI [1,3])
C2598420 (UMLS CUI [2])
Code List
Condition Type
CL Item
ICD-9-CM/PCS (09)
CL Item
ICD-10-CM/PCS (10)
CL Item
ICD-11-CM/PCS (11)
CL Item
SNOMED CT (SM)
CL Item
Human Phenotype Ontology (HP)
CL Item
Algorithmic (AG)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Condition Source
text
C0449416 (UMLS CUI [1,1])
C0012634 (UMLS CUI [1,2])
Code List
Condition Source
CL Item
Patient-reported medical history (PR)
CL Item
Healthcare problem list (HC)
CL Item
Registry cohort (RG)
CL Item
PCORnet-defined condition algorithm (PC)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Raw Condition Status
Item
Raw Condition Status
text
C0012634 (UMLS CUI [1,1])
C0449438 (UMLS CUI [1,2])
Raw Condition
Item
Raw Condition
text
C0012634 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
Raw Condition Type
Item
Raw Condition Type
text
C0012634 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
C0332307 (UMLS CUI [1,3])
Raw Condition Source
Item
Raw Condition Source
text
C0449416 (UMLS CUI [1,1])
C0012634 (UMLS CUI [1,2])

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

Fields marked with * are required.

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