RSF_PERSON_L_VW

(SQL View)
 Index Back

SFA - Contact View

CRM Sales - A view of all SFA Contacts

SELECT A.PERSON_ID , B.NAME , B.FIRST_NAME , B.LAST_NAME , B.FIRST_NAME_SRCH , B.LAST_NAME_SRCH , A.COMM_METHOD , A.BO_ID , B.NAME , B.BO_NAME_AC FROM PS_RD_PERSON A , PS_BO_NAME B , PS_RSF_LEAD C WHERE A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID_CUST AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
7 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL The person's preferred method of communication.
C=Call
E=Email Only
F=Fax
I=XML only
M=Standard Mail
P=Email & Print
R=XML & Print
S=SMS
8 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
9 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field
10 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object