DW_DEPARTMENT_RF_DH

It stores department hierarchy information in row flattened format.

Details

Module:

Key Columns

TREE_VERSION_ID, TREE_CODE, RF_TREE_NODE_ID, ENTERPRISE_ID, TREE_STRUCTURE_CODE, TREE_NODE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ENTERPRISE_ID NUMBER 38 0 True Enterprise Identifier    
TREE_STRUCTURE_CODE VARCHAR2 32   True Code for the Organization Tree Structure #1    
TREE_CODE VARCHAR2 32   True Code for the Organization Tree    
TREE_VERSION_ID VARCHAR2 64   True Tree version Identifier DW_TREE_VERSION_D_TL TREE_VERSION_ID
TREE_NODE_ID VARCHAR2 64   True Unique identifier for tree node.    
RF_TREE_NODE_ID VARCHAR2 64   True Unique identifier for tree node.    
SOURCE_RECORD_ID VARCHAR2 256     Source record identifier    
PK1_VALUE NUMBER 38 0   Primary key value of the node. DW_INTERNAL_ORG_D ORGANIZATION_ID
PARENT_PK1_VALUE NUMBER 38 0   Primary key value of the parent node. DW_INTERNAL_ORG_D ORGANIZATION_ID
NODE_DISTANCE NUMBER 38 0   Distance between the Node and its Ancestor.    
LEAF_FLAG VARCHAR2 16     Flag to indicate if this Node is a Leaf Node.    

Notes

#1 Tree version status, effective start date and effective end date are present in DW_TREE_VERSION_D table. Join using TREE_CODE, TREE_STRUCTURE_CODE, TREE_VERSION_ID.

#2 Translated tree version name, tree version description and tree version comments are present in DW_TREE_VERSION_D_TL table. Join using TREE_CODE, TREE_STRUCTURE_CODE, TREE_VERSION_ID,ENTERPRISE_ID.

#3 Translated tree name and tree description are present in DW_TREE_D_TL table. Join using TREE_CODE, TREE_STRUCTURE_CODE.

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