ID

19197

Description

PCORnet Common Data Model (CDM) Lab Result CM 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 (4)
  1. 12/12/16 12/12/16 -
  2. 7/22/19 7/22/19 -
  3. 3/30/20 3/30/20 -
  4. 9/20/21 9/20/21 -
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.

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) Lab Result CM

English

PCORnet Common Data Model (CDM) Lab Result CM

1 forms  
Lab Result CM
Description

Lab Result CM

Alias
UMLS CUI-1
C1254595
UMLS CUI-2
C0022885
Lab Result CM ID
Description

Arbitrary identifier for each unique LAB_RESULT_CM 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]
C1254595
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
Lab Name
Description

Laboratory result common measure, a categorical identification for the type of test, which is harmonized across all contributing data partners. Please note that it is possible for more than one LOINC® code, CPT code, and/or local code to be associated with one LAB_NAME.

Data type

text

Alias
UMLS CUI [1,1]
C0022885
UMLS CUI [1,2]
C0027365
Specimen Source
Description

Specimen source. All records will have a specimen source; some tests have several possible values for SPECIMEN_SOURCE. Please see the Implementation Guidance for additional details. (Description updated for v3.1.)

Data type

text

Alias
UMLS CUI [1,1]
C0449416
UMLS CUI [1,2]
C0370003
Lab LOINC
Description

Logical Observation Identifiers, Names, and Codes (LOINC®) from the Regenstrief Institute. Results with local versions of LOINC codes (e.g., LOINC candidate codes) should be included in the RAW_ table field, but the LOINC variable should be set to missing. Current LOINC codes are from 3-7 characters long but Regenstrief suggests a length of 10 for future growth. The last digit of the LOINC code is a check digit and is always preceded by a hyphen. All parts of the LOINC code, including the hyphen, must be included. Do not pad the LOINC code with leading zeros.

Data type

text

Alias
UMLS CUI [1,1]
C1136323
UMLS CUI [1,2]
C0022885
Priority
Description

Immediacy of test. The intent of this variable is to determine whether the test was obtained as part of routine care or as an emergent/urgent diagnostic test (designated as Stat or Expedite).

Data type

text

Alias
UMLS CUI [1,1]
C0549179
UMLS CUI [1,2]
C0022885
Result Loc
Description

Location of the test result. Point of Care locations may include anticoagulation clinic, newborn nursery, finger stick in provider office, or home. The default value is ‘L’ unless the result is Point of Care. There should not be any missing values.

Data type

text

Alias
UMLS CUI [1,1]
C1254595
UMLS CUI [1,2]
C0450429
lab PX
Description

Optional variable for local and standard procedure codes, used to identify the originating order for the lab test.

Data type

integer

Alias
UMLS CUI [1,1]
C0022885
UMLS CUI [1,2]
C0805701
Lab PX Type
Description

Procedure code type, if applicable. Value set modified in v3.1 to combine CPT and HCPCS codes into one category; also, ICD-9 value set item typo corrected to specify ICD-9-PCS.

Data type

text

Alias
UMLS CUI [1,1]
C0022885
UMLS CUI [1,2]
C0805701
UMLS CUI [1,3]
C0332307
Lab Order Date
Description

Date test was ordered.

Data type

date

Alias
UMLS CUI [1,1]
C0011008
UMLS CUI [1,2]
C0022885
UMLS CUI [1,3]
C1272683
Specimen Date
Description

Date specimen was collected.

Data type

date

Alias
UMLS CUI [1,1]
C0370003
UMLS CUI [1,2]
C1516698
UMLS CUI [1,3]
C0011008
Specimen Time
Description

Time specimen was collected.

Data type

time

Alias
UMLS CUI [1,1]
C0370003
UMLS CUI [1,2]
C1516698
UMLS CUI [1,3]
C0040223
Result Date
Description

Result Date.

Data type

date

Alias
UMLS CUI [1,1]
C1254595
UMLS CUI [1,2]
C0011008
Result Time
Description

Result Time.

Data type

time

Alias
UMLS CUI [1,1]
C1254595
UMLS CUI [1,2]
C0040223
Result Qual
Description

Standardized result for qualitative results. This variable should be NI for quantitative results. Please see the Implementation Guidance for additional details and information on acceptable values for each qualitative LAB_NAME (description updated in v3.1).

Data type

text

Alias
UMLS CUI [1,1]
C1254595
UMLS CUI [1,2]
C0332306
Result Num
Description

Standardized/converted result for quantitative results. Please see the Implementation Guidance for additional details (description updated for v3.1). v3.1 modification: SAS data type corrected to Numeric. Number precision and scale updated in v3.1.

Data type

float

Alias
UMLS CUI [1,1]
C1254595
UMLS CUI [1,2]
C0392762
Result Modifier
Description

Modifier for result values.

Data type

text

Alias
UMLS CUI [1,1]
C1254595
UMLS CUI [1,2]
C1515926
Result Unit
Description

Converted/standardized units for the result. Please see the Implementation Guidance for additional details (description updated in v3.1).

Data type

text

Alias
UMLS CUI [1,1]
C1254595
UMLS CUI [1,2]
C1519795
Norm Range Low
Description

