RBF_PROFILE_VW

(SQL View)
 Index Back

Customer Contacts

This view brings all the contacts of a customer (FSI specific)

SELECT A.PERSON_ID , B.BO_ID ,A.NAME ,A.LAST_NAME ,A.FIRST_NAME ,A.MIDDLE_NAME ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,B.CUST_ID ,B.BO_ID_CUST ,D.ROLE_TYPE_ID ,C.BO_NAME FROM PS_RB_PRSN_P_NM_VW A , PS_RBF_BO_CST_C_VW B , PS_BO_NAME_PRIM_VW C , PS_BO_ROLE D , PS_BO_SRCH_GRP_TYP E WHERE A.BO_ID = B.BO_ID AND B.BO_ID_CUST = C.BO_ID AND C.BO_ID = D.BO_ID AND D.ROLE_TYPE_ID = E.ROLE_TYPE_ID AND E.SRCH_GROUP_ID = 23

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
3 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
6 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
7 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
8 WS_HOME_PHONE Character(24) VARCHAR2(24) NOT NULL Home Telephone Number
9 WS_WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Telephone Number
10 WS_WORK_EXT Character(6) VARCHAR2(6) NOT NULL Phone Extension
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SETID
13 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
14 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
15 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
16 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
17 CUST_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to represent the customer name