RC_AGT_CALL_VW1 (SQL View)	Index Back
Agent calls count information Agents summarized call counts based on his team and campaigns.

RC_AGT_CALL_VW1

(SQL View)

Agent calls count information

Agents summarized call counts based on his team and campaigns.

SELECT PERSON_ID , SUM(RC_COMPLETED_CALL) , SUM(RC_CALLS_LEFT) FROM PS_RC_AGT_CALL_VW GROUP BY 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

#	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