Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
Table 394: Indexes for Trunk_Group_Five_Minute Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Trunk_Group_Five_Minute
DateTime, TrunkGroupID, TimeZone
clustered, unique, primary key located
on PRIMARY
on PRIMARY
XPKTrunk_Group_Five_Minute
Table 395: Fields in Trunk_Group_Five_Minute table
Keys and
NULL
Option
NULL
Option
Data Type
Description
Name
NULL
DBINT
Total time, in seconds, during the current half-hour
interval that all trunks in the group were busy.
interval that all trunks in the group were busy.
AllTrunksBusyToHalf
PK NOT
NULL
NULL
DBSMALLDATE
Central Controller date and time at the start of the
five-minute interval.
five-minute interval.
DateTime
NOT
NULL
NULL
DBINT
Currently not used, set to zero (0).
RecoveryDay
AK-1 NOT
NULL
NULL
DBFLT8
A unique ID assigned to each record and used
internally by the Unified ICM/Unified CCE software
to track the record.
internally by the Unified ICM/Unified CCE software
to track the record.
RecoveryKey
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
PK, FK
NOT
NULL
NOT
NULL
DBINT
Foreign key from the Trunk Group table.
TrunkGroupID
NULL
DBINT
Number of non-busy trunks in the group at the end
of the five-minute interval.
of the five-minute interval.
TrunksIdle
NULL
DBINT
Number of trunks in this trunk group in service at
the end of the five-minute interval.
the end of the five-minute interval.
TrunksInService
Trunk_Group_Half_Hour
This is in the
category. For database rules, see
Central database only.
Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0
605
All tables
Trunk_Group_Half_Hour