RY_RECORD_IDH=Hard Bounce
S=Soft Bounce
U=Unknown Bounce
Default Value: U
E=E-mail Response Processor
M=E-mail Service
U=Unknown
Default Value: U
RY_EMAIL_BOUNCE(SQL Table) |
Index Back |
|---|---|
Bounced Email LogTransaction Log for All Email Bounced |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_RECORD_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 2 | RY_IND_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 3 | RY_ACTION_ID | Number(18,0) | DECIMAL(18) NOT NULL | Id for a dialog element for the dialog designer. |
| 4 | RY_LIST_ID | Number(18,0) | DECIMAL(18) NOT NULL | Audience ID for Dialogs, used in the dialog designer. |
| 5 | CONTACTED_DTTM | DateTime(26) | TIMESTAMP | Contacted On |
| 6 | REPEAT_SEQ_NUMBER | Number(18,0) | DECIMAL(18) NOT NULL | Repeat Number |
| 7 | RY_BOUNCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Dialog email bounce type (hard, soft and unknown).
H=Hard Bounce S=Soft Bounce U=Unknown Bounce Default Value: U |
| 8 | RY_BOUNCE_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Used for define email bounce source. 'M' for mail service (including Bulk Mailer, Single Mailer and Frequency Mailer), 'E' for ERP (including bounce process and reply process). 'U' for upgrade (unknown)
E=E-mail Response Processor M=E-mail Service U=Unknown Default Value: U |