Lower bound of the normal range assigned by the laboratory. Value should only contain the value of the lower bound. The symbols >, <, >=, <= should be removed. For example, if the normal range for a test is >100 and <300, then "100" should be entered.

Data type

float

Alias
UMLS CUI [1,1]
C0086715
UMLS CUI [1,2]
C1254595
Norm Modifier Low
Description

Modifier for NORM_RANGE_LOW values. For numeric results one of the following needs to be true: 1) Both MODIFIER_LOW and MODIFIER_HIGH contain EQ (e.g. normal values fall in the range 3-10) 2) MODIFIER_LOW contains GT or GE and MODIFIER_HIGH contains NO (e.g. normal values are >3 with no upper boundary) 3) MODIFIER_HIGH contains LT or LE and MODIFIER_LOW contains NO (e.g. normal values are <=10 with no lower boundary)

Data type

text

Alias
UMLS CUI [1,1]
C0086715
UMLS CUI [1,2]
C1254595
Norm Range High
Description

Upper bound of the normal range assigned by the laboratory. Value should only contain the value of the upper bound. The symbols >, <, >=, <= should be removed. For example, if the normal range for a test is >100 and <300, then "300" should be entered.

Data type

float

Alias
UMLS CUI [1,1]
C0086715
UMLS CUI [1,2]
C1254595
Norm Modifier High
Description

Modifier for NORM_RANGE_HIGH values. For numeric results one of the following needs to be true: 1) Both MODIFIER_LOW and MODIFIER_HIGH contain EQ (e.g. normal values fall in the range 3-10) 2) MODIFIER_LOW contains GT or GE and MODIFIER_HIGH contains NO (e.g. normal values are >3 with no upper boundary) 3) MODIFIER_HIGH contains LT or LE and MODIFIER_LOW contains NO (e.g. normal values are <=10 with no lower boundary)

Data type

text

Alias
UMLS CUI [1,1]
C0086715
UMLS CUI [1,2]
C1254595
ABN IND
Description

Abnormal result indicator. This value comes from the source data; do not apply logic to create it.

Data type

text

Alias
UMLS CUI [1,1]
C1254595
UMLS CUI [1,2]
C1704258
UMLS CUI [1,3]
C1522602
Raw Lab Name
Description

Local name related to an individual lab test.

Data type

text

Alias
UMLS CUI [1,1]
C0022885
UMLS CUI [1,2]
C0027365
Raw Lab Code
Description

Local code related to an individual lab test.

Data type

integer

Alias
UMLS CUI [1,1]
C0022885
UMLS CUI [1,2]
C0805701
Raw Panel
Description

Local code related to a battery or panel of lab tests.

Data type

integer

Alias
UMLS CUI [1,1]
C1999270
UMLS CUI [1,2]
C0022885
UMLS CUI [1,3]
C0805701
Raw Result
Description

The original test result value as seen in your source data. Values may include a decimal point, a sign or text (e.g., POSITIVE, NEGATIVE, DETECTED). The symbols >, <, >=, <= should be removed from the value and stored in the Modifier variable instead.

Data type

float

Alias
UMLS CUI [1]
C2826772
Raw Unit
Description

Original units for the result in your source data.

Data type

text

Alias
UMLS CUI [1,1]
C1254595
UMLS CUI [1,2]
C1519795
Raw Order Dept
Description

Local code for ordering provider department.

Data type

text

Alias
UMLS CUI [1,1]
C1704729
UMLS CUI [1,2]
C0022885
UMLS CUI [1,3]
C1272683
Raw Facility Code
Description

Local facility code that identifies the hospital or clinic. Taken from facility claims.

Data type

text

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

Similar models

PCORnet Common Data Model (CDM) Lab Result CM

