GPS_JGSCGRSR_VW

(SQL View)
 Index Back

Civil Service Rank x Grade Map

Prompt view against GPS_JG_SC_GR_SR.

SELECT A.SETID , A.LABOR_AGREEMENT , A.EMPL_CTG , A.EFFDT , A.SAL_ADMIN_PLAN , A.GPS_REMUN_REG , A.GPS_JG_SC , A.GPS_SC_GROUP , A.GRADE , A.GPS_CSR_CD , B.DESCR120_2 FROM PS_GPS_JG_SC_GR_SR A , PS_GPS_CSR_CODES B WHERE B.SETID = A.SETID AND B.GPS_CSR_CD = A.GPS_CSR_CD AND %EffdtCheck(GPS_CSR_CODES B1, B, A.EFFDT) AND B.EFF_STATUS = 'A'

  • Related Language Record: GPS_JGSCGRSR_VL

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

    8 GPS_SC_GROUP Character(4) VARCHAR2(4) NOT NULL This field is used to define Service Class Group values.
    1=Without University Degree
    2=With University Degree
    ED=Simple Service
    GD=Upper Service
    HD=Supreme Service
    MD=Midrange Service
    9 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: SAL_GRADE_TBL

    10 GPS_CSR_CD Character(15) VARCHAR2(15) NOT NULL This field is used to define Civil Service Ranks.

    Prompt Table: GPS_CSR_CODES

    11 DESCR120_2 Character(120) VARCHAR2(120) NOT NULL This is used to store the Male Description of Civil Service Ranks.