OSP UNIT HIERARCHY Table
View exposing organizational unit hierarchy relationships for OSP including parent-child relationships and hierarchical levels used for organizational rollups and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HAS_CHILDREN_FLAG |
Indicator identifying whether has children (Y/N). |
VARCHAR2 |
1 |
OSP_UNIT_KEY |
Surrogate key identifying the osp unit. |
VARCHAR2 |
8 |
PARENT_OSP_UNIT_KEY |
Surrogate key identifying the parent osp unit. |
VARCHAR2 |
8 |
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |