RC_PROFILE_VW

(SQL View)
 Index Back

Customer Contacts

This view brings BO_IDs of the contacts for a specific customer.

SELECT DISTINCT A1.PERSON_ID ,G.BO_ID_1 ,A2.NAME ,A2.LAST_NAME ,A2.FIRST_NAME ,A2.MIDDLE_NAME ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' ,H.CUST_ID ,G.BO_ID_2 ,D.ROLE_TYPE_ID ,C.BO_NAME ,'N' , 0 , 0 , 0 , 0 FROM PS_RD_PERSON A1 , PS_BO_NAME A2 , PS_BO_REL G , PS_BC H , PS_BO_REL_CAT_ITEM I , PS_BO_SRCH_GRP_TYP B2 , PS_BO_NAME C , PS_BO_ROLE D , PS_BO_SRCH_GRP_TYP E WHERE A1.BO_ID = G.BO_ID_1 AND G.BO_ID_2 = C.BO_ID AND C.BO_ID = D.BO_ID AND D.ROLE_TYPE_ID = E.ROLE_TYPE_ID AND D.ROLE_START_DT <= %CurrentDateIn AND D.ROLE_END_DT > %CurrentDateIn AND E.SRCH_GROUP_ID = 2 AND G.ROLE_TYPE_ID_2 = B2.ROLE_TYPE_ID AND B2.SRCH_GROUP_ID IN (2, 23) AND A1.BO_ID = A2.BO_ID AND A2.PRIMARY_IND = 'Y' AND C.PRIMARY_IND = 'Y' AND I.REL_TYPE_ID = G.REL_TYPE_ID AND I.BO_REL_CATEGORY_ID IN (1) AND G.BO_ID_2 = H.BO_ID AND G.START_DT <= %CurrentDateIn AND (G.END_DT > %CurrentDateIn OR G.END_DT IS NULL)

# 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
18 CONSUMER_FLAG Character(1) VARCHAR2(1) NOT NULL To indicate whether a person has a consumer role.
19 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.
20 ROLE_TYPE_ID_PART Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner
21 BO_ID_PART_CONT Signed Number(32,0) DECIMAL(31) NOT NULL This is the business object identifier for the partner contact.
22 ROLE_TYPE_ID_PARTC Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the partner contact