RB_EMAIL_E

(SQL Table)
 Index Back

Emails with Errors

Record is used to store emails that encountered errors

  • Related Language Record: RB_EMAIL_E_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.
    2 EMAIL_FROM Character(254) VARCHAR2(254) NOT NULL Email From
    3 EMAIL_TO Character(254) VARCHAR2(254) NOT NULL EMAIL_TO
    4 EMAIL_CC Character(254) VARCHAR2(254) NOT NULL EMAIL_CC
    5 EMAIL_BCC Character(254) VARCHAR2(254) NOT NULL EMAIL_BCC
    6 EMAIL_SENDER Character(254) VARCHAR2(254) NOT NULL EMAIL_SENDER
    7 EMAIL_REPLYTO Character(254) VARCHAR2(254) NOT NULL Reply To
    8 EMAIL_SUBJECT254 Character(254) VARCHAR2(254) NOT NULL Email Subject
    9 EMAIL_TEXTLONG Long Character CLOB Message Text
    10 EMAIL_FILEPATH Character(254) VARCHAR2(254) NOT NULL EMAIL_FILEPATH
    11 EMAIL_FILEALIAS Character(254) VARCHAR2(254) NOT NULL EMAIL_FILEALIAS
    12 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
    13 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code Field. This Field is imported into CRM DB from Human Resources Database.
    14 SOURCE_SYSTEM Character(3) VARCHAR2(3) NOT NULL This field stores the system name that initiated a specific transaction
    CM=Correspondence Management
    15 UID20_1 Character(20) VARCHAR2(20) NOT NULL UID.................................................................................
    16 CHARSET Character(40) VARCHAR2(40) NOT NULL Character Set
    17 EMAIL_PRIMARY_ADDR Character(60) VARCHAR2(60) NOT NULL Field used to specify the primary email address in the recipients email address list
    18 SUBMIT_DTTM DateTime(26) TIMESTAMP Submitted Datetime
    19 EMAIL_ERR_STATUS Character(3) VARCHAR2(3) NOT NULL Field stores stages of email that encountered errors
    010=Open
    020=Closed - Unable to Resend
    030=Closed - Resent
    20 ERROR_MESSAGE Character(254) VARCHAR2(254) NOT NULL For Standard Journal (SJE)