RAE_CSTSUM_VW (SQL View)	Index Back
Event Cost Records Summarize the costs of all sessions for an event -

RAE_CSTSUM_VW

(SQL View)

Event Cost Records

Summarize the costs of all sessions for an event -

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 RAE_EVENT_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 RAE_EVT_SESSION_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Session Identification field. Character field that will contain a generated Session 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 RAE_EVT_SESSN_NAME Character(50) VARCHAR2(50) NOT NULL Session Name - field containing the name of the session

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	RAE_EVENT_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	RAE_EVT_SESSION_ID	Character(15)	VARCHAR2(15) NOT NULL	Marketing - Session Identification field. Character field that will contain a generated Session 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	RAE_EVT_SESSN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Session Name - field containing the name of the session
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.