RB_CLSD_AFTR_VW(SQL View) |
Index Back |
|---|---|
Closed afer Mailbox due dateUsed for ERMS Reports. This will display a list of all emails that have been closed (responded to) after the mailbox due date. |
| SELECT DISTINCT A.MAILBOX_ID ,A.INTERACTION_ID , A.CURRENT_WL , A.ASSIGNED_TO , A.MB_DUE_DTTM , A.CLOSED_DTTM , A.MCF_EMAIL_ID , C.OPRID FROM PS_RB_IN_EMAIL A , PS_RI_INTERACTION B , PSOPRALIAS C WHERE A.INTERACTION_ID = B.ROOT_INTER_ID AND A.CLOSED_DTTM IS NOT NULL AND MB_DUE_DTTM < CLOSED_DTTM AND A.ASSIGNED_TO = C.OPRALIASVALUE AND B.ROW_ADDED_OPRID = C.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 2 | INTERACTION_ID | Character(15) | VARCHAR2(15) NOT NULL | interaction id |
| 3 | CURRENT_WL | Character(30) | VARCHAR2(30) NOT NULL | Current Worklist Value |
| 4 | OPRALIASVALUE | Character(30) | VARCHAR2(30) NOT NULL | User ID Attribute Value |
| 5 | MB_DUE_DTTM | DateTime(26) | TIMESTAMP | Mailbox level (or external) due date/time |
| 6 | CLOSED_DTTM | DateTime(26) | TIMESTAMP | Date Time stamp for when the case status category was changed to closed. |
| 7 | MCF_EMAIL_ID | Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 8 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |