Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 548
   
2-178
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2      Table Details
Galaxy_Trunk_IGroup Table
Galaxy_Trunk_IGroup Table
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a trunk 
information group configured on a Galaxy ACD.
Table 2-173 Galaxy_Trunk_IGroup Table Constraints
Constraint
Field Name(s)
PK
DateTime
IGroupID
PeripheralID
TimeZone
AK-1
RecoveryKey
FK
PeripheralID
TrunkGroupID
Table 2-174 Galaxy_Trunk_IGroup Table
Field Name
Description
Data Type
Keys and 
Null Option
AllTrunksBusyTime
Total time, in seconds, that all trunks in the 
I-group were busy.
DBINT
NOT NULL
CallsAbandoned
Number of external calls on this trunk group that 
were lost before being answered.
DBSMALLINT
NOT NULL
CallsHandled
Number of external calls on this trunk group that 
were answered.
DBSMALLINT
NOT NULL
CallsHeld
Number of external calls that exceed a specified 
system threshold before being answered or 
abandoned.
DBSMALLINT
NOT NULL
DateTime
The Central Controller date and time at the 
beginning of the reporting interval.
DBDATETIME
PK
NOT NULL
GateAssignment
The Galaxy identifier of the gate to which the 
I-group is assigned.
DBTINYINT
NOT NULL
GateValid
Indicates whether all trunks in the I-group 
remained assigned to the gate for the entire 
reporting interval.
DBTINYINT
NOT NULL
IGroupID
The Galaxy identifier for the trunk I-group.
DBSMALLINT
PK
NOT NULL
InODCallsAbandoned
Number of overflow/diversion-in calls accepted 
on tie-lines in this group, but lost before being 
answered.
DBSMALLINT
NOT NULL
InODCallsHandled
Number of overflow/diversion-in calls accepted 
on tie-lines in this group and eventually answered.
DBSMALLINT
NOT NULL