RA_COST_SUM_VW2

(SQL View)
 Index Back

Campaign Cost Summary View

This view is used in the Track Costs Page.

SELECT A.BUSINESS_UNIT , A.RA_CAMPAIGN_ID , A.RA_COST_METRIC_ID , B.DESCR , C.DESCR , A.CURRENCY_CD , SUM(A.RA_FORECAST_AMT) , SUM(A.RA_ACTUAL_AMT) FROM PS_RA_CMPGN_COST A , PS_RA_COST_METRICS B , PS_RA_UD_COST_TYPE C WHERE A.RA_COST_METRIC_ID = B.RA_COST_METRIC_ID AND B.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.BUSINESS_UNIT AND RECNAME = 'RA_COST_METRICS') AND B.SETID = C.SETID AND B.RA_COST_TYPE_ID = C.RA_COST_TYPE_ID GROUP BY A.BUSINESS_UNIT,A.RA_CAMPAIGN_ID,A.RA_COST_METRIC_ID, B.DESCR, C.DESCR,A.CURRENCY_CD

  • Related Language Record: RA_COSTSUMV2LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    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_COST_METRIC_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Cost Metric ID / Description
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
    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