HRS_SAL_STEP_I

(SQL View)
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.

SELECT SETID ,SAL_ADMIN_PLAN ,GRADE ,EFFDT ,STEP ,CURRENCY_CD ,HOURLY_RT ,MONTHLY_RT ,ANNUAL_RT ,STEP_DESCR FROM PS_SAL_STEP_TBL

  • 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 STEP_DESCR Character(30) VARCHAR2(30) NOT NULL Description field for salary step