HRS_FND_EML_VW

(SQL View)
 Index Back

SELECT A.EMPLID , B.E_ADDR_TYPE , A.NAME_DISPLAY , B.EMAIL_ADDR , B.PREF_EMAIL_FLAG FROM PS_HRS_PERSON_NM_I A , PS_HRS_PER_EMAIL_I B WHERE A.EMPLID=B.EMPLID AND (EXISTS ( SELECT 'X' FROM PS_HRS_ACTJOB_I WHERE EMPLID = A.EMPLID) OR EXISTS ( SELECT 'X' FROM PS_HRS_ACTPOI_I WHERE EMPLID = A.EMPLID))

  • Related Language Record: HRS_FND_EML_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Type
    BUSN=Business
    CAMP=Campus
    DORM=Dormitory
    HOME=Home
    OTHR=Other
    3 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    4 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    5 PREF_EMAIL_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred
    N=No
    Y=Yes

    Y/N Table Edit