documentation:cdm:observation
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext 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:// | ||
| + | |||
| + | 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, | The OBSERVATION table captures clinical facts about a Person obtained in the context of examination, | ||
| ^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. | ||
| - | |||
documentation/cdm/observation.1476402422.txt.gz · Last modified: by gowtham_rao