DW_ORG_HIRERARCHY_DENORM_DH

This table stores deflated structure of organization hierarchy.

Details

Module: Grants Management

Key Columns

CHILD_ORGANIZATION_ID, TREE_STRUCTURE_CODE, TREE_CODE, PARENT_ORGANIZATION_ID, TREE_VERSION_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     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.    

Copyright © 2019, 2023, Oracle and/or its affiliates.