RA_RESPONSE2_VW

(SQL View)
Index Back

view for Response metric

view for Response metric To calculate the response metric for a campaign

SELECT A.BUSINESS_UNIT ,R.RA_ROLLUP_CMPGN_ID ,A.RA_CAMPAIGN_ID ,A.RA_CMPGN_WAVE_ID , B.LEAD_ID , B.OPPORTUNITY_ID ,B.RC_PROSPECT_SW , B.CONV_FROM_TLM_DTTM ,C.RA_PROMOTION_CODE ,D.LEAD_ID , E.OPPORTUNITY_ID FROM PS_RA_CMPGN_WAVE A ,PS_RSF_LEAD B ,PS_RA_SO_QUO_COUNT C ,PS_RO_RSF_LOPPY_VW D ,PS_RO_RSF_LOPPY_VW E ,PS_RA_RLUP_MET_VW R WHERE A.BUSINESS_UNIT = R.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = R.RA_CAMPAIGN_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT_RA(+) AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID(+) AND A.RA_CMPGN_WAVE_ID = B.RA_CMPGN_WAVE_ID(+) AND A.RA_PROMOTION_CODE = C.RA_PROMOTION_CODE(+) AND B.LEAD_ID = D.LEAD_ID(+) AND B.OPPORTUNITY_ID = E.OPPORTUNITY_ID(+) GROUP BY A.BUSINESS_UNIT ,R.RA_ROLLUP_CMPGN_ID,A.RA_CAMPAIGN_ID ,A.RA_CMPGN_WAVE_ID , B.LEAD_ID , B.OPPORTUNITY_ID ,B.RC_PROSPECT_SW , B.CONV_FROM_TLM_DTTM ,C.RA_PROMOTION_CODE ,D.LEAD_ID , E.OPPORTUNITY_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_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.
4 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
5 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
6 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
7 RC_PROSPECT_SW Character(1) VARCHAR2(1) NOT NULL Outbound Marketing
8 CONV_FROM_TLM_DTTM DateTime(26) TIMESTAMP Convert from TeleSales Date and Time
9 RA_PROMOTION_CODE Character(35) VARCHAR2(35) NOT NULL Marketing - campaign wave promotion code
10 LEAD_OPP_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
11 LEAD_SOURCE_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation to identify the source of a Sales Lead.