It stores position hierarchy information in column flattened format.
Module:
ENTERPRISE_ID, TREE_STRUCTURE_CODE, POSITION_ID, TREE_CODE, TREE_VERSION_ID
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. |
#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