SCC_PREF_EMAIL

(SQL View)
 Index Back

Preferred E-Mail Address View

This view returns the preferred e-mail address.

SELECT EMPLID , EMAIL_ADDR FROM PS_HCR_PER_EMAIL_I WHERE PREF_EMAIL_FLAG = 'Y'

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address