MASTER DEPT HIERARCHY Table
View exposing master department hierarchy records including DLC identifiers and hierarchical rollup levels used for organizational reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_CODE |
Code identifying dlc. |
VARCHAR2 |
180 |
DLC_KEY |
Surrogate key identifying the dlc. |
VARCHAR2 |
180 |
DLC_NAME |
Dlc name associated with the record. |
VARCHAR2 |
840 |
HIERARCHY_TYPE |
Hierarchy type associated with the record. |
VARCHAR2 |
600 |
MASTER_DEPT_HIER_LEVEL_1_CODE |
Code identifying master dept hier level 1. |
VARCHAR2 |
180 |
MASTER_DEPT_HIER_LEVEL_1_NAME |
Master dept hier level 1 name associated with the record. |
VARCHAR2 |
840 |
MASTER_DEPT_HIER_LEVEL_2_CODE |
Code identifying master dept hier level 2. |
VARCHAR2 |
180 |
MASTER_DEPT_HIER_LEVEL_2_NAME |
Master dept hier level 2 name associated with the record. |
VARCHAR2 |
840 |
MASTER_DEPT_HIER_LEVEL_3_CODE |
Code identifying master dept hier level 3. |
VARCHAR2 |
180 |
MASTER_DEPT_HIER_LEVEL_3_NAME |
Master dept hier level 3 name associated with the record. |
VARCHAR2 |
840 |
MASTER_DEPT_HIER_LEVEL_4_CODE |
Code identifying master dept hier level 4. |
VARCHAR2 |
180 |
MASTER_DEPT_HIER_LEVEL_4_NAME |
Master dept hier level 4 name associated with the record. |
VARCHAR2 |
840 |
MASTER_DEPT_HIER_LEVEL_5_CODE |
Code identifying master dept hier level 5. |
VARCHAR2 |
180 |
MASTER_DEPT_HIER_LEVEL_5_NAME |
Master dept hier level 5 name associated with the record. |
VARCHAR2 |
840 |