: Record Table 933

Notes

The omop_observation_period table contains records which define spans of time during which two conditions are expected to hold: (i) Clinical Events that happened to the Person are recorded in the Event tables, and (ii) absense of records indicate such Events did not occur during this span of time.
Further details can be found in the OMOP CDM Clinical Data Tables specifications - https://ohdsi.github.io/CommonDataModel/cdm53.html#OBSERVATION_PERIOD
Due to some data quality issues identified by research groups who have been using the returned OMOP derivation dataset, the record-level tables are now restricted. Please see Field 20142 for more information.

18 Columns

#	Column	Type	Notes
1	eid	integer	A foreign key identifier to the Person about whom the observation was recorded.
2	observation_concept_id	integer	A foreign key to the standard observation concept identifier in the Standardized Vocabularies.
3	observation_date	date	The date of the observation.
4	observation_datetime	timestamp	The date and time of the observation.
5	observation_id	integer	A unique identifier for each observation.
6	observation_source_concept_id	integer	A foreign key to a Concept that refers to the code used in the source.
7	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.
8	observation_type_concept_id	integer	A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of the observation.
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.

15 Related OMOP Record Tables

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

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