HCDL_MULTI_JOB

(SQL View)
 Index Back

Delegation Muti Job View

Delegation Muti Job View

SELECT A.EMPLID ,A.EMPL_RCD ,A.PER_ORG ,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_HCDL_CURR_JOB 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 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
    CWR=Contingent Worker
    EMP=Employee
    POI=Person of Interest
    4 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    5 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: JOBCODE_TBL

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

    Prompt Table: POSITION_DATA

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