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 [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 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
