ID

35296

Beschrijving

OMOP Common Data Model (CDM) Measurement 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. OMOP Common Data Model Version 6.0 Specifications 11October2018. The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medical products. © 2014 Observational Health Data Sciences and Informatics. This work is based on work by the Observational Medical Outcomes Partnership (OMOP) and used under license from the FNIH at http://omop.fnih.org/publiclicense. Version updated on 26.02.2019, from https://github.com/OHDSI/CommonDataModel/wiki/MEASUREMENT Measurements differ from Observations in that they require a standardized test or some other activity to generate a quantitative or qualitative result. For example, LOINC 1755-8 concept_id 3027035 'Albumin [Mass/time] in 24 hour Urine' is the lab test to measure a certain chemical in a urine sample. Even though each Measurement always have a result, the fields VALUE_AS_NUMBER and VALUE_AS_CONCEPT_ID are not mandatory. When the result is not known, the Measurement record represents just the fact that the corresponding Measurement was carried out, which in itself is already useful information for some use cases. 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). For some Measurement Concepts, the result is included in the test. For example, ICD10 concept_id 45595451 'Presence of alcohol in blood, level not specified' indicates a Measurement and the result (present). In those situations, the CONCEPT_RELATIONSHIP table in addition to the 'Maps to' record contains a second record with the relationship_id set to 'Maps to value'. In this example, the 'Maps to' relationship directs to 4041715 'Blood ethanol measurement' as well as a 'Maps to value' record to 4181412 'Present'. If reference ranges for upper and lower limit of normal as provided (typically by a laboratory) these are stored in the RANGE_HIGH and RANGE_LOW fields. Ranges have the same unit as the VALUE_AS_NUMBER. The Visit during which the observation was made is recorded through a reference to the VISIT_OCCURRENCE table. This information is not always available. The Provider making the observation is recorded through a reference to the PROVIDER table. This information is not always available. If there is a negative value coming from the source, set the VALUE_AS_NUMBER to NULL, with the exception of the following Measurements (listed as LOINC codes): 1925-7 Base excess in Arterial blood by calculation 1927-3 Base excess in Venous blood by calculation 8632-2 QRS-Axis 11555-0 Base excess in Blood by calculation 1926-5 Base excess in Capillary blood by calculation 28638-5 Base excess in Arterial cord blood by calculation 28639-3 Base excess in Venous cord blood by calculation

Link

http://omop.fnih.org/publiclicense

Trefwoorden

Versies (4)
  1. 04-01-17 04-01-17 -
  2. 12-02-19 12-02-19 -
  3. 26-02-19 26-02-19 -
  4. 26-02-19 26-02-19 -
Houder van rechten

Observational Medical Outcomes Partnership (OMOP)

Geüploaded op

26 februari 2019

DOI

Voor een aanvraag inloggen.

Licentie

Creative Commons BY-NC 3.0
Model Commentaren :

Hier kunt u commentaar leveren op het model. U kunt de tekstballonnen bij de itemgroepen en items gebruiken om er specifiek commentaar op te geven.

Terug naar het model Commentaren
Itemgroep Commentaren voor :

Item Commentaren voor :

U moet ingelogd zijn om formulieren te downloaden. AUB inloggen of schrijf u gratis in.

OMOP Common Data Model (CDM) Measurement

Engels

OMOP Common Data Model (CDM) Measurement

1 Formulieren  
Measurement
Beschrijving

Measurement

Alias
UMLS CUI-1
C0242485
UMLS CUI-2
C2708733
Measurement ID
Beschrijving

A unique identifier for each measurement.

Datatype

integer

Alias
UMLS CUI [1,1]
C0242485
UMLS CUI [1,2]
C1300638
Person ID
Beschrijving

A foreign key identifier to the Person about whom the measurement was recorded. The demographic details of that Person are stored in the PERSON table.

Datatype

integer

Alias
UMLS CUI [1]
C2348585
Measurement concept ID
Beschrijving

A foreign key to the standard measurement concept identifier in the Standardized Vocabularies. These belong to the 'Measurement' domain, but could overlap with the 'Observation' domain. Valid Measurement Concepts (MEASUREMENT_CONCEPT_ID) belong to the 'Measurement' domain, but could overlap with the 'Observation' domain. This is due to the fact that there is a continuum between systematic examination or testing (Measurement) and a simple determination of fact (Observation). When the Measurement Source Value of the code cannot be translated into a standard Measurement Concept ID, a Measurement entry is stored with only the corresponding SOURCE_CONCEPT_ID and MEASUREMENT_SOURCE_VALUE and a MEASUREMENT_CONCEPT_ID of 0.

Datatype

integer

Alias
UMLS CUI [1,1]
C0242485
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Measurement date
Beschrijving

The date of the Measurement.

Datatype

date

Alias
UMLS CUI [1,1]
C0242485
UMLS CUI [1,2]
C0011008
Measurement datetime
Beschrijving

The date and time of the Measurement. Some database systems don't have a datatype of time. To accommodate all temporal analyses, datatype datetime can be used.

Datatype

datetime

Alias
UMLS CUI [1,1]
C0242485
UMLS CUI [1,2]
C0011008
UMLS CUI [2,1]
C0242485
UMLS CUI [2,2]
C0040223
Measurement time
Beschrijving

The time of the Measurement. This is present for backwards compatibility and will be deprecated in an upcoming version. (Type varchar(10))

Datatype

time

Alias
UMLS CUI [1,1]
C0242485
UMLS CUI [1,2]
C0040223
Measurement type concept ID
Beschrijving

A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the provenance from where the Measurement record was recorded. These belong to the 'Meas Type' vocabulary

Datatype

integer

Alias
UMLS CUI [1,1]
C0242485
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Operator concept ID
Beschrijving

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 <, <=, =, >=, > and these concepts belong to the 'Meas Value Operator' domain. 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 =.

Datatype

integer

Alias
UMLS CUI [1,1]
C1705273
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Value as number
Beschrijving

A Measurement result where the result is expressed as a numeric value. The Unit is optional even if a VALUE_AS_NUMBER is provided.

Datatype

float

Alias
UMLS CUI [1,1]
C0242485
UMLS CUI [1,2]
C1522609
Value as concept ID
Beschrijving

A foreign key to a Measurement result represented as a Concept from the Standardized Vocabularies (e.g., positive/negative, present/absent, low/high, etc.). These belong to the 'Meas Value' domain. Valid Concepts for the VALUE_AS_CONCEPT field belong to the 'Meas Value' domain.

Datatype

integer

Alias
UMLS CUI [1,1]
C0242485
UMLS CUI [1,2]
C1522609
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Unit concept ID
Beschrijving

A foreign key to a Standard Concept ID of Measurement Units in the Standardized Vocabularies that belong to the 'Unit' domain.

Datatype

integer

Alias
UMLS CUI [1,1]
C1519795
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Range low
Beschrijving

The lower limit of the normal range of the Measurement result. The lower range is assumed to be of the same unit of measure as the Measurement value.

Datatype

float

Alias
UMLS CUI [1,1]
C0086715
UMLS CUI [1,2]
C2827739
Range high
Beschrijving

The upper limit of the normal range of the measurement. The upper range is assumed to be in the same units of measure as the measurement value.

Datatype

float

Alias
UMLS CUI [1,1]
C0086715
UMLS CUI [1,2]
C2827740
Provider ID
Beschrijving

A foreign key to the provider in the PROVIDER table who was responsible for initiating or obtaining the measurement.

Datatype

integer

Alias
UMLS CUI [1,1]
C1138603
UMLS CUI [1,2]
C1300638
Visit occurrence ID
Beschrijving

A foreign key to the Visit in the VISIT_OCCURRENCE table during which the Measurement was recorded.

Datatype

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Visit detail ID
Beschrijving

A foreign key to the Visit Detail in the VISIT_DETAIL table during which the Measurement was recorded.

Datatype

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1522508
UMLS CUI [1,3]
C1300638
Measurement source value
Beschrijving

The measurement name as it appears in the source data. This code is mapped to a standard concept in the Standardized Vocabularies and the original code is, stored here for reference. (Type varchar(50))

Datatype

text

Alias
UMLS CUI [1,1]
C0242485
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0805701
Measurement source concept ID
Beschrijving

A foreign key to a concept that refers to the code used in the source.

Datatype

integer

Alias
UMLS CUI [1,1]
C0242485
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Unit source value
Beschrijving

The source code for the unit as it appears in the source data. This code is mapped to a standard unit concept in the Standardized Vocabularies and the original code is, stored here for reference. (Type varchar(50))

Datatype

text

Alias
UMLS CUI [1,1]
C1519795
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0805701
Value source value
Beschrijving

The source value associated with the content of the value_as_number or value_as_concept_id as stored in the source data. (Type varchar(50))

Datatype

text

Alias
UMLS CUI [1,1]
C0449416
UMLS CUI [1,2]
C1522609
Terug naar het begin van de pagina

Similar models

OMOP Common Data Model (CDM) Measurement

1 Formulieren
Name
Type
Description | Question | Decode (Coded Value)
Datatype
Alias
Item Group
Measurement
C0242485 (UMLS CUI-1)
C2708733 (UMLS CUI-2)
Measurement ID
Item
Measurement ID
integer
C0242485 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Person ID
Item
Person ID
integer
C2348585 (UMLS CUI [1])
Measurement concept ID
Item
Measurement concept ID
integer
C0242485 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Measurement date
Item
Measurement date
date
C0242485 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
Measurement datetime
Item
Measurement datetime
datetime
C0242485 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
C0242485 (UMLS CUI [2,1])
C0040223 (UMLS CUI [2,2])
Measurement time
Item
Measurement time
time
C0242485 (UMLS CUI [1,1])
C0040223 (UMLS CUI [1,2])
Measurement type concept ID
Item
Measurement type concept ID
integer
C0242485 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Operator concept ID
Item
Operator concept ID
integer
C1705273 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Value as number
Item
Value as number
float
C0242485 (UMLS CUI [1,1])
C1522609 (UMLS CUI [1,2])
Value as concept ID
Item
Value as concept ID
integer
C0242485 (UMLS CUI [1,1])
C1522609 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Unit concept ID
Item
Unit concept ID
integer
C1519795 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Range low
Item
Range low
float
C0086715 (UMLS CUI [1,1])
C2827739 (UMLS CUI [1,2])
Range high
Item
Range high
float
C0086715 (UMLS CUI [1,1])
C2827740 (UMLS CUI [1,2])
Provider ID
Item
Provider ID
integer
C1138603 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Visit occurrence ID
Item
Visit occurrence ID
integer
C1512346 (UMLS CUI [1,1])
C2745955 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Visit detail ID
Item
Visit detail ID
integer
C1512346 (UMLS CUI [1,1])
C1522508 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Measurement source value
Item
Measurement source value
text
C0242485 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
Measurement source concept ID
Item
Measurement source concept ID
integer
C0242485 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Unit source value
Item
Unit source value
text
C1519795 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
Value source value
Item
Value source value
text
C0449416 (UMLS CUI [1,1])
C1522609 (UMLS CUI [1,2])
Terug naar het begin van de pagina 

Contact

Gebruik dit formulier voor feedback, vragen en verbeteringsvoorstellen.

Velden gemarkeerd met een * zijn verplicht.

Help

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial