Cisco Cisco E-Mail Manager Unity Integration Option Technical References
![Cisco](https://files.manualsbrain.com/attachments/7380d0050044647c30f5c24bbbf5d0c0b6d9bb84/common/fit/150/50/faa183d287233c52228cfea3dbc2a127fe780f60564fcb0955d9c3d1cd23/brand_logo.png)
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:
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.
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.
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:
were abandoned in queue during the half-hour
interval. This value is calculated as follows:
DelayQAbandTimeToHalf /
CallsAbandQToHalf.
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.
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:
to the route in the half-hour interval. This value
is calculated as follows:
AnswerWaitTimeToHalf /
CallsAnsweredToHalf.
CallsAnsweredToHalf.
int
NULL
AnswerWaitTimeToHalf
Sum of answer wait time in seconds for all
incoming calls to the route during the half-hour
interval.
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:
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.
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
Option