Guide d'implémentation du GT Standards et Interopérabilité pour les EDS
0.1.0 - ci-build France flag

Guide d'implémentation du GT Standards et Interopérabilité pour les EDS - Local Development build (v0.1.0) built by the FHIR (HL7® FHIR® Standard) Build Tools. See the Directory of published versions

Logical Model: OMOPMeasurement - Detailed Descriptions

Draft as of 2024-11-23

Definitions for the OMOPMeasurement logical model.

Guidance on how to interpret the contents of this table can be found here

0. OMOPMeasurement
Definition

The MEASUREMENT table contains records of Measurements, 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. Measurements are stored as attribute value pairs, with the attribute as the Measurement Concept and the value representing the result. The value can be a Concept (stored in VALUE_AS_CONCEPT), or a numerical value (VALUE_AS_NUMBER) with a Unit (UNIT_CONCEPT_ID). The Procedure for obtaining the sample is housed in the PROCEDURE_OCCURRENCE table, though it is unnecessary to create a PROCEDURE_OCCURRENCE record for each measurement if one does not exist in the source data. Measurements differ from Observations in that they require a standardized test or some other activity to generate a quantitative or qualitative result. If there is no result, it is assumed that the lab test was conducted but the result was not captured.

ShortMeasurement OMOP Table
Logical ModelInstances of this logical model are not marked to be the target of a Reference
2. OMOPMeasurement.measurement-id
Definition

Measurement Identifier

ShortMeasurement Identifier
Control1..1
Typeinteger
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
4. OMOPMeasurement.person-id
Definition

The PERSON_ID of the Person for whom the Measurement is recorded. This may be a system generated code.

ShortPerson
Control1..1
TypeReference(Person OMOP Table)
6. OMOPMeasurement.measurement-concept-id
Definition

The MEASUREMENT_CONCEPT_ID field is recommended for primary use in analyses, and must be used for network studies.

ShortMeasurement
Control1..1
TypeReference(Concept OMOP Table)
8. OMOPMeasurement.measurement-date
Definition

Use this date to determine the date of the measurement.

ShortMeasurement Date
Control1..1
Typedate
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
10. OMOPMeasurement.measurement-datetime
Definition

Measurement Datetime

ShortMeasurement Datetime
Control0..1
TypedateTime
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
12. OMOPMeasurement.measurement-time
Definition

Measurement Time

ShortMeasurement Time
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
14. OMOPMeasurement.measurement-type-concept-id
Definition

This field can be used to determine the provenance of the Measurement record, as in whether the measurement was from an EHR system, insurance claim, registry, or other sources.

ShortMeasurement Type
Control1..1
TypeReference(Concept OMOP Table)
16. OMOPMeasurement.operator-concept-id
Definition

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 =.

ShortOperator
Control0..1
TypeReference(Concept OMOP Table)
18. OMOPMeasurement.value-as-number
Definition

This is the numerical value of the Result of the Measurement, if available. Note that measurements such as blood pressures will be split into their component parts i.e. one record for systolic, one record for diastolic.

ShortValue as Number
Control0..1
Typedecimal
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
20. OMOPMeasurement.value-as-concept-id
Definition

If the raw data gives a categorial result for measurements those values are captured and mapped to standard concepts in the 'Meas Value' domain.

ShortValue as Concept
Control0..1
TypeReference(Concept OMOP Table)
22. OMOPMeasurement.unit-concept-id
Definition

There is currently no recommended unit for individual measurements, i.e. it is not mandatory to represent Hemoglobin a1C measurements as a percentage. UNIT_SOURCE_VALUES should be mapped to a Standard Concept in the Unit domain that best represents the unit as given in the source data.

ShortUnit
Control0..1
TypeReference(Concept OMOP Table)
24. OMOPMeasurement.range-low
Definition

Ranges have the same unit as the VALUE_AS_NUMBER. These ranges are provided by the source and should remain NULL if not given.

ShortRange Low
Control0..1
Typedecimal
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
26. OMOPMeasurement.range-high
Definition

Ranges have the same unit as the VALUE_AS_NUMBER. These ranges are provided by the source and should remain NULL if not given.

