SDB_IBEMAIL_MVW (SQL View)	Index Back
Email Merge View Inbound Email Merge view used for CDH integration with dashboard.

SDB_IBEMAIL_MVW

(SQL View)

Email Merge View

Inbound Email Merge view used for CDH integration with dashboard.

SELECT MCF_EMAIL_ID , 'I' , CASE WHEN BO_ID_CUST = 0 THEN BO_ID_CONTACT ELSE BO_ID_CUST END FROM PS_RB_IN_EMAIL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MCF_EMAIL_ID Number(16,0) DECIMAL(16) NOT NULL Email Id

2 IB_OB_INDICATOR Character(1) VARCHAR2(1) NOT NULL Inbound or Outbound Emal Indicator. This is used in ERMS Section in Contact Center Dashboard.

3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MCF_EMAIL_ID	Number(16,0)	DECIMAL(16) NOT NULL	Email Id
2	IB_OB_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Inbound or Outbound Emal Indicator. This is used in ERMS Section in Contact Center Dashboard.
3	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.