RB_CONT_ACCT_VW (SQL View)	Index Back
Contacts for account team Select all contacts for customers where user is part of the account team

RB_CONT_ACCT_VW

(SQL View)

Contacts for account team

Select all contacts for customers where user is part of the account team

SELECT DISTINCT A.SETID , A.CUST_ID , B.PERSON_ID , SUSER.PERSON_ID , BOCOMP.BO_NAME , BOPERS.BO_NAME , R.BO_ID_2 , R.BO_ID_1 , R.ROLE_TYPE_ID_2 , R.ROLE_TYPE_ID_1 , R.SYNCID FROM PS_BC A , PS_RD_PERSON B , PS_BO BOCOMP , PS_BO BOPERS , PS_BO_REL R , PS_BO_REL_ACCT_OWN OWNER , PS_RB_ACCT_OWNR_VW C , PS_RD_PERSON SUSER WHERE R.REL_TYPE_ID BETWEEN 9 AND 14 AND R.ROLE_TYPE_ID_2 IN ( 2 , 9) AND A.BO_ID = R.BO_ID_2 AND R.BO_ID_1 = B.BO_ID AND BOCOMP.BO_ID = R.BO_ID_2 AND BOCOMP.BO_ID = A.BO_ID AND BOCOMP.BO_ID = C.BO_ID_CUST AND BOPERS.BO_ID = R.BO_ID_1 AND BOPERS.BO_ID = B.BO_ID AND SUSER.PERSON_ID = OWNER.PERSON_ID AND SUSER.PERSON_ID = C.PERSON_ID_OWNER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

3 PERSON_ID_CONT Character(15) VARCHAR2(15) NOT NULL Person ID

4 PERSON_ID_OWNER Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

5 COMPANY_NAME Character(70) VARCHAR2(70) NOT NULL Company Name

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

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

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

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

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

11 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
3	PERSON_ID_CONT	Character(15)	VARCHAR2(15) NOT NULL	Person ID
4	PERSON_ID_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
5	COMPANY_NAME	Character(70)	VARCHAR2(70) NOT NULL	Company Name
6	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
7	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
8	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
9	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
10	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
11	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.