DW_GL_SEGMENT_DH

GL Segment Hierarchy dimension

Details

Module:

Key Columns

HIERARCHY_VERSION_ID, GL_SEGMENT, HIERARCHY_TREE_CODE, HIERARCHY_VALUESET_CODE

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     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.