RB_CONSUMER_VW

(SQL View)
 Index Back

Consumer customer view

This view lists all the persons who are consumers.

SELECT A.PERSON_ID , A.SETID ,B.NAME ,B.LAST_NAME_SRCH ,B.FIRST_NAME_SRCH ,B.PREF_FIRST_NAME ,A.TITLE ,A.BO_ID FROM PS_RD_PERSON A , PS_RD_PERSON_NAME B , PS_BO C , PS_BC D WHERE A.PERSON_ID = B.PERSON_ID AND A.BO_ID = C.BO_ID AND C.BO_ID = D.BO_ID AND D.CUSTOMER_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Default Value: NEXT

2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
6 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name
7 TITLE Character(35) VARCHAR2(35) NOT NULL Title
8 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID