Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-163
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Route_Five_Minute Table
Route_Five_Minute Table
Central database only.
Each row contains statistics about a route during the most recent five-minute interval.
The ICM software generates Route_Five_Minute records for each route.
Table 2-141 Route_Five_Minute Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
The Central Controller date and time at the start
of the five-minute interval.
of the five-minute interval.
smalldatetime
PK, NOT NULL
RouteID
Foreign key from the Route table.
int
PK, FK, NOT
NULL
NULL
TimeZone
The time zone for the date and time. The value
is the offset in minutes from GMT.
is the offset in minutes from GMT.
int
PK, NOT NULL
CallsInProgress
The total number of inbound and outbound calls
that had previously been offered (for example,
calls being played an announcement, queued
calls, or connected calls) and are currently being
handled for the route at the end of the
five-minute interval.
that had previously been offered (for example,
calls being played an announcement, queued
calls, or connected calls) and are currently being
handled for the route at the end of the
five-minute interval.
int
NULL
CallsOfferedToday
Running total of incoming calls plus internal
calls offered to the route since midnight.
calls offered to the route since midnight.
int
NULL
CallsIncomingToday
Running total of incoming calls to this route
since midnight. Incoming calls include only
Inbound ACD calls arriving on trunks (that is,
calls that are not internally generated).
since midnight. Incoming calls include only
Inbound ACD calls arriving on trunks (that is,
calls that are not internally generated).
int
NULL
CallsHandledToday
Running total of calls to the route handled at the
peripheral since midnight. CallsHandled
includes all call handled by any answering
resource for the route (for example, an IVR,
agent, or voice mail port).
peripheral since midnight. CallsHandled
includes all call handled by any answering
resource for the route (for example, an IVR,
agent, or voice mail port).
int
NULL
CallsRoutedToday
Running total of calls the ICM software sent to
the route since midnight.
the route since midnight.
int
NULL
CallsAbandQToday
Running total of calls to the route abandoned in
queue since midnight.
queue since midnight.
int
NULL
ServiceLevelToday
Cumulative ICM service level for this route
since midnight. The ICM software uses the same
type of calculation as specified for the service
associated with the route.
since midnight. The ICM software uses the same
type of calculation as specified for the service
associated with the route.
real
NULL
ServiceLevelTo5
The ICM service level for the route for the
five-minute interval.
five-minute interval.
real
NULL
ServiceLevelCallsToday
Cumulative total of calls to the route answered
within the ICM service level since midnight.
within the ICM service level since midnight.
int
NULL