documentation:cdm:cdm:vocabulary
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
documentation:cdm:cdm:vocabulary [2014/11/14 15:35] cgreich created |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== 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
Page Tools
