Cisco Cisco IP Contact Center Release 4.6.1 기술 참조
(via TrunkGroupID)
Table 207: Indexes for Trunk_Group_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Trunk_Group_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Trunk_Group_Half_Hour
DateTime, TrunkGroupID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKTrunk_Group_Half_Hour
Fields in Trunk_Group_Half_Hour Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Total time, in seconds, during the half-hour interval that all trunks
in the group were busy.
in the group were busy.
AllTrunksBusyToHalf
NULL
DBINT
Number of calls to the trunk group abandoned during the current
half-hour interval.
half-hour interval.
CallsAbandonedToHalf
NULL
DBINT
Number of incoming calls received on the trunk group during
the half-hour interval.
the half-hour interval.
CallsInToHalf
NULL
DBINT
Number of outbound calls sent on the trunk group during the
half-hour interval.
half-hour interval.
CallsOutToHalf
PK NOT NULL
DBSMALLDATE
Central Controller date and time at the start of the half-hour
interval.
interval.
DateTime
IE-1 NULL
DBDATETIME
The current date and time stamp when the records are written to
the HDS database. The logger database has NULL for this
column.
the HDS database. The logger database has NULL for this
column.
DbDateTime
NULL
DBINT
Aggregate number of seconds trunks in the group were in service
during the half-hour interval.
during the half-hour interval.
InServiceTimeToHalf
NULL
DBINT
Aggregate number of seconds trunks in the group were used for
inbound calls during the half-hour interval.
inbound calls during the half-hour interval.
InUseInboundTimeToHalf
NULL
DBINT
Aggregate number of seconds trunks in the group were used for
outbound calls during the half-hour interval.
outbound calls during the half-hour interval.
InUseOutboundTimeToHalf
NOT NULL
DBINT
Currently not used, set to zero (0).
RecoveryDay
AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
ICM/IPCC Enterprise software to track the record.
RecoveryKey
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
423
Chapter 2: All Tables
Trunk_Group_Half_Hour Table