ShortRange High
Control0..1
Typedecimal
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
28. OMOPMeasurement.provider-id
Definition

The provider associated with measurement record, e.g. the provider who ordered the test or the provider who recorded the result.

ShortProvider
Control0..1
TypeReference(Provider OMOP Table)
30. OMOPMeasurement.visit-occurrence-id
Definition

The visit during which the Measurement occurred.

ShortVisit Occurence
Control0..1
TypeReference(Visit Occurrence OMOP Table)
32. OMOPMeasurement.visit-detail-id
Definition

The VISIT_DETAIL record during which the Measurement occurred. For example, if the Person was in the ICU at the time the VISIT_OCCURRENCE record would reflect the overall hospital stay and the VISIT_DETAIL record would reflect the ICU stay during the hospital visit.

ShortVisit Detail
Control0..1
TypeReference(Visit Detail OMOP Table)
34. OMOPMeasurement.measurement-source-value
Definition

This field houses the verbatim value from the source data representing the Measurement that occurred. For example, this could be an ICD10 or Read code.

ShortMeasurement Source Value
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
36. OMOPMeasurement.measurement-source-concept-id
Definition

This is the concept representing the MEASUREMENT_SOURCE_VALUE and may not necessarily be standard. This field is discouraged from use in analysis because it is not required to contain Standard Concepts that are used across the OHDSI community, and should only be used when Standard Concepts do not adequately represent the source detail for the Measurement necessary for a given analytic use case. Consider using MEASUREMENT_CONCEPT_ID instead to enable standardized analytics that can be consistent across the network.

ShortMeasurement Source
Control0..1
TypeReference(Concept OMOP Table)
38. OMOPMeasurement.unit-source-value
Definition

This field houses the verbatim value from the source data representing the unit of the Measurement that occurred.

ShortUnit Source Value
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
40. OMOPMeasurement.unit-source-concept-id
Definition

This is the concept representing the UNIT_SOURCE_VALUE and may not necessarily be standard. This field is discouraged from use in analysis because it is not required to contain Standard Concepts that are used across the OHDSI community, and should only be used when Standard Concepts do not adequately represent the source detail for the Measurement necessary for a given analytic use case. Consider using UNIT_CONCEPT_ID instead to enable standardized analytics that can be consistent across the network.

ShortUnit Source
Control0..1
TypeReference(Concept OMOP Table)
42. OMOPMeasurement.value-source-value
Definition

This field houses the verbatim result value of the Measurement from the source data .

ShortValue Source Value
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
44. OMOPMeasurement.measurement-event-id
Definition

If the Measurement record is related to another record in the database, this field is the primary key of the linked record.

ShortMeasurement Event
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
46. OMOPMeasurement.meas-event-field-concept-id
Definition

If the Measurement record is related to another record in the database, this field is the CONCEPT_ID that identifies which table the primary key of the linked record came from.

ShortMeasurement Event Field
Control0..1
TypeReference(Concept OMOP Table)

Guidance on how to interpret the contents of this table can be found here

0. OMOPMeasurement
Definition

The MEASUREMENT table contains records of Measurements, 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. Measurements are stored as attribute value pairs, with the attribute as the Measurement Concept and the value representing the result. The value can be a Concept (stored in VALUE_AS_CONCEPT), or a numerical value (VALUE_AS_NUMBER) with a Unit (UNIT_CONCEPT_ID). The Procedure for obtaining the sample is housed in the PROCEDURE_OCCURRENCE table, though it is unnecessary to create a PROCEDURE_OCCURRENCE record for each measurement if one does not exist in the source data. Measurements differ from Observations in that they require a standardized test or some other activity to generate a quantitative or qualitative result. If there is no result, it is assumed that the lab test was conducted but the result was not captured.

ShortMeasurement OMOP Table
Control0..*
Is Modifierfalse
Logical ModelInstances of this logical model are not marked to be the target of a Reference
2. OMOPMeasurement.measurement-id
Definition

Measurement Identifier

ShortMeasurement Identifier
Control1..1
Typeinteger
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
4. OMOPMeasurement.person-id
Definition

