RB_CONT_MBR_VW

(SQL View)
Index Back

Contact List team members

Contacts for customers where the user who is logged in is part of the account team for that customer

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_RB_ACCT_MBR_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 = C.PERSON_ID_MBR

# 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_MBR 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.