RA_COST_RLUP_VW (SQL View)	Index Back
Program Roll up Costs Program Roll up costs at the roll up level, used for calculating all costs for all children at the roll up level

RA_COST_RLUP_VW

(SQL View)

Program Roll up Costs

Program Roll up costs at the roll up level, used for calculating all costs for all children at the roll up level

SELECT A.BUSINESS_UNIT , A.RA_ROLLUP_CMPGN_ID , C.RA_CMPGN_NAME , B.RA_CAMPAIGN_ID , E.RA_CMPGN_NAME , ' ' , ' ' , D.DESCR , B.RA_UNIT_COST , B.RA_FORECAST_AMT , B.RA_ACTUAL_AMT FROM PS_RA_PROGRAM_TBL A , PS_RA_CMPGN_COST B , PS_RA_CAMPAIGN C , PS_RA_COST_METRICS D , PS_RA_CAMPAIGN E , PS_SET_CNTRL_REC SC WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_ROLLUP_CMPGN_ID = B.RA_CAMPAIGN_ID AND D.SETID = SC.SETID AND SC.RECNAME = 'RA_COST_METRICS' AND SC.SETCNTRLVALUE = A.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RA_ROLLUP_CMPGN_ID = C.RA_CAMPAIGN_ID AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.RA_ROLLUP_CMPGN_ID = E.RA_CAMPAIGN_ID AND B.RA_COST_METRIC_ID = D.RA_COST_METRIC_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 RA_ROLLUP_CMPGN_ID Character(15) VARCHAR2(15) NOT NULL Campaign - Roll Up (Parent) Campaign Identification

3 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

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

5 RA_CMPGN_NAME Character(50) VARCHAR2(50) NOT NULL Campaign Name - field containing the name of the campaign.

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

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

8 DESCR Character(30) VARCHAR2(30) NOT NULL Description

9 RA_UNIT_COST Number(12,2) DECIMAL(11,2) NOT NULL Marketing - Unit Cost

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RA_ROLLUP_CMPGN_ID	Character(15)	VARCHAR2(15) NOT NULL	Campaign - Roll Up (Parent) Campaign Identification
3	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
4	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.
5	RA_CMPGN_NAME	Character(50)	VARCHAR2(50) NOT NULL	Campaign Name - field containing the name of the campaign.
6	RA_CMPGN_WAVE_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to uniquely identify a Marketing - Campaign Activity (wave) ID
7	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.
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	RA_UNIT_COST	Number(12,2)	DECIMAL(11,2) NOT NULL	Marketing - Unit Cost
10	RA_FORECAST_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Marketing - Costs Amounts
11	RA_ACTUAL_AMT	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Campaign Actual Cost / Value