The PERSON_ID of the Person for whom the Measurement is recorded. This may be a system generated code.

ShortPerson
Control1..1
TypeReference(Person OMOP Table)
6. OMOPMeasurement.measurement-concept-id
Definition

The MEASUREMENT_CONCEPT_ID field is recommended for primary use in analyses, and must be used for network studies.

ShortMeasurement
Control1..1
TypeReference(Concept OMOP Table)
8. OMOPMeasurement.measurement-date
Definition

Use this date to determine the date of the measurement.

ShortMeasurement Date
Control1..1
Typedate
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
10. OMOPMeasurement.measurement-datetime
Definition

Measurement Datetime

ShortMeasurement Datetime
Control0..1
TypedateTime
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
12. OMOPMeasurement.measurement-time
Definition

Measurement Time

ShortMeasurement Time
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
14. OMOPMeasurement.measurement-type-concept-id
Definition

This field can be used to determine the provenance of the Measurement record, as in whether the measurement was from an EHR system, insurance claim, registry, or other sources.

ShortMeasurement Type
Control1..1
TypeReference(Concept OMOP Table)
16. OMOPMeasurement.operator-concept-id
Definition

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 =.

ShortOperator
Control0..1
TypeReference(Concept OMOP Table)
18. OMOPMeasurement.value-as-number
Definition

This is the numerical value of the Result of the Measurement, if available. Note that measurements such as blood pressures will be split into their component parts i.e. one record for systolic, one record for diastolic.

ShortValue as Number
Control0..1
Typedecimal
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
20. OMOPMeasurement.value-as-concept-id
Definition

If the raw data gives a categorial result for measurements those values are captured and mapped to standard concepts in the 'Meas Value' domain.

ShortValue as Concept
Control0..1
TypeReference(Concept OMOP Table)
22. OMOPMeasurement.unit-concept-id
Definition

There is currently no recommended unit for individual measurements, i.e. it is not mandatory to represent Hemoglobin a1C measurements as a percentage. UNIT_SOURCE_VALUES should be mapped to a Standard Concept in the Unit domain that best represents the unit as given in the source data.

ShortUnit
Control0..1
TypeReference(Concept OMOP Table)
24. OMOPMeasurement.range-low
Definition

Ranges have the same unit as the VALUE_AS_NUMBER. These ranges are provided by the source and should remain NULL if not given.

ShortRange Low
Control0..1
Typedecimal
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
26. OMOPMeasurement.range-high
Definition

Ranges have the same unit as the VALUE_AS_NUMBER. These ranges are provided by the source and should remain NULL if not given.

ShortRange High
Control0..1
Typedecimal
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
28. OMOPMeasurement.provider-id
Definition

The provider associated with measurement record, e.g. the provider who ordered the test or the provider who recorded the result.

ShortProvider
Control0..1
TypeReference(Provider OMOP Table)
30. OMOPMeasurement.visit-occurrence-id
Definition

The visit during which the Measurement occurred.

ShortVisit Occurence
Control0..1
TypeReference(Visit Occurrence OMOP Table)
32. OMOPMeasurement.visit-detail-id
Definition

The VISIT_DETAIL record during which the Measurement occurred. For example, if the Person was in the ICU at the time the VISIT_OCCURRENCE record would reflect the overall hospital stay and the VISIT_DETAIL record would reflect the ICU stay during the hospital visit.

ShortVisit Detail
Control0..1
TypeReference(Visit Detail OMOP Table)
34. OMOPMeasurement.measurement-source-value
Definition

This field houses the verbatim value from the source data representing the Measurement that occurred. For example, this could be an ICD10 or Read code.

ShortMeasurement Source Value
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
36. OMOPMeasurement.measurement-source-concept-id
Definition

This is the concept representing the MEASUREMENT_SOURCE_VALUE and may not necessarily be standard. This field is discouraged from use in analysis because it is not required to contain Standard Concepts that are used across the OHDSI community, and should only be used when Standard Concepts do not adequately represent the source detail for the Measurement necessary for a given analytic use case. Consider using MEASUREMENT_CONCEPT_ID instead to enable standardized analytics that can be consistent across the network.

