Technical References

Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a trunk
information group congured on a Galaxy ACD.
Related table
Peripheral (page 250) (via PeripheralID)
Trunk (page 419) (via TrunkID)
Table 104: Indexes for Galaxy_Trunk_IGroup Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Galaxy_Galaxy_Trunk_IGroup
DateTime, PeripheralID, IGroupID,
TimeZone
nonclustered, unique, primary key
located on PRIMARY
XPKGalaxy_Galaxy_Trunk_IGroup
Fields in Galaxy_Trunk_IGroup Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLDBINT
Total time, in seconds, that all trunks in the I-group were busy.
AllTrunksBusyTime
NOT NULLDBSMALLINT
Number of external calls on this trunk group that were lost before
being answered.
CallsAbandoned
NOT NULLDBSMALLINT
Number of external calls on this trunk group that were answered.
CallsHandled
NOT NULLDBSMALLINT
Number of external calls that exceed a specied system threshold
before being answered or abandoned.
CallsHeld
PK NOT NULLDBDATETIME
The Central Controller date and time at the beginning of the
reporting interval.
DateTime
NOT NULLDBTINYINT
The Galaxy identier of the gate to which the I-group is assigned.
GateAssignment
NOT NULLDBTINYINT
Indicates whether all trunks in the I-group remained assigned to
the gate for the entire reporting interval.
GateValid
PK NOT NULLDBSMALLINT
The Galaxy identier for the trunk I-group.
IGroupID
NOT NULLDBSMALLINT
Number of overow/diversion-in calls accepted on tie-lines in this
group, but lost before being answered.
InODCallsAbandoned
NOT NULLDBSMALLINT
Number of overow/diversion-in calls hadnled on tie-lines in this
group.
InODCallsHandled
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
206
Chapter 2: All Tables
Galaxy_Trunk_IGroup Table