HCDL_PROXY_VW

(SQL View)
 Index Back

Proxy Search View

A list of potential proxies by name or hierarchy.

SELECT A.EMPLID ,A.EMPL_RCD ,A.PER_ORG , ' ' ,D.NAME_DISPLAY ,D.LAST_NAME_SRCH ,D.FIRST_NAME_SRCH ,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

    Prompt Table: PERSON

    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 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
    5 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    7 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    8 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: JOBCODE_TBL

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

    Prompt Table: POSITION_DATA

    15 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    16 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
    17 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID