RSF_LE_DUPC_VW

(SQL View)
 Index Back

Volume Import Verification

This record is a holding table for Leads being imported. This provides the user with an opportunity to verify the Leads moving to the real table RSF_LEAD.

SELECT C.LEAD_ID , C.CONTACT_ID , C.CONTACT_NAME , C.FIRST_NAME , C.LAST_NAME , C.COUNTRY_CODE , C.WORK_PHONE , C.EXTENSION , C.HOME_PHONE , C.CELL_PHONE , C.FAX , C.EMAILID FROM PS_RSF_LE_CONTACTS C

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
3 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
4 FIRST_NAME_CNCT Character(30) VARCHAR2(30) NOT NULL First Name Contact
5 LAST_NAME_CNCT Character(30) VARCHAR2(30) NOT NULL Last Name
6 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.
7 WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Phone
8 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.
9 HOME_PHONE Character(24) VARCHAR2(24) NOT NULL Home Phone
10 CELL_PHONE Character(24) VARCHAR2(24) NOT NULL Cell Phone
11 FAX Character(24) VARCHAR2(24) NOT NULL This is the fax number field.
12 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address