ID

37392

Description

Lab results This table is used to store quantitative and qualitative measurements from blood and other body specimens. 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 (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 -
Copyright Holder

PCORnet

Uploaded on

July 22, 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

Lab results V4.1

1 forms  
  1. StudyEvent: ODM
    1. Lab results V4.1
Lab results CM
Description

Lab results CM

Alias
UMLS CUI-1
C1254595
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

text

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

text

Alias
UMLS CUI [1]
C2348585
Encounter ID
Description

Arbitrary encounter-level identifier. Not all lab results will be associated with a healthcare encounter.

Data type

text

Alias
UMLS CUI [1,1]
C1947978
UMLS CUI [1,2]
C1300638
Specimen Source
Description

Specimen source. All records will have a specimen source; some tests have several possible values for SPECIMEN_SOURCE.

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]
C0549179
Result Location
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]
C1274040
UMLS CUI [1,2]
C0450429
Lab Procedure Code
Description

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

Data type

text

Alias
UMLS CUI [1,1]
C0022885
UMLS CUI [1,2]
C0805701
Laboratory Procedure Type
Description

Procedure code type, if applicable.

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]
C0022885
UMLS CUI [1,2]
C0011008
UMLS CUI [1,3]
C1705178
Specimen Date and Time
Description

Date and time specimen was collected.

Data type

datetime

Alias
UMLS CUI [1,1]
C1302413
UMLS CUI [1,2]
C0040223
Result Date and Time
Description

Result Date and Time

Data type

datetime

Alias
UMLS CUI [1,1]
C1717740
UMLS CUI [1,2]
C0587081
Result Quality
Description

Standardized result for qualitative results. This variable should be NI for quantitative results.

Data type

text

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

If the qualitative result has been mapped to SNOMED CT, the corresponding SNOMED code can be placed here.

Data type

text

Alias
UMLS CUI [1,1]
C1274040
UMLS CUI [1,2]
C1623497
Result Number
Description

Standardized/converted result for quantitative results.

Data type

integer

Alias
UMLS CUI [1,1]
C1274040
UMLS CUI [1,2]
C0237753
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 quantitative result.

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

text

Alias
UMLS CUI [1,1]
C0086715
UMLS CUI [1,2]
C1254595
UMLS CUI [1,3]
C0205251
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
UMLS CUI [1,3]
C3542952
UMLS CUI [1,4]
C0205251
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

text

Alias
UMLS CUI [1,1]
C0086715
UMLS CUI [1,2]
C1254595
UMLS CUI [1,3]
C0205250
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
UMLS CUI [1,3]
C0205250
UMLS CUI [1,4]
C3542952
Abnormal result indicator
Description

Abnormal result indicator. This value comes from the source data; do not apply logic to create it. If field is blank in source data, map to the appropriate flavor of null (guidance added in v4.0).

Data type

text

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

Local name related to an individual lab test.

Data type

text

Alias
UMLS CUI [1,1]
C1882331
UMLS CUI [1,2]
C0205313
Raw Lab Code
Description

Local code related to an individual lab test.

Data type

text

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

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

Data type

text

Alias
UMLS CUI [1,1]
C1999270
UMLS CUI [1,2]
C0205313
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).

Data type

text

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
UMLS CUI [1,3]
C0205313
Raw Order Department
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
UMLS CUI [1,4]
C0205313
Raw Facility Code
Description

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

Data type

text

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

Similar models

Lab results V4.1

1 forms
  1. StudyEvent: ODM
    1. Lab results V4.1
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Lab results CM
C1254595 (UMLS CUI-1)
Lab Result CM ID
Item
Lab Result CM ID
text
C1254595 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Pat ID
Item
Patient ID
text
C2348585 (UMLS CUI [1])
Encounter ID
Item
Encounter ID
text
C1947978 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Specimen Source
Item
Specimen Source
text
C0449416 (UMLS CUI [1,1])
C0370003 (UMLS CUI [1,2])
Lab LOINC
Item
Lab LOINC
text
C1136323 (UMLS CUI [1,1])
C0022885 (UMLS CUI [1,2])
Item
Priority
text
C0549179 (UMLS CUI [1])
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 Location
text
C1274040 (UMLS CUI [1,1])
C0450429 (UMLS CUI [1,2])
Result Location
Code List
Result Location
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 Procedure Code
text
C0022885 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
Item
Laboratory Procedure Type
text
C0022885 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
C0332307 (UMLS CUI [1,3])
Lab PX Type
Code List
Laboratory Procedure Type
CL Item
ICD-9-CM  (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
C0022885 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
C1705178 (UMLS CUI [1,3])
Specimen Date and Time
Item
Specimen Date and Time
datetime
C1302413 (UMLS CUI [1,1])
C0040223 (UMLS CUI [1,2])
Result Date and Time
Item
Result Date and Time
datetime
C1717740 (UMLS CUI [1,1])
C0587081 (UMLS CUI [1,2])
Result Quality
Item
Result Quality
text
C1254595 (UMLS CUI [1,1])
C0332306 (UMLS CUI [1,2])
Result SNOMED
Item
Result SNOMED
text
C1274040 (UMLS CUI [1,1])
C1623497 (UMLS CUI [1,2])
Result Number
Item
Result Number
integer
C1274040 (UMLS CUI [1,1])
C0237753 (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
text
C0086715 (UMLS CUI [1,1])
C1254595 (UMLS CUI [1,2])
C0205251 (UMLS CUI [1,3])
Item
text
C0086715 (UMLS CUI [1,1])
C1254595 (UMLS CUI [1,2])
C3542952 (UMLS CUI [1,3])
C0205251 (UMLS CUI [1,4])
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
text
C0086715 (UMLS CUI [1,1])
C1254595 (UMLS CUI [1,2])
C0205250 (UMLS CUI [1,3])
Item
Norm Modifier High
text
C0086715 (UMLS CUI [1,1])
C1254595 (UMLS CUI [1,2])
C0205250 (UMLS CUI [1,3])
C3542952 (UMLS CUI [1,4])
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
Abnormal result indicator
text
C1254595 (UMLS CUI [1,1])
C1704258 (UMLS CUI [1,2])
C1522602 (UMLS CUI [1,3])
ABN IND
Code List
Abnormal result indicator
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 UN=Unknown OT=Other (NI)
Raw Lab Name
Item
Raw Labe Name
text
C1882331 (UMLS CUI [1,1])
C0205313 (UMLS CUI [1,2])
Raw Lab Code
Item
Raw Lab Code
text
C0022885 (UMLS CUI [1,1])
C0805701 (UMLS CUI [1,2])
C0205313 (UMLS CUI [1,3])
Raw Panel
Item
Raw Panel
text
C1999270 (UMLS CUI [1,1])
C0205313 (UMLS CUI [1,2])
Raw Result
Item
Raw Result
text
C2826772 (UMLS CUI [1])
Raw Unit
Item
Raw Unit
text
C1254595 (UMLS CUI [1,1])
C1519795 (UMLS CUI [1,2])
C0205313 (UMLS CUI [1,3])
Raw Order Department
Item
Raw Order Department
text
C1704729 (UMLS CUI [1,1])
C0022885 (UMLS CUI [1,2])
C1272683 (UMLS CUI [1,3])
C0205313 (UMLS CUI [1,4])
Raw Facility Code
Item
Raw Facility Code
text
C1549700 (UMLS CUI [1,1])
C0205313 (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