This is an old revision of the document!
This table changed in version 5.1 of the OMOP CDM. The fields condition_start_datetime and condition_end_datetime were added. For 5.0.1, this table changed in version 5.X of the OMOP CDM. The fields condition_status_concept_id and condition_status_source_value were added.
Conditions are records of a Person suggesting the presence of a disease or medical condition stated as a diagnosis, a sign or a symptom, which is either observed by a Provider or reported by the patient. Conditions are recorded in different sources and levels of standardization, for example:
Field | Required | Type | Description |
---|---|---|---|
condition_occurrence_id | Yes | integer | A unique identifier for each Condition Occurrence event. |
person_id | Yes | integer | A foreign key identifier to the Person who is experiencing the condition. The demographic details of that Person are stored in the PERSON table. |
condition_concept_id | Yes | integer | A foreign key that refers to a Standard Condition Concept identifier in the Standardized Vocabularies. |
condition_start_date | Yes | date | The date when the instance of the Condition is recorded. |
condition_start_datetime | No | datetime | The date and time when the instance of the Condition is recorded. |
condition_end_date | No | date | The date when the instance of the Condition is considered to have ended. |
condition_end_datetime | No | date | The date when the instance of the Condition is considered to have ended. |
condition_type_concept_id | Yes | 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. |
stop_reason | No | varchar(20) | The reason that the condition was no longer present, as indicated in the source data. |
provider_id | No | integer | A foreign key to the Provider in the PROVIDER table who was responsible for capturing (diagnosing) the Condition. |
visit_occurrence_id | No | integer | A foreign key to the visit in the VISIT table during which the Condition was determined (diagnosed). |
condition_status_concept_id | No | integer | A foreign key to the predefined concept in the standard vocabulary reflecting the condition status. |
condition_source_concept_id | No | integer | A foreign key to a Condition Concept that refers to the code used in the source. |
condition_source_value | No | varchar(50) | 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_status_source_value | No | varchar(50) |
condition_status_source_value