I'm trying to pull:
Inbound calls for yesterday that connected to an agent
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.
Solved! Go to Solution.
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?
Allen, take a look at the database schema for your version of UCCE. Every field is outlined in there.
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
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.
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
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.
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.
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.
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.
Where to check IB or OB calls and router keys with 0 results. PLease provide me steps or path for UCCE, environment.