ID

35296

Beskrivning

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

Länk

http://omop.fnih.org/publiclicense

Nyckelord

Versioner (4)
  1. 2017-01-04 2017-01-04 -
  2. 2019-02-12 2019-02-12 -
  3. 2019-02-26 2019-02-26 -
  4. 2019-02-26 2019-02-26 -
Rättsinnehavare

Observational Medical Outcomes Partnership (OMOP)

Uppladdad den

26 februari 2019

DOI

För en begäran logga in.

Licens

Creative Commons BY-NC 3.0
Modellkommentarer :

Här kan du kommentera modellen. Med hjälp av pratbubblor i Item-grupperna och Item kan du lägga in specifika kommentarer.

Tillbaka till modellkommentarer
Itemgroup-kommentar för :

Item-kommentar för :

Du måste vara inloggad för att kunna ladda ner formulär. Var vänlig logga in eller registrera dig utan kostnad.

OMOP Common Data Model (CDM) Measurement

Engelsk

OMOP Common Data Model (CDM) Measurement

1 Formulär  
Measurement
Beskrivning

Measurement

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

A unique identifier for each measurement.

Datatyp

integer

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

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.

Datatyp

integer

Alias
UMLS CUI [1]
C2348585
Measurement concept ID
Beskrivning

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.

Datatyp

integer

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

The date of the Measurement.

Datatyp

date

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

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.

Datatyp

datetime

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

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

Datatyp

time

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

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

Datatyp

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
Beskrivning

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

Datatyp

integer

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

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

Datatyp

float

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

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.

Datatyp

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
Beskrivning

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

Datatyp

integer

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

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.

Datatyp

float

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

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.

Datatyp

float

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

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

Datatyp

integer

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

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

Datatyp

integer

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

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

Datatyp

integer

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

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

Datatyp

text

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

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

Datatyp

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
Beskrivning

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

Datatyp

text

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

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

Datatyp

text

Alias
UMLS CUI [1,1]
C0449416
UMLS CUI [1,2]
C1522609
Tillbaka till toppen

Similar models

OMOP Common Data Model (CDM) Measurement

1 Formulär
Name
Typ
Description | Question | Decode (Coded Value)
Datatyp
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])
Tillbaka till toppen 

Kontakt

Använd detta formulär för feedback, frågor och förslag på förbättringar.

Fält markerade med * är obligatoriska.

Hjälp

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