documentation:cdm:condition_occurrence
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
documentation:cdm:condition_occurrence [2017/01/27 05:22] gowtham_rao [Table] |
documentation:cdm:condition_occurrence [2017/04/27 01:05] cukarthik [CONDITION_OCCURRENCE table] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== CONDITION_OCCURRENCE table ===== | ===== CONDITION_OCCURRENCE table ===== | ||
| - | 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 23: | ||
| | 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 ==== | ||
| Line 42: | Line 41: | ||
| * Preliminary diagnosis: use concept_id 4033240 | * Preliminary diagnosis: use concept_id 4033240 | ||
| * Final diagnosis: use concept_id 4230359 – should also be used for ‘Discharge diagnosis’ | * Final diagnosis: use concept_id 4230359 – should also be used for ‘Discharge diagnosis’ | ||
| - | |||
documentation/cdm/condition_occurrence.txt · Last modified: 2017/09/25 15:02 by clairblacketer
Page Tools
