DW_ORGANIZATION_CF_DH

It stores organization hierarchy information in column flattened format.

Details

Module:

Key Columns

TREE_VERSION_ID, ENTERPRISE_ID, ORGANIZATION_ID, TREE_CODE, TREE_STRUCTURE_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 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
ORGANIZATION_ID NUMBER 38 0 True Organization 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_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 0, this is the bottom most level. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL1_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 1. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL2_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 2. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL3_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 3. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL4_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 4. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL5_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 5. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL6_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 6. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL7_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 7. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL8_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 8. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL9_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 9. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL10_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 10. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL11_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 11. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL12_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 12. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL13_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 13. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL14_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 14. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL15_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 15. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL16_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 16. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL17_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 17. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL18_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 18. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL19_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 19. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL20_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 20. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL21_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 21. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL22_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 22. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL23_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 23. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL24_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 24. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL25_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 25. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL26_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 26. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL27_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 27. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL28_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 28. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL29_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 29. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL30_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 30. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEVEL31_ORGANIZATION_ID NUMBER 38 0   Organization Identifier at the level 31. DW_INTERNAL_ORG_D ORGANIZATION_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.