MAIL_READ_INSTANCEUNIQUE_IDRB_MAILEXCP_LOG(SQL Table) |
Index Back |
|---|---|
Mail Exception LogsThis table records all the Exception E-mails that have gone thru the CRM Mail Reader process. These exceptions are triggered by the Spam lists and Custom Filters setup at ERMS system level |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MAIL_READ_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Instance of Mail Reader Process for logging information which can be used for Analytics purposes in the future |
| 2 | UNIQUE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Unique_Id |
| 3 | MCF_UID | Character(70) | VARCHAR2(70) NOT NULL | UIDL |
| 4 | MCF_EMAIL_MSG_ID | Character(254) | VARCHAR2(254) NOT NULL | Message ID |
| 5 | MAIL_FILTER_ID | Character(30) | VARCHAR2(30) NOT NULL | Id filed of Mail filter Table |
| 6 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 7 | MCF_EMAIL_FROM | Character(254) | VARCHAR2(254) NOT NULL | From |
| 8 | MCF_WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 9 | MCF_MSG_SIZE | Number(15,0) | DECIMAL(15) NOT NULL | Message size |
| 10 | MCF_EMAIL_TEXT | Long Character | CLOB | Text |