RC_OM_2PRADR_VW

(SQL View)
 Index Back

Telemarketing view

Telemarketing view used for recording selected Prospect. For Preview Dialing status selected has been expanded from just N to N and C

SELECT DISTINCT A.BUSINESS_UNIT_RA , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.BO_ID_CUST , A.BO_ID_CONTACT , G.BO_NAME_DISPLAY , H.BO_NAME_DISPLAY , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.NAME , D.RA_CMPGN_NAME , E.RA_WAVE_NAME , C.ADDRESS1 , C.CITY , C.STATE , C.POSTAL , A.LEAD_ID , K.RC_CALLBACK_DATE , K.RC_CALLBACK_TIME FROM PS_RSF_LEAD A , PS_RB_PRSN_P_NM_VW B , PS_RT_OM_1PRADR_VW C , PS_RA_CAMPAIGN D , PS_RA_CMPGN_WAVE E , PS_RSF_LE_CONTACTS F , PS_BO_NAME G , PS_BO_NAME H , PS_RC_CALLRSLT_MAX K WHERE A.LEAD_ID = F.LEAD_ID AND F.SEQNUM = 1 AND B.BO_ID = F.BO_ID_CONTACT AND A.BUSINESS_UNIT_RA = D.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = D.RA_CAMPAIGN_ID AND A.BUSINESS_UNIT_RA = E.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = E.RA_CAMPAIGN_ID AND A.RA_CMPGN_WAVE_ID = E.RA_CMPGN_WAVE_ID AND A.RC_PROSPECT_SW = 'Y' AND A.RC_PROSPECT_STAT IN ('N', 'C') AND G.BO_ID = F.BO_ID_CONTACT AND G.PRIMARY_IND = 'Y' AND H.BO_ID = A.BO_ID_CUST AND (E.END_DATE > %CurrentDateIn OR (E.END_DATE = %CurrentDateIn AND E.END_TIME >= %CurrentTimeIn)) AND H.PRIMARY_IND = 'Y' AND A.BO_ID_CUST = C.BO_ID (+) AND A.ROLE_TYPE_ID_CUST = C.ROLE_TYPE_ID (+) AND A.LEAD_ID = K.LEAD_ID (+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RA_NONVW

2 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.

Prompt Table: RA_CMPGN_ID_VW

3 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID

Prompt Table: RA_WAVE_ID_VW

4 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
5 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
6 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
7 BO_NAME_DISPLAY_1 Character(80) VARCHAR2(80) NOT NULL This field represents the Display Name for a business object
8 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
9 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
10 NAME Character(50) VARCHAR2(50) NOT NULL Name
11 RA_CMPGN_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Name - field containing the name of the campaign.
12 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.
13 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
14 CITY Character(30) VARCHAR2(30) NOT NULL City
15 STATE Character(6) VARCHAR2(6) NOT NULL State
16 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
17 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
18 RC_CALLBACK_DATE Date(10) DATE Outbound Marketing
19 RC_CALLBACK_TIME Time(15) TIMESTAMP Outbound Marketing field holding the time for a Prospect to be called back.