RC_PROFILE2_VW

(SQL View)
 Index Back

Consumer Contacts

Profile View used for Customer Contacts in Higher Education.

SELECT DISTINCT A.PERSON_ID , D.BO_ID , A.NAME , A.LAST_NAME , A.FIRST_NAME , A.MIDDLE_NAME , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , D.BO_ID , D.ROLE_TYPE_ID , C.BO_NAME , 'W' FROM PS_RB_PRSN_P_NM_VW A , PS_BO_NAME_PRIM_VW C , PS_BO_ROLE D , PS_BO_SRCH_GRP_TYP E WHERE A.BO_ID = D.BO_ID AND C.BO_ID = A.BO_ID AND D.ROLE_START_DT <= %CurrentDateIn AND D.ROLE_END_DT > %CurrentDateIn AND D.ROLE_TYPE_ID = E.ROLE_TYPE_ID AND E.SRCH_GROUP_ID = 35

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