DW_POSITION_CF_DH

It stores position hierarchy information in column flattened format.

Details

Module:

Key Columns

ENTERPRISE_ID, POSITION_ID, TREE_VERSION_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 Position Tree Structure #1    
TREE_CODE VARCHAR2 32   True Code for the Position Tree    
TREE_VERSION_ID VARCHAR2 64   True Tree version Identifier DW_TREE_VERSION_D_TL TREE_VERSION_ID
POSITION_ID NUMBER 38 0 True Position 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_POSITION_ID NUMBER 38 0   Position Identifier at the level 0, this is the bottom most level. #2 DW_POSITION_D POSITION_ID
LEVEL1_POSITION_ID NUMBER 38 0   Position Identifier at the level 1. DW_POSITION_D POSITION_ID
LEVEL2_POSITION_ID NUMBER 38 0   Position Identifier at the level 2. DW_POSITION_D POSITION_ID
LEVEL3_POSITION_ID NUMBER 38 0   Position Identifier at the level 3. DW_POSITION_D POSITION_ID
LEVEL4_POSITION_ID NUMBER 38 0   Position Identifier at the level 4. DW_POSITION_D POSITION_ID
LEVEL5_POSITION_ID NUMBER 38 0   Position Identifier at the level 5. DW_POSITION_D POSITION_ID
LEVEL6_POSITION_ID NUMBER 38 0   Position Identifier at the level 6. DW_POSITION_D POSITION_ID
LEVEL7_POSITION_ID NUMBER 38 0   Position Identifier at the level 7. DW_POSITION_D POSITION_ID
LEVEL8_POSITION_ID NUMBER 38 0   Position Identifier at the level 8. DW_POSITION_D POSITION_ID
LEVEL9_POSITION_ID NUMBER 38 0   Position Identifier at the level 9. DW_POSITION_D POSITION_ID
LEVEL10_POSITION_ID NUMBER 38 0   Position Identifier at the level 10. DW_POSITION_D POSITION_ID
LEVEL11_POSITION_ID NUMBER 38 0   Position Identifier at the level 11. DW_POSITION_D POSITION_ID
LEVEL12_POSITION_ID NUMBER 38 0   Position Identifier at the level 12. DW_POSITION_D POSITION_ID
LEVEL13_POSITION_ID NUMBER 38 0   Position Identifier at the level 13. DW_POSITION_D POSITION_ID
LEVEL14_POSITION_ID NUMBER 38 0   Position Identifier at the level 14. DW_POSITION_D POSITION_ID
LEVEL15_POSITION_ID NUMBER 38 0   Position Identifier at the level 15. DW_POSITION_D POSITION_ID
LEVEL16_POSITION_ID NUMBER 38 0   Position Identifier at the level 16. DW_POSITION_D POSITION_ID
LEVEL17_POSITION_ID NUMBER 38 0   Position Identifier at the level 17. DW_POSITION_D POSITION_ID
LEVEL18_POSITION_ID NUMBER 38 0   Position Identifier at the level 18. DW_POSITION_D POSITION_ID
LEVEL19_POSITION_ID NUMBER 38 0   Position Identifier at the level 19. DW_POSITION_D POSITION_ID
LEVEL20_POSITION_ID NUMBER 38 0   Position Identifier at the level 20. DW_POSITION_D POSITION_ID
LEVEL21_POSITION_ID NUMBER 38 0   Position Identifier at the level 21. DW_POSITION_D POSITION_ID
LEVEL22_POSITION_ID NUMBER 38 0   Position Identifier at the level 22. DW_POSITION_D POSITION_ID
LEVEL23_POSITION_ID NUMBER 38 0   Position Identifier at the level 23. DW_POSITION_D POSITION_ID
LEVEL24_POSITION_ID NUMBER 38 0   Position Identifier at the level 24. DW_POSITION_D POSITION_ID
LEVEL25_POSITION_ID NUMBER 38 0   Position Identifier at the level 25. DW_POSITION_D POSITION_ID
LEVEL26_POSITION_ID NUMBER 38 0   Position Identifier at the level 26. DW_POSITION_D POSITION_ID
LEVEL27_POSITION_ID NUMBER 38 0   Position Identifier at the level 27. DW_POSITION_D POSITION_ID
LEVEL28_POSITION_ID NUMBER 38 0   Position Identifier at the level 28. DW_POSITION_D POSITION_ID
LEVEL29_POSITION_ID NUMBER 38 0   Position Identifier at the level 29. DW_POSITION_D POSITION_ID
LEVEL30_POSITION_ID NUMBER 38 0   Position Identifier at the level 30. DW_POSITION_D POSITION_ID
LEVEL31_POSITION_ID NUMBER 38 0   Position Identifier at the level 31. DW_POSITION_D POSITION_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.

#2 Position Dimension (DW_POSITION_D) is a effective dated table. While joining with Position Dimension, Join on Effective dates along with POSITION_ID