07-21-2005 10:28 PM - edited 03-13-2019 11:02 PM
We are creating ICM SQL table for reporting purpose for one customer. Customer IPCC is setup for inbound and wants a report on outbound calls made by agnets. Agents are making outbound calls by manually dialing the numbers and calls are not routed by ICM. We are refering following tables in ICM
Agent_Skill_Group_Half_Hour_Table
AgentOutCallsTimeToHalf
TalkOutTimeToHalf
AgentOutCallsTalkTimeToHalf
Service_Half_Hour_Table
CallsOutToHalf
CallsOutHalf
CallsOutNow
Service_Real_Time_Table
CallsOutHalf
CallsOutNow
Skill_Group_Half_Hour_Table
TalkingOut
AgentOutCallsTimeToHalf
AgentOutCallsToHalf
AgentOutCallsTalkTimeToHalf
Please advice for inbound ICM setup can we get any data for outbound calls from above fields in ICM Tables.
07-22-2005 12:39 PM
Here is a link to the ICM 5.0 DB schema handbook:
http://www.cisco.com/univercd/cc/td/doc/product/icm/icmentpr/icm50doc/coreicm5/confadm/dataschm.pdf
Search for talkingout, talkout, etc to find tables that contain fields related to talking out.
Some of the tables you mentioned contain fields related to outbound calls.
Hope this helps.
John.
07-26-2005 12:14 AM
Thanks John.
I know about this document. But it does not specify that fields in table will capture data for outbound calls in case IPCC is setup for inbound calls
07-26-2005 02:29 AM
Data will be captured for all inbound and outbound calls to and from the system with IPCC set up for inbound calls.
Try a simple experiment with 1 phone set up to take inbound IPCC routed calls. Make some outbound calls with the phone and see that the outbound fields in the database get populated.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide