This table contains information about cost center segment hierarchy.
Module:
HIERARCHY_VERSION_ID, HIERARCHY_TREE_CODE, COST_CENTER_SEGMENT, HIERARCHY_VALUESET_CODE
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
HIERARCHY_VALUESET_CODE | VARCHAR2 | 128 | True | Cost center hierarchy tree value set identifier. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE | |
HIERARCHY_TREE_CODE | VARCHAR2 | 32 | True | Cost center hierarchy tree identifier. | |||
COST_CENTER_SEGMENT | VARCHAR2 | 128 | True | Cost center number. | DW_COST_CENTER_D | COST_CENTER_SEGMENT | |
HIERARCHY_VERSION_ID | VARCHAR2 | 64 | True | Cost center hierarchy tree version. | |||
SOURCE_RECORD_ID | VARCHAR2 | 512 | Source record identifier. | ||||
HIERARCHY_NAME | VARCHAR2 | 128 | Cost center hierarchy name. | ||||
HIERARCHY_VERSION_NAME | VARCHAR2 | 128 | Name of cost center hierarchy tree version. | ||||
TREE_CODE_VER_EFF_START_DATE | DATE | Start date of hierarchy. | |||||
TREE_CODE_VER_EFF_END_DATE | DATE | End date of hierarchy. | |||||
HIERARCHY_VERSION_STATUS | VARCHAR2 | 32 | Hierarchy version status. | ||||
LEVEL0_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 0. | ||||
LEVEL0_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 0. It is the lowest level. | ||||
LEVEL0_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 0. | ||||
LEVEL1_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 1. | ||||
LEVEL1_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 1. | ||||
LEVEL1_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 1. | ||||
LEVEL2_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 2. | ||||
LEVEL2_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 2. | ||||
LEVEL2_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 2. | ||||
LEVEL3_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 3. | ||||
LEVEL3_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 3. | ||||
LEVEL3_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 3. | ||||
LEVEL4_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 4. | ||||
LEVEL4_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 4. | ||||
LEVEL4_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 4. | ||||
LEVEL5_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 5. | ||||
LEVEL5_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 5. | ||||
LEVEL5_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 5. | ||||
LEVEL6_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 6. | ||||
LEVEL6_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 6. | ||||
LEVEL6_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 6. | ||||
LEVEL7_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 7. | ||||
LEVEL7_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 7. | ||||
LEVEL7_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 7. | ||||
LEVEL8_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 8. | ||||
LEVEL8_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 8. | ||||
LEVEL8_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 8. | ||||
LEVEL9_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 9. | ||||
LEVEL9_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 9. | ||||
LEVEL9_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 9. | ||||
LEVEL10_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 10. | ||||
LEVEL10_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 10. | ||||
LEVEL10_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 10. | ||||
LEVEL11_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 11. | ||||
LEVEL11_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 11. | ||||
LEVEL11_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 11. | ||||
LEVEL12_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 12. | ||||
LEVEL12_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 12. | ||||
LEVEL12_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 12. | ||||
LEVEL13_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 13. | ||||
LEVEL13_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 13. | ||||
LEVEL13_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 13. | ||||
LEVEL14_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 14. | ||||
LEVEL14_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 14. | ||||
LEVEL14_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 14. | ||||
LEVEL15_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 15. | ||||
LEVEL15_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 15. | ||||
LEVEL15_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 15. | ||||
LEVEL16_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 16. | ||||
LEVEL16_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 16. | ||||
LEVEL16_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 16. | ||||
LEVEL17_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 17. | ||||
LEVEL17_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 17. | ||||
LEVEL17_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 17. | ||||
LEVEL18_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 18. | ||||
LEVEL18_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 18. | ||||
LEVEL18_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 18. | ||||
LEVEL19_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 19. | ||||
LEVEL19_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 19. | ||||
LEVEL19_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 19. | ||||
LEVEL20_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 20. | ||||
LEVEL20_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 20. | ||||
LEVEL20_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 20. | ||||
LEVEL21_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 21. | ||||
LEVEL21_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 21. | ||||
LEVEL21_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 21. | ||||
LEVEL22_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 22. | ||||
LEVEL22_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 22. | ||||
LEVEL22_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 22. | ||||
LEVEL23_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 23. | ||||
LEVEL23_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 23. | ||||
LEVEL23_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 23. | ||||
LEVEL24_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 24. | ||||
LEVEL24_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 24. | ||||
LEVEL24_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 24. | ||||
LEVEL25_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 25. | ||||
LEVEL25_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 25. | ||||
LEVEL25_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 25. | ||||
LEVEL26_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 26. | ||||
LEVEL26_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 26. | ||||
LEVEL26_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 26. | ||||
LEVEL27_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 27. | ||||
LEVEL27_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 27. | ||||
LEVEL27_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 27. | ||||
LEVEL28_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 28. | ||||
LEVEL28_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 28. | ||||
LEVEL28_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 28. | ||||
LEVEL29_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 29. | ||||
LEVEL29_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 29. | ||||
LEVEL29_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 29. | ||||
LEVEL30_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 30. | ||||
LEVEL30_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 30. | ||||
LEVEL30_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 30. | ||||
LEVEL31_SEGMENT | VARCHAR2 | 128 | Cost center number at hierarchy level 31. | ||||
LEVEL31_VALUESET_CODE | VARCHAR2 | 128 | Value set for cost center number at hierarchy level 31. It is the highest level. | ||||
LEVEL31_SEGMENT_ID | VARCHAR2 | 256 | Level identifier, Derived by combining value set code and segment number at hierarchy level 31. | ||||
FIXED_HIER_LEVEL | NUMBER | 38 | 0 | Distance of the node from the highest level of hierarchy. |