PERS_NAME_PRF

(SQL View)
 Index Back

Employee Name Types

NAME_TYPE_VW is a view of NAMES that allows for a level 1 scroll that controls the NAME_TYPES.

SELECT EMPLID ,NAME_TYPE , LAST_NAME , FIRST_NAME , MIDDLE_NAME , NAME FROM PS_NAME_CURR_VW WHERE NAME_TYPE = 'PRF'

  • Related Language Record: NAME_CURR_VWL

  • Parent record: PERSON

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

    Prompt Table: PERSON

    2 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Prompt Table: NAME_TYPE_TBL

    3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    5 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name