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 Next revision Both sides next revision | ||
|
documentation:cdm:measurement [2014/12/06 16:45] cgreich |
documentation:cdm:measurement [2015/04/01 20:41] vojtechhuser |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== MEASUREMENT table ===== | ===== MEASUREMENT table ===== | ||
| - | A Measurement is a structured value (numerical or categorical) obtained through systematic and standardized examination or testing of a Person or Person's sample. The Measurement table contains measurement 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^ | ||
| |measurement_id|Yes|integer|A unique identifier for each Measurement.| | |measurement_id|Yes|integer|A unique identifier for each Measurement.| | ||
| Line 6: | Line 6: | ||
| |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.| | + | |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_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 28: | Line 28: | ||
| * For some Measurement Concepts, the result is included in the test. For example, SNOMED-CT 71628007 concept_id 4325125 'Abnormal presence of albumin' indicates a Measurement (albumin in sample) and the result (abnormal). In future releases of the Standardized Vocabularies, these will be split into the correct Measurement and result. | * For some Measurement Concepts, the result is included in the test. For example, SNOMED-CT 71628007 concept_id 4325125 'Abnormal presence of albumin' indicates a Measurement (albumin in sample) and the result (abnormal). In future releases of the Standardized Vocabularies, these will be split into the correct Measurement and result. | ||
| * The operator_concept_id is optionally given for relative Measurements where the precise value is not available but its relation to a certain benchmarking value is. For example, this can be used for minimal detection thresholds of a test. | * The operator_concept_id is optionally given for relative Measurements where the precise value is not available but its relation to a certain benchmarking value is. For example, this can be used for minimal detection thresholds of a test. | ||
| - | * The meaning of Concept 4172703 for '=' is identical to omission of a operator_concept_id value. Since the use of this field is rare, it's important when devising analyses to not to forget testing for the content of this field. | + | * The meaning of Concept 4172703 for '=' is identical to omission of a operator_concept_id value. Since the use of this field is rare, it's important when devising analyses to not to forget testing for the content of this field for values different from =. |
| * Valid Concepts for the operator_concept_id field belong to the 'Meas Value Operator' domain. | * Valid Concepts for the operator_concept_id field belong to the 'Meas Value Operator' domain. | ||
| * The Unit is optional even if a value_as_number is provided. | * The Unit is optional even if a value_as_number is provided. | ||
documentation/cdm/measurement.txt · Last modified: 2017/09/25 15:02 by clairblacketer
Page Tools
