documentation:cdm:measurement
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:measurement [2016/06/04 06:13] cgreich |
documentation:cdm:measurement [2017/02/07 03:41] cukarthik |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== MEASUREMENT table ===== | ===== MEASUREMENT table ===== | ||
| + | |||
| + | This table changed in version 5.1 of the OMOP CDM. The field measurement_datetime was added. | ||
| + | |||
| + | ----- | ||
| + | |||
| The MEASUREMENT table contains records of Measurement, i.e. structured values (numerical or categorical) obtained through systematic and standardized examination or testing of a Person or Person's sample. The MEASUREMENT table contains both orders and results of such Measurements as laboratory tests, vital signs, quantitative findings from pathology reports, etc. | The MEASUREMENT table contains records of Measurement, i.e. structured values (numerical or categorical) obtained through systematic and standardized examination or testing of a Person or Person's sample. The MEASUREMENT table contains both orders and results of such Measurements as laboratory tests, vital signs, quantitative findings from pathology reports, etc. | ||
| ^Field^Required^Type^Description^ | ^Field^Required^Type^Description^ | ||
| Line 6: | Line 11: | ||
| |measurement_concept_id|Yes|integer|A foreign key to the standard measurement concept identifier in the Standardized Vocabularies.| | |measurement_concept_id|Yes|integer|A foreign key to the standard measurement concept identifier in the Standardized Vocabularies.| | ||
| |measurement_date|Yes|date|The date of the Measurement.| | |measurement_date|Yes|date|The date of the Measurement.| | ||
| - | |measurement_time|No|time|The time of the Measurement. (Some database systems don't have a datatype of time. To accomodate all temporal analyses, datatype datetime can be used (combining measurement_date and measurement_time)[[http://forums.ohdsi.org/t/date-time-and-datetime-problem-and-the-world-of-hours-and-1day/314|Relevant Forum Discussion]]| | + | |measurement_datetime|No|datetime|The date and time of the Measurement. (Some database systems don't have a datatype of time. To accomodate all temporal analyses, datatype datetime can be used (combining measurement_date and measurement_time)[[http://forums.ohdsi.org/t/date-time-and-datetime-problem-and-the-world-of-hours-and-1day/314|Relevant Forum Discussion]]| |
| |measurement_type_concept_id|Yes|integer|A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the provenance from where the Measurement record was recorded.| | |measurement_type_concept_id|Yes|integer|A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the provenance from where the Measurement record was recorded.| | ||
| |operator_concept_id|No|integer|A foreign key identifier to the predefined Concept in the Standardized Vocabularies reflecting the mathematical operator that is applied to the value_as_number. Operators are <, ≤, =, ≥, >.| | |operator_concept_id|No|integer|A foreign key identifier to the predefined Concept in the Standardized Vocabularies reflecting the mathematical operator that is applied to the value_as_number. Operators are <, ≤, =, ≥, >.| | ||
| Line 34: | Line 39: | ||
| * 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/measurement.txt · Last modified: 2017/09/25 15:02 by clairblacketer
Page Tools
