Our environment include a CCM 4.1 cluster, a CRS IP-IVR server and an IPCC Enterprise 6.0 system. Counting the calls handled by Contact Center for a specific CallType (5006) I've found a data mismatch...
From call_type_half_hour table definition in DBSchema document:
"CallsHandledHalf in is the total number of calls of this call type handled
in the current half-hour.
Termination_Call_Detail records with a
CallDisposition of 6, 13, 14, 28, 29, 30, or 34 are
counted as CallHandled.
Note Valid for both IPCC and standard ACD
targets that use translation routes."
On t_termination_call_detail there are 33 calls, in t_call_type_half_hour there are 14...
In attached file can find the queries on DB and the results.