RC_AGT_PRSPT_V2

(SQL View)
 Index Back

Agent Prospect view

Outbound Marketing

SELECT B.LEAD_ID , C.BUSINESS_UNIT , C.RA_CAMPAIGN_ID , C.RA_CMPGN_WAVE_ID , C.RA_WAVE_NAME , C.END_DATE , C.RA_OFFER_ID , D.CONTACT_NAME , B.CUST_ID , B.CUST_SETID , B.BO_ID_CUST , D.CONTACT_ID , B.ROLE_TYPE_ID_CUST , C.RA_SCRIPT_ID_OTBN , D.WORK_PHONE , D.BO_ID_CONTACT , C.RA_PROMOTION_CODE FROM PS_RSF_LEAD B , PS_RA_CMPGN_WAVE C , PS_RSF_LE_CONTACTS D WHERE C.BUSINESS_UNIT = B.BUSINESS_UNIT_RA AND C.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND C.RA_CMPGN_WAVE_ID = B.RA_CMPGN_WAVE_ID AND D.LEAD_ID = B.LEAD_ID AND D.SEQNUM = 1

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RA_NONVW

3 RA_CAMPAIGN_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.
4 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
5 RA_WAVE_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Activity (Wave) Name - field containing the campaign activity (wave) name. Campaign Activity (Wave Name) could be either program generated or free form entry.
6 END_DATE Date(10) DATE End date field to store an end date.
7 RA_OFFER_ID Character(15) VARCHAR2(15) NOT NULL Marketing Offer ID
8 NAME Character(50) VARCHAR2(50) NOT NULL Name
9 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
10 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer Setid
11 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
12 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
13 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer
14 RA_SCRIPT_ID_OTBN Number(12,0) DECIMAL(12) NOT NULL Outbound Script ID - Numeric
15 WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Phone
16 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
17 RA_PROMOTION_CODE Character(35) VARCHAR2(35) NOT NULL Marketing - campaign wave promotion code