GL Segment2 Hierarchy dimension
Module:
HIERARCHY_VALUESET_CODE, HIERARCHY_VERSION_ID, HIERARCHY_TREE_CODE, GL_SEGMENT
| 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, 2024, Oracle and/or its affiliates.