FE_NAME_PROMPT

(SQL View)
 Index Back

Employee prompt used for eApps


SELECT A.NAME , A.EMPLID FROM PS_PERSONAL_DT_FST A WHERE A.EMPLID IN ( SELECT EMPLID FROM PS_GVT_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