OMOP Common Data Model (CDM) Observation

Observation
Beschrijving

Observation

Alias
UMLS CUI-1
C0700325
UMLS CUI-2
C2708733
UMLS CUI-3
C1955348
Observation ID
Beschrijving

A unique identifier for each observation.

Datatype

integer

Alias
UMLS CUI [1,1]
C0700325
UMLS CUI [1,2]
C1300638
Person ID
Beschrijving

A foreign key identifier to the person about whom the observation was recorded. The demographic details of that person are stored in the person table.

Datatype

integer

Alias
UMLS CUI [1,1]
C0027361
UMLS CUI [1,2]
C1300638
Observation concept ID
Beschrijving

A foreign key to the standard observation concept identifier in the Standardized Vocabularies.

Datatype

integer

Alias
UMLS CUI [1,1]
C0700325
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Observation date
Beschrijving

The date of the observation.

Datatype

date

Alias
UMLS CUI [1,1]
C0700325
UMLS CUI [1,2]
C0011008
Observation time
Beschrijving

The time of the observation.

Datatype

time

Alias
UMLS CUI [1,1]
C0700325
UMLS CUI [1,2]
C0040223
Observation type concept ID
Beschrijving

A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of the observation.

Datatype

integer

Alias
UMLS CUI [1,1]
C0700325
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Value as number
Beschrijving

The observation result stored as a number. This is applicable to observations where the result is expressed as a numeric value.

Datatype

float

Alias
UMLS CUI [1,1]
C0700325
UMLS CUI [1,2]
C1522609
UMLS CUI [1,3]
C0449788
Value as string
Beschrijving

The observation result stored as a string. This is applicable to observations where the result is expressed as verbatim text.

Datatype

text

Alias
UMLS CUI [1,1]
C0700325
UMLS CUI [1,2]
C1522609
UMLS CUI [1,3]
C1547402
Value as concept ID
Beschrijving

A foreign key to an observation result stored as a concept identifier. This is applicable to observations where the result can be expressed as a standard concept from the Standardized Vocabularies (e.g., positive/negative, present/absent, low/high, etc.).

Datatype

integer

Alias
UMLS CUI [1,1]
C1522609
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Qualifier concept ID
Beschrijving

A foreign key to a standard concept identifier for a qualifier (e.g., severity of drug-drug interaction alert)

Datatype

integer

Alias
UMLS CUI [1,1]
C1514623
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Unit concept ID
Beschrijving

A foreign key to a standard concept identifier of measurement units in the Standardized Vocabularies.

Datatype

integer

Alias
UMLS CUI [1,1]
C1519795
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Provider ID
Beschrijving

A foreign key to the provider in the provider table who was responsible for making the observation.

Datatype

integer

Alias
UMLS CUI [1,1]
C1138603
UMLS CUI [1,2]
C1300638
Visit occurrence ID
Beschrijving

A foreign key to the visit in the visit table during which the observation was recorded.

Datatype

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Observation source value
Beschrijving

The observation code as it appears in the source data. This code is mapped to a standard concept in the Standardized Vocabularies and the original code is, stored here for reference.

Datatype

text

Alias
UMLS CUI [1,1]
C0700325
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C1522609
Observation source concept ID
Beschrijving

A foreign key to a concept that refers to the code used in the source.

Datatype

integer

Alias
UMLS CUI [1,1]
C0700325
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Unit source value
Beschrijving

The source code for the unit as it appears in the source data. This code is mapped to a standard unit concept in the Standardized Vocabularies and the original code is, stored here for reference.

Datatype

text

Alias
UMLS CUI [1,1]
C1519795
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C1522609
Qualifier source value
Beschrijving

The source value associated with a qualifier to characterize the observation

Datatype

text

Alias
UMLS CUI [1,1]
C1514623
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C1522609

Similar models

OMOP Common Data Model (CDM) Observation

Name
Type
Description | Question | Decode (Coded Value)
Datatype
Alias
Item Group
Observation
C0700325 (UMLS CUI-1)
C2708733 (UMLS CUI-2)
C1955348 (UMLS CUI-3)
Observation ID
Item
Observation ID
integer
C0700325 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Person ID
Item
Person ID
integer
C0027361 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Observation concept ID
Item
Observation concept ID
integer
C0700325 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Observation date
Item
Observation date
date
C0700325 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
Observation time
Item
Observation time
time
C0700325 (UMLS CUI [1,1])
C0040223 (UMLS CUI [1,2])
Observation type concept ID
Item
Observation type concept ID
integer
C0700325 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Value as number
Item
Value as number
float
C0700325 (UMLS CUI [1,1])
C1522609 (UMLS CUI [1,2])
C0449788 (UMLS CUI [1,3])
Value as string
Item
Value as string
text
C0700325 (UMLS CUI [1,1])
C1522609 (UMLS CUI [1,2])
C1547402 (UMLS CUI [1,3])
Value as concept ID
Item
Value as concept ID
integer
C1522609 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Qualifier concept ID
Item
Qualifier concept ID
integer
C1514623 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Unit concept ID
Item
Unit concept ID
integer
C1519795 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Provider ID
Item
Provider ID
integer
C1138603 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Visit occurrence ID
Item
Visit occurrence ID
integer
C1512346 (UMLS CUI [1,1])
C2745955 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Observation source value
Item
Observation source value
text
C0700325 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C1522609 (UMLS CUI [1,3])
Observation source concept ID
Item
Observation source concept ID
integer
C0700325 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Unit source value
Item
Unit source value
text
C1519795 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C1522609 (UMLS CUI [1,3])
Qualifier source value
Item
Qualifier source value
text
C1514623 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C1522609 (UMLS CUI [1,3])