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.
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. |
vocabulary_id previously | vocabulary_id Version 5 |
---|---|
0 | None |
1 | SNOMED |
2 | ICD9CM |
3 | ICD9Proc |
4 | CPT4 |
5 | HCPCS |
6 | LOINC |
7 | NDFRT |
8 | RxNorm |
9 | NDC |
10 | GPI |
11 | UCUM |
12 | Gender |
13 | Race |
14 | Place of Service |
15 | MedDRA |
16 | Multum |
17 | Read |
18 | OXMIS |
19 | Indication |
20 | ETC |
21 | ATC |
22 | Multilex |
24 | Visit |
28 | VA Product |
31 | SMQ |
32 | VA Class |
33 | Cohort |
34 | ICD10 |
35 | ICD10PCS |
36 | Drug Type |
37 | Condition Type |
38 | Procedure Type |
39 | Observation Type |
40 | DRG |
41 | MDC |
42 | APC |
43 | Revenue Code |
44 | Ethnicity |
45 | Death Type |
46 | Mesh |
47 | NUCC |
48 | Specialty |
49 | LOINC |
50 | SPL |
53 | Genseqno |
54 | CCS |
55 | OPCS4 |
56 | Gemscript |
57 | HES Specialty |
58 | Note Type |
59 | Domain |
60 | PCORNet |
61 | Obs Period Type |
62 | Visit Type |
63 | Device Type |
64 | Meas Type |
65 | Currency |
66 | Relationship |
67 | Vocabulary |
68 | Concept Class |
69 | Cohort Type |
70 | ICD10CM |
71 | ICDO3 |