Beskrivning

A unique identifier for each Vocabulary, such as ICD9CM, SNOMED, Visit. The VOCABULARY_ID field contains an alphanumerical identifier, that can also be used as the abbreviation of the Vocabulary name. The record with VOCABULARY_ID = 'None' is reserved to contain information regarding the current version of the Entire Standardized Vocabularies. (Type varchar(20))

Datatyp

text

Alias

UMLS CUI [1,1]

C0042926

UMLS CUI [1,2]

C1300638

Beskrivning

The name describing the vocabulary, for example "International Classification of Diseases, Ninth Revision, Clinical Modification, Volume 1 and 2 (NCHS)" etc. The VOCABULARY_NAME field contains the full official name of the Vocabulary, as well as the source or vendor in parenthesis. (Type varchar(255))

Datatyp

text

Alias

UMLS CUI [1,1]

C0042926

UMLS CUI [1,2]

C0027365

Beskrivning

External reference to documentation or available download of the about the vocabulary. (Type varchar(255))

Datatyp

text

Alias

UMLS CUI [1,1]

C0042926

UMLS CUI [1,2]

C1706462

Beskrivning

Version of the vocabulary as indicated in the source. (Type varchar(255))

Datatyp

text

Alias

UMLS CUI [1,1]

C0042926

UMLS CUI [1,2]

C0333052

Beskrivning

A foreign key that refers to a standard concept identifier in the CONCEPT table for the Vocabulary the VOCABULARY record belongs to. Each Vocabulary has an entry in the CONCEPT table, which is recorded in the VOCABULARY_CONCEPT_ID field. This is for purposes of creating a closed Information Model, where all entities in the OMOP CDM are covered by a unique Concept.

Datatyp

integer

Alias

UMLS CUI [1,1]

C0042926

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638