Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-179
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Galaxy_Trunk_IGroup Table
Related tables:
(via PeripheralID)
Group (via TrunkGroupID)
InODCallsRejected
Number of overflow/diversion-in calls offered on
tie-lines in this group, but rejected.
tie-lines in this group, but rejected.
DBSMALLINT
NOT NULL
ISDNCallByCallRejects
Number of ISDN calls rejected by this I-group
because of call-by-call service limitations.
because of call-by-call service limitations.
DBSMALLINT
NOT NULL
ISDNCallsWithAniSid
Number of ISDN calls on this I-group for which
ANI was received.
ANI was received.
DBSMALLINT
NOT NULL
LoadODOutHoldTime
Total time, in seconds, that tie-lines and load
transfer trunks in this I-group were used for
overflow/diversion and load transfer of out calls.
transfer trunks in this I-group were used for
overflow/diversion and load transfer of out calls.
DBINT
NOT NULL
LoadTransferOut
This field applies to Galaxy-8 ACDs only.
DBSMALLINT
NOT NULL
OutCalls
Number of calls made on outbound trunks.
DBSMALLINT
NOT NULL
OutCallTalkTime
Total time, in seconds, that trunks in this I-group
were used for outbound calls.
were used for outbound calls.
DBINT
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.
DBSMALLINT
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.
DBSMALLINT
NOT NULL
PeripheralID
The ICM software identifier for the ACD.
DBSMALLINT
PK, FK
NOT NULL
PeripheralTimeZone
The time zone for the ACD. The value is the offset
in minutes from GMT.
in minutes from GMT.
DBINT
NOT NULL
RecoveryKey
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT NULL
SecondsInPeriod
Number of seconds in the reporting period.
DBSMALLINT
NOT NULL
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.
DBINT
PK
NOT NULL
TrunkAssignedTime
Total time, in seconds, that trunks were assigned
to this I-group.
to this I-group.
DBINT
NOT NULL
TrunkGroupID
The ICM software identifier for the trunk group
associated with this I-group.
associated with this I-group.
DBINT
FK
NULL
TrunkIdleTime
Total time, in seconds, that trunks in the I-group
were not busy with in or out calls.
were not busy with in or out calls.
DBINT
NOT NULL
Table 2-174 Galaxy_Trunk_IGroup Table (continued)
Field Name
Description
Data Type
Keys and
Null Option
Null Option