RY_RECORD_IDB=Mailcaster
S=Single Emailer
Default Value: %DateTime
RY_EXP_EM_LOG(SQL Table) |
Index Back |
|---|---|
Expired email log tableEmails that have been expired from the frequency queue. |
| # | 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 | IS_SOLICITED | Character(1) | VARCHAR2(1) NOT NULL | IS_SOLICITED |
| 7 | REPEAT_SEQ_NUMBER | Number(18,0) | DECIMAL(18) NOT NULL | Repeat Number |
| 8 | RY_SR_ACTION_ID | Number(18,0) | DECIMAL(18) NOT NULL | Field used by Online Marketing. |
| 9 | RY_BUK_SNGL_MAILER | Character(1) | VARCHAR2(1) NOT NULL |
Field used by Online Marketing.
B=Mailcaster S=Single Emailer |
| 10 | START_DTTM | DateTime(26) | TIMESTAMP | start date time |
| 11 | RY_QUE_END_DT | Date(10) | DATE | Use for Online Marketing |
| 12 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP |
This is a datetime field for record creation.
Default Value: %DateTime |