RSFD_MRG_CALL_V (SQL View)	Index Back
Call Report Customer Merge The view for dashboard of the Call reports where a merge of Customers has happened and the which sales representatives are impacted.

RSFD_MRG_CALL_V

(SQL View)

Call Report Customer Merge

The view for dashboard of the Call reports where a merge of Customers has happened and the which sales representatives are impacted.

SELECT A.CALL_REPORT_ID , A.PERSON_ID , A.BO_ID_CUST FROM PS_RSFD_CALL_RPT_V A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CALL_REPORT_ID Number(15,0) DECIMAL(15) NOT NULL Unique Identifier for Call Reports.

2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

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	CALL_REPORT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Unique Identifier for Call Reports.
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.