NAME_TYPE_VW

(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 DISTINCT A.EMPLID ,B.ORDER_BY_SEQ ,A.NAME_TYPE FROM PS_NAMES A , PS_NAME_TYPE_TBL B WHERE A.NAME_TYPE = B.NAME_TYPE

  • 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 ORDER_BY_SEQ Number(2,0) SMALLINT NOT NULL Added in Mouse Over Label
    3 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

    Prompt Table: NAME_TYPE_TBL