EG_SS_EMAIL_LOG

(SQL Table)
Index Back

Log email for Self Service ECO

Created on 03/29/00 RML Log email conversation for self service applicaton - ECO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ECO_ID Character(10) VARCHAR2(10) NOT NULL ECO Number
3 EG_DATETIME_SENT DateTime(26) TIMESTAMP Created on 03/27/00 RML Use to track email conversation in ECO (self service)

Default Value: %datetime

4 EG_FROM_USER Character(30) VARCHAR2(30) NOT NULL Created on 03/27/00 RML Use in log email conversation
5 EG_EMAIL_TO Character(254) VARCHAR2(254) NOT NULL To
6 EG_EMAIL_BCC Character(254) VARCHAR2(254) NOT NULL bcc
7 EG_EMAIL_CC Character(254) VARCHAR2(254) NOT NULL cc
8 EMAIL_SUBJECT_LONG Character(85) VARCHAR2(85) NOT NULL Email Subject
9 EMAIL_TEXTLONG Long Character CLOB Message Text