RB_TOTAL_EMLS_V (SQL View)	Index Back
Total Emails in system Used for ERMS Reports. This will display a list of all emails that are in the system, excluding Spam emails

RB_TOTAL_EMLS_V

(SQL View)

Total Emails in system

Used for ERMS Reports. This will display a list of all emails that are in the system, excluding Spam emails

SELECT B.MAILBOX_ID , B.INTERACTION_ID , B.SLA_EXT_BASE_DTTM FROM PS_RB_ERMS_SYSDEFN A , PS_RB_IN_EMAIL B WHERE A.TMPLT_CATEGRY_ID <> B.TMPLT_CATEGRY_ID

# 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 INTERACTION_ID Character(15) VARCHAR2(15) NOT NULL interaction id

3 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

#	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	INTERACTION_ID	Character(15)	VARCHAR2(15) NOT NULL	interaction id
3	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added