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:44] cgreich |
documentation:cdm:measurement [2014/12/06 17:46] cgreich |
||
---|---|---|---|
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 27: | Line 27: | ||
* Valid Concepts for the value_as_concept field belong to the 'Meas Value' domain. | * Valid Concepts for the value_as_concept field belong to the 'Meas Value' domain. | ||
* 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 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 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 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. |