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