RC_OB_CMPGWV_VW

(SQL View)
 Index Back

Telemarketing Campaign Wave

Telemarketing Campaign wave view

SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.RA_WAVE_NAME , A.RA_PRIORITY , A.START_DATE , A.END_DATE , A.START_TIME , A.END_TIME , A.RA_LIST_ID , B.RC_LIST_COUNT , B.RC_COMPLETED_CALL , B.RC_ATTEMPTED_CALL , B.RC_POSITIVE_CALL , B.RC_ORDER_CALL , B.RC_DONOT_CALL , B.RC_CALLBACK_CALL , B.RC_NO_CONTACT , ' ' FROM PS_RA_CMPGN_WAVE A , PS_RC_CALL_SUMMRY B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND A.RA_CMPGN_WAVE_ID = B.RA_CMPGN_WAVE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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.
3 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
4 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.
5 RA_PRIORITY Character(1) VARCHAR2(1) NOT NULL Marketing - campaign wave content task priority
1=High Priority
2=Medium Priority
3=Low Priority
6 START_DATE Date(10) DATE Start Date for Gen Standing PO
7 END_DATE Date(10) DATE End date field to store an end date.
8 START_TIME Time(15) TIMESTAMP Start of Shift
9 END_TIME Time(15) TIMESTAMP End of Shift
10 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID
11 RC_LIST_COUNT Number(8,0) INTEGER NOT NULL Outbound Marketing
12 RC_CLOSED Number(8,0) INTEGER NOT NULL Outbound Marketing
13 RC_ATTEMPTED_CALL Number(8,0) INTEGER NOT NULL Call Center - Outbound Marketing Prospects - Attempted Calls
14 RC_POSITIVE_CALL Number(8,0) INTEGER NOT NULL Call Center - Outbound Marketing Prospects - Positive Calls
15 RC_ORDER_CALL Number(8,0) INTEGER NOT NULL Call Center - Outbound Marketing Prospects -Order Calls
16 RC_DONOT_CALL Number(8,0) INTEGER NOT NULL Call Center - Outbound Marketing Prospects -Do Not Contact Calls
17 RC_CALLBACK_CALL Number(8,0) INTEGER NOT NULL Outbound Marketing
18 RC_NO_CONTACT Number(8,0) INTEGER NOT NULL Outbound Marketing
19 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.