EMPL_NAME_VW

(SQL View)
 Index Back

Employee Name

This view is used to retrieve employee name data for displaying first and last names on the direct reports pagelet. The emplid from this table is also used for the direct reports related actions. This record is referenced in the Related Content for mapping emplid to related actions.

SELECT EMPLID , FIRST_NAME , LAST_NAME FROM PS_PERSON_NAME

  • Related Language Record: PERSON_NAME_LNG

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

    Prompt Table: PERSONAL_DATA

    3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

    Prompt Table: PERSONAL_DATA