1 forms
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Lab Result CM
C1254595 (UMLS CUI-1)
C0022885 (UMLS CUI-2)
Lab Result CM ID
Item
Lab Result CM ID
integer
C1254595 (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])
Item
Lab Name
text
C0022885 (UMLS CUI [1,1])
C0027365 (UMLS CUI [1,2])
Lab Name
Code List
Lab Name
CL Item
Hemoglobin A1c (A1C)
CL Item
Creatine kinase total (CK)
CL Item
Creatine kinase MB (CK_MB)
CL Item
Creatine kinase MB/creatine kinase total (CK_MBI)
CL Item
Creatinine (CREATININE)
CL Item
Hemoglobin (HGB)
CL Item
Low-density lipoprotein (LDL)
CL Item
International normalized ratio (INR)
CL Item
Troponin I cardiac (TROP_I)
CL Item
Troponin T cardiac (qualitative) (TROP_T_QL)
CL Item
Troponin T cardiac (quantitative) (TROP_T_QN)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Specimen Source
text
C0449416 (UMLS CUI [1,1])
C0370003 (UMLS CUI [1,2])
Specimen Source
Code List
Specimen Source
CL Item
Blood (BLOOD)
CL Item
Cerebrospinal fluid (CSF)
CL Item
Plasma (PLASMA)
CL Item
Platelet poor plasma (PPP)
CL Item
Serum (SERUM)
CL Item
Serum/plasma (SR_PLS)
CL Item
Urine (URINE)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Lab LOINC
Item
Lab LOINC
text
C1136323 (UMLS CUI [1,1])
C0022885 (UMLS CUI [1,2])
Item
Priority
text
C0549179 (UMLS CUI [1,1])
C0022885 (UMLS CUI [1,2])
Priority
Code List
Priority
CL Item
Expedite (E)
CL Item
Routine (R)
CL Item
Stat (S)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
Result Loc
text
C1254595 (UMLS CUI [1,1])
C0450429 (UMLS CUI [1,2])
Result Loc
Code List
Result Loc
CL Item
Lab (L)
CL Item
Point of Care (P)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Lab PX
Item
lab PX
integer
C0022885 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
Item
Lab PX Type
text
C0022885 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
C0332307 (UMLS CUI [1,3])
Lab PX Type
Code List
Lab 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 (LC)
CL Item
NDC (ND)
CL Item
Revenue (RE)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Lab Order Date
Item
Lab Order Date
date
C0011008 (UMLS CUI [1,1])
C0022885 (UMLS CUI [1,2])
C1272683 (UMLS CUI [1,3])
Specimen Date
Item
Specimen Date
date
C0370003 (UMLS CUI [1,1])
C1516698 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
Specimen Time
Item
Specimen Time
time
C0370003 (UMLS CUI [1,1])
C1516698 (UMLS CUI [1,2])
C0040223 (UMLS CUI [1,3])
Result Date
Item
Result Date
date
C1254595 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
Result Time
Item
Result Time
time
C1254595 (UMLS CUI [1,1])
C0040223 (UMLS CUI [1,2])
Item
Result Qual
text
C1254595 (UMLS CUI [1,1])
C0332306 (UMLS CUI [1,2])
Result Qual
Code List
Result Qual
CL Item
BORDERLINE (BORDERLINE)
CL Item
POSITIVE (POSITIVE)
CL Item
NEGATIVE (NEGATIVE)
CL Item
UNDETERMINED (UNDETERMINED)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Result Num
Item
Result Num
float
C1254595 (UMLS CUI [1,1])
C0392762 (UMLS CUI [1,2])
Item
Result Modifier
text
C1254595 (UMLS CUI [1,1])
C1515926 (UMLS CUI [1,2])
Result Modifier
Code List
Result Modifier
CL Item
Equal (EQ)
CL Item
Greater than or equal to (GE)
CL Item
Greater than (GT)
CL Item
Less than or equal to (LE)
CL Item
Less than (LT)
CL Item
Text (TX)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Result Unit
Item
Result Unit
text
C1254595 (UMLS CUI [1,1])
C1519795 (UMLS CUI [1,2])
Norm Range Low
Item
Norm Range Low
float
C0086715 (UMLS CUI [1,1])
C1254595 (UMLS CUI [1,2])
Item
Norm Modifier Low
text
C0086715 (UMLS CUI [1,1])
C1254595 (UMLS CUI [1,2])
Norm Modifier Low
Code List
Norm Modifier Low
CL Item
Equal (EQ)
CL Item
Greater than or equal to (GE)
CL Item
Greater than (GT)
CL Item
No lower limit (NO)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Norm Range High
Item
Norm Range High
float
C0086715 (UMLS CUI [1,1])
C1254595 (UMLS CUI [1,2])
Item
Norm Modifier High
text
C0086715 (UMLS CUI [1,1])
C1254595 (UMLS CUI [1,2])
Norm Modifier High
Code List
Norm Modifier High
CL Item
Equal (EQ)
CL Item
Less than or equal to (LE)
CL Item
Less than (LT)
CL Item
No higher limit (NO)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Item
ABN IND
text
C1254595 (UMLS CUI [1,1])
C1704258 (UMLS CUI [1,2])
C1522602 (UMLS CUI [1,3])
ABN IND
Code List
ABN IND
CL Item
Abnormal (AB)
CL Item
Abnormally high (AH)
CL Item
Abnormally low (AL)
CL Item
Critically high (CH)
CL Item
Critically low (CL)
CL Item
Critical (CR)
CL Item
Inconclusive (IN)
CL Item
Normal (NL)
CL Item
No information (NI)
CL Item
Unknown (UN)
CL Item
Other (OT)
Raw Lab Name
Item
Raw Lab Name
text
C0022885 (UMLS CUI [1,1])
C0027365 (UMLS CUI [1,2])
Raw Lab Code
Item
Raw Lab Code
integer
C0022885 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
Raw Panel
Item
Raw Panel
integer
C1999270 (UMLS CUI [1,1])
C0022885 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
Raw Result
Item
Raw Result
float
C2826772 (UMLS CUI [1])
Raw Unit
Item
Raw Unit
text
C1254595 (UMLS CUI [1,1])
C1519795 (UMLS CUI [1,2])
Raw Order Dept
Item
Raw Order Dept
text
C1704729 (UMLS CUI [1,1])
C0022885 (UMLS CUI [1,2])
C1272683 (UMLS CUI [1,3])
Raw Facility Code
Item
Raw Facility Code
text
C1549700 (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