JOBCODE_TBL_V1

(SQL View)
 Index Back

Current Job Codes View

JOBCODE_TBL_VW is a view of the JOBCODE_TBL which retrieves only the active, current effective-dated records.

SELECT A.SETID , A.JOBCODE ,A.DESCR ,A.DESCRSHORT ,A.MANAGER_LEVEL ,A.JOB_FUNCTION ,A.JOB_FAMILY ,A.SETID_SALARY ,A.SAL_ADMIN_PLAN ,A.GRADE ,A.STEP 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 A.SETID = B.SETID)

  • Related Language Record: JOBCDTBL_V1_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 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
    6 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code

    Prompt Table: JOBFUNCTION_TBL

    7 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    8 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

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

    Prompt Table: SAL_PLAN_TBL

    10 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: SAL_GRADE_TBL

    11 STEP Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: SAL_STEP_TBL