RA_CM_CSTSUM_VW (SQL View)	Index Back
Campaign Cost Records Summarize the costs of all waves for a campaign - see RA_CM_CSTSUM_V2 for summary of costs on a campaign

RA_CM_CSTSUM_VW

(SQL View)

Campaign Cost Records

Summarize the costs of all waves for a campaign - see RA_CM_CSTSUM_V2 for summary of costs on a campaign

SELECT A.BUSINESS_UNIT ,A.RA_CAMPAIGN_ID ,A.RA_CMPGN_WAVE_ID , D.RA_PROGRAM_TYPE ,C.RA_WAVE_NAME ,C.RA_BUDGET_AMT , SUM(A.RA_FORECAST_AMT) , SUM(A.RA_ACTUAL_AMT) , A.CURRENCY_CD FROM PS_RA_WAVE_COST A , PS_RA_CMPGN_WAVE C , PS_RA_PROGRAM_TBL D WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = C.RA_CAMPAIGN_ID AND A.RA_CMPGN_WAVE_ID = C.RA_CMPGN_WAVE_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = D.RA_CAMPAIGN_ID GROUP BY A.BUSINESS_UNIT ,A.RA_CAMPAIGN_ID ,A.RA_CMPGN_WAVE_ID ,C.RA_WAVE_NAME, C.RA_BUDGET_AMT, A.CURRENCY_CD, D.RA_PROGRAM_TYPE

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

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

4 RA_PROGRAM_TYPE Character(4) VARCHAR2(4) NOT NULL Marketing Program type - field that contains valid program types used in marketing, such as Campaigns, Roll ups, Dialogs and Trade Promotions
CMP=Campaign
DLG=Dialog
EVT=Event
RLU=Roll up

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 RA_BUDGET_AMT Number(18,2) DECIMAL(17,2) NOT NULL Campaign Budget Amount

7 RA_FORECAST_AMT Signed Number(15,2) DECIMAL(13,2) NOT NULL Marketing - Costs Amounts

8 RA_ACTUAL_AMT Signed Number(15,2) DECIMAL(13,2) NOT NULL Campaign Actual Cost / Value

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

#	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.
3	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID
4	RA_PROGRAM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Marketing Program type - field that contains valid program types used in marketing, such as Campaigns, Roll ups, Dialogs and Trade Promotions CMP=Campaign DLG=Dialog EVT=Event RLU=Roll up
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	RA_BUDGET_AMT	Number(18,2)	DECIMAL(17,2) NOT NULL	Campaign Budget Amount
7	RA_FORECAST_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Marketing - Costs Amounts
8	RA_ACTUAL_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Campaign Actual Cost / Value
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.