Cisco Cisco Unified Contact Center Enterprise 9.0(2) テクニカルリファレンス
2-271
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Route_Half_Hour Table
CallsHandledToHalf
Total number of calls handled on this route during
the half-hour interval. CallsHandled includes all
calls handled by any answering resource for the
route (for example, an IVR, agent, or voice mail
port).
the half-hour interval. CallsHandled includes all
calls handled by any answering resource for the
route (for example, an IVR, agent, or voice mail
port).
A handled call is:
•
An incoming ACD call that was answered by
an agent, and then completed.
an agent, and then completed.
•
A call associated with Outbound Option that
the agent answered, and then completed.
the agent answered, and then completed.
•
A non-voice task that the agent started
working on then completed.
working on then completed.
A handled call/task is completed when the agent
associated with the call/task finishes the wrap-up
work associated with the call/task.
associated with the call/task finishes the wrap-up
work associated with the call/task.
DBINT
NULL
CallsIncomingToHalf
Total of incoming calls on this route during the
half-hour interval. Incoming calls include only
Inbound ACD calls arriving on trunks (that is,
calls that are not internally generated).
half-hour interval. Incoming calls include only
Inbound ACD calls arriving on trunks (that is,
calls that are not internally generated).
DBINT
NULL
CallsOfferedToHalf
Total of incoming calls plus internal calls offered
on this route during the half-hour interval.
on this route during the half-hour interval.
DBINT
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.
DBINT
NULL
CallsRoutedToHalf
Total calls the ICM software sent to this route
during the half-hour interval.
during the half-hour interval.
DBINT
NULL
DateTime
The date and time at the start of the half-hour
interval.
interval.
DBSMALLDATE
PK
NOT NULL
DbDateTime
The current date and time stamp when the records
are written to the HDS database. The logger
database has NULL for this column.
are written to the HDS database. The logger
database has NULL for this column.
DBDATETIME
IE-1
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
that were abandoned in queue waited during the
interval. These are calls that existed in the queue
but were abandoned before being
by an
agent or trunk device.
DBINT
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.
DBINT
NULL
Table 2-290 Route_Half_Hour Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option