EMAIL_ADDRESSES

(SQL Table)
Index Back

Email Addresses

Stores non effective dated electronic addresses.

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

    Default Value: NEW

    Prompt Table: PERSONAL_DATA

    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