Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
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
PK, FK 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
half-hour interval.
half-hour interval.
TrunksIdle
NULL
DBINT
Number of trunks in the group in service at the end of the
half-hour interval.
half-hour interval.
TrunksInService
Trunk_Group_Real_Time Table
category. For database rules, click
Local database only.
Contains real time information about each trunk group.
The ICM software generates a Trunk_Group_Real_Time record for each trunk group.
Related table
(via TrunkGroupID)
Table 208: Indexes for Trunk_Group_Real_Time Table
index_keys
index_description
index_name
TrunkGroupID
nonclustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKTrunk_Group_Real_Time
Fields in Trunk_Group_Real_Time Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Total number of seconds during the current half-hour interval that
all trunks in the group were busy.
all trunks in the group were busy.
AllTrunksBusyHalf
NULL
DBINT
Total number of seconds since midnight that all trunks in the group
were busy.
were busy.
AllTrunksBusyToday
NULL
DBINT
Number of calls to the trunk group abandoned in queue during the
current half-hour interval.
current half-hour interval.
CallsAbandonedHalf
NULL
DBINT
Number of calls to the trunk group abandoned in queue since
midnight.
midnight.
CallsAbandonedToday
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
424
Chapter 2: All Tables
Trunk_Group_Real_Time Table