EMAIL_IDFO_SNDMAIL_HIST(SQL Table) |
Index Back |
|---|---|
Send Email History Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMAIL_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Email ID |
| 2 | DATETIME_SENT | DateTime(26) | TIMESTAMP | Datetime Sent |
| 3 | EMAIL_FROM | Character(254) | VARCHAR2(254) NOT NULL | Email From |
| 4 | EMAIL_TO | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_TO |
| 5 | EMAIL_CC | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_CC |
| 6 | EMAIL_BCC | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_BCC |
| 7 | FO_EMAIL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 8 | EMAIL_TEXTLONG | Long Character | CLOB | Message Text |