# DW_GL_SEGMENT2_DH

GL Segment2 Hierarchy dimension

## Details

Module:

## Key Columns

HIERARCHY_TREE_CODE, GL_SEGMENT, HIERARCHY_VALUESET_CODE, HIERARCHY_VERSION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
HIERARCHY_VALUESET_CODE | VARCHAR2 | 128 |  | True | Accounting segment hierarchy tree value set identifier. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
HIERARCHY_TREE_CODE | VARCHAR2 | 32 |  | True | Accounting segment hierarchy tree identifier. |  |
GL_SEGMENT | VARCHAR2 | 128 |  | True | Accounting segment number. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
HIERARCHY_VERSION_ID | VARCHAR2 | 64 |  | True | Accounting segment hierarchy tree version. |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
HIERARCHY_NAME | VARCHAR2 | 128 |  |  | Accounting segment hierarchy name. |  |
HIERARCHY_VERSION_NAME | VARCHAR2 | 128 |  |  | Accounting segment hierarchy tree version name. |  |
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 |  |  | Accounting segment number at hierarchy level 0. |  |
LEVEL0_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 1. |  |
LEVEL1_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 2. |  |
LEVEL2_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 3. |  |
LEVEL3_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 4. |  |
LEVEL4_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 5. |  |
LEVEL5_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 6. |  |
LEVEL6_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 7. |  |
LEVEL7_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 8. |  |
LEVEL8_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 9. |  |
LEVEL9_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 10. |  |
LEVEL10_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 11. |  |
LEVEL11_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 12. |  |
LEVEL12_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 13. |  |
LEVEL13_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 14. |  |
LEVEL14_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 15. |  |
LEVEL15_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 16. |  |
LEVEL16_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 17. |  |
LEVEL17_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 18. |  |
LEVEL18_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 19. |  |
LEVEL19_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 20. |  |
LEVEL20_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 21. |  |
LEVEL21_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 22. |  |
LEVEL22_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 23. |  |
LEVEL23_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 24. |  |
LEVEL24_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 25. |  |
LEVEL25_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 26. |  |
LEVEL26_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 27. |  |
LEVEL27_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 28. |  |
LEVEL28_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 29. |  |
LEVEL29_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 30. |  |
LEVEL30_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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 |  |  | Accounting segment number at hierarchy level 31. |  |
LEVEL31_VALUESET_CODE | VARCHAR2 | 128 |  |  | Value set for accounting 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. |  |
HIERARCHY_NAME_HIERARCHY_VERSION_NAME | VARCHAR2 | 256 |  |  | Concatenate Accounting segment hierarchy name and version name |  |
LEVEL0_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL1_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL2_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL3_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL4_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL5_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL6_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL7_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL8_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL9_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL10_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL11_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL12_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL13_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL14_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL15_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL16_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL17_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL18_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL19_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL20_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL21_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL22_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL23_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL24_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL25_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL26_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL27_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL28_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL29_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL30_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |
LEVEL31_DRILL_KEY | VARCHAR2 | 999 |  |  |  |  |

Copyright Â© 2019, 2026, Oracle and/or its affiliates.