HR_LBR_JC_VW

(SQL View)
Index Back

Current Job Codes View

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

SELECT A.SETID , A.JOBCODE ,A.JOB_FAMILY ,A.DESCR ,A.DESCRSHORT ,A.MANAGER_LEVEL ,A.JOB_FUNCTION ,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' 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: HR_LBR_JC_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID

    Prompt Table: SET_VLD_HR_02

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

    Prompt Table: JOBCODE_TBL

    3 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    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 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_SAL_JOB_VW

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

    Prompt Table: SET_SALPLAN_VW

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

    Prompt Table: SET_SALGRADE_VW

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

    Prompt Table: SET_SALSTEP_VW

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