Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 620
Keys and Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Aggregate number of seconds trunks in the group were in use for
outbound calls during the half-hour interval.
InUseOutboundTimeToHalf
PK NOT NULL
DBINT
Identifies the network trunk group.
NetworkTrunkGroupID
NOT NULL
DBINT
Currently not used, set to zero (0).
RecoveryDay
NOT NULL
DBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
PK NOT NULL
DBINT
The time zone for the date and time. The value is the offset in
minutes from UTC (formerly called GMT).
TimeZone
NULL
DBINT
Number of idle trunks in the network trunk group at the end of
the half-hour interval.
TrunksIdle
NULL
DBINT
Number of in-service trunks in the network trunk group at the end
of the half-hour interval.
TrunksInService
Network_Trunk_Group_Real_Time Table
 category. For database rules, click 
Local database only.
Provides real-time statistics for each network trunk group in the system.
The ICM software generates a Network_Trunk_Group_Real_Time record for each network
trunk group.
Related table
 (via NetworkTrunkGroupID)
Table 129: Indexes for Network_Trunk_Group_Real_Time Table
index_keys
index_description
index_name
NetworkTrunkGroupID
clustered, unique, primary key
located on PRIMARY
XPKNetwork_Trunk_Group_Real_Ti
Fields in Network_Trunk_Group_Real_Time Table:
Keys and Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
Total number of seconds that all trunks in the network trunk group
have been simultaneously busy during the current half-hour interval.
AllTrunksBusyHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
242
Chapter 2:  All Tables
Network_Trunk_Group_Real_Time Table