Cisco Cisco IP Contact Center Release 4.6.1 Références techniques
2-107
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Galaxy_Trunk_IGroup Table
IGroupID
The Galaxy identifier for the trunk I-group.
smallint
PK, NOT NULL
TimeZone
The time zone for the Central Controller. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
int
PK, NOT NULL
TrunkGroupID
The ICM software identifier for the trunk group
associated with this I-group.
associated with this I-group.
int
FK, NULL
PeripheralTimeZone
The time zone for the ACD. The value is the offset in
minutes from GMT.
minutes from GMT.
int
NOT NULL
SecondsInPeriod
Number of seconds in the reporting period.
smallint
NOT NULL
GateAssignment
The Galaxy identifier of the gate to which the I-group
is assigned.
is assigned.
tinyint
NOT NULL
GateValid
Indicates whether all trunks in the I-group remained
assigned to the gate for the entire reporting interval.
assigned to the gate for the entire reporting interval.
tinyint
NOT NULL
CallsHandled
Number of external calls on this trunk group that were
answered.
answered.
smallint
NOT NULL
CallsAbandoned
Number of external calls on this trunk group that were
lost before being answered.
lost before being answered.
smallint
NOT NULL
CallsHeld
Number of external calls that exceed a specified
system threshold before being answered or abandoned.
system threshold before being answered or abandoned.
smallint
NOT NULL
OutCalls
Number of calls made on outbound trunks.
smallint
NOT NULL
LoadTransferOut
This field applies to Galaxy-8 ACDs only.
smallint
NOT NULL
OutODCallsAccepted
Number of overflow/diversion-out calls made on
tie-lines in this group and accepted by the receiving
node.
tie-lines in this group and accepted by the receiving
node.
smallint
NOT NULL
OutODCallsRejected
Number of overflow/diversion-out calls made on
tie-lines in this group and rejected by the receiving
node.
tie-lines in this group and rejected by the receiving
node.
smallint
NOT NULL
InODCallsHandled
Number of overflow/diversion-in calls accepted on
tie-lines in this group and eventually answered.
tie-lines in this group and eventually answered.
smallint
NOT NULL
InODCallsAbandoned
Number of overflow/diversion-in calls accepted on
tie-lines in this group, but lost before being answered.
tie-lines in this group, but lost before being answered.
smallint
NOT NULL
InODCallsRejected
Number of overflow/diversion-in calls offered on
tie-lines in this group, but rejected.
tie-lines in this group, but rejected.
smallint
NOT NULL
ISDNCallByCallRejects
Number of ISDN calls rejected by this I-group because
of call-by-call service limitations.
of call-by-call service limitations.
smallint
NOT NULL
ISDNCallsWIthAniSid
Number of ISDN calls on this I-group for which ANI
was received.
was received.
smallint
NOT NULL
TrunkAssignedTime
Total time, in seconds, that trunks were assigned to this
I-group.
I-group.
int
NOT NULL
AllTrunksBusyTime
Total time, in seconds, that all trunks in the I-group
were busy.
were busy.
int
NOT NULL
Table 2-86 Galaxy_Trunk_IGroup Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option