RC_CALLRSLT_MAX

(SQL View)
 Index Back

Call Result Last

Table contains the last call result if status is no contact or callback fro RC_CALL_RESULT table

SELECT A.LEAD_ID , A.RC_CALLBACK_DATE , A.RC_CALLBACK_TIME , A.RC_CALL_STATUS , A.SEQNO FROM PS_RC_CALL_RESULT A WHERE A.SEQNO =( SELECT MAX(SEQNO) FROM PS_RC_CALL_RESULT WHERE A.LEAD_ID = LEAD_ID) AND A.RC_CALL_STATUS IN ('CB', 'NC')

# 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 RC_CALLBACK_DATE Date(10) DATE Outbound Marketing
3 RC_CALLBACK_TIME Time(15) TIMESTAMP Outbound Marketing field holding the time for a Prospect to be called back.
4 RC_CALL_STATUS Character(2) VARCHAR2(2) NOT NULL Outbound Marketing
CB=Call Back
CL=Close
NC=No Contact
5 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number