Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-82
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Call_Type_Real_Time Table
Call_Type_Real_Time Table
Local database only.
Provides real-time statistics for each call type defined in the ICM software. The ICM software generates
a Call_Type_Real_Time record for each call type.
a Call_Type_Real_Time record for each call type.
Table 2-64 Call_Type_Real_Time Table Constraints
Constraint
Field Name(s)
PK
CallTypeID
FK
CallTypeID
Table 2-65 Call_Type_Real_Time Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AnswerWaitTimeHalf
The sum of answer wait time in seconds for all
calls of this call type that were answered during
the half-hour interval.
calls of this call type that were answered during
the half-hour interval.
This field is applicable to both ICM and IPCC
Enterprise with the following exception: the field
is not incremented if the call is answered by an
agent on a standard ACD unless the call was
translation routed.
Enterprise with the following exception: the field
is not incremented if the call is answered by an
agent on a standard ACD unless the call was
translation routed.
DBINT
NULL
AnswerWaitTimeTo5
The sum of answer wait time in seconds for all
calls answered for this call type during the
five-minute interval.
calls answered for this call type during the
five-minute interval.
DBINT
NULL
AnswerWaitTimeToday
The sum of answer wait time in seconds for all
calls of this call type answered since midnight
calls of this call type answered since midnight
DBINT
NULL
AvgRouterDelayQHalf
Average number of seconds spent in the
CallRouter queue for calls of this type that have
been removed from the queue so far during the
current half- hour interval.
CallRouter queue for calls of this type that have
been removed from the queue so far during the
current half- hour interval.
This field is applicable to both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
AvgRouterDelayQNow
Average number of seconds spent in the
CallRouter queue for calls of this type that are
currently in queue.
CallRouter queue for calls of this type that are
currently in queue.
DBINT
NULL
AvgRouterDelayQTo5
Average number of seconds spent in the
CallRouter queue for calls of this type that were
removed from the queue during the rolling five-
minute interval.
CallRouter queue for calls of this type that were
removed from the queue during the rolling five-
minute interval.
DBINT
NULL
AvgRouterDelayQToday
Average number of seconds spent in the
CallRouter queue for calls of this type that were
removed from the queue since midnight.
CallRouter queue for calls of this type that were
removed from the queue since midnight.
DBINT
NULL