JOBCODE_GRADE

(SQL View)
 Index Back

Job Evaluations by Grade Lvl

JOBCODE_GRADE is a view which selects all Job Codes in each Salary Grade and ranks them in descending order by total job evaluation points. It is used in the Salary Administration application.

SELECT A.SETID_SALARY ,A.SAL_ADMIN_PLAN ,A.GRADE ,A.JOB_POINTS_TOTAL ,A.SETID ,A.JOBCODE ,A.DESCR ,A.DESCRSHORT ,A.JOB_FUNCTION ,A.MANAGER_LEVEL ,A.JOB_KNOWHOW_POINTS ,A.JOB_ACCNTAB_POINTS ,A.JOB_PROBSLV_POINTS FROM PS_JOBCODE_TBL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_JOBCODE_TBL B WHERE B.JOBCODE = A.JOBCODE AND B.EFFDT <= %CURRENTDATEIN AND B.SETID = A.SETID)

  • Related Language Record: JOBCD_GRADE_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    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 JOB_POINTS_TOTAL Number(5,0) INTEGER NOT NULL Total Points
    5 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    9 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code

    Prompt Table: JOBFUNCTION_TBL

    10 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level
    0=Chief Operating Officer
    1=Director
    2=Senior Officer
    3=Vice President
    4=Senior Manager
    5=Mid-Level Manager
    6=First-Line Manager
    7=Supervisor
    8=All Other Positions
    9=Non-Manager
    11 JOB_KNOWHOW_POINTS Number(5,0) INTEGER NOT NULL Knowhow-Points
    12 JOB_ACCNTAB_POINTS Number(5,0) INTEGER NOT NULL Accountability-Points
    13 JOB_PROBSLV_POINTS Number(5,0) INTEGER NOT NULL Problem-Solving-Points