Cisco Cisco IPCC Web Option Technical References
2-152
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
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-151 Galaxy_Agent_Igroup Table Constraints
Constraint
Field Name(s)
PK
DateTime
IGroupID
PeripheralID
TimeZone
IGroupID
PeripheralID
TimeZone
AK-1
RecoveryKey
FK
PeripheralID
Table 2-152 Galaxy_Agent_Igroup Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AssignedTime
Total time, in seconds, that agents were assigned
to this I-group.
to this I-group.
DBINT
NOT NULL
AvailableTime
Total time, in seconds, that agents were in the
Available state for the I-group.
Available state for the I-group.
DBINT
NOT NULL
BreakTime
Total time, in seconds, that agents spent in the
Break state
Break state
DBINT
NOT NULL
CallsTransferredOut
Number of calls
transferred.
DBSMALLINT
NOT NULL
DateTime
The date and time at the end of the reporting
interval.
interval.
DBDATETIME
PK
NOT NULL
IGroupID
The Galaxy identifier for the group.
DBSMALLINT
PK
NOT NULL
OutCalls
Number of out calls made by an agent position on
an outbound trunk or dial tandem tie-line.
an outbound trunk or dial tandem tie-line.
DBSMALLINT
NOT NULL
OutCallTalkTime
Total time, in seconds, that agents were connected
to an outbound trunk or tie-line with no inbound
call in progress.
to an outbound trunk or tie-line with no inbound
call in progress.
DBINT
NOT NULL
PeripheralID
The ICM software identifier for the ACD.
DBSMALLINT
PK, FK
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.
DBINT
NOT NULL
PlugInTime
Total time, in seconds, that agents were plugged-in
to this I-group.
to this I-group.
DBINT
NOT NULL