This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:cdm:observation [2016/10/13 23:47] gowtham_rao |
documentation:cdm:observation [2017/09/25 15:02] (current) clairblacketer |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== OBSERVATION table ===== | ===== OBSERVATION 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 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 12: | ||
|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 37: | ||
* 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. | ||
- |