RA_RESPONSE2_VW(SQL View) |
Index Back |
---|---|
view for Response metricview 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. |