EG_SS_EMAIL_LOG(SQL Table) |
Index Back |
---|---|
Log email for Self Service ECOCreated on 03/29/00 RML Log email conversation for self service applicaton - ECO |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
2 | Character(10) | VARCHAR2(10) NOT NULL | ECO Number | |
3 | 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 |