DW_ORGANIZATION_RF_DH
It stores organization 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
| 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 ancestor 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.