documentation:cdm:vocabulary
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
documentation:cdm:vocabulary [2014/12/13 18:45] cgreich |
documentation:cdm:vocabulary [2017/09/25 14:57] clairblacketer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== VOCABULARY table ===== | ===== VOCABULARY table ===== | ||
| + | **THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|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. | + | 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^ | ^Field^Required^Type^Description^ | ||
| - | |vocabulary_id|Yes|varchar(20)|A unique identifier for each vocabulary, such as ICD9CM, SNOMED, Visit.| | + | |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_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_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_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_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.| |
| ==== Conventions ==== | ==== Conventions ==== | ||
| - | * There is one record for each Vocabulary. One Vocabulary source or vendor can issue several Vocabularies, each of them creating their own record in the VOCABULARY table. However, the choice of whether a Vocabulary contains Concepts of different Concept Classes, or when these different classes constitute separate Vocabularies cannot precisely be decided based on the definition of what constitutes a Vocabulary. For example, the ICD-9 Volume 1 and 2 codes (ICD9CM, containing predominantly conditions and some procedures and observations) and the ICD-9 Volume 3 codes (ICD9Proc, containing predominantly procedures) are realized as two different vocabularies. On the other hand, SNOMED-CT codes of the class Condition and those of the class Procedure are part of one and the same Vocabulary. | + | * There is one record for each Vocabulary. One Vocabulary source or vendor can issue several Vocabularies, each of them creating their own record in the VOCABULARY table. However, the choice of whether a Vocabulary contains Concepts of different Concept Classes, or when these different classes constitute separate Vocabularies cannot precisely be decided based on the definition of what constitutes a Vocabulary. For example, the ICD-9 Volume 1 and 2 codes (ICD9CM, containing predominantly conditions and some procedures and observations) and the ICD-9 Volume 3 codes (ICD9Proc, containing predominantly procedures) are realized as two different Vocabularies. On the other hand, SNOMED-CT codes of the class Condition and those of the class Procedure are part of one and the same Vocabulary. Please refer to the Standardized Vocabularies [[documentation:vocabulary:vocabularies|Specifications]] for details of each Vocabulary. |
| * The vocabulary_id field contains an alphanumerical identifier, that can also be used as the abbreviation of the Vocabulary name. | * 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. | ||
| * The vocabulary_name field contains the full official name of the Vocabulary, as well as the source or vendor in parenthesis. | * The vocabulary_name field contains the full official name of the Vocabulary, as well as the source or vendor in parenthesis. | ||
| - | * 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. | + | * 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. |
| * In past versions of the VOCABULARY table, the vocabulary_id used to be a numerical value. A conversion table between these old and new IDs is given below: | * In past versions of the VOCABULARY table, the vocabulary_id used to be a numerical value. A conversion table between these old and new IDs is given below: | ||
| ^vocabulary_id previously^vocabulary_id Version 5^ | ^vocabulary_id previously^vocabulary_id Version 5^ | ||
| - | |0|None| | + | |0|[[documentation:vocabulary:none|None]]| |
| - | |1|[[documentation:vocabulary:SNOMED|SNOMED]]| | + | |1|[[documentation:vocabulary:snomed|SNOMED]]| |
| - | |2|[[documentation:vocabulary:ICD9CM|ICD9CM]]| | + | |2|[[documentation:vocabulary:icd9cm|ICD9CM]]| |
| - | |3|[[documentation:vocabulary:ICD9Proc|ICD9Proc]]| | + | |3|[[documentation:vocabulary:icd9proc|ICD9Proc]]| |
| - | |4|[[documentation:vocabulary:CPT4|CPT4]]| | + | |4|[[documentation:vocabulary:cpt4|CPT4]]| |
| - | |5|[[documentation:vocabulary:HCPCS|HCPCS]]| | + | |5|[[documentation:vocabulary:hcpcs|HCPCS]]| |
| - | |6|[[documentation:vocabulary:LOINC|LOINC]]| | + | |6|[[documentation:vocabulary:loinc|LOINC]]| |
| - | |7|[[documentation:vocabulary:NDFRT|NDFRT]]| | + | |7|[[documentation:vocabulary:ndfrt|NDFRT]]| |
| - | |8|[[documentation:vocabulary:RxNorm|RxNorm]]| | + | |8|[[documentation:vocabulary:rxnorm|RxNorm]]| |
| - | |9|[[documentation:vocabulary:NDC|NDC]]| | + | |9|[[documentation:vocabulary:ndc|NDC]]| |
| - | |10|[[documentation:vocabulary:GPI|GPI]]| | + | |10|[[documentation:vocabulary:gpi|GPI]]| |
| - | |11|[[documentation:vocabulary:UCUM|UCUM]]| | + | |11|[[documentation:vocabulary:ucum|UCUM]]| |
| - | |12|[[documentation:vocabulary:Gender|Gender]]| | + | |12|[[documentation:vocabulary:gender|Gender]]| |
| - | |13|[[documentation:vocabulary:Race|Race]]| | + | |13|[[documentation:vocabulary:race|Race]]| |
| - | |14|[[documentation:vocabulary:Place of Service|Place of Service]]| | + | |14|[[documentation:vocabulary:place_of_service|Place of Service]]| |
| - | |15|[[documentation:vocabulary:MedDRA|MedDRA]]| | + | |15|[[documentation:vocabulary:meddra|MedDRA]]| |
| - | |16|[[documentation:vocabulary:Multum|Multum]]| | + | |16|[[documentation:vocabulary:multum|Multum]]| |
| - | |17|[[documentation:vocabulary:Read|Read]]| | + | |17|[[documentation:vocabulary:read|Read]]| |
| - | |18|[[documentation:vocabulary:OXMIS|OXMIS]]| | + | |18|[[documentation:vocabulary:oxmis|OXMIS]]| |
| - | |19|[[documentation:vocabulary:Indication|Indication]]| | + | |19|[[documentation:vocabulary:indication|Indication]]| |
| - | |20|[[documentation:vocabulary:ETC|ETC]]| | + | |20|[[documentation:vocabulary:etc|ETC]]| |
| - | |21|[[documentation:vocabulary:ATC|ATC]]| | + | |21|[[documentation:vocabulary:atc|ATC]]| |
| - | |22|[[documentation:vocabulary:Multilex|Multilex]]| | + | |22|[[documentation:vocabulary:multilex|Multilex]]| |
| - | |24|[[documentation:vocabulary:Visit|Visit]]| | + | |24|[[documentation:vocabulary:visit|Visit]]| |
| - | |28|[[documentation:vocabulary:VA Product|VA Product]]| | + | |28|[[documentation:vocabulary:va_product|VA Product]]| |
| - | |31|[[documentation:vocabulary:SMQ|SMQ]]| | + | |31|[[documentation:vocabulary:smq|SMQ]]| |
| - | |32|[[documentation:vocabulary:VA Class|VA Class]]| | + | |32|[[documentation:vocabulary:va_class|VA Class]]| |
| - | |33|[[documentation:vocabulary:Cohort|Cohort]]| | + | |33|[[documentation:vocabulary:cohort|Cohort]]| |
| - | |34|[[documentation:vocabulary:ICD10|ICD10]]| | + | |34|[[documentation:vocabulary:icd10|ICD10]]| |
| - | |35|[[documentation:vocabulary:ICD10PCS|ICD10PCS]]| | + | |35|[[documentation:vocabulary:icd10pcs|ICD10PCS]]| |
| - | |36|[[documentation:vocabulary:Drug Type|Drug Type]]| | + | |36|[[documentation:vocabulary:concept_type_vocabularies|Drug Type]]| |
| - | |37|[[documentation:vocabulary:Condition Type|Condition Type]]| | + | |37|[[documentation:vocabulary:concept_type_vocabularies|Condition Type]]| |
| - | |38|[[documentation:vocabulary:Procedure Type|Procedure Type]]| | + | |38|[[documentation:vocabulary:concept_type_vocabularies|Procedure Type]]| |
| - | |39|[[documentation:vocabulary:Observation Type|Observation Type]]| | + | |39|[[documentation:vocabulary:concept_type_vocabularies|Observation Type]]| |
| - | |40|[[documentation:vocabulary:DRG|DRG]]| | + | |40|[[documentation:vocabulary:drg|DRG]]| |
| - | |41|[[documentation:vocabulary:MDC|MDC]]| | + | |41|[[documentation:vocabulary:mdc|MDC]]| |
| - | |42|[[documentation:vocabulary:APC|APC]]| | + | |42|[[documentation:vocabulary:apc|APC]]| |
| - | |43|[[documentation:vocabulary:Revenue Code|Revenue Code]]| | + | |43|[[documentation:vocabulary:revenue_code|Revenue Code]]| |
| - | |44|[[documentation:vocabulary:Ethnicity|Ethnicity]]| | + | |44|[[documentation:vocabulary:ethnicity|Ethnicity]]| |
| - | |45|[[documentation:vocabulary:Death Type|Death Type]]| | + | |45|[[documentation:vocabulary:concept_type_vocabularies|Death Type]]| |
| - | |46|[[documentation:vocabulary:Mesh|Mesh]]| | + | |46|[[documentation:vocabulary:mesh|Mesh]]| |
| - | |47|[[documentation:vocabulary:NUCC|NUCC]]| | + | |47|[[documentation:vocabulary:nucc|NUCC]]| |
| - | |48|[[documentation:vocabulary:Specialty|Specialty]]| | + | |48|[[documentation:vocabulary:specialty|Specialty]]| |
| - | |49|[[documentation:vocabulary:LOINC Hierarchy|LOINC Hierarchy]]| | + | |49|[[documentation:vocabulary:loinc|LOINC]]| |
| - | |50|[[documentation:vocabulary:SPL|SPL]]| | + | |50|[[documentation:vocabulary:spl|SPL]]| |
| - | |53|[[documentation:vocabulary:Genseqno|Genseqno]]| | + | |53|[[documentation:vocabulary:genseqno|Genseqno]]| |
| - | |54|[[documentation:vocabulary:CCS|CCS]]| | + | |54|[[documentation:vocabulary:ccs|CCS]]| |
| - | |55|[[documentation:vocabulary:OPCS4|OPCS4]]| | + | |55|[[documentation:vocabulary:opcs4|OPCS4]]| |
| - | |56|[[documentation:vocabulary:Gemscript|Gemscript]]| | + | |56|[[documentation:vocabulary:gemscript|Gemscript]]| |
| - | |57|[[documentation:vocabulary:HES Specialty|HES Specialty]]| | + | |57|[[documentation:vocabulary:hes_specialty|HES Specialty]]| |
| - | |58|[[documentation:vocabulary:Note Type|Note Type]]| | + | |58|[[documentation:vocabulary:concept_type_vocabularies|Note Type]]| |
| - | |59|[[documentation:vocabulary:Domain|Domain]]| | + | |59|[[documentation:vocabulary:domain|Domain]]| |
| - | |60|[[documentation:vocabulary:PCORNet|PCORNet]]| | + | |60|[[documentation:vocabulary:pcornet|PCORNet]]| |
| - | |61|[[documentation:vocabulary:Obs Period Type|Obs Period Type]]| | + | |61|[[documentation:vocabulary:concept_type_vocabularies|Obs Period Type]]| |
| - | |62|[[documentation:vocabulary:Visit Type|Visit Type]]| | + | |62|[[documentation:vocabulary:concept_type_vocabularies|Visit Type]]| |
| - | |63|[[documentation:vocabulary:Device Type|Device Type]]| | + | |63|[[documentation:vocabulary:concept_type_vocabularies|Device Type]]| |
| - | |64|[[documentation:vocabulary:Meas Type|Meas Type]]| | + | |64|[[documentation:vocabulary:concept_type_vocabularies|Meas Type]]| |
| - | |65|[[documentation:vocabulary:Currency|Currency]]| | + | |65|[[documentation:vocabulary:currency|Currency]]| |
| - | |66|[[documentation:vocabulary:Relationship|Relationship]]| | + | |66|[[documentation:vocabulary:relationship|Relationship]]| |
| - | |67|[[documentation:vocabulary:Vocabulary|Vocabulary]]| | + | |67|[[documentation:vocabulary:vocabulary|Vocabulary]]| |
| - | |68|[[documentation:vocabulary:Concept Class|Concept Class]]| | + | |68|[[documentation:vocabulary:concept_class|Concept Class]]| |
| - | |69|[[documentation:vocabulary:Cohort Type|Cohort Type]]| | + | |69|[[documentation:vocabulary:concept_type_vocabularies|Cohort Type]]| |
| - | |70|[[documentation:vocabulary:ICD10CM|ICD10CM]]| | + | |70|[[documentation:vocabulary:icd10cm|ICD10CM]]| |
documentation/cdm/vocabulary.txt · Last modified: 2020/01/03 12:31 by ekorchmar
Page Tools
