GVT_JOBCODE_GRD

(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 ,%subrec(JOBCDGRD_FEDSBR, A) 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: GVT_JOBG_LNG_VW

    • # 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
    14 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan

    Prompt Table: GVT_PAY_PLAN

    15 GVT_PATCOB_CD Character(1) VARCHAR2(1) NOT NULL PATCOB Code
    1=Exception 1
    2=Exception 2
    3=Exception 3
    4=Exception 4
    5=Exception 5
    6=Exception 6
    7=Exception 7
    8=Exception 8
    A=Administrative
    B=Blue Collar
    C=Clerical
    M=Mixed Collar
    O=Other White Collar
    P=Professional
    T=Technical
    16 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
    17 GVT_CLS_STANDARD Character(15) VARCHAR2(15) NOT NULL Classification Standard