HCDL_NAME_SRCH

(SQL View)
 Index Back

Name search

Name search view for Delegation

SELECT A.NAME , A.EMPLID FROM PS_PERSON_NAME A WHERE A.EMPLID IN ( SELECT EMPLID FROM PS_HCDL_CURR_JOB)

  • Parent record: PERSON

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