RD_CR_CONTACT_V (SQL View)	Index Back
Call Report for a Contact List of Call Reports for a given Contact

RD_CR_CONTACT_V

(SQL View)

Call Report for a Contact

List of Call Reports for a given Contact

SELECT B.PERSON_ID ,A.CALL_REPORT_ID ,B.BO_ID_CONTACT ,B.ROLE_TYPE_ID_CNTCT ,B.BO_ID_CUST ,B.ROLE_TYPE_ID_CUST ,B.PRIMARY_IND ,A.SYNCID ,A.SYNCDTTM ,C.BO_NAME_DISPLAY FROM PS_RD_CALL_REPORT A , PS_RD_CALLRPT_CONT B , PS_RD_PRSN_PNM_VW C WHERE A.CALL_REPORT_ID = B.CALL_REPORT_ID AND B.PERSON_ID = C.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

4 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

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

6 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

7 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes

8 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

9 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

10 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	CALL_REPORT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Unique Identifier for Call Reports.
3	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
4	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
5	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
6	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
7	PRIMARY_IND	Character(1)	VARCHAR2(1) NOT NULL	Flag that indicates whether or not it is Primary N=No Y=Yes
8	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
9	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time
10	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object