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.
- MODIFIER_PATH
- A path that delineates the modifier's hierarchy
- MODIFIER_CD
- A code that represents the modifier
- NAME_CHAR
- The name of the modifier
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 |
