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: Measurement OMOP Table

Official URL: https://interop.esante.gouv.fr/ig/fhir/eds/StructureDefinition/OMOPMeasurement Version: 0.1.0
Draft as of 2024-11-23 Computable Name: OMOPMeasurement

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.

Usage:

Formal Views of Profile Content

Description of Profiles, Differentials, Snapshots and how the different presentations work.

This structure is derived from Base

NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPMeasurement 0..* Base Measurement OMOP Table
Instances of this logical model are not marked to be the target of a Reference
... measurement_id 1..1 integer Measurement Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... measurement_concept_id 1..1 Reference(Concept OMOP Table) Measurement
... measurement_datetime 0..1 dateTime Measurement Datetime
... measurement_time 0..1 string Measurement Time
... measurement_type_concept_id 1..1 Reference(Concept OMOP Table) Measurement Type
... operator_concept_id 0..1 Reference(Concept OMOP Table) Operator
... value_as_number 0..1 decimal Value as Number
... value_as_concept_id 0..1 Reference(Concept OMOP Table) Value as Concept
... unit_concept_id 0..1 Reference(Concept OMOP Table) Unit
... range_low 0..1 decimal Range Low
... range_high 0..1 decimal Range High
... provider_id 0..1 Reference(Provider OMOP Table) Provider
... visit_occurrence_id 0..1 Reference(Visit Occurrence OMOP Table) Visit Occurence
... visit_detail_id 0..1 Reference(Visit Detail OMOP Table) Visit Detail
... measurement_source_value 0..1 string Measurement Source Value
... measurement_source_concept_id 0..1 Reference(Concept OMOP Table) Measurement Source
... unit_source_value 0..1 string Unit Source Value
... unit_source_concept_id 0..1 Reference(Concept OMOP Table) Unit Source
... value_source_value 0..1 string Value Source Value
... measurement_event_id 0..1 string Measurement Event
... meas_event_field_concept_id 0..1 Reference(Concept OMOP Table) Measurement Event Field

doco Documentation for this format
NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPMeasurement 0..* Base Measurement OMOP Table
Instances of this logical model are not marked to be the target of a Reference
... measurement_id 1..1 integer Measurement Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... measurement_concept_id 1..1 Reference(Concept OMOP Table) Measurement
... measurement_datetime 0..1 dateTime Measurement Datetime
... measurement_time 0..1 string Measurement Time
... measurement_type_concept_id 1..1 Reference(Concept OMOP Table) Measurement Type
... operator_concept_id 0..1 Reference(Concept OMOP Table) Operator
... value_as_number 0..1 decimal Value as Number
... value_as_concept_id 0..1 Reference(Concept OMOP Table) Value as Concept
... unit_concept_id 0..1 Reference(Concept OMOP Table) Unit
... range_low 0..1 decimal Range Low
... range_high 0..1 decimal Range High
... provider_id 0..1 Reference(Provider OMOP Table) Provider
... visit_occurrence_id 0..1 Reference(Visit Occurrence OMOP Table) Visit Occurence
... visit_detail_id 0..1 Reference(Visit Detail OMOP Table) Visit Detail
... measurement_source_value 0..1 string Measurement Source Value
... measurement_source_concept_id 0..1 Reference(Concept OMOP Table) Measurement Source
... unit_source_value 0..1 string Unit Source Value
... unit_source_concept_id 0..1 Reference(Concept OMOP Table) Unit Source
... value_source_value 0..1 string Value Source Value
... measurement_event_id 0..1 string Measurement Event
... meas_event_field_concept_id 0..1 Reference(Concept OMOP Table) Measurement Event Field

doco Documentation for this format
NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPMeasurement 0..* Base Measurement OMOP Table
Instances of this logical model are not marked to be the target of a Reference
... measurement_id 1..1 integer Measurement Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... measurement_concept_id 1..1 Reference(Concept OMOP Table) Measurement
... measurement_datetime 0..1 dateTime Measurement Datetime
... measurement_time 0..1 string Measurement Time
... measurement_type_concept_id 1..1 Reference(Concept OMOP Table) Measurement Type
... operator_concept_id 0..1 Reference(Concept OMOP Table) Operator
... value_as_number 0..1 decimal Value as Number
... value_as_concept_id 0..1 Reference(Concept OMOP Table) Value as Concept
... unit_concept_id 0..1 Reference(Concept OMOP Table) Unit
... range_low 0..1 decimal Range Low
... range_high 0..1 decimal Range High
... provider_id 0..1 Reference(Provider OMOP Table) Provider
... visit_occurrence_id 0..1 Reference(Visit Occurrence OMOP Table) Visit Occurence
... visit_detail_id 0..1 Reference(Visit Detail OMOP Table) Visit Detail
... measurement_source_value 0..1 string Measurement Source Value
... measurement_source_concept_id 0..1 Reference(Concept OMOP Table) Measurement Source
... unit_source_value 0..1 string Unit Source Value
... unit_source_concept_id 0..1 Reference(Concept OMOP Table) Unit Source
... value_source_value 0..1 string Value Source Value
... measurement_event_id 0..1 string Measurement Event
... meas_event_field_concept_id 0..1 Reference(Concept OMOP Table) Measurement Event Field

