FO_APP_PRF_EML

(SQL View)
 Index Back

Email Addresses

Stores non effective dated electronic addresses.

SELECT APPLID , E_ADDR_TYPE , EMAIL_ADDR FROM %Table(FO_APP_EMAIL_AD) WHERE PREF_EMAIL_FLAG = 'Y'

  • Parent record: APPLICANT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
    2 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Type
    BUSN=Business
    CAMP=Campus
    DORM=Dorm
    HOME=Home
    OTHR=Other
    3 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address