Cisco Cisco IPCC Web Option Technical References
Keys and
Null Option:
Null Option:
Data Type:
Description:
Field Name:
NULL
DBFLT4
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.
ICM software uses the same type of calculation as specified for
the service associated with the route.
ServiceLevelToday
PK 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
NULL
DBFLT4
This field is not used.
Unused1
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.
30-minute interval. The ICM software generates Route_Half_Hour records for each route.
Related Table
Table 162: Indexes for Route_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Route_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Route_Half_Hour
DateTime, RouteID, TimeZone
clustered, unique, primary key located
on PRIMARY
on PRIMARY
XPKRoute_Half_Hour
Fields in Route_Half_Hour Table:
Keys and
Null
Option:
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Sum of answer wait time in seconds for all incoming calls to the
route during the half-hour interval.
route during the half-hour interval.
AnswerWaitTimeToHalf
NULL
DBINT
Average delay time of calls to the route that were abandoned in
queue during the half-hour interval. This value is calculated as
follows: DelayQAbandTimeToHalf / CallsAbandQToHalf
queue during the half-hour interval. This value is calculated as
follows: DelayQAbandTimeToHalf / CallsAbandQToHalf
AvgDelayQAbandToHalf
NULL
DBINT
Average delay in seconds for calls queued for the route during the
half-hour interval. The value is calculated as follows:
DelayQTimeToHalf / CallsQToHalf
half-hour interval. The value is calculated as follows:
DelayQTimeToHalf / CallsQToHalf
AvgDelayQToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
288
Chapter 2: All Tables
Route_Half_Hour Table