DW_DEPARTMENT_CF_DH

It stores department hierarchy information in column flattened format.

Details

Module:

Key Columns

TREE_VERSION_ID, DEPARTMENT_ID, ENTERPRISE_ID, TREE_STRUCTURE_CODE, TREE_CODE

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 Department Tree Structure #1    
TREE_CODE VARCHAR2 32   True Code for the Department Tree    
TREE_VERSION_ID VARCHAR2 64   True Tree version Identifier DW_TREE_VERSION_D_TL TREE_VERSION_ID
DEPARTMENT_ID NUMBER 38 0 True Department Id of the hierarchy node.    
SOURCE_RECORD_ID VARCHAR2 256     Source record identifier    
TREE_VERSION_END_DATE DATE       indicates the date at the beginning of the date range within which the tree version is effective.    
TREE_VERSION_START_DATE DATE       indicates the date at the end of the date range within which the tree version is effective.    
TREE_VERSION_STATUS VARCHAR2 32     Tree Version Status, Possible Value is ACTIVE, as only Active Trees are stored in this table.    
LEVEL0_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 0, this is the bottom most level. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL1_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 1. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL2_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 2. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL3_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 3. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL4_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 4. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL5_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 5. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL6_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 6. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL7_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 7. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL8_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 8. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL9_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 9. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL10_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 10. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL11_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 11. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL12_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 12. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL13_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 13. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL14_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 14. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL15_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 15. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL16_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 16. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL17_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 17. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL18_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 18. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL19_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 19. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL20_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 20. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL21_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 21. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL22_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 22. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL23_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 23. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL24_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 24. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL25_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 25. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL26_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 26. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL27_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 27. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL28_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 28. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL29_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 29. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL30_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 30. DW_DEPARTMENT_D DEPARTMENT_ID
LEVEL31_DEPARTMENT_ID NUMBER 38 0   Department Identifier at the level 31. DW_DEPARTMENT_D DEPARTMENT_ID
NODE_DISTANCE NUMBER 38 0   Distance between the Node and its Ancestor.    

Notes

#1 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, TREE_NODE_ID

ENTERPRISE_ID.