GM_PRJ_EMAIL_VW

(SQL View)
 Index Back

Project View of Email IDs

View of EMAIL_ADDRESSES to display E-Mail addresses for department contact.

SELECT EMPLID, EMAIL_ADDR FROM PS_EMAIL_ADDRESSES WHERE E_ADDR_TYPE ='BUSN'

  • Parent record: PERSONAL_DATA

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

    Prompt Table: PERSONAL_DATA

    2 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address