Technical References

Fields in Galaxy_Agent_IGroup Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLDBINT
Total time, in seconds, that agents were assigned to this I-group.
AssignedTime
NOT NULLDBINT
Total time, in seconds, that agents were in the Available state for
the I-group.
AvailableTime
NOT NULLDBINT
Total time, in seconds, that agents spent in the Break state
BreakTime
NOT NULLDBSMALLINT
Number of calls handled by this I-group and then transferred.
CallsTransferredOut
PK NOT NULLDBDATETIME
The date and time at the end of the reporting interval.
DateTime
PK NOT NULLDBSMALLINT
The Galaxy identifier for the group.
IGroupID
NOT NULLDBSMALLINT
Number of out calls made by an agent position on an outbound
trunk or dial tandem tie-line.
OutCalls
NOT NULLDBINT
Total time, in seconds, that agents were connected to an outbound
trunk or tie-line with no inbound call in progress.
OutCallTalkTime
PK, FK NOT NULLDBSMALLINT
The ICM software identifier for the ACD.
PeripheralID
NOT NULLDBINT
The time zone in which the ACD is located. The value is the offset
in minutes from UTC (formerly called GMT).
PeripheralTimeZone
NOT NULLDBINT
Total time, in seconds, that agents were plugged-in to this I-group.
PlugInTime
NOT NULLDBSMALLINT
Number of external calls, internal gate transfer calls, and internal
gate calls connected to a primary agent position during the
interval.
PrimaryCallsHandled
NOT NULLDBINT
Total time, in seconds, that primary agents spent in wrap-up for
external, internal gate transfer, and internal gate transfer calls.
PrimaryCallworkTime
NOT NULLDBSMALLINT
Number of overflow/diversion-in calls connected to a primary
agent position during the interval.
PrimaryODCallsHandled
NOT NULLDBINT
Total time, in seconds, that primary agents spent in wrap-up for
overflow/diversion-in calls.
PrimaryODCallworkTime
NOT NULLDBINT
Total time, in seconds, that primary agents were connected to
overflow/diversion-in calls.
PrimaryODTalkTIme
NOT NULLDBINT
Total time, in seconds, that primary agents were connected to
external calls, internal gate transfer calls, or internal gate calls.
PrimaryTalkTime
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
184
Chapter 2: All Tables
Galaxy_Agent_IGroup Table