Technical References

Table 94: Indexes for Galaxy_Agent_Performance Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Galaxy_Agent_Performance
SignInTime, PeripheralID, AgentID,
TimeZone
nonclustered, unique, primary key
located on PRIMARY
XPKGalaxy_Agent_Performance
Fields in Galaxy_Agent_Performance Table:
Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLDBTINYINT
A yes/no indicator.
ActivityIndicator
PK NOT NULLDBINT
The Galaxy identifier for the agent.
AgentID
NULLVNAME32
The agent’s name, as known to the ACD.
AgentName
NOT NULLDBSMALLINT
Four-digit extension number.
AgentPhoneNumber
NOT NULLDBSMALLINT
Number of times the agent used the Supervisor key to request
assistance.
AssistQueueCount
NOT NULLDBSMALLINT
Total time, in seconds, the agent was in the Available state.
AvailTime
NOT NULLDBSMALLINT
Total time, in seconds, the agent spent in the Break state.
BreakTime
NOT NULLDBSMALLINT
Number of out calls by this agent on an outbound trunk or dial tandem
tie-line.
OutCalls
NOT NULLDBSMALLINT
Total time, in seconds, the agent spent connected to an outbound
trunk or tie-line with no inbound call in progress.
OutCallTime
PK, FK NOT NULLDBSMALLINT
An ICM software identifier for the ACD.
PeripheralID
NOT NULLDBINT
The time zone for the ACD. The value is the offset in minutes from
UTC (formerly called GMT).
PeripheralTimeZone
NOT NULLDBSMALLINT
The ACD port to which the agent is connected.
PortID
NOT NULLDBSMALLINT
Number of external calls, internal gate transfer calls, internal gate
calls, and overflow/diversion-in calls connected to the agent while
primarily assigned to the gate.
PriCallsHandled
NOT NULLDBSMALLINT
Total time, in seconds, the agent spent in wrap-up after primary
assignment external, internal gate transfer, overflow/diversion-in,
and internal gate calls.
PriCallworkTime
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
186
Chapter 2: All Tables
Galaxy_Agent_Performance Table