RAE_EVENTCST_VW (SQL View)	Index Back
Event Costs Sum up event costs not only from event level, but from session level. Used in Metrics.

RAE_EVENTCST_VW

(SQL View)

Event Costs

Sum up event costs not only from event level, but from session level. Used in Metrics.

SELECT BUSINESS_UNIT ,RAE_EVENT_ID ,RA_ACTUAL_AMT ,SEQNO ,ROW_LASTMANT_DTTM FROM PS_RAE_EVENT_COST UNION SELECT BUSINESS_UNIT , RAE_EVENT_ID , RA_ACTUAL_AMT , SEQNO ,ROW_LASTMANT_DTTM FROM PS_RAE_EVTSES_COST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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 RA_ACTUAL_AMT Signed Number(15,2) DECIMAL(13,2) NOT NULL Campaign Actual Cost / Value

4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

5 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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	RA_ACTUAL_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Campaign Actual Cost / Value
4	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.