MASTER DEPT HIERARCHY Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_CODE |
The code for the DLC associated with this room set, e.g., D_BIOLOGY. |
VARCHAR2 |
180 |
DLC_KEY |
a unigue key to enable joining information stored with other forms of Department Key |
VARCHAR2 |
180 |
DLC_NAME |
The name of the DLC associated with this room set. |
VARCHAR2 |
840 |
HIERARCHY_TYPE |
XXX |
VARCHAR2 |
600 |
MASTER_DEPT_HIER_LEVEL_1_CODE |
XXX |
VARCHAR2 |
180 |
MASTER_DEPT_HIER_LEVEL_1_NAME |
XXX |
VARCHAR2 |
840 |
MASTER_DEPT_HIER_LEVEL_2_CODE |
XXX |
VARCHAR2 |
180 |
MASTER_DEPT_HIER_LEVEL_2_NAME |
XXX |
VARCHAR2 |
840 |
MASTER_DEPT_HIER_LEVEL_3_CODE |
XXX |
VARCHAR2 |
180 |
MASTER_DEPT_HIER_LEVEL_3_NAME |
XXX |
VARCHAR2 |
840 |
MASTER_DEPT_HIER_LEVEL_4_CODE |
XXX |
VARCHAR2 |
180 |
MASTER_DEPT_HIER_LEVEL_4_NAME |
XXX |
VARCHAR2 |
840 |
MASTER_DEPT_HIER_LEVEL_5_CODE |
XXX |
VARCHAR2 |
180 |
MASTER_DEPT_HIER_LEVEL_5_NAME |
XXX |
VARCHAR2 |
840 |