Cisco Cisco IP Contact Center Release 4.6.2 Technical References
Keys and
Null
Option:
Null
Option:
Data Type:
Description:
Field Name:
PK, FK NOT
NULL
NULL
DBINT
Foreign key from the Route table.
RouteID
NULL
DBINT
Cumulative total of calls to the route abandoned within the ICM
service level during the half-hour interval.
service level during the half-hour interval.
ServiceLevelAbandToHalf
NULL
DBINT
Number of calls to the route that have had a service level event
during the current half-hour interval.
during the current half-hour interval.
ServiceLevelCallsOfferedToHalf
NULL
DBINT
Cumulative total of calls to the route answered within the ICM
service level during the half-hour interval.
service level during the half-hour interval.
ServiceLevelCallsToHalf
NULL
DBFLT4
Cumulative ICM service level for the route during the half-hour
interval. The ICM software uses the same type of service level
calculation as specified for the service associated with the route.
interval. The ICM software uses the same type of service level
calculation as specified for the service associated with the route.
ServiceLevelToHalf
NULL
DBINT
Service Level Type used to calculate Service level for this interval
ServiceLevelType
NULL
DBINT
The time, in seconds, accumulated by calls that were too short to be
counted as abandoned during the half-hour interval. These calls were
abandoned before the abandoned call wait time expired.
counted as abandoned during the half-hour interval. These calls were
abandoned before the abandoned call wait time expired.
ShortCallsTimeToHalf
NULL
DBINT
The total number of calls to the route that were too short to be
considered abandoned during the half-hour interval. A call is
considered abandoned during the half-hour interval. A call is
ShortCallsToHalf
determined to be a short call if it is abandoned before the Abandoned
Call Wait Time expired. Short calls are not considered abandoned,
nor are they accounted for in any of the ICM abandoned calls
calculations.
Call Wait Time expired. Short calls are not considered abandoned,
nor are they accounted for in any of the ICM abandoned calls
calculations.
NULL
DBINT
The number of seconds the call was talking plus the number of
seconds the call was on hold. TalkTime for routes and services is
seconds the call was on hold. TalkTime for routes and services is
TalkTimeToHalf
taken from the TalkTime and HoldTime. It is counted when any
after-call work associated with the call is completed, and the database
is updated every half hour.
after-call work associated with the call is completed, and the database
is updated every half hour.
NOT NULL
DBINT
The time zone for the date and time. The value is the offset in
minutes from UTC (formerly called GMT).
minutes from UTC (formerly called GMT).
TimeZone
Route_Real_Time Table
Local database only.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
292
Chapter 2: All Tables
Route_Real_Time Table