RY_SMAIL_LOG

(SQL Table)
Index Back

Email Sent Log

Transaction Log for Single Email Job

# 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_FLOW_INS_ID Number(18,0) DECIMAL(18) NOT NULL Dialog Flow Instance ID