Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
Keys and
NULL
Option
NULL
Option
Data Type
Description
Name
NULL
DBFLT4
Service level for the route for the five-minute
interval.
interval.
ServiceLevelTo5
NULL
DBFLT4
Cumulative service level for this route since
midnight. The system software uses the same type
of calculation as specified for the service associated
with the route.
midnight. The system software uses the same type
of calculation as specified for the service associated
with the route.
ServiceLevelToday
PK NOT
NULL
NULL
DBINT
The time zone for the date and time. The value is
the offset in minutes from UTC (formerly called
GMT).
the offset in minutes from UTC (formerly called
GMT).
TimeZone
NULL
DBFLT4
This field is not used.
Unused1
Route_Half_Hour
This table is in the
category. To see database rules for these tables, see
Central database only. Each row contains statistics for each route during the most recent 30-minute interval.
The system software generates Route_Half_Hour records for each route.
The system software generates Route_Half_Hour records for each route.
Related Table
(via RouteID)
Table 297: Indexes for Route_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key located
on PRIMARY
on PRIMARY
XAK1Route_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Route_Half_Hour
DateTime, RouteID, TimeZone
clustered, unique, primary key located on
PRIMARY
PRIMARY
XPKRoute_Half_Hour
Table 298: Fields in Route_Half_Hour table
Keys and
NULL
Option
NULL
Option
Data Type
Description
Name
NULL
DBINT
Sum of answer wait time in seconds for all incoming
calls to the route during the half-hour interval.
calls to the route during the half-hour interval.
AnswerWaitTimeToHalf
Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0
400
All tables
Route_Half_Hour