DW_PAY_COST_SEGMENT4_DH (Preview)

This table requires activation of Payroll Balances functional area. Pay Cost Segment4 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.