doco Documentation for this format

Differential View

This structure is derived from Base

NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPMeasurement 0..* Base Measurement OMOP Table
Instances of this logical model are not marked to be the target of a Reference
... measurement_id 1..1 integer Measurement Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... measurement_concept_id 1..1 Reference(Concept OMOP Table) Measurement
... measurement_datetime 0..1 dateTime Measurement Datetime
... measurement_time 0..1 string Measurement Time
... measurement_type_concept_id 1..1 Reference(Concept OMOP Table) Measurement Type
... operator_concept_id 0..1 Reference(Concept OMOP Table) Operator
... value_as_number 0..1 decimal Value as Number
... value_as_concept_id 0..1 Reference(Concept OMOP Table) Value as Concept
... unit_concept_id 0..1 Reference(Concept OMOP Table) Unit
... range_low 0..1 decimal Range Low
... range_high 0..1 decimal Range High
... provider_id 0..1 Reference(Provider OMOP Table) Provider
... visit_occurrence_id 0..1 Reference(Visit Occurrence OMOP Table) Visit Occurence
... visit_detail_id 0..1 Reference(Visit Detail OMOP Table) Visit Detail
... measurement_source_value 0..1 string Measurement Source Value
... measurement_source_concept_id 0..1 Reference(Concept OMOP Table) Measurement Source
... unit_source_value 0..1 string Unit Source Value
... unit_source_concept_id 0..1 Reference(Concept OMOP Table) Unit Source
... value_source_value 0..1 string Value Source Value
... measurement_event_id 0..1 string Measurement Event
... meas_event_field_concept_id 0..1 Reference(Concept OMOP Table) Measurement Event Field

doco Documentation for this format

Key Elements View

NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPMeasurement 0..* Base Measurement OMOP Table
Instances of this logical model are not marked to be the target of a Reference
... measurement_id 1..1 integer Measurement Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... measurement_concept_id 1..1 Reference(Concept OMOP Table) Measurement
... measurement_datetime 0..1 dateTime Measurement Datetime
... measurement_time 0..1 string Measurement Time
... measurement_type_concept_id 1..1 Reference(Concept OMOP Table) Measurement Type
... operator_concept_id 0..1 Reference(Concept OMOP Table) Operator
... value_as_number 0..1 decimal Value as Number
... value_as_concept_id 0..1 Reference(Concept OMOP Table) Value as Concept
... unit_concept_id 0..1 Reference(Concept OMOP Table) Unit
... range_low 0..1 decimal Range Low
... range_high 0..1 decimal Range High
... provider_id 0..1 Reference(Provider OMOP Table) Provider
... visit_occurrence_id 0..1 Reference(Visit Occurrence OMOP Table) Visit Occurence
... visit_detail_id 0..1 Reference(Visit Detail OMOP Table) Visit Detail
... measurement_source_value 0..1 string Measurement Source Value
... measurement_source_concept_id 0..1 Reference(Concept OMOP Table) Measurement Source
... unit_source_value 0..1 string Unit Source Value
... unit_source_concept_id 0..1 Reference(Concept OMOP Table) Unit Source
... value_source_value 0..1 string Value Source Value
... measurement_event_id 0..1 string Measurement Event
... meas_event_field_concept_id 0..1 Reference(Concept OMOP Table) Measurement Event Field

doco Documentation for this format

Snapshot View

NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPMeasurement 0..* Base Measurement OMOP Table
Instances of this logical model are not marked to be the target of a Reference
... measurement_id 1..1 integer Measurement Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... measurement_concept_id 1..1 Reference(Concept OMOP Table) Measurement
... measurement_datetime 0..1 dateTime Measurement Datetime
... measurement_time 0..1 string Measurement Time
... measurement_type_concept_id 1..1 Reference(Concept OMOP Table) Measurement Type
... operator_concept_id 0..1 Reference(Concept OMOP Table) Operator
... value_as_number 0..1 decimal Value as Number
... value_as_concept_id 0..1 Reference(Concept OMOP Table) Value as Concept
... unit_concept_id 0..1 Reference(Concept OMOP Table) Unit
... range_low 0..1 decimal Range Low
... range_high 0..1 decimal Range High
... provider_id 0..1 Reference(Provider OMOP Table) Provider
... visit_occurrence_id 0..1 Reference(Visit Occurrence OMOP Table) Visit Occurence
... visit_detail_id 0..1 Reference(Visit Detail OMOP Table) Visit Detail
... measurement_source_value 0..1 string Measurement Source Value
... measurement_source_concept_id 0..1 Reference(Concept OMOP Table) Measurement Source
... unit_source_value 0..1 string Unit Source Value
... unit_source_concept_id 0..1 Reference(Concept OMOP Table) Unit Source
... value_source_value 0..1 string Value Source Value
... measurement_event_id 0..1 string Measurement Event
... meas_event_field_concept_id 0..1 Reference(Concept OMOP Table) Measurement Event Field

doco Documentation for this format

 

Other representations of profile: CSV, Excel