EPO_MULTI_JOB_V

(SQL View)
 Index Back

Delegation Muti Job View

Delegation Muti Job View

SELECT A.EMPLID ,A.EMPL_RCD , D.NAME_DISPLAY ,A.SETID_DEPT ,A.DEPTID ,B.DESCR ,A.JOBCODE ,C.DESCR ,A.LOCATION ,A.POSITION_NBR ,A.COMPANY ,A.REPORTS_TO ,A.SUPERVISOR_ID FROM PS_EPO_CURR_JOB_VW A , PS_DEPT_TBL_EFF_VW B , PS_JOBCODE_TBL_VW C , PS_PERSON_NAME D WHERE A.SETID_DEPT = B.SETID AND A.DEPTID = B.DEPTID AND A.SETID_JOBCODE = C.SETID AND A.JOBCODE = C.JOBCODE AND A.EMPLID = D.EMPLID

  • Related Language Record: HCDL_MJOB_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    4 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    6 DEPTNAME Character(30) VARCHAR2(30) NOT NULL Department Name
    7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    8 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    9 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    10 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    11 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    12 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
    13 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID