HCDL_FNAME_VW

(SQL View)
 Index Back

First Name prompt

First Name prompt for HCDL_DERIVED.FIRST_NAME_SRCH

SELECT DISTINCT A.FIRST_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 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