Beschreibung

A unique identifier for each observation.

Datentyp

integer

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C1300638

Beschreibung

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

Datentyp

integer

Alias

UMLS CUI [1,1]

C0027361

UMLS CUI [1,2]

C1300638

Beschreibung

A foreign key to the standard observation concept identifier in the Standardized Vocabularies. Each survey response record is the response to a specific question identified by the OBSERVATION_CONCEPT_ID. This concept ID is a unique question contained in the CONCEPT table.

Datentyp

integer

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638

Beschreibung

The date of the observation.

Datentyp

date

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C0011008

Beschreibung

The date and time of the observation.

Datentyp

datetime

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C0011008

UMLS CUI [1,3]

C0040223

Beschreibung

A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of the observation.

Datentyp

integer

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C0332307

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Beschreibung

The observation result stored as a number. This is applicable to observations where the result is expressed as a numeric value.

Datentyp

float

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C1522609

Beschreibung

The observation result stored as a string. This is applicable to observations where the result is expressed as verbatim text. (Type varchar(60))

Datentyp

text

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C1547402

Beschreibung

A foreign key to an observation result stored as a concept identifier. This is applicable to observations where the result can be expressed as a standard concept from the Standardized Vocabularies (e.g., positive/negative, present/absent, low/high, etc.). Valid Concepts of the VALUE AS CONCEPT field are not enforced, but typically belong to the 'Meas Value' domain. Note that the value of VALUE_AS_CONCEPT_ID may be provided through mapping from a source Concept which contains the content of the Observation. 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'.

Datentyp

integer

Alias

UMLS CUI [1,1]

C1522609

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638

Beschreibung

A foreign key to a standard concept identifier for a qualifier (e.g., severity of drug-drug interaction alert). The QUALIFIER_CONCEPT_ID field contains all attributes specifying the clinical fact further, such as as degrees, severities, drug-drug interaction alerts etc.

Datentyp

integer

Alias

UMLS CUI [1,1]

C1514623

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638

Beschreibung

A foreign key to a standard concept identifier of measurement units in the Standardized Vocabularies.

Datentyp

integer

Alias

UMLS CUI [1,1]

C1519795

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638

Beschreibung

A foreign key to the provider in the provider table who was responsible for making the observation. The Provider making the observation is recorded through a reference to the PROVIDER table. This information is not always available.

Datentyp

integer

Alias

UMLS CUI [1,1]

C1138603

UMLS CUI [1,2]

C1300638

Beschreibung

A foreign key to the visit in the visit occurence table during which the observation was recorded. The Visit during which the Observation was made is recorded through a reference to the VISIT_OCCURRENCE table. This information is not always available.

Datentyp

integer

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C2745955

UMLS CUI [1,3]

C1300638

Beschreibung

A foreign key to the visit in the VISIT_DETAIL table during which the observation was recorded. The Visit Detail during which the Observation was made is recorded through a reference to the VISIT_DETAIL table. This information is not always available.

Datentyp

integer

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C1522508

UMLS CUI [1,3]

C1300638

Beschreibung

The observation code 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))

Datentyp

text

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C0449416

UMLS CUI [1,3]

C0805701

UMLS CUI [1,4]

C0600091

Beschreibung

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

Datentyp

integer

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C0449416

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Beschreibung

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

Datentyp

text

Alias

UMLS CUI [1,1]

C1519795

UMLS CUI [1,2]

C0449416

UMLS CUI [1,3]

C0805701

Beschreibung

The source value associated with a qualifier to characterize the observation. (Type varchar(50))

Datentyp

text

Alias

UMLS CUI [1,1]

C1514623

UMLS CUI [1,2]

C0449416

UMLS CUI [1,3]

C0805701

UMLS CUI [1,4]

C0600091

Beschreibung

A foreign key to an event table (e.g., PROCEDURE_OCCURRENCE_ID).

Datentyp

integer

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C0441471

UMLS CUI [1,3]

C1300638

Beschreibung

A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies referring to the field represented in the OBSERVATION EVENT ID.

Datentyp

integer

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C0441471

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Beschreibung

The observation result stored as a datetime value. This is applicable to observations where the result is expressed as a point in time.

Datentyp

integer

Alias

UMLS CUI [1,1]

C0700325

UMLS CUI [1,2]

C0011008

UMLS CUI [1,3]

C0040223

UMLS CUI [1,4]

C1522609