HCDL_LNAME_VW

(SQL View)
 Index Back

Last name prompt

Last name prompt for HCDL_ADMIN_SRCH and HCDL_DERIVED LAST_NAME_SRCH

SELECT DISTINCT A.LAST_NAME_SRCH ,A.NAME , A.EMPLID FROM PS_PERSON_NAME A WHERE 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 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    2 NAME Character(50) VARCHAR2(50) NOT NULL Name
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID