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/13 18:45] – cgreich | documentation:cdm:vocabulary [2020/01/03 12:31] (current) – ekorchmar | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== VOCABULARY table ===== | ===== VOCABULARY table ===== | ||
| + | **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|[[documentation: | + | |1|[[documentation: |
| - | |2|[[documentation: | + | |2|[[documentation: |
| - | |3|[[documentation: | + | |3|[[documentation: |
| - | |4|[[documentation: | + | |4|[[documentation: |
| - | |5|[[documentation: | + | |5|[[documentation: |
| - | |6|[[documentation: | + | |6|[[documentation: |
| - | |7|[[documentation: | + | |7|[[documentation: |
| - | |8|[[documentation: | + | |8|[[documentation: |
| - | |9|[[documentation: | + | |9|[[documentation: |
| - | |10|[[documentation: | + | |10|[[documentation: |
| - | |11|[[documentation: | + | |11|[[documentation: |
| - | |12|[[documentation: | + | |12|[[documentation: |
| - | |13|[[documentation: | + | |13|[[documentation: |
| - | |14|[[documentation: | + | |14|[[documentation: |
| - | |15|[[documentation: | + | |15|[[documentation: |
| - | |16|[[documentation: | + | |16|[[documentation: |
| - | |17|[[documentation: | + | |17|[[documentation: |
| - | |18|[[documentation: | + | |18|[[documentation: |
| - | |19|[[documentation: | + | |19|[[documentation: |
| - | |20|[[documentation: | + | |20|[[documentation: |
| - | |21|[[documentation: | + | |21|[[documentation: |
| - | |22|[[documentation: | + | |22|[[documentation: |
| - | |24|[[documentation: | + | |24|[[documentation: |
| - | |28|[[documentation: | + | |28|[[documentation: |
| - | |31|[[documentation: | + | |31|[[documentation: |
| - | |32|[[documentation: | + | |32|[[documentation: |
| - | |33|[[documentation: | + | |33|[[documentation: |
| - | |34|[[documentation: | + | |34|[[documentation: |
| - | |35|[[documentation: | + | |35|[[documentation: |
| - | |36|[[documentation: | + | |36|[[documentation: |
| - | |37|[[documentation: | + | |37|[[documentation: |
| - | |38|[[documentation: | + | |38|[[documentation: |
| - | |39|[[documentation: | + | |39|[[documentation: |
| - | |40|[[documentation: | + | |40|[[documentation: |
| - | |41|[[documentation: | + | |41|[[documentation: |
| - | |42|[[documentation: | + | |42|[[documentation: |
| - | |43|[[documentation: | + | |43|[[documentation: |
| - | |44|[[documentation: | + | |44|[[documentation: |
| - | |45|[[documentation: | + | |45|[[documentation: |
| - | |46|[[documentation: | + | |46|[[documentation: |
| - | |47|[[documentation: | + | |47|[[documentation: |
| - | |48|[[documentation: | + | |48|[[documentation: |
| - | |49|[[documentation: | + | |49|[[documentation: |
| - | |50|[[documentation: | + | |50|[[documentation: |
| - | |53|[[documentation: | + | |53|[[documentation: |
| - | |54|[[documentation: | + | |54|[[documentation: |
| - | |55|[[documentation: | + | |55|[[documentation: |
| - | |56|[[documentation: | + | |56|[[documentation: |
| - | |57|[[documentation: | + | |57|[[documentation: |
| - | |58|[[documentation: | + | |58|[[documentation: |
| - | |59|[[documentation: | + | |59|[[documentation: |
| - | |60|[[documentation: | + | |60|[[documentation: |
| - | |61|[[documentation: | + | |61|[[documentation: |
| - | |62|[[documentation: | + | |62|[[documentation: |
| - | |63|[[documentation: | + | |63|[[documentation: |
| - | |64|[[documentation: | + | |64|[[documentation: |
| - | |65|[[documentation: | + | |65|[[documentation: |
| - | |66|[[documentation: | + | |66|[[documentation: |
| - | |67|[[documentation: | + | |67|[[documentation: |
| - | |68|[[documentation: | + | |68|[[documentation: |
| - | |69|[[documentation: | + | |69|[[documentation: |
| - | |70|[[documentation: | + | |70|[[documentation: |
| + | |71|[[documentation: | ||
documentation/cdm/vocabulary.1418496335.txt.gz · Last modified: by cgreich