Beschrijving

A unique identifier for each concept across all domains. For all Concepts, whether they are custom generated or adopted from published terminologies, a unique numeric identifier concept_id is assigned and used as the key to link all observational data to the corresponding Concept reference data. The concept_id of a Concept is persistent, i.e. stays the same for the same Concept between releases of the Standardized Vocabularies. Values for CONCEPT_IDs generated as part of Standardized Vocabularies will be reserved from 0 to 2,000,000,000. Above this range, CONCEPT_IDs are available for local use and are guaranteed not to clash with future releases of the Standardized Vocabularies.

Datatype

integer

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C1300638

Beschrijving

An unambiguous, meaningful and descriptive name for the concept.

Datatype

text

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C0027365

Beschrijving

A foreign key to the DOMAIN table the Concept belongs to.

Datatype

text

Alias

UMLS CUI [1,1]

C1883204

UMLS CUI [1,2]

C1300638

Beschrijving

A foreign key to the vocabulary table indicating from which source the concept has been adapted.

Datatype

text

Alias

UMLS CUI [1,1]

C0042926

UMLS CUI [1,2]

C1300638

Beschrijving

The attribute or concept class of the Concept. Examples are 'Clinical Drug', 'Ingredient', 'Clinical Finding' etc. Concept Class attributes should not be confused with Classification Concepts. These are separate Concepts that have a hierarchical relationship to Standard Concepts or each other, while Concept Classes are unique Vocabulary-specific attributes for each Concept. Standard Concepts (designated as 'S' in the standard_concept field) may appear in CDM tables in all *_concept_id fields, whereas Classification Concepts ('C') should not appear in the CDM data, but participate in the construction of the CONCEPT_ANCESTOR table and can be used to identify Descendants that may appear in the data. See CONCEPT_ANCESTOR table. Non-standard Concepts can only appear in *_source_concept_id fields and are not used in CONCEPT_ANCESTOR table. Please refer to the Standardized Vocabularies specifications for details of the Standard Concept designation.

Datatype

text

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C0456387

UMLS CUI [1,3]

C1300638

Beschrijving

This flag determines where a Concept is a Standard Concept, i.e. is used in the data, a Classification Concept, or a non-standard Source Concept. The allowables values are 'S' (Standard Concept) and 'C' (Classification Concept), otherwise the content is NULL.

Datatype

text

Alias

UMLS CUI [1,1]

C0034925

UMLS CUI [1,2]

C0178566

Beschrijving

The concept code represents the identifier of the Concept in the source vocabulary, such as SNOMED-CT concept IDs, RxNorm RXCUIs etc. Note that concept codes are not unique across vocabularies. For Concepts inherited from published terminologies, the source code is retained in the concept_code field and can be used to reference the source vocabulary.

Datatype

text

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C0805701

Beschrijving

The date when the Concept was first recorded. The default value is 1-Jan-1970, meaning, the Concept has no (known) date of inception. Concepts without a known instantiated date are assigned valid_start_date of '1-Jan-1970'.

Datatype

date

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C2349101

UMLS CUI [1,3]

C0808070

Beschrijving

The date when the Concept became invalid because it was deleted or superseded (updated) by a new concept. The default value is 31-Dec-2099, meaning, the Concept is valid until it becomes deprecated. Concepts that are not invalid are assigned valid_end_date of '31-Dec-2099'.

Datatype

date

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C2349101

UMLS CUI [1,3]

C0806020

Beschrijving

Reason the Concept was invalidated. Possible values are D (deleted), U (replaced with an update) or NULL when valid_end_date has the default value. Deprecated Concepts (with a valid_end_date before the release date of the Standardized Vocabularies) will have a value of 'D' (deprecated without successor) or 'U' (updated). The updated Concepts have a record in the CONCEPT_RELATIONSHIP table indicating their active replacement Concept.

Datatype

text

Alias

UMLS CUI [1,1]

C0178566

UMLS CUI [1,2]

C3245471

UMLS CUI [1,3]

C0566251