The CONCEPT_DIMENSION table contains one row for each concept. Possible concept types are diagnoses, procedures, medications and lab tests. The structure of the table gives enough flexibility to store virtually any type of concept, such as demographics and genetics data.
The CONCEPT_DIMENSION table has three REQUIRED columns.
- CONCEPT_PATH
- A path that delineates the concept's hierarchy
- CONCEPT_CD
- A code that represents the diagnosis, procedure, or any other coded value
- NAME_CHAR
- The name of the concept
CONCEPT_DIMENSION |
|
|
PK |
CONCEPT_PATH |
varchar(700) |
|
CONCEPT_CD |
varchar(50) |
|
NAME_CHAR |
varchar(2000) |
|
CONCEPT_BLOB |
text |
|
UPDATE_DATE |
datetime |
|
DOWNLOAD_DATE |
datetime |
|
IMPORT_DATE |
datetime |
|
SOURCESYSTEM_CD |
varchar(50) |
|
UPLOAD_ID |
int |
