RA_WHATIF_VW

(SQL View)
 Index Back

WhatIf Marketing ACE

This view used by WhatIf Analysis Marketing report for ACE

SELECT K.PROBINST , A.RA_ROLLUP_CM_NAME , A.RA_CMPGN_NAME , A.RA_WAVE_NAME , A.DESCR , A.RA_LIST_NAME , A.LIST_CURR_COUNT , A.NO_OF_LEADS , A.NO_OF_OPPOR , A.NO_OF_CUSTOMERS , A.RA_CMPGN_COST , A.RA_CMPGN_REVENUE , A.RA_ROLLUP_CMPGN_ID , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.RA_LIST_ID , A.BUSINESS_UNIT FROM PS_RA_WHATIFQRY_VW A , PS_RA_WIF_ALY_INST K , PS_RA_WIF_ANALYTIC J WHERE A.BUSINESS_UNIT = J.BUSINESS_UNIT AND A.RA_CMPGN_STATUS_CD = J.RA_CMPGN_STATUS_CD AND A.START_DATE >= J.START_DATE AND A.START_DATE <= J.END_DATE AND K.OPRID = J.OPRID AND K.RUN_CNTL_ID = J.RUN_CNTL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 RA_ROLLUP_CM_NAME Character(50) VARCHAR2(50) NOT NULL Rollup Campaign Name - used in view for Home Grd. This is the name of the rollup campaign
3 RA_CMPGN_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Name - field containing the name of the campaign.
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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 RA_LIST_NAME Character(30) VARCHAR2(30) NOT NULL Audience / List Name
7 LIST_CURR_COUNT Number(18,0) DECIMAL(18) NOT NULL Audience current count
8 NO_OF_LEADS Number(10,0) DECIMAL(10) NOT NULL Number of leads field
9 NO_OF_OPPOR Number(10,0) DECIMAL(10) NOT NULL Field used in Interactive report. RA_WHATIF
10 NO_OF_CUSTOMERS Number(10,0) DECIMAL(10) NOT NULL No. of Customers
11 RA_CMPGN_COST Number(20,2) DECIMAL(19,2) NOT NULL Campaign Cost
12 RA_CMPGN_REVENUE Number(20,2) DECIMAL(19,2) NOT NULL Field used in Interactive report. RA_WHATIF
13 RA_ROLLUP_CMPGN_ID Character(15) VARCHAR2(15) NOT NULL Campaign - Roll Up (Parent) Campaign Identification
14 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.
15 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID

Prompt Table: RA_UD_CPGN_STAT

16 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID
17 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit