: Record Table 933

Record Table 933

Title:	OMOP Observation Period
Access field:	20142 (Present in OMOP dataset)

Table name

omop_observation

Table group

OMOP

Debut

Feb 2023

Row count

687,000,000+

Parent table

n/a

Version

Mar 2023

Size

72GB

Stability

Complete

Cost Tier

d2 o2 s2

18 Columns

#	Column	Type	Notes
1	observation_concept_id	integer	A foreign key to the standard observation concept identifier in the Standardized Vocabularies.
2	observation_date	date	The date of the observation.
3	observation_datetime	timestamp	The date and time of the observation.
4	observation_id	integer	A unique identifier for each observation.
5	observation_source_concept_id	integer	A foreign key to a Concept that refers to the code used in the source.
6	observation_source_value	string	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.
7	observation_type_concept_id	integer	A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of the observation.
8	person_id	integer	A foreign key identifier to the Person about whom the observation was recorded.
9	provider_id	integer	A foreign key to the provider in the PROVIDER table who was responsible for making the observation.
10	qualifier_concept_id	integer	A foreign key to a Standard Concept ID for a qualifier (e.g., severity of drug-drug interaction alert)
11	qualifier_source_value	string	The source value associated with a qualifier to characterize the observation
12	unit_concept_id	integer	A foreign key to a Standard Concept ID of measurement units in the Standardized Vocabularies.
13	unit_source_value	string	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.
14	value_as_concept_id	integer	A foreign key to an observation result stored as a Concept ID. 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.).
15	value_as_number	float	The observation result stored as a number. This is applicable to observations where the result is expressed as a numeric value.
16	value_as_string	string	The observation result stored as a string. This is applicable to observations where the result is expressed as verbatim text.
17	visit_detail_id	integer
18	visit_occurrence_id	integer	A foreign key to the visit in the VISIT_OCCURRENCE table during which the observation was recorded.

Column

Type

Notes

observation_concept_id

integer

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

observation_date

date

The date of the observation.

observation_datetime

timestamp

The date and time of the observation.

observation_id

integer

A unique identifier for each observation.

observation_source_concept_id

integer

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

observation_source_value

string

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.

observation_type_concept_id

integer

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

person_id

integer

A foreign key identifier to the Person about whom the observation was recorded.

provider_id

integer

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

qualifier_concept_id

integer

A foreign key to a Standard Concept ID for a qualifier (e.g., severity of drug-drug interaction alert)

qualifier_source_value

string

The source value associated with a qualifier to characterize the observation

unit_concept_id

integer

A foreign key to a Standard Concept ID of measurement units in the Standardized Vocabularies.

unit_source_value

string

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.

value_as_concept_id

integer

A foreign key to an observation result stored as a Concept ID. 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.).

value_as_number

float

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

value_as_string

string

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

visit_detail_id

integer

visit_occurrence_id

integer

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

Table ID	Table	Title
924	omop_condition_era	OMOP Condition Era
925	omop_condition_occurrence	OMOP Condition Occurrence
926	omop_death	OMOP Death
927	omop_device_exposure	OMOP Device Exposure
928	omop_dose_era	OMOP Dose Era
929	omop_drug_era	OMOP Drug Era
930	omop_drug_exposure	OMOP Drug Exposure
931	omop_measurement	OMOP Measurement
932	omop_note	OMOP Note
934	omop_observation_period	OMOP Observation
935	omop_person	OMOP Person
936	omop_procedure_occurrence	OMOP Procedure Occurrence
937	omop_specimen	OMOP Specimen
938	omop_visit_detail	OMOP Visit Detail
939	omop_visit_occurrence	OMOP Visit Occurrence

Table ID

Table

Title

924

omop_condition_era

OMOP Condition Era

925

omop_condition_occurrence

OMOP Condition Occurrence

926

omop_death

OMOP Death