SAL_STEP_TBL

(SQL Table)
 Index Back

Salary Step Table

SAL_STEP_TBL is used to store the salary for each step when multi-step grade is used. The control flag for multi-step grade is found on the Installation record. When it is set to 'Yes', employees salaries are automatically set to the one stored on this table for their Salary Administration Plan, Grade, and Step.

  • Related Language Record: SAL_STP_TBL_LNG

  • Parent record: SAL_GRADE_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_05

    2 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: SAL_PLAN_TBL

    3 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: SAL_GRADE_TBL

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 STEP Number(2,0) SMALLINT NOT NULL Step
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    7 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    8 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
    9 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    10 INCREM_MONTHS Number(3,0) SMALLINT NOT NULL Months to Next Step Increment
    11 INCREM_HOURS Number(8,2) DECIMAL(7,2) NOT NULL Hours to Next Step Increment
    12 DAILY_RT Number(19,3) DECIMAL(18,3) NOT NULL Daily Rate
    13 GVT_BIWEEKLY_RT Number(10,2) DECIMAL(9,2) NOT NULL Biweekly Rate
    14 GVT_INCREM_DAYS Number(3,0) SMALLINT NOT NULL Days to Next Step Increment
    15 GVT_INCREM_WEEKS Number(3,0) SMALLINT NOT NULL Weeks to Next Step Increment
    16 GVT_STEP Character(2) VARCHAR2(2) NOT NULL US Federal Step

    Default Value: SAL_STEP_TBL.STEP

    17 GVT_WGI_ADJ Number(3,0) SMALLINT NOT NULL WGI Adjustment

    Default Value: 80

    18 CLASSN_CURRENT_AUS Number(3,0) SMALLINT NOT NULL This field identifies the classification term and level for an employee in respect of their current duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes.

    Prompt Table: DTYA_CURCLS_AUS

    19 APS_MIN_CLS_AUS Character(2) VARCHAR2(2) NOT NULL This field is associated with the APS grouping that is used for reporting purposes.
    01=APS Group 1
    02=APS Group 2
    03=APS Group 3
    04=APS Group 4
    05=APS Group 5
    06=APS Group 6
    07=APS Group 7
    08=APS Group 8
    09=APS Group 9
    10=APS Group 10
    11=APS Group 11
    51=Agency Head
    60=APS Trainee
    20 APS_MAX_CLS_AUS Character(2) VARCHAR2(2) NOT NULL This field is associated with the APS grouping that is used for reporting purposes.
    01=APS Group 1
    02=APS Group 2
    03=APS Group 3
    04=APS Group 4
    05=APS Group 5
    06=APS Group 6
    07=APS Group 7
    08=APS Group 8
    09=APS Group 9
    10=APS Group 10
    11=APS Group 11
    51=Agency Head
    60=APS Trainee
    21 STEP_DESCR Character(30) VARCHAR2(30) NOT NULL Description field for salary step