ID

37065

Description

PCORnet Common Data Model (CDM) Condition This table includes both healthcare and non-healthcare settings. Rollback or voided transactions and other adjustments should be processed (removed) before populating this table. A condition represents a patient’s diagnosed and self-reported health conditions and diseases. The patient’s medical history and current state may both be represented. PCORnet Common Data Model (CDM) The PCORnet Common Data Model (CDM) is a specification that defines a standard organization and representationof data for the PCORnet Distributed Research Network. The PCORnet CDM is a key component of the PCORnet Distributed Research Network (DRN) infrastructure. http://www.pcornet.org/pcornet-common-data-model/

Link

http://www.pcornet.org/pcornet-common-data-model/

Keywords

Versions (3)
  1. 12/12/16 12/12/16 -
  2. 7/1/19 7/1/19 -
  3. 3/30/20 3/30/20 -
Copyright Holder

PCORnet

Uploaded on

July 1, 2019

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)

English

Condition V4.1

1 forms  
  1. StudyEvent: ODM
    1. Condition V4.1
Condition
Description

Condition

Alias
UMLS CUI-1
C0012634
UMLS CUI-2
C0011900
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

text

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

Arbitrary person-level identifier. Used to link across tables. All PATIDs in this table must be present in the DEMOGRAPHIC table.

Data type

integer

Alias
UMLS CUI [1]
C2348585
Encounter ID
Description

Arbitrary encounter-level identifier used to link across tables. This should only be populated if the item was collected as part of a healthcare encounter. If more than one encounter association is present, this field should be populated with the ID of the encounter when the condition was first entered into the system. However, please note that many conditions may be recorded outside of an encounter context. All ENCOUNTERIDs in this table must also be present in the ENCOUNTER table.

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]
C0684224
UMLS CUI [1,2]
C0348080
UMLS CUI [1,3]
C0011008
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,1]
C0574845
UMLS CUI [1,2]
C0012634
Condition Status
Description

Condition status corresponding with REPORT_DATE. The value of IN=Inactive may be used in situations where a condition is not resolved, but is not currently active (for example, psoriasis).

Data type

text

Alias
UMLS CUI [1,1]
C0012634
UMLS CUI [1,2]
C0449438
Condition Code
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.

Data type

text

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

Condition code type. Please note: The “Other” category is meant to identify internal use ontologies and codes.

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. “Registry cohort” generally refers to cohorts of patients flagged with a certain set of characteristics for management within a health system. “Patient-reported” can include self-reported medical history and/or current medical conditions, not captured via healthcare problem lists or registry cohorts. This field is a derived attribute, and is not expected to be an explicit data field within a source system

Data type

text

Alias
UMLS CUI [1,1]
C0449416
UMLS CUI [1,2]
C0012634
Raw Condition Status
Description

Field for originating value, prior to mapping into the PCORnet CDM value set.

Data type

text

Alias
UMLS CUI [1,1]
C0012634
UMLS CUI [1,2]
C0449438
UMLS CUI [1,3]
C0205313
Raw Condition
Description

Field for originating value, 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]
C0205313
Raw Condition Type
Description

Field for originating value, 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
UMLS CUI [1,4]
C0205313
Raw Condition Source
Description

Field for originating value, prior to mapping into the PCORnet CDM value set.

Data type

text

Alias
UMLS CUI [1,1]
C0449416
UMLS CUI [1,2]
C0012634
UMLS CUI [1,3]
C0205313
Back to the top of the page

Similar models

Condition V4.1

1 forms
  1. StudyEvent: ODM
    1. Condition V4.1
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Condition
C0012634 (UMLS CUI-1)
C0011900 (UMLS CUI-2)
Condition ID
Item
Condition ID
text
C0348080 (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
C0684224 (UMLS CUI [1,1])
C0348080 (UMLS CUI [1,2])
C0011008 (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,1])
C0012634 (UMLS CUI [1,2])
Item
Condition Status
text
C0012634 (UMLS CUI [1,1])
C0449438 (UMLS CUI [1,2])
Condition Status
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 Code
text
C0012634 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
Item
Condition Type
text
C0012634 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
C0332307 (UMLS CUI [1,3])
C2598420 (UMLS CUI [2])
Condition Type
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])
Condition Source
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])
C0205313 (UMLS CUI [1,3])
Raw Condition
Item
Raw Condition
text
C0012634 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
C0205313 (UMLS CUI [1,3])
Raw Condition Type
Item
Raw Condition Type
text
C0012634 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
C0332307 (UMLS CUI [1,3])
C0205313 (UMLS CUI [1,4])
Raw Condition Source
Item
Raw Condition Source
text
C0449416 (UMLS CUI [1,1])
C0012634 (UMLS CUI [1,2])
C0205313 (UMLS CUI [1,3])
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