NOTIFY_GUIDSEQNOPT_WF_GUIDLOG(SQL Table) |
Index Back |
|---|---|
RIM response log record.Keeps track of all incoming RIM responses for each particular GUID. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NOTIFY_GUID |
Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| 2 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 3 | EMAIL_FROM | Character(254) | VARCHAR2(254) NOT NULL | Email From |
| 4 | WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 5 | WL_RESPONSE | Character(30) | VARCHAR2(30) NOT NULL | Response Name |
| 6 | EMAIL_SENDER | Character(254) | VARCHAR2(254) NOT NULL | EMAIL_SENDER |
| 7 | UIDL | Character(70) | VARCHAR2(70) NOT NULL | UIDL |
| 8 | WL_PROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Process Flag |
| 9 | EMAIL_PROCDTTM | DateTime(26) | TIMESTAMP | Email processing date/time |
| 10 | EMAIL_TEXTLONG | Long Character | CLOB | Message Text |