SPB_PERS_EMAIL

(SQL Table)
Index Back

User Email Types

User Email Types

  • Parent record: SPB_PERSON_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    2 EMAIL_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type
    BUSN=Business
    HOFF=Home Office
    HOME=Home
    3 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    4 PRIMARY_FLAG Character(1) VARCHAR2(1) NOT NULL Primary
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N