UID20RB_EMAIL_ORGL(SQL Table) |
Index Back |
|---|---|
Email OriginalRecord is used to store original values of emails that failed to be delivered on the first attempt |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | UID20 |
Character(20) | VARCHAR2(20) NOT NULL | This field is for UID of 20 characters long. |
| 2 | EMAIL_FROM | Character(254) | VARCHAR2(254) NOT NULL | Email From |
| 3 | EMAIL_TO | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_TO |
| 4 | EMAIL_CC | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_CC |
| 5 | EMAIL_BCC | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_BCC |
| 6 | EMAIL_SENDER | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_SENDER |
| 7 | EMAIL_REPLYTO | Character(254) | VARCHAR2(254) NOT NULL | Reply To |
| 8 | EMAIL_SUBJECT254 | Character(254) | VARCHAR2(254) NOT NULL | Email Subject |
| 9 | EMAIL_TEXTLONG | Long Character | CLOB | Message Text |
| 10 | EMAIL_FILEPATH | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_FILEPATH |
| 11 | EMAIL_FILEALIAS | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_FILEALIAS |