Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

Page of 404
 
2-106
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Galaxy_Trunk_IGroup Table
Related tables:
Peripheral (via PeripheralID)
Trunk (via TrunkID)
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.
TimeZone
The time zone for the Central Controller. The 
value is the offset in minutes from GMT.
int
PK, NOT NULL
PeripheralTimeZone
The time zone in which the ACD is located. The 
value is the offset in minutes from GMT.
int
NOT NULL
TerminationType
Valid options include:
8 = Direct Inward Dial (DID)
14 = Inter-tandem
26 = Off-Network Access Line
41 = Tie Line
47 = Operator Service
50 = Operator Service Feature Group D
51 = Australian Off-Network Access Line
52 = Australian Tie Line
53 = Australian Direct Gate Dial
54 = DNIS
64 = Directory Assistance Intercept
65 = ISDN
smallint
NOT NULL
TrunkIGroup
Galaxy identifier for the Trunk Information 
Group that contains this trunk.
smallint
NOT NULL
CallCount
Number of calls counted on the trunk.
smallint
NOT NULL
RecoveryKey
A value used internally by the ICM software to 
track virtual time.
float
AK1, NOT 
NULL
Table 2-85 Galaxy_Trunk_Call_Count Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-86 Galaxy_Trunk_IGroup Table
Field Name
Description
Data Type
Keys and Null 
Option
DateTime
The Central Controller date and time at the beginning 
of the reporting interval.
datetime
PK, NOT NULL
PeripheralID
The ICM software identifier for the ACD.
smallint
PK, FK, NOT 
NULL