RT_CALLBACK_VW1

(SQL View)
 Index Back

Callback View

Telemarketing Call Back view - used for calculating the NOT ATTEMPTED calls

SELECT A.BUSINESS_UNIT_RA , A.RA_CAMPAIGN_ID , A.RA_CMPGN_WAVE_ID , A.LEAD_ID , B.RC_CALL_STATUS , B.SEQNO FROM PS_RSF_LEAD A , PS_RC_CALL_RESULT B WHERE A.LEAD_ID = B.LEAD_ID AND B.RC_CALL_STATUS IN ('CB', 'NC', ' ') AND B.DONE_FLAG = 'N' AND B.SEQNO = ( SELECT MAX(B.SEQNO) FROM PS_RC_CALL_RESULT B WHERE B.LEAD_ID = A.LEAD_ID AND B.RC_CALL_STATUS IN ('CB', 'NC', ' ') AND DONE_FLAG = 'N')

# 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_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID
4 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
5 RC_CALL_STATUS Character(2) VARCHAR2(2) NOT NULL Outbound Marketing
CB=Call Back
CL=Close
NC=No Contact
6 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number