Technical References

Keys
and
Null
Option:
Data Type:Description:Field Name:
This time begins when the call reaches the Router or when the call
changes CallTypes and ends when the call disconnects.
This time is reset if the CallType changes.
Does not include short calls.
Note: Note: In an IPCC Enterprise Gateway deployment, ICM (parent)
connected with an IPCC Enterprise with an IPCC System PG (child)
or IPCC Express (child) through IPCC Gateway PG, network queuing
data is not available in the child or in the child agent/supervisor
desktop. The time spent in the network queue is not included in the
reporting metrics in the child. A call center manager who would
normally only look at the IPCC child reports will need to also look
at the parent ICM reports for network queuing data.
NULLDBINT
During the half-hour interval, the total time that all the calls spent at
the VRU in the current call type.
CTVRUTimeToHalf
Note: In a NAM/CICM deployment (VRU at NAM), this value is
updated for calls that the CICM sends to the VRU. Calls that the NAM
itself sends to the VRU update the call type metrics in the NAM.
Note: In a NAM/CICM deployment (VRU1 at NAM and VRU2 at
CICM), this value is updated for calls that the CICM sends to VRU1.
Calls that the NAM Router itself sends to VRU1 update the call type
metrics in the NAM. Service data for VRU2 is stored in the CICM
data base.
Note: Note: In an IPCC Enterprise Gateway deployment, ICM (parent)
connected with an IPCC Enterprise with an IPCC System PG (child)
or IPCC Express (child) through IPCC Gateway PG, network queuing
data is not available in the child or in the child agent/supervisor
desktop. The time spent in the network queue is not included in the
reporting metrics in the child. A call center manager who would
normally only look at the IPCC child reports will need to also look
at the parent ICM reports for network queuing data.
PK NOT
NULL
DBSMALLDATE
The Central Controller date and time at the start of the interval when
the row was generated..
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
For the half-hour interval, the total time spent by all calls for this call
type that abandoned at the agent's desktop before being answered.
DelayAgentAbandTimeToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
89
Chapter 2: All Tables
Call_Type_Half_Hour Table