UID20010=Open
020=Closed - Unable to Resend
030=Closed - Resent
RB_EMAIL_E_VW(SQL View) |
Index Back |
|---|---|
Emails with ErrorsView is used in the Search Undelivered Emails component |
| SELECT UID20 , EMAIL_FROM , EMAIL_TO , EMAIL_SENDER , EMAIL_SUBJECT254 , USERID , SUBMIT_DTTM , EMAIL_ERR_STATUS , ERROR_MESSAGE FROM PS_RB_EMAIL_E |
| # | 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_SENDER | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_SENDER |
| 5 | EMAIL_SUBJECT254 | Character(254) | VARCHAR2(254) NOT NULL | Email Subject |
| 6 | SUBMIT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Submitted By OPRID......................................... |
| 7 | SUBMIT_DTTM | DateTime(26) | TIMESTAMP | Submitted Datetime |
| 8 | EMAIL_ERR_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Field stores stages of email that encountered errors
010=Open 020=Closed - Unable to Resend 030=Closed - Resent |
| 9 | ERROR_MESSAGE | Character(254) | VARCHAR2(254) NOT NULL | For Standard Journal (SJE) |