DW_ORG_HIERARCHY_DENORM_DH (Preview)
This table requires activation of Grants Management functional area. This table stores deflated structure of organization hierarchy.
Details
Module: Grants Management
Key Columns
PARENT_ORGANIZATION_ID, TREE_CODE, TREE_VERSION_ID, TREE_STRUCTURE_CODE, CHILD_ORGANIZATION_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PARENT_ORGANIZATION_ID | NUMBER | True | Identifier of the parent organization | ||||
| CHILD_ORGANIZATION_ID | NUMBER | True | Identifier of the child organization | ||||
| TREE_STRUCTURE_CODE | VARCHAR2 | 32 | True | TREE_STRUCTURE_CODE | |||
| TREE_CODE | VARCHAR2 | 32 | True | TREE_CODE | |||
| TREE_VERSION_ID | VARCHAR2 | 64 | True | SponsorBasePEOLocNumber | |||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. System | ||||
| OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 | Used to implement optimistic locking. | |||
| PARENT_LEVEL | NUMBER | 38 | 0 | Stores the level of the parent organization | |||
| CHILD_LEVEL | NUMBER | 38 | 0 | Stores the level of the child organization | |||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. |