RAE_CMCSTSUM_VW (SQL View)	Index Back
Event Session Cost Records Summarize the costs of all SESSIONS for an EVENT - used by Rollup Campaign Summarization Page See RAE_CMCSTSUM_V2 for Event Costs for Rollup Campaign Summarization Page

RAE_CMCSTSUM_VW

(SQL View)

Event Session Cost Records

Summarize the costs of all SESSIONS for an EVENT - used by Rollup Campaign Summarization Page See RAE_CMCSTSUM_V2 for Event Costs for Rollup Campaign Summarization Page

SELECT A.BUSINESS_UNIT ,A.RAE_EVENT_ID ,A.RAE_EVT_SESSION_ID , D.RA_PROGRAM_TYPE ,C.RAE_EVT_SESSN_NAME ,C.RA_BUDGET_AMT , SUM(A.RA_FORECAST_AMT) , SUM(A.RA_ACTUAL_AMT) , A.CURRENCY_CD FROM PS_RAE_EVTSES_COST A , PS_RAE_EVT_SESSION C , PS_RA_PROGRAM_TBL D WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RAE_EVENT_ID = C.RAE_EVENT_ID AND A.RAE_EVT_SESSION_ID = C.RAE_EVT_SESSION_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.RAE_EVENT_ID = D.RAE_EVENT_ID GROUP BY A.BUSINESS_UNIT ,A.RAE_EVENT_ID ,A.RAE_EVT_SESSION_ID ,C.RAE_EVT_SESSN_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.