This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:cdm:condition_occurrence [2017/02/07 03:40] cukarthik |
documentation:cdm:condition_occurrence [2017/09/25 15:02] (current) clairblacketer |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== CONDITION_OCCURRENCE table ===== | ===== CONDITION_OCCURRENCE table ===== | ||
+ | **THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|CDM working group]] for more information** | ||
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. | 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. | ||
Line 23: | Line 24: | ||
| condition_source_concept_id | No | integer | A foreign key to a Condition Concept that refers to the code used in the source. | | | 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_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 | No | varchar(50) | |
- | condition_status_source_value | + | |
==== Conventions ==== | ==== Conventions ==== |