RB_ERMS_V_PRS_V

(SQL View)
Index Back

Emails Processed by Agents

Used for ERMS reports......................

SELECT A.MAILBOX_ID ,A.LAST_GROUP_WL ,1 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,A.ROW_ADDED_DTTM ,A.ROW_ADDED_DTTM FROM PS_RB_EM_ROUT_HIST A WHERE A.NEW_WL IN ( SELECT B.OPRID FROM PSOPRALIAS B) GROUP BY A.MAILBOX_ID ,A.LAST_GROUP_WL ,A.ROW_ADDED_DTTM

# 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 LAST_GROUP_WL Character(30) VARCHAR2(30) NOT NULL Last/Current Group-level Worklist
3 RB_EMAIL_ASSIGNED Number(8,0) INTEGER NOT NULL Detail item status
4 RB_EXIST_THREADS Number(8,0) INTEGER NOT NULL Used for ERMS Reporting.....................
5 RB_NEW_THREADS Number(8,0) INTEGER NOT NULL Used for ERMS Reporting.......................
6 RB_EMAIL_REASIGNED Number(8,0) INTEGER NOT NULL Used for ERMS Reporting..........................
7 RB_TOTAL_EMAILS Number(8,0) INTEGER NOT NULL Detail item status
8 RB_CLOSED_DUEDATE Number(8,0) INTEGER NOT NULL Detail item status
9 RB_CLOSED_CAN Number(8,0) INTEGER NOT NULL Detail item status
10 RB_CLOSED_DUP Number(8,0) INTEGER NOT NULL Detail item status
11 RB_CLOSED_REP Number(8,0) INTEGER NOT NULL Detail item status
12 RB_CLOSED_AUTO Number(8,0) INTEGER NOT NULL Detail item status
13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
14 CLOSED_DTTM DateTime(26) TIMESTAMP Date Time stamp for when the case status category was changed to closed.