SET_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 DISTINCT SETID ,JOBCODE ,DESCRSHORT ,DESCR ,SETID_SALARY ,SAL_ADMIN_PLAN ,GRADE ,MANAGER_LEVEL ,JOB_FUNCTION , SURVEY_SALARY , CURRENCY_CD FROM PS_JOBCODE_TBL

  • Related Language Record: SET_JOBCDVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID
    6 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    7 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
    8 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
    9 JOB_FUNCTION Character(3) VARCHAR2(3) NOT NULL Job Function Code

    Prompt Table: JOBFUNCTION_TBL

    10 SURVEY_SALARY Number(8,0) INTEGER NOT NULL Survey Salary
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL