Cisco Cisco Unified Contact Center Enterprise 9.0(2) Referencia técnica
2-269
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Route_Half_Hour Table
Related tables:
(via RouteID)
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.
TimeZone
The time zone for the date and time. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
DBINT
PK
NOT NULL
Unused1
This field is not used.
DBFLT4
NULL
Table 2-288 Route_Five_Minute Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option
Table 2-289 Route_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
DateTime
RouteID
TimeZone
RouteID
TimeZone
AK-1
RecoveryKey
FK
RouteID
IE-1
DbDateTime
Table 2-290 Route_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AnswerWaitTimeToHalf
Sum of answer wait time in seconds for all
incoming calls to the route during the half-hour
interval.
incoming calls to the route during the half-hour
interval.
DBINT
NULL
AvgDelayQAbandToHalf
Average delay time of calls to the route that were
abandoned in queue during the half-hour interval.
This value is calculated as follows:
abandoned in queue during the half-hour interval.
This value is calculated as follows:
DelayQAbandTimeToHalf /
CallsAbandQToHalf
CallsAbandQToHalf
DBINT
NULL
AvgDelayQToHalf
Average delay in seconds for calls queued for the
route during the half-hour interval. The value is
calculated as follows:
route during the half-hour interval. The value is
calculated as follows:
DelayQTimeToHalf / CallsQToHalf
DBINT
NULL