RSF_CNTCT_BC_VW

(SQL View)
 Index Back

The Contact Customer view

This view returns all the customers the person belongs to.

SELECT R.BO_ID_2 , A.PERSON_ID , B.FIRST_NAME , B.LAST_NAME , B.FIRST_NAME_SRCH , B.LAST_NAME_SRCH , B.BO_NAME , B.BO_NAME_AC , A.TITLE , A.BO_ID , R.START_DT , R.ROLE_TYPE_ID_1 , R.ROLE_TYPE_ID_2 , R.REL_TYPE_ID , A.BO_ID , B.NAME FROM PS_RD_PERSON A , PS_BO_NAME B , PS_BO_REL R WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y' AND A.BO_ID = R.BO_ID_1 AND R.ROLE_TYPE_ID_1 = 8 AND R.ROLE_TYPE_ID_2 IN (2, 9) AND R.REL_TYPE_ID IN (9, 10, 13, 14) AND R.START_DT <= %CurrentDateIn AND R.END_DT > %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

Prompt Table: RB_BO_CUST_VW

2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
7 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
8 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
9 TITLE Character(35) VARCHAR2(35) NOT NULL Title
10 BO_ID_CNTCT Number(31,0) DECIMAL(31) NOT NULL This field represents the business object ID for a Contact
11 START_DT Date(10) DATE Start date field to store start date value.
12 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
13 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
14 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID
15 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
16 NAME Character(50) VARCHAR2(50) NOT NULL Name