HCDL_LNAM_VW

(SQL View)
 Index Back

Last name prompt

Last name prompt for Add Proxy page.

SELECT DISTINCT B.OPRID , A.LAST_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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    3 NAME Character(50) VARCHAR2(50) NOT NULL Name
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID