DW_DEPARTMENT_RF_DH

It stores department hierarchy information in row flattened format.

Details

Module:

Key Columns

TREE_NODE_ID, TREE_STRUCTURE_CODE, TREE_CODE, ENTERPRISE_ID, RF_TREE_NODE_ID, TREE_VERSION_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 This column is for Oracle Internal use only. 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.