PERS_APPL_NAME

(SQL View)
 Index Back

Person Name

Person Names Interface View

SELECT A.EMPLID , A.NAME_DISPLAY FROM PS_NAMES A WHERE A.NAME_TYPE = 'PRI' AND A.EFF_STATUS = 'A' AND A.EFFDT IN ( SELECT MAX(B.EFFDT) FROM PS_NAMES B WHERE B.EMPLID = A.EMPLID AND B.EFF_STATUS = 'A' AND B.NAME_TYPE = 'PRI')

  • Related Language Record: PERS_APPL_NMLNG

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPL_REFERRAL_ID Character(11) VARCHAR2(11) NOT NULL Employee Referral ID
    2 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country