The MODIFIER_DIMENSION table contains one row for each modifier. The modifier has the similar hierarchical organization as the concept type. The Ontology cell maintains the mapping of how the modifier applies to the types of concepts and at what level; whether it is applied to a particular concept or to all its children.
The MODIFIER_DIMENSION table has three REQUIRED columns.

  1. MODIFIER_PATH


  1. MODIFIER_CD


  1. NAME_CHAR



MODIFIER_DIMENSION

 

 

PK

MODIFIER_PATH

varchar(700)

 

MODIFIER_CD

varchar(50)

 

NAME_CHAR

varchar(2000)

 

MODIFIER_BLOB

text

 

UPDATE_DATE

datetime

 

DOWNLOAD_DATE

datetime

 

IMPORT_DATE

datetime

 

SOURCESYSTEM_CD

varchar(50)

 

UPLOAD_ID

int