RB_ERMS_V_DUP_V

(SQL View)
Index Back

Emails closed as Duplicate

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

SELECT A.MAILBOX_ID ,A.LAST_GROUP_WL ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,COUNT(*) ,0 ,0 ,A.CLOSED_DTTM ,A.CLOSED_DTTM FROM PS_RB_IN_EMAIL A WHERE A.CLOSED_DTTM IS NOT NULL AND A.RB_DETAIL_STATUS = 'DUP' GROUP BY A.MAILBOX_ID,A.LAST_GROUP_WL,A.CLOSED_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.