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:observation [2016/10/13 23:47] gowtham_rao |
documentation:cdm:observation [2017/02/07 03:41] cukarthik |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== OBSERVATION table ===== | ===== OBSERVATION table ===== | ||
+ | |||
+ | This table changed in version 5.1 of the OMOP CDM. The field observation_datetime was added. | ||
+ | |||
+ | ----- | ||
+ | |||
The OBSERVATION table captures clinical facts about a Person obtained in the context of examination, questioning or a procedure. Any data that cannot be represented by any other domains, such as social and lifestyle facts, medical history, family history, etc. are recorded here. | The OBSERVATION table captures clinical facts about a Person obtained in the context of examination, questioning or a procedure. Any data that cannot be represented by any other domains, such as social and lifestyle facts, medical history, family history, etc. are recorded here. | ||
^Field^Required^Type^Description^ | ^Field^Required^Type^Description^ | ||
Line 6: | Line 11: | ||
|observation_concept_id|Yes|integer|A foreign key to the standard observation concept identifier in the Standardized Vocabularies.| | |observation_concept_id|Yes|integer|A foreign key to the standard observation concept identifier in the Standardized Vocabularies.| | ||
|observation_date|Yes|date|The date of the observation.| | |observation_date|Yes|date|The date of the observation.| | ||
- | |observation_time|No|time|The time of the observation.| | + | |observation_datetime|No|datetime|The date and time of the observation.| |
|observation_type_concept_id|Yes|integer|A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of the observation.| | |observation_type_concept_id|Yes|integer|A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of the observation.| | ||
|value_as_number|No|float|The observation result stored as a number. This is applicable to observations where the result is expressed as a numeric value.| | |value_as_number|No|float|The observation result stored as a number. This is applicable to observations where the result is expressed as a numeric value.| | ||
Line 31: | Line 36: | ||
* The Visit during which the observation was made is recorded through a reference to the VISIT_OCCURRENCE table. This information is not always available. | * The Visit during which the observation was made is recorded through a reference to the VISIT_OCCURRENCE table. This information is not always available. | ||
* The Provider making the observation is recorded through a reference to the PROVIDER table. This information is not always available. | * The Provider making the observation is recorded through a reference to the PROVIDER table. This information is not always available. | ||
- |