Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-87
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Galaxy_Agent_Igroup Table
Galaxy_Agent_Igroup Table
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about an agent
information group configured on a Galaxy ACD.
information group configured on a Galaxy ACD.
Table 2-75 Galaxy_Agent_Igroup Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
The date and time at the end of the reporting
interval.
interval.
datetime
PK, NOT NULL
PeripheralID
The ICM software identifier for the ACD.
smallint
PK, FK, NOT
NULL
NULL
IGroupID
The Galaxy identifier for the group.
smallint
PK, NOT NULL
TimeZone
The time zone for the date and time. The value
is the offset in minutes from GMT.
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
SecondsInPeriod
Total time, in seconds, that I-group data was
being accumulated during the reporting interval.
being accumulated during the reporting interval.
smallint
NOT NULL
PrimaryCallsHandled
Number of external calls, internal gate transfer
calls, and internal gate calls connected to a
primary agent position during the interval.
calls, and internal gate calls connected to a
primary agent position during the interval.
smallint
NOT NULL
SecondaryCallsHandled
Number of external calls, internal gate transfer
calls, and internal gate calls connected to a
secondary agent position during the interval.
calls, and internal gate calls connected to a
secondary agent position during the interval.
smallint
NOT NULL
PrimaryODCallsHandled
Number of overflow/diversion-in calls
connected to a primary agent position during the
interval.
connected to a primary agent position during the
interval.
smallint
NOT NULL
SecondaryODCallsHandled
Number of overflow/diversion-in calls
connected to a secondary agent position during
the interval.
connected to a secondary agent position during
the interval.
smallint
NOT NULL
OutCalls
Number of out calls made by an agent position
on an outbound trunk or dial tandem tie-line.
on an outbound trunk or dial tandem tie-line.
smallint
NOT NULL
CallsTransferredOut
Number of calls handled by this I-group and
then transferred.
then transferred.
smallint
NOT NULL
BreakTime
Total time, in seconds, that agents spent in the
Break state
Break state
int
NOT NULL
AssignedTime
Total time, in seconds, that agents were assigned
to this I-group.
to this I-group.
int
NOT NULL
PlugInTime
Total time, in seconds, that agents were
plugged-in to this I-group.
plugged-in to this I-group.
int
NOT NULL
AvailableTime
Total time, in seconds, that agents were in the
Available state for the I-group.
Available state for the I-group.
int
NOT NULL