I am working on a UCCE environment version 9.0.
We need to create a report in CUIC that shows the calls offered to specific call types.
We have tried two options, the first one based on Route_Call_Detail table and the other based on the Call_Type_Interval.
When we ran the two queries in the same interval of time, they gave different results.
Attached are the two queries.
I would appreciate if someone can just advise which table should we rely on, Route_Call_Detail or Call_Type_Interval.
Thank you in advance.
If the call type is being changed during the script execution (for example, with a Call Type node) then those call types will not be accounted for in Route Call Detail, as no separate route request was made for the newly changed calltype.
If no call type changes are being made via scripting, then these results *should* be the same, provided that a full day's worth of data is included in the query, as a single interval may have calls crossing over a boundary condition where they are counted in 1 interval in the Interval record and another in Route Call Detail.