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

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.