Cisco Cisco IP Contact Center Release 4.6.1 Technical References
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.
information group configured on a Galaxy ACD.
TimeZone
The time zone for the Central Controller. The
value is the offset in minutes from GMT.
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.
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
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.
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.
track virtual time.
float
AK1, NOT
NULL
NULL
Table 2-85 Galaxy_Trunk_Call_Count Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-86 Galaxy_Trunk_IGroup Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
The Central Controller date and time at the beginning
of the reporting interval.
of the reporting interval.
datetime
PK, NOT NULL
PeripheralID
The ICM software identifier for the ACD.
smallint
PK, FK, NOT
NULL
NULL