Cisco Cisco IPCC Web Option Technical References
Fields in Galaxy_Agent_IGroup Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
Total time, in seconds, that agents were assigned to this I-group.
AssignedTime
NOT NULL
DBINT
Total time, in seconds, that agents were in the Available state for
the I-group.
the I-group.
AvailableTime
NOT NULL
DBINT
Total time, in seconds, that agents spent in the Break state
BreakTime
NOT NULL
DBSMALLINT
Number of calls handled by this I-group and then transferred.
CallsTransferredOut
PK NOT NULL
DBDATETIME
The date and time at the end of the reporting interval.
DateTime
PK NOT NULL
DBSMALLINT
The Galaxy identifier for the group.
IGroupID
NOT NULL
DBSMALLINT
Number of out calls made by an agent position on an outbound
trunk or dial tandem tie-line.
trunk or dial tandem tie-line.
OutCalls
NOT NULL
DBINT
Total time, in seconds, that agents were connected to an outbound
trunk or tie-line with no inbound call in progress.
trunk or tie-line with no inbound call in progress.
OutCallTalkTime
PK, FK NOT NULL
DBSMALLINT
The ICM software identifier for the ACD.
PeripheralID
NOT NULL
DBINT
The time zone in which the ACD is located. The value is the offset
in minutes from UTC (formerly called GMT).
in minutes from UTC (formerly called GMT).
PeripheralTimeZone
NOT NULL
DBINT
Total time, in seconds, that agents were plugged-in to this I-group.
PlugInTime
NOT NULL
DBSMALLINT
Number of external calls, internal gate transfer calls, and internal
gate calls connected to a primary agent position during the
interval.
gate calls connected to a primary agent position during the
interval.
PrimaryCallsHandled
NOT NULL
DBINT
Total time, in seconds, that primary agents spent in wrap-up for
external, internal gate transfer, and internal gate transfer calls.
external, internal gate transfer, and internal gate transfer calls.
PrimaryCallworkTime
NOT NULL
DBSMALLINT
Number of overflow/diversion-in calls connected to a primary
agent position during the interval.
agent position during the interval.
PrimaryODCallsHandled
NOT NULL
DBINT
Total time, in seconds, that primary agents spent in wrap-up for
overflow/diversion-in calls.
overflow/diversion-in calls.
PrimaryODCallworkTime
NOT NULL
DBINT
Total time, in seconds, that primary agents were connected to
overflow/diversion-in calls.
overflow/diversion-in calls.
PrimaryODTalkTIme
NOT NULL
DBINT
Total time, in seconds, that primary agents were connected to
external calls, internal gate transfer calls, or internal gate calls.
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