vocabulary
Vocabulary Tables
Table Columns
| field | type | required | phi | phi scrubbing operation |
|---|---|---|---|---|
| vocabulary_id | STRING | Yes | No | |
| vocabulary_name | STRING | Yes | No | |
| vocabulary_reference | STRING | Yes | No | |
| vocabulary_version | STRING | No | No | |
| vocabulary_concept_id | INTEGER | Yes | No | |
| load_table_id (Stanford construct for traceability) | STRING | No | No | |
| load_row_id (Stanford construct for traceability) | STRING | No | No |
Columns Description
vocabulary_id
A unique identifier for each Vocabulary, such as ICD9CM, SNOMED, Visit.
vocabulary_name
The name describing the vocabulary, for example “International Classification of Diseases, Ninth Revision, Clinical Modification, Volume 1 and 2 (NCHS)” etc.
vocabulary_reference
External reference to documentation or available download of the about the vocabulary.
vocabulary_version
Version of the Vocabulary as indicated in the source.
vocabulary_concept_id
A foreign key that refers to a standard concept identifier in the CONCEPT table for the Vocabulary the VOCABULARY record belongs to
load_table_id (stanford construct for traceability)
A json string with the primary keys of the table in Clarity where most of the information for a given row is sourced
load_row_id (stanford construct for traceability)
A reference to the position in the ETL code responsible for bringing in this row level data