BU_JOBCD_VW

(SQL View)
 Index Back

Jobcode view

/*bu/setid 09/19/1997 */ View to get the values from jobcode_tbl on careerpath_tbl.next_posn_jobcd carresponding to careerpath_tbl.setid_jobcode.

SELECT %Substring(A.SETCNTRLVALUE,1,5) ,B.JOBCODE ,B.EFFDT ,B.EFF_STATUS ,B.DESCR ,B.DESCRSHORT ,B.SETID_SALARY ,B.SAL_ADMIN_PLAN ,B.GRADE ,B.MANAGER_LEVEL ,B.JOB_FUNCTION ,B.STD_HOURS FROM PS_SET_CNTRL_REC A , PS_JOBCODE_TBL B WHERE A.RECNAME='JOBCODE_TBL' AND A.SETID=B.SETID

  • Related Language Record: BU_JOBCDVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_JOBC Character(5) VARCHAR2(5) NOT NULL Business Unit for a Jobcode
    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 EFFDT Date(10) DATE Effective Date
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID
    8 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    9 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    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_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code

    Prompt Table: JOBFUNCTION_TBL

    12 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours