: Record Table 925

Record Table 925

Title:	OMOP Condition Occurrence
Access field:	20142 (Present in OMOP dataset)

Table name

omop_condition_occurrence

Table group

OMOP

Debut

Feb 2023

Row count

34,000,000+

Parent table

n/a

Version

Sep 2024

Size

2GB

Stability

Complete

Cost Tier

dX o2 s2

16 Columns

#	Column	Type	Notes
1	condition_concept_id	integer	A foreign key that refers to a Standard Condition Concept identifier in the Standardized Vocabularies.
2	condition_end_date	date	The date when the instance of the Condition is considered to have ended.
3	condition_end_datetime	timestamp	The date when the instance of the Condition is considered to have ended.
4	condition_occurrence_id	integer	A unique identifier for each Condition Era.
5	condition_source_concept_id	integer	The source code for the condition as it appears in the source data. This code is mapped to a standard condition concept in the Standardized Vocabularies and the original code is stored here for reference.
6	condition_source_value	string	A foreign key to a Condition Concept that refers to the code used in the source.
7	condition_start_date	date	The date when the instance of the Condition is recorded.
8	condition_start_datetime	timestamp	The date and time when the instance of the Condition is recorded.
9	condition_status_concept_id	integer
10	condition_status_source_value	string
11	condition_type_concept_id	integer	A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the source data from which the condition was recorded, the level of standardization, and the type of occurrence.
12	eid	integer	A foreign key identifier to the Person who is experiencing the Condition.
13	provider_id	integer	A foreign key to the Provider in the PROVIDER table who was responsible for capturing (diagnosing) the Condition.
14	stop_reason	string	The reason that the condition was no longer present, as indicated in the source data.
15	visit_detail_id	integer	A foreign key to the predefined concept in the standard vocabulary reflecting the condition status.
16	visit_occurrence_id	integer	A foreign key to the visit in the VISIT table during which the Condition was determined (diagnosed).

Column

Type

Notes

condition_concept_id

integer

A foreign key that refers to a Standard Condition Concept identifier in the Standardized Vocabularies.

condition_end_date

date

The date when the instance of the Condition is considered to have ended.

condition_end_datetime

timestamp

The date when the instance of the Condition is considered to have ended.

condition_occurrence_id

integer

A unique identifier for each Condition Era.

condition_source_concept_id

integer

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

condition_source_value

string

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

condition_start_date

date

The date when the instance of the Condition is recorded.

condition_start_datetime

timestamp

The date and time when the instance of the Condition is recorded.

condition_status_concept_id

integer

condition_status_source_value

string

condition_type_concept_id

integer

A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the source data from which the condition was recorded, the level of standardization, and the type of occurrence.

eid

integer

A foreign key identifier to the Person who is experiencing the Condition.

provider_id

integer

A foreign key to the Provider in the PROVIDER table who was responsible for capturing (diagnosing) the Condition.

stop_reason

string

The reason that the condition was no longer present, as indicated in the source data.

visit_detail_id

integer

A foreign key to the predefined concept in the standard vocabulary reflecting the condition status.

visit_occurrence_id

integer

A foreign key to the visit in the VISIT table during which the Condition was determined (diagnosed).

Table ID	Table	Title
924	omop_condition_era	OMOP Condition Era
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
933	omop_observation	OMOP Observation Period
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

OMOP Condition Era

OMOP Death

OMOP Device Exposure