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 |