11-01-2013 11:04 AM - edited 03-14-2019 12:41 PM
I'm trying to pull:
Inbound calls for yesterday that connected to an agent
and
Outbound calls for yesterday originating from an agent (no Outbound Option/Dialer)
I need to do it with the Termination Call Detail so that I can filter out an InstrumentNumber range. For the life of me, I can't figure out how to limit it to only inbound/only outbound.
Any help/ideas?
Solved! Go to Solution.
11-01-2013 11:39 AM
For O/B call you can filter using Rouer Call Key as ZERO in TCD table.
SIVANESAN R
11-01-2013 02:23 PM
Just did a quick review of the schema... I think you'll want to look at the PeripheralCallType field in the TCD. PeripheralCallType=9 should match the AgentOutCalls stat.
-Jameson
11-01-2013 11:39 AM
For O/B call you can filter using Rouer Call Key as ZERO in TCD table.
SIVANESAN R
11-01-2013 11:47 AM
That's so easy it makes me angry. Thank you!
11-01-2013 12:25 PM
Actually I spoke to soon,
I need something that will give me the same total that the AgentOutCalls in Agent_Skill_Group_Interval gets me.
is there a document anywhere that will tell me how those fields like AgentOutCalls are calculated?
11-01-2013 02:01 PM
Allen, take a look at the database schema for your version of UCCE. Every field is outlined in there.
-Jameson
11-01-2013 02:08 PM
I've been going over it multiple times. It tells what it is (Outbound call count) but not what parameters are used to create it
11-01-2013 02:20 PM
It's just incremented directly in the table when any after call wrapup completes on an outbound call.
One possible reason your TCD counts may not match... I think RouterCallKey only gets set for calls that are routed by an ICM script. So any calls direct to the agent's ACD line that don't go through ICM DNP and an ICM script probably won't get one.
-Jameson
11-01-2013 02:23 PM
Just did a quick review of the schema... I think you'll want to look at the PeripheralCallType field in the TCD. PeripheralCallType=9 should match the AgentOutCalls stat.
-Jameson
11-01-2013 05:02 PM
You were absolutely right! I knew it was PeripheralCallType but I scrolled through that list 50 times I did not see 9 outbound. I rulled out 4 (transfer) but somehow passed 9 right up. So now I narrowed it down to 9 and linked the sourceskll to the agent table and tada I have what I'm looking for.
Thank you very very much
11-03-2013 07:55 AM
From TCD you can get the outbound calls using the PeripheralCallType = 9 or router call key = 0. This will not match with the AgentOutCalls in the Agent_Skill_Group_Half_Hour.
All the outbound calls are associated to the default call skill group, hence you need to look for the agentoutcalls for any agent against the default skill group.
All the best.
11-04-2013 11:39 AM
Mohamed, I would not use RouterCallKey=0. RouterCallKey=0 will potentially give the following PeripheralCallType values:
PeripheralCallType=9 should match on the AgentOutCalls against the default skill group. In newer versions of UCCE (8.0 and up I believe), the default skill can be set on an Agent by Agent basis to override the system-wide setting.
-Jameson
02-16-2018 02:19 AM
Hi Salim,
Hope you are doing good,
I am recently working in UCCE environment and I want to learn how to check PeripheralCallType = 9 or IB/OB calls details on ICM.
Please provide the step by step information that I will be grateful.
Thank you,
Arjun Kamble
02-16-2018 05:31 AM
Arjun, please stop posting the same message, you posted it three times in the other thread as well.
The SQL query that is mentioned earlier in the post and the Schema guide should be able to get you started for what you are looking for. In addition, consider looking through the CUIC reports in some of the stock reports, they may have what you want.
02-22-2018 03:33 AM
Thanks Bill
02-15-2018 06:21 AM
Hi Sir,
Where to check IB or OB calls and router keys with 0 results. PLease provide me steps or path for UCCE, environment.
Thank you,
Arjun Kamble
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