VOCABULARY table

THIS IS OUTDATED. All documentation is now on the github wiki. Please refer there or to the CDM working group for more information

The VOCABULARY table includes a list of the Vocabularies collected from various sources or created de novo by the OMOP community. This reference table is populated with a single record for each Vocabulary source and includes a descriptive name and other associated attributes for the Vocabulary.

FieldRequiredTypeDescription
vocabulary_idYesvarchar(20)A unique identifier for each Vocabulary, such as ICD9CM, SNOMED, Visit.
vocabulary_nameYesvarchar(255)The name describing the vocabulary, for example “International Classification of Diseases, Ninth Revision, Clinical Modification, Volume 1 and 2 (NCHS)” etc.
vocabulary_referenceYesvarchar(255)External reference to documentation or available download of the about the vocabulary.
vocabulary_versionYesvarchar(255)Version of the Vocabulary as indicated in the source.
vocabulary_concept_idYesintegerA foreign key that refers to a standard concept identifier in the CONCEPT table for the Vocabulary the VOCABULARY record belongs to.

Conventions