documentation:cdm:vocabulary
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| documentation:cdm:vocabulary [2014/12/02 01:49] – [Conventions] jduke | documentation:cdm:vocabulary [2020/01/03 12:31] (current) – ekorchmar | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== VOCABULARY | + | ===== VOCABULARY |
| + | **THIS IS OUTDATED. All documentation is now on the [[https:// | ||
| - | The VOCABULARY table includes a list of the vocabularies | + | The VOCABULARY table includes a list of the Vocabularies |
| - | + | ||
| - | 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 " | |vocabulary_name|Yes|varchar(255)|The name describing the vocabulary, for example " | ||
| |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 | + | |vocabulary_version|Yes|varchar(255)|Version of the Vocabulary |
| - | |vocabulary_concept_id|Yes|integer|A foreign key that refers to a standard concept identifier in the CONCEPT table for the vocabulary | + | |vocabulary_concept_id|Yes|integer|A foreign key that refers to a standard concept identifier in the CONCEPT table for the Vocabulary |
| ==== Conventions ==== | ==== Conventions ==== | ||
| - | * There is one record for each Vocabulary. One Vocabulary source or vendor can issue several Vocabularies, | + | * There is one record for each Vocabulary. One Vocabulary source or vendor can issue several Vocabularies, |
| * 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 = ' | ||
| * 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 | + | * Each Vocabulary has an entry in the 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: |
| - | |1|SNOMED| | + | |1|[[documentation: |
| - | |2|ICD9CM| | + | |2|[[documentation: |
| - | |3|ICD9Proc| | + | |3|[[documentation: |
| - | |4|CPT4| | + | |4|[[documentation: |
| - | |5|HCPCS| | + | |5|[[documentation: |
| - | |6|LOINC| | + | |6|[[documentation: |
| - | |7|NDFRT| | + | |7|[[documentation: |
| - | |8|RxNorm| | + | |8|[[documentation: |
| - | |9|NDC| | + | |9|[[documentation: |
| - | |10|GPI| | + | |10|[[documentation: |
| - | |11|UCUM| | + | |11|[[documentation: |
| - | |12|Gender| | + | |12|[[documentation: |
| - | |13|Race| | + | |13|[[documentation: |
| - | |14|Place of Service| | + | |14|[[documentation: |
| - | |15|MedDRA| | + | |15|[[documentation: |
| - | |16|Multum| | + | |16|[[documentation: |
| - | |17|Read| | + | |17|[[documentation: |
| - | |18|OXMIS| | + | |18|[[documentation: |
| - | |19|Indication| | + | |19|[[documentation: |
| - | |20|ETC| | + | |20|[[documentation: |
| - | |21|ATC| | + | |21|[[documentation: |
| - | |22|Multilex| | + | |22|[[documentation: |
| - | |24|Visit| | + | |24|[[documentation: |
| - | |28|VA Product| | + | |28|[[documentation: |
| - | |31|SMQ| | + | |31|[[documentation: |
| - | |32|VA Class| | + | |32|[[documentation: |
| - | |33|Cohort| | + | |33|[[documentation: |
| - | |34|ICD10| | + | |34|[[documentation: |
| - | |35|ICD10PCS| | + | |35|[[documentation: |
| - | |36|Drug Type| | + | |36|[[documentation: |
| - | |37|Condition Type| | + | |37|[[documentation: |
| - | |38|Procedure Type| | + | |38|[[documentation: |
| - | |39|Observation Type| | + | |39|[[documentation: |
| - | |40|DRG| | + | |40|[[documentation: |
| - | |41|MDC| | + | |41|[[documentation: |
| - | |42|APC| | + | |42|[[documentation: |
| - | |43|Revenue Code| | + | |43|[[documentation: |
| - | |44|Ethnicity| | + | |44|[[documentation: |
| - | |45|Death Type| | + | |45|[[documentation: |
| - | |46|Mesh| | + | |46|[[documentation: |
| - | |47|NUCC| | + | |47|[[documentation: |
| - | |48|Specialty| | + | |48|[[documentation: |
| - | |49|LOINC | + | |49|[[documentation: |
| - | |50|SPL| | + | |50|[[documentation: |
| - | |53|Genseqno| | + | |53|[[documentation: |
| - | |54|CCS| | + | |54|[[documentation: |
| - | |55|OPCS4| | + | |55|[[documentation: |
| - | |56|Gemscript| | + | |56|[[documentation: |
| - | |57|HES Specialty| | + | |57|[[documentation: |
| - | |58|Note Type| | + | |58|[[documentation: |
| - | |59|Domain| | + | |59|[[documentation: |
| - | |60|PCORNet| | + | |60|[[documentation: |
| - | |61|Obs Period Type| | + | |61|[[documentation: |
| - | |62|Visit Type| | + | |62|[[documentation: |
| - | |63|Device Type| | + | |63|[[documentation: |
| - | |64|Meas Type| | + | |64|[[documentation: |
| - | |65|Currency| | + | |65|[[documentation: |
| - | |66|Relationship| | + | |66|[[documentation: |
| - | |67|Vocabulary| | + | |67|[[documentation: |
| - | |68|Concept Class| | + | |68|[[documentation: |
| - | |69|Cohort Type| | + | |69|[[documentation: |
| - | |70|ICD10CM| | + | |70|[[documentation: |
| + | |71|[[documentation: | ||
documentation/cdm/vocabulary.1417484993.txt.gz · Last modified: by jduke