HCDL_FNAM_VW

(SQL View)
 Index Back

First name prompt

First name prompt for Add Proxy page.

SELECT DISTINCT A.FIRST_NAME_SRCH ,A.NAME , A.EMPLID FROM PS_PERSON_NAME A , PSOPRDEFN B WHERE A.EMPLID=B.EMPLID AND (A.EMPLID IN ( SELECT EMPLID FROM PS_HCDL_CURR_JOB) OR A.EMPLID IN ( SELECT EMPLID FROM PS_HCDL_poi_vw))

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    2 NAME Character(50) VARCHAR2(50) NOT NULL Name
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID