RB_ERMS_C_RSN_V

(SQL View)
Index Back

Emails Reassigned

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

SELECT C.TMPLT_CATEGRY_NAME ,0 ,0 ,0 ,1 ,0 ,0 ,0 ,0 ,0 ,0 ,B.ROW_ADDED_DTTM ,B.ROW_ADDED_DTTM FROM PS_RB_IN_EMAIL A , PS_RB_EM_ROUT_HIST B , PS_RBC_TEMPLT_CAT C WHERE A.MCF_EMAIL_ID = B.MCF_EMAIL_ID AND B.EMAIL_STATUS = 'RASN' AND A.TMPLT_CATEGRY_ID = C.TMPLT_CATEGRY_ID GROUP BY C.TMPLT_CATEGRY_NAME,B.ROW_ADDED_DTTM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TMPLT_CATEGRY_NAME Character(30) VARCHAR2(30) NOT NULL Holds the names of the categories. 01/16/03: Set the Format Type to "Mixedcase", from Uppercase.
2 RB_EMAIL_ASSIGNED Number(8,0) INTEGER NOT NULL Detail item status
3 RB_EXIST_THREADS Number(8,0) INTEGER NOT NULL Used for ERMS Reporting.....................
4 RB_NEW_THREADS Number(8,0) INTEGER NOT NULL Used for ERMS Reporting.......................
5 RB_EMAIL_REASIGNED Number(8,0) INTEGER NOT NULL Used for ERMS Reporting..........................
6 RB_TOTAL_EMAILS Number(8,0) INTEGER NOT NULL Detail item status
7 RB_CLOSED_DUEDATE Number(8,0) INTEGER NOT NULL Detail item status
8 RB_CLOSED_CAN Number(8,0) INTEGER NOT NULL Detail item status
9 RB_CLOSED_DUP Number(8,0) INTEGER NOT NULL Detail item status
10 RB_CLOSED_REP Number(8,0) INTEGER NOT NULL Detail item status
11 RB_CLOSED_AUTO Number(8,0) INTEGER NOT NULL Detail item status
12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
13 CLOSED_DTTM DateTime(26) TIMESTAMP Date Time stamp for when the case status category was changed to closed.