Technical References

Keys
and
Null
Option:
Data Type:Description:Field Name:
For multi-media, the number of tasks routed to the service during the
half-hour interval.
Valid for IPCC Enterprise.
NULLDBINT
Number of calls handled by the service but not otherwise accounted
for during the half-hour interval. These are calls that do not fit into
CallsTerminatedOtherToHalf
the criteria for handled, abandoned, or transferred calls. They were
terminated for other reasons, which may include drop/no answer,
forced busy, or timed out.
Not valid for IPCC Enterprise.
Not valid for non-voice tasks. Set to zero by OPC.
PK NOT
NULL
DBSMALLDATE
Central Controller date and time at the start of the half-hour interval.
DateTime
NULLDBDATETIME
The current date and time stamp when the records are written to the
HDS database. The logger database has NULL for this column.
DbDateTime
NULLDBINT
Number of seconds that calls for the service that were abandoned in
queue waited during the interval. These are calls that existed in the
DelayQAbandTimeToHalf
queue but were abandoned before being handled by an agent or trunk
device.
Not valid for IPCC Enterprise.
Not valid for non-voice tasks. Set to zero by OPC.
Note: Note: When ICM is connected with IPCC through an IPCC
Gateway PG, this value is incremented by any condition on the child
that causes the call to terminate while in the queue.
NULLDBINT
Sum of delay time of all calls to the service in queue during the
half-hour interval. This field is populated from the LocalQTime.
DelayQTimeToHalf
Not valid for IPCC Enterprise.
Not valid for non-voice tasks. Set to zero by OPC.
NULLDBINT
Number of calls to the service that were determined to be closed
following an interruption in data during the half-hour interval.
ForcedClosedCallsToHalf
ForcedClosedCalls are calls that terminated because of errors tracking
the call’s state transition. Calls may become forced closed if there is
lack of events from the ACD’s CTI interfaces (for example, a lack of
a Disconnect event, or failure on the switch’s CTI connection).
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
339
Chapter 2: All Tables
Service_Half_Hour Table