# DW_PAY_COST_SEGMENT8_DH (Preview)

This table requires activation of Payroll Balances functional area. Pay Cost Segment8 Hierarchy dimension

## Details

Module: Global Payroll

## Key Columns

HIERARCHY_TREE_CODE, HIERARCHY_VERSION_ID, PAY_COST_SEGMENT, HIERARCHY_VALUESET_CODE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
HIERARCHY_VALUESET_CODE | VARCHAR2 | 128 |  | True | Segment hierarchy tree value set identifier. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
HIERARCHY_TREE_CODE | VARCHAR2 | 32 |  | True | Segment hierarchy tree identifier. |  |
PAY_COST_SEGMENT | VARCHAR2 | 128 |  | True | Segment number. |  |
HIERARCHY_VERSION_ID | VARCHAR2 | 64 |  | True | Segment hierarchy tree version. |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
TREE_CODE_VER_EFF_START_DATE | DATE |  |  |  | Hierarchy start date. |  |
TREE_CODE_VER_EFF_END_DATE | DATE |  |  |  | Hierarchy end date. |  |
HIERARCHY_VERSION_STATUS | VARCHAR2 | 32 |  |  | Hierarchy version status. |  |
LEVEL0_SEGMENT | VARCHAR2 | 128 |  |  | Segment number at hierarchy level 0. |  |
LEVEL0_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 1. |  |
LEVEL1_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 2. |  |
LEVEL2_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 3. |  |
LEVEL3_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 4. |  |
LEVEL4_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 5. |  |
LEVEL5_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 6. |  |
LEVEL6_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 7. |  |
LEVEL7_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 8. |  |
LEVEL8_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 9. |  |
LEVEL9_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 10. |  |
LEVEL10_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 11. |  |
LEVEL11_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 12. |  |
LEVEL12_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 13. |  |
LEVEL13_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 14. |  |
LEVEL14_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 15. |  |
LEVEL15_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 16. |  |
LEVEL16_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 17. |  |
LEVEL17_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 18. |  |
LEVEL18_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 19. |  |
LEVEL19_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 20. |  |
LEVEL20_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 21. |  |
LEVEL21_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 22. |  |
LEVEL22_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 23. |  |
LEVEL23_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 24. |  |
LEVEL24_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 25. |  |
LEVEL25_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 26. |  |
LEVEL26_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 27. |  |
LEVEL27_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 28. |  |
LEVEL28_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 29. |  |
LEVEL29_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 30. |  |
LEVEL30_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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 |  |  | Segment number at hierarchy level 31. |  |
LEVEL31_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for Segment 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. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.