Cisco Cisco IPCC Web Option Technical References
2-166
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Route_Half_Hour Table
Route_Half_Hour Table
Central database only.
Each row contains statistics for each route during the most recent 30-minute interval.
The ICM software generates Route_Half_Hour records for each route.
Table 2-142 Route_Half_Hour Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
The date and time at the start of the half-hour
interval.
interval.
smalldatetime
PK, 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, NULL
CallsOfferedToHalf
Total of incoming calls plus internal calls
offered on this route during the half-hour
interval.
offered on this route during the half-hour
interval.
int
NULL
CallsIncomingToHalf
Total of incoming calls on this route during the
half-hour interval. Incoming calls include only
Inbound ACD calls arriving on trunks (that is,
calls that are not internally generated).
half-hour interval. Incoming calls include only
Inbound ACD calls arriving on trunks (that is,
calls that are not internally generated).
int
NULL
CallsHandledToHalf
Total number of calls handled on this route
during the half-hour interval. CallsHandled
includes all calls handled by any answering
resource for the route (for example, an IVR,
agent, or voice mail port).
during the half-hour interval. CallsHandled
includes all calls handled by any answering
resource for the route (for example, an IVR,
agent, or voice mail port).
int
NULL
CallsRoutedToHalf
Total calls the ICM software sent to this route
during the half-hour interval.
during the half-hour interval.
int
NULL
CallsAbandQToHalf
Number of calls abandoned in queue on this
route during the half-hour interval.
route during the half-hour interval.
int
NULL
ServiceLevelToHalf
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.
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.
real
NULL
ServiceLevelCallsToHalf
Cumulative total of calls to the route answered
within the ICM service level during the
half-hour interval.
within the ICM service level during the
half-hour interval.
int
NULL
ServiceLevelAbandToHalf
Cumulative total of calls to the route
abandoned within the ICM service level during
the half-hour interval.
abandoned within the ICM service level during
the half-hour interval.
int
NULL
ServiceLevelCallsOfferedToHalf
Number of calls to the route answered or
abandoned during the half-hour interval.
abandoned during the half-hour interval.
int
NULL