GPS_JG_SC_MAP

(SQL Table)
 Index Back

Job Group/Service Class Map

This stores the valid values of Job Group/Service Class for a given Employee Category, Salary Admin Plan and Remuneration Regulation combination.

  • Parent record: GPS_REM_REG_MAP

    • # 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_14

    2 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Prompt Table: EMPL_CTG

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

    Prompt Table: EMPL_CTG_L1

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Prompt Table: SAL_PLAN_TBL

    6 GPS_REMUN_REG Character(4) VARCHAR2(4) NOT NULL This field is used for Remuneration Regulation values.

    Prompt Table: GPS_REMUN_REG

    7 GPS_JG_SC Character(4) VARCHAR2(4) NOT NULL This field is used for Job Group/Service Class values.

    Prompt Table: GPS_JG_SC