RT_SALE_EFFC_VW

(SQL View)
Index Back

Sales Effectiveness View

View to get data on Telemarketing Sales Effectiveness

SELECT A.LEAD_ID , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.BUSINESS_UNIT , B.RC_BS_STATUS , B.ROW_LASTMANT_DTTM , B.SETID_PROV_GRP , B.PROVIDER_GRP_ID , B.ASSIGNED_TO FROM PS_RSF_LEAD A , PS_RC_CALL_RESULT B , PS_RA_CMPGN_WAVE C WHERE (A.RC_PROSPECT_SW = 'Y' OR CONV_FROM_TLM_DTTM IS NOT NULL) AND B.LEAD_ID = A.LEAD_ID AND B.RC_CALL_STATUS = 'CL' AND B.SEQNO = ( SELECT MAX( C.SEQNO) FROM PS_RC_CALL_RESULT C WHERE C.LEAD_ID = B.LEAD_ID) AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.RA_CAMPAIGN_ID = A.RA_CAMPAIGN_ID AND C.RA_CMPGN_WAVE_ID = A.RA_CMPGN_WAVE_ID AND C.RA_SCRIPT_ID_OTBN <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
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_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 RC_BS_STATUS Character(1) VARCHAR2(1) NOT NULL Branch Script Status. It is ether Valid or Invalid.
C=Completed
P=Processing
S=Started
6 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
7 SETID_PROV_GRP Character(5) VARCHAR2(5) NOT NULL SetID
8 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
9 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.