PERSONAL_VW

(SQL View)
 Index Back

Personal Data Name View

PERSONAL_VW is a view of Personal Data which retrieves only the name. It is used for the incubent(s) name in Position Management, because the Personal Data record was already being accessed in the panel via work scrolls.

SELECT A.EMPLID , A.NAME_DISPLAY FROM PS_NAMES A WHERE A.NAME_TYPE = 'PRI' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_NAMES B WHERE B.EMPLID = A.EMPLID AND B.NAME_TYPE = A.NAME_TYPE AND B.EFFDT <= %CurrentDateIn )

  • 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 Character(50) VARCHAR2(50) NOT NULL Name