Cisco Cisco E-Mail Manager Unity Integration Option Technical References

Page of 404
 
2-167
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Route_Half_Hour Table
AvgDelayQToHalf
Average delay in seconds for calls queued for 
the route during the half-hour interval. The 
value is calculated as follows:
DelayQTimeToHalf / CallsQToHalf.
int
NULL
DelayQTimeToHalf
Sum of delay time of all calls in queue for the 
route during the half-hour interval. This field is 
populated with the LocalQTime from the 
Termination_Call_Detail record.
int
NULL
CallsQToHalf
Number of calls to the route in queue during the 
half-hour interval. A call that queues multiple 
times is counted as queued once for the route.
int
NULL
AvgDelayQAbandToHalf
Average delay time of calls to the route that 
were abandoned in queue during the half-hour 
interval. This value is calculated as follows:
DelayQAbandTimeToHalf / 
CallsAbandQToHalf.
int
NULL
DelayQAbandTimeToHalf
The total number of seconds that calls to the 
route that were abandoned in queue waited 
during the interval. These are calls that existed 
in the queue but were abandoned before being 
handled by an agent or trunk device.
int
NULL
AvgSpeedAnswerToHalf
Average answer wait time for all incoming calls 
to the route in the half-hour interval. This value 
is calculated as follows:
AnswerWaitTimeToHalf / 
CallsAnsweredToHalf.
int
NULL
AnswerWaitTimeToHalf
Sum of answer wait time in seconds for all 
incoming calls to the route during the half-hour 
interval.
int
NULL
AvgTalkTimeToHalf
The average talk time in seconds for calls to the 
route. Talk time includes the time that calls 
were in a talking or hold state. It is populated 
with the TalkTime and HoldTime associated 
with call to the route (from 
Termination_Call_Detail). This value is 
calculated as follows:
TalkTimeToHalf / CallsHandledToHalf
The field is updated in the database when all 
after-call work associated with the call is 
completed.
int
NULL
Table 2-142 Route_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option