Sidebar
documentation:cdm:cdm:vocabulary
This is an old revision of the document!
Vocabulary
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.
The record with vocabulary_id = 0 is reserved to contain information regarding the current version of the Entire Standardized Vocabularies.
| Field | Required | Type | Description |
|---|---|---|---|
| vocabulary_id | Yes | varchar(20) | A unique identifier for each vocabulary, such as ICD9CM, SNOMED, Visit. |
| vocabulary_name | Yes | varchar(255) | The name describing the vocabulary, for example “International Classification of Diseases, Ninth Revision, Clinical Modification, Volume 1 and 2 (NCHS)” etc. |
| vocabulary_reference | Yes | varchar(255) | External reference to documentation or available download of the about the vocabulary. |
| vocabulary_version | Yes | varchar(255) | Version of the vocabulary as indicated in the source. |
| vocabulary_concept_id | Yes | integer | A foreign key that refers to a standard concept identifier in the CONCEPT table for the vocabulary the VOCABULARY record belongs to. |
documentation/cdm/cdm/vocabulary.1415979337.txt.gz · Last modified: 2014/11/14 15:35 by cgreich
