SDB_OBEMAIL_MVW (SQL View)	Index Back
Email Merge View Outbound Email Merge view used for CDH integration with dashboard

SDB_OBEMAIL_MVW

(SQL View)

Email Merge View

Outbound Email Merge view used for CDH integration with dashboard

SELECT CMF_ID , 'O' , BO_ID_CUST FROM PS_RBC_REQST_REC WHERE CMF_TRNS_SEQ_NUM = 1 AND CMF_KEY_SEQ_NUM = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CMF_ID Character(36) VARCHAR2(36) NOT NULL Correspondence 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	CMF_ID	Character(36)	VARCHAR2(36) NOT NULL	Correspondence 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.