SAL_GRADE_TBL

(SQL Table)
 Index Back

Salary Grade Table

SAL_GRADE_TBL is the reference table for salary ranges. The mimimum, midpoint, and maximum salary are used to calculate compa ratio and percent of range. Several edits are done in the system to warn that an employee is over the maximum or under the mimimum for their salary grade.

  • Related Language Record: SAL_GRADE_LANG

  • Parent Record Of GVT_RTND_SS_VW GVT_SAL_STP_VW HRS_GVT_STP_VW1 HRS_GVT_STP_VW2 HRS_SAL_STEP_I SAL_GRD_REV_JPN SAL_GRD_TBL_JPN SAL_STEP_FRM_VW SAL_STEP_MC_VW SAL_STEP_PUB SAL_STEP_TBL SAL_STEP_TO_VW SAL_STEP_VW SAL_STEP_VW_LNG SAL_STP_TBL_LNG TL_SAL_STEP_VW

    • # 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
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 SALARY_MATRIX_CD Character(5) VARCHAR2(5) NOT NULL Salary Matrix Code

    Prompt Table: SAL_MATRIX_TBL

    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    10 MIN_RT_HOURLY Number(19,6) DECIMAL(18,6) NOT NULL Minimum Pay Rate-Hourly
    11 MID_RT_HOURLY Number(19,6) DECIMAL(18,6) NOT NULL Midpoint Pay Rate-Hourly
    12 MAX_RT_HOURLY Number(19,6) DECIMAL(18,6) NOT NULL Maximum Pay Rate-Hourly
    13 MIN_RT_MONTHLY Number(19,3) DECIMAL(18,3) NOT NULL Minimum Pay Rate-Monthly
    14 MID_RT_MONTHLY Number(19,3) DECIMAL(18,3) NOT NULL Midpoint Pay Rate-Monthly
    15 MAX_RT_MONTHLY Number(19,3) DECIMAL(18,3) NOT NULL Maximum Pay Rate-Monthly
    16 MIN_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Minimum Pay Rate-Annual
    17 MID_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Midpoint Pay Rate-Annual
    18 MAX_RT_ANNUAL Number(19,3) DECIMAL(18,3) NOT NULL Maximum Pay Rate-Annual
    19 STEP_INCREM_TYPE Character(1) VARCHAR2(1) NOT NULL Step Increment Type
    D=Date Based Increment Type
    E=Either Hours or Date Based
    H=Hours Based Increment Type
    M=Manual Based Increment Type
    W=Weeks Based Increment Type
    20 STEP_INCREM_ACCUM Character(3) VARCHAR2(3) NOT NULL Spec Accum for Step Increments

    Prompt Table: SPCL_EARNS_TBL

    21 MIN_RT_DAILY Number(19,3) DECIMAL(18,3) NOT NULL Minimum Pay rate-Daily
    22 MID_RT_DAILY Number(19,3) DECIMAL(18,3) NOT NULL Midpoint Pay rate-Daily
    23 MAX_RT_DAILY Number(19,3) DECIMAL(18,3) NOT NULL Maximum Pay rate-Daily
    24 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Prompt Table: EMPL_CTG

    25 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category

    Prompt Table: EMPL_CTG_L1

    26 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory

    Prompt Table: EMPL_CTG_L2

    27 EMPL_CTG_L2 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory 2

    Prompt Table: EMPL_CTG_L3

    28 GVT_MAX_RT_BIWK Number(10,2) DECIMAL(9,2) NOT NULL Maximum Pay Rate - BiWeekly
    29 GVT_MID_RT_BIWK Number(10,2) DECIMAL(9,2) NOT NULL Midpoint Pay Rate - BiWeekly
    30 GVT_MIN_RT_BIWK Number(10,2) DECIMAL(9,2) NOT NULL Minimum Pay Rate - BiWeekly
    31 GRADE_TITLE_JPN Character(60) VARCHAR2(60) NOT NULL Description field for the grade name
    32 MIN_YRS_GRADE Number(2,0) SMALLINT NOT NULL This field represents the minimum number of years an employee must reside in a grade to be eligible to graduate out of the grade
    33 MAX_YRS_GRADE Number(2,0) SMALLINT NOT NULL This field represents the maximum years an employee can remain in a particular grade. When this criteria has been met, the employee is eligible to graduate out of this grade
    34 MIN_GRD_AGE Number(2,0) SMALLINT NOT NULL This field represents the minimum age for an employee to become eligible to graduate out of the grade.
    35 REVIEW_COUNT Number(2,0) SMALLINT NOT NULL This field represents the number of reviews to be included in the shohkaku (grade advance) evaluation
    36 ELIGIBILITY_POINTS Number(5,1) DECIMAL(4,1) NOT NULL This field represents the minimum number of review points that must be met for an employee to graduate out of the grade
    37 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_STANDARD_VW