documentation:cdm:observation
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: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. | ||
| - | |||
documentation/cdm/observation.txt ยท Last modified: 2017/09/25 15:02 by clairblacketer
Page Tools
