RY_SMAIL_HIS

(SQL Table)
Index Back

Email Sent Log

Transaction history for Single Email

# 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 INTERACTION_ID Character(15) VARCHAR2(15) NOT NULL interaction id
3 RY_EMAIL_FROM_ADDR Character(80) VARCHAR2(80) NOT NULL OLM outbound email send address
4 RY_EMAIL_REPL_ADDR Character(80) VARCHAR2(80) NOT NULL OLM outbound email reply address
5 RY_EMAIL_TO_ADDR Character(254) VARCHAR2(254) NOT NULL Email To Address field to use email history
6 RY_EMAIL_SUBJECT Character(254) VARCHAR2(254) NOT NULL OLM Email Document Subject Area
7 RY_EMAIL_BODY Long Character CLOB OLM outbound email body