JOB_CD_TBL_VW

(SQL View)
 Index Back

Current Job Codes View

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

SELECT A.SETID , A.JOBCODE , A.EFFDT ,A.DESCR ,A.DESCRSHORT ,A.MANAGER_LEVEL ,A.JOB_FUNCTION ,A.JOB_FAMILY ,A.SETID_SALARY ,A.SAL_ADMIN_PLAN ,A.GRADE ,A.STEP ,A.STD_HOURS ,A.STD_HRS_FREQUENCY ,A.SAL_RANGE_MID_RATE ,A.SAL_RANGE_CURRENCY ,A.SAL_RANGE_FREQ FROM PS_JOBCODE_TBL A WHERE A.EFF_STATUS = 'A'

  • Related Language Record: JOBCDTBL_V2_LNG

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

    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 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
    7 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code

    Prompt Table: JOBFUNCTION_TBL

    8 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    9 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

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

    Prompt Table: SET_SALPLAN_VW

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

    Prompt Table: SET_SALGRADE_VW

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

    Prompt Table: SET_SALSTEP_VW

    13 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    14 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
    15 SAL_RANGE_MID_RATE Number(19,6) DECIMAL(18,6) NOT NULL Salary Range Midpoint Rate
    16 SAL_RANGE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Salary Range Currency
    17 SAL_RANGE_FREQ Character(5) VARCHAR2(5) NOT NULL Salary Range Frequency