# DW_DEPARTMENT_RF_DH

It stores department hierarchy information in row flattened format.

## Details

Module:

## Key Columns

TREE_STRUCTURE_CODE, TREE_CODE, RF_TREE_NODE_ID, TREE_NODE_ID, TREE_VERSION_ID, ENTERPRISE_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.

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