RC_CNTCT_SW_VW1

(SQL View)
 Index Back

Customer Contacts View

Call Center Customer Contact view. This view returns all the contacts for all the customers in the selected business unit.

SELECT ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_RD_PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
2 NAME_SEARCH Character(50) VARCHAR2(50) NOT NULL Name
3 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
8 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.