RSF_OPP_CONT_VW (SQL View)	Index Back
Contacts for an Opportunity This tables lists all the Customer Contacts for an opportunity and their roles and whether they are decision makers or not.

RSF_OPP_CONT_VW

(SQL View)

Contacts for an Opportunity

This tables lists all the Customer Contacts for an opportunity and their roles and whether they are decision makers or not.

SELECT OPPORTUNITY_ID , CONTACT_NAME , FIRST_NAME , LAST_NAME , CONTACT_ID , WORK_PHONE , EXTENSION , BO_ID_CONTACT FROM PS_RSF_OPP_CONTACT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID

2 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.

3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

5 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

6 WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Phone

7 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
2	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
3	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
4	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
5	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
6	WORK_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Work Phone
7	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	This field stores the Phone extension.
8	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.