Descrição

A unique identifier for each measurement.

Tipo de dados

integer

Alias

UMLS CUI [1,1]

C0242485

UMLS CUI [1,2]

C1300638

Descrição

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.

Tipo de dados

integer

Alias

UMLS CUI [1]

C2348585

Descrição

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.

Tipo de dados

integer

Alias

UMLS CUI [1,1]

C0242485

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638

Descrição

The date of the Measurement.

Tipo de dados

date

Alias

UMLS CUI [1,1]

C0242485

UMLS CUI [1,2]

C0011008

Descrição

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.

Tipo de dados

datetime

Alias

UMLS CUI [1,1]

C0242485

UMLS CUI [1,2]

C0011008

UMLS CUI [2,1]

C0242485

UMLS CUI [2,2]

C0040223

Descrição

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

Tipo de dados

time

Alias

UMLS CUI [1,1]

C0242485

UMLS CUI [1,2]

C0040223

Descrição

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

Tipo de dados

integer

Alias

UMLS CUI [1,1]

C0242485

UMLS CUI [1,2]

C0332307

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Descrição

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

Tipo de dados

integer

Alias

UMLS CUI [1,1]

C1705273

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638

Descrição

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

Tipo de dados

float

Alias

UMLS CUI [1,1]

C0242485

UMLS CUI [1,2]

C1522609

Descrição

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.

Tipo de dados

integer

Alias

UMLS CUI [1,1]

C0242485

UMLS CUI [1,2]

C1522609

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Descrição

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

Tipo de dados

integer

Alias

UMLS CUI [1,1]

C1519795

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638

Descrição

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.

Tipo de dados

float

Alias

UMLS CUI [1,1]

C0086715

UMLS CUI [1,2]

C2827739

Descrição

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.

Tipo de dados

float

Alias

UMLS CUI [1,1]

C0086715

UMLS CUI [1,2]

C2827740

Descrição

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

Tipo de dados

integer

Alias

UMLS CUI [1,1]

C1138603

UMLS CUI [1,2]

C1300638

Descrição

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

Tipo de dados

integer

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C2745955

UMLS CUI [1,3]

C1300638

Descrição

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

Tipo de dados

integer

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C1522508

UMLS CUI [1,3]

C1300638

Descrição

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.

Tipo de dados

text

Alias

UMLS CUI [1,1]

C0242485

UMLS CUI [1,2]

C0449416

UMLS CUI [1,3]

C0805701

Descrição

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

Tipo de dados

integer

Alias

UMLS CUI [1,1]

C0242485

UMLS CUI [1,2]

C0449416

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Descrição

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.

Tipo de dados

text

Alias

UMLS CUI [1,1]

C1519795

UMLS CUI [1,2]

C0449416

UMLS CUI [1,3]

C0805701

Descrição

The source value associated with the content of the value_as_number or value_as_concept_id as stored in the source data.

Tipo de dados

text

Alias

UMLS CUI [1,1]

C0449416

UMLS CUI [1,2]

C1522609