cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
181
Views
0
Helpful
0
Replies
Highlighted
Beginner

UCCE 11.6 TCD and Call_Type_Interval discrepancies

Hello,

 

the customer is running on UCCE 11.6.2 and noticed a strange discrepancies in historical database.

The number of calls reported in Call_Type_Interval is different from the number of calls of given Call Type reported in Termination_Call_Detail.

 

These two queries provides same output (difference only in list of SUMmed columns):

 
select SUM(ServiceLevelCallsOffered) from Call_Type_Interval
where DateTime >= '2020-05-12 00:00:00' and DateTime <= '2020-05-12 23:59:59' and CallTypeID = 5446
--> 878 calls

select SUM(CallsHandled + ErrorCount + ICRDefaultRouted + NetworkDefaultRouted + ReturnBusy + ReturnRing + NetworkAnnouncement + OverflowOut + IncompleteCalls + ShortCalls + CallsRoutedNonAgent + CallsRONA + ReturnRelease + AgentErrorCount + TotalCallsAband + DelayAgentAbandTime) from Call_Type_Interval
where DateTime >= '2020-05-12 00:00:00' and DateTime <= '2020-05-12 23:59:59' and CallTypeID = 5446
--> 878 calls
 

But this query counting calls from TCD provides different value:

 

select COUNT(DISTINCT RouterCallKey) from Termination_Call_Detail where DateTime >= '2020-05-12 00:00:00' and DateTime <= '2020-05-12 23:59:59' and CallTypeID = 5446
--> 882

 

So to me it seems that TCD contains more calls of given Call type than Call_Type_Interval.

Some days the calls are aligned and OK, but some days this difference is visible and I have no idea what might causing it.


Does anybode have any experience with this?

 

Thanks