RB_AG_EF_WTMP_V(SQL View) |
Index Back |
|---|---|
Emails without templatesUsed for ERMS reports. Contains emails that were responded to, without using a template. |
| SELECT B.ROW_ADDED_OPRID ,0 ,0 ,COUNT(*) ,0 ,0 ,0 ,0 ,B.ROW_ADDED_DTTM ,B.ROW_ADDED_DTTM ,CASE WHEN B.ROW_ADDED_DTTM > B.ROW_ADDED_DTTM THEN 1 ELSE 0 END CASE ,0 ,0 ,0 FROM PS_RB_EM_APPL_TEMP A , PS_RBC_REQUEST B , PS_RBC_RECIPIENT C , PS_RI_INTERACTION D , PS_RB_IN_EMAIL E , PSOPRALIAS F WHERE A.CMF_ID = B.CMF_ID AND B.CMF_ID = C.CMF_ID AND C.INTERACTION_ID = D.INTERACTION_ID AND D.PARENT_INTER_ID = E.INTERACTION_ID AND B.ROW_ADDED_OPRID = F.OPRID GROUP BY B.ROW_ADDED_OPRID,B.ROW_ADDED_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 |