RB_AG_EF_DUED_V(SQL View) |
Index Back |
|---|---|
Emails closed after due dateUsed for ERMS reports...................... |
| SELECT DISTINCT A.CLOSED_BY_OPRID ,1 ,0 ,0 ,0 ,0 ,0 ,0 ,A.CLOSED_DTTM ,A.CLOSED_DTTM ,CASE WHEN A.CLOSED_DTTM > A.CLOSED_DTTM THEN 1 ELSE 0 END CASE ,0 ,0 ,0 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_LASTMANT_OPRID = C.OPRID GROUP BY A.CLOSED_BY_OPRID,A.CLOSED_DTTM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RB_CLOSED_DUEDATE | Number(8,0) | INTEGER NOT NULL | Detail item status |
| 3 | RB_EMAIL_ASSIGNED | Number(8,0) | INTEGER NOT NULL | Detail item status |
| 4 | RB_REP_WITH_TEMPL | Number(8,0) | INTEGER NOT NULL | Used for ERMS Reporting....................... |
| 5 | RB_CLOSED_CAN | Number(8,0) | INTEGER NOT NULL | Detail item status |
| 6 | RB_CLOSED_DUP | Number(8,0) | INTEGER NOT NULL | Detail item status |
| 7 | RB_CLOSED_REP | Number(8,0) | INTEGER NOT NULL | Detail item status |
| 8 | RB_CLOSED_SPAM | Number(8,0) | INTEGER NOT NULL | Detail item status |
| 9 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 10 | CLOSED_DTTM | DateTime(26) | TIMESTAMP | Date Time stamp for when the case status category was changed to closed. |
| 11 | ACTIVE | Number(5,0) | INTEGER NOT NULL | Active |
| 12 | ABE_SEQ | Number(6,0) | INTEGER NOT NULL | Address Book sequence number. |
| 13 | ABE_SEQ_MAX | Number(6,0) | INTEGER NOT NULL | This field is used during the Address Book entry upgrade and Data Import to hold the highest ABE Sequence. |
| 14 | COUNT_TOTAL | Number(9,0) | DECIMAL(9) NOT NULL | Total Count |