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_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 |