/
CONCEPT_DIMENSION Table

CONCEPT_DIMENSION Table

Sep 04, 2018

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.

  1. CONCEPT_PATH

  • A path that delineates the concept's hierarchy

 

  1. CONCEPT_CD

  • A code that represents the diagnosis, procedure, or any other coded value

 

  1. 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