RC_AGT_CALL_VW

(SQL View)
 Index Back

Agent calls information

Agent calls count based on his team and campaigns.

SELECT PERSON_ID , SUM(RC_COMPLETED_CALL) , SUM(RC_CALLS_LEFT) FROM PS_RC_OM_AGTCMP_VW A , PS_RC_CALL_SUMMRY B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND A.RA_CMPGN_WAVE_ID = B.RA_CMPGN_WAVE_ID GROUP BY PERSON_ID UNION ALL SELECT PERSON_ID , SUM(B.RC_COMPLETED_CALL) , SUM(B.RC_CALLS_LEFT) FROM PS_RC_AGT_SMRY_VW A , PS_RC_CALL_SUMMRY B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RA_CAMPAIGN_ID = B.RA_CAMPAIGN_ID AND A.RA_CMPGN_WAVE_ID = B.RA_CMPGN_WAVE_ID GROUP BY A.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 RC_CALLS_LEFT Number(8,0) INTEGER NOT NULL Calls Remaining
3 RC_COMPLETED_CALL Number(8,0) INTEGER NOT NULL Outbound Marketing