ShortMeasurement Source
Control0..1
TypeReference(Concept OMOP Table)
38. OMOPMeasurement.unit-source-value
Definition

This field houses the verbatim value from the source data representing the unit of the Measurement that occurred.

ShortUnit Source Value
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
40. OMOPMeasurement.unit-source-concept-id
Definition

This is the concept representing the UNIT_SOURCE_VALUE and may not necessarily be standard. This field is discouraged from use in analysis because it is not required to contain Standard Concepts that are used across the OHDSI community, and should only be used when Standard Concepts do not adequately represent the source detail for the Measurement necessary for a given analytic use case. Consider using UNIT_CONCEPT_ID instead to enable standardized analytics that can be consistent across the network.

ShortUnit Source
Control0..1
TypeReference(Concept OMOP Table)
42. OMOPMeasurement.value-source-value
Definition

This field houses the verbatim result value of the Measurement from the source data .

ShortValue Source Value
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
44. OMOPMeasurement.measurement-event-id
Definition

If the Measurement record is related to another record in the database, this field is the primary key of the linked record.

ShortMeasurement Event
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
46. OMOPMeasurement.meas-event-field-concept-id
Definition

If the Measurement record is related to another record in the database, this field is the CONCEPT_ID that identifies which table the primary key of the linked record came from.

ShortMeasurement Event Field
Control0..1
TypeReference(Concept OMOP Table)

Guidance on how to interpret the contents of this table can be found here

0. OMOPMeasurement
Definition

The MEASUREMENT table contains records of Measurements, 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. Measurements are stored as attribute value pairs, with the attribute as the Measurement Concept and the value representing the result. The value can be a Concept (stored in VALUE_AS_CONCEPT), or a numerical value (VALUE_AS_NUMBER) with a Unit (UNIT_CONCEPT_ID). The Procedure for obtaining the sample is housed in the PROCEDURE_OCCURRENCE table, though it is unnecessary to create a PROCEDURE_OCCURRENCE record for each measurement if one does not exist in the source data. Measurements differ from Observations in that they require a standardized test or some other activity to generate a quantitative or qualitative result. If there is no result, it is assumed that the lab test was conducted but the result was not captured.

ShortMeasurement OMOP Table
Control0..*
Is Modifierfalse
Logical ModelInstances of this logical model are not marked to be the target of a Reference
2. OMOPMeasurement.measurement-id
Definition

Measurement Identifier

ShortMeasurement Identifier
Control1..1
Typeinteger
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
4. OMOPMeasurement.person-id
Definition

The PERSON_ID of the Person for whom the Measurement is recorded. This may be a system generated code.

ShortPerson
Control1..1
TypeReference(Person OMOP Table)
6. OMOPMeasurement.measurement-concept-id
Definition

The MEASUREMENT_CONCEPT_ID field is recommended for primary use in analyses, and must be used for network studies.

ShortMeasurement
Control1..1
TypeReference(Concept OMOP Table)
8. OMOPMeasurement.measurement-date
Definition

Use this date to determine the date of the measurement.

ShortMeasurement Date
Control1..1
Typedate
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
10. OMOPMeasurement.measurement-datetime
Definition

Measurement Datetime

ShortMeasurement Datetime
Control0..1
TypedateTime
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
12. OMOPMeasurement.measurement-time
Definition

Measurement Time

ShortMeasurement Time
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
14. OMOPMeasurement.measurement-type-concept-id
Definition

This field can be used to determine the provenance of the Measurement record, as in whether the measurement was from an EHR system, insurance claim, registry, or other sources.

ShortMeasurement Type
Control1..1
TypeReference(Concept OMOP Table)
16. OMOPMeasurement.operator-concept-id
Definition

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 =.

ShortOperator
Control0..1
TypeReference(Concept OMOP Table)
18. OMOPMeasurement.value-as-number
Definition

This is the numerical value of the Result of the Measurement, if available. Note that measurements such as blood pressures will be split into their component parts i.e. one record for systolic, one record for diastolic.

ShortValue as Number
Control0..1
Typedecimal
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
20. OMOPMeasurement.value-as-concept-id
Definition

If the raw data gives a categorial result for measurements those values are captured and mapped to standard concepts in the 'Meas Value' domain.

ShortValue as Concept
Control0..1
TypeReference(Concept OMOP Table)
22. OMOPMeasurement.unit-concept-id
Definition

There is currently no recommended unit for individual measurements, i.e. it is not mandatory to represent Hemoglobin a1C measurements as a percentage. UNIT_SOURCE_VALUES should be mapped to a Standard Concept in the Unit domain that best represents the unit as given in the source data.

ShortUnit
Control0..1
TypeReference(Concept OMOP Table)
24. OMOPMeasurement.range-low
Definition

Ranges have the same unit as the VALUE_AS_NUMBER. These ranges are provided by the source and should remain NULL if not given.

ShortRange Low
Control0..1
Typedecimal
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
26. OMOPMeasurement.range-high
Definition

Ranges have the same unit as the VALUE_AS_NUMBER. These ranges are provided by the source and should remain NULL if not given.

ShortRange High
Control0..1
Typedecimal
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
28. OMOPMeasurement.provider-id
Definition

The provider associated with measurement record, e.g. the provider who ordered the test or the provider who recorded the result.

ShortProvider
Control0..1
TypeReference(Provider OMOP Table)
30. OMOPMeasurement.visit-occurrence-id
Definition

The visit during which the Measurement occurred.

ShortVisit Occurence
Control0..1
TypeReference(Visit Occurrence OMOP Table)
32. OMOPMeasurement.visit-detail-id
Definition

The VISIT_DETAIL record during which the Measurement occurred. For example, if the Person was in the ICU at the time the VISIT_OCCURRENCE record would reflect the overall hospital stay and the VISIT_DETAIL record would reflect the ICU stay during the hospital visit.

ShortVisit Detail
Control0..1
TypeReference(Visit Detail OMOP Table)
34. OMOPMeasurement.measurement-source-value
Definition

This field houses the verbatim value from the source data representing the Measurement that occurred. For example, this could be an ICD10 or Read code.

ShortMeasurement Source Value
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
36. OMOPMeasurement.measurement-source-concept-id
Definition

This is the concept representing the MEASUREMENT_SOURCE_VALUE and may not necessarily be standard. This field is discouraged from use in analysis because it is not required to contain Standard Concepts that are used across the OHDSI community, and should only be used when Standard Concepts do not adequately represent the source detail for the Measurement necessary for a given analytic use case. Consider using MEASUREMENT_CONCEPT_ID instead to enable standardized analytics that can be consistent across the network.

ShortMeasurement Source
Control0..1
TypeReference(Concept OMOP Table)
38. OMOPMeasurement.unit-source-value
Definition

This field houses the verbatim value from the source data representing the unit of the Measurement that occurred.

ShortUnit Source Value
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
40. OMOPMeasurement.unit-source-concept-id
Definition

This is the concept representing the UNIT_SOURCE_VALUE and may not necessarily be standard. This field is discouraged from use in analysis because it is not required to contain Standard Concepts that are used across the OHDSI community, and should only be used when Standard Concepts do not adequately represent the source detail for the Measurement necessary for a given analytic use case. Consider using UNIT_CONCEPT_ID instead to enable standardized analytics that can be consistent across the network.

ShortUnit Source
Control0..1
TypeReference(Concept OMOP Table)
42. OMOPMeasurement.value-source-value
Definition

This field houses the verbatim result value of the Measurement from the source data .

ShortValue Source Value
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
44. OMOPMeasurement.measurement-event-id
Definition

If the Measurement record is related to another record in the database, this field is the primary key of the linked record.

ShortMeasurement Event
Control0..1
Typestring
Primitive ValueThis primitive element may be present, or absent, or replaced by an extension
46. OMOPMeasurement.meas-event-field-concept-id
Definition

If the Measurement record is related to another record in the database, this field is the CONCEPT_ID that identifies which table the primary key of the linked record came from.

ShortMeasurement Event Field
Control0..1
TypeReference(Concept OMOP Table)