Cisco Cisco IP Contact Center Release 4.6.1 Referencia técnica
Table 94: Indexes for Galaxy_Agent_Performance Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Galaxy_Agent_Performance
SignInTime, PeripheralID, AgentID,
TimeZone
TimeZone
nonclustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKGalaxy_Agent_Performance
Fields in Galaxy_Agent_Performance Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
DBTINYINT
A yes/no indicator.
ActivityIndicator
PK NOT NULL
DBINT
The Galaxy identifier for the agent.
AgentID
NULL
VNAME32
The agent’s name, as known to the ACD.
AgentName
NOT NULL
DBSMALLINT
Four-digit extension number.
AgentPhoneNumber
NOT NULL
DBSMALLINT
Number of times the agent used the Supervisor key to request
assistance.
assistance.
AssistQueueCount
NOT NULL
DBSMALLINT
Total time, in seconds, the agent was in the Available state.
AvailTime
NOT NULL
DBSMALLINT
Total time, in seconds, the agent spent in the Break state.
BreakTime
NOT NULL
DBSMALLINT
Number of out calls by this agent on an outbound trunk or dial tandem
tie-line.
tie-line.
OutCalls
NOT NULL
DBSMALLINT
Total time, in seconds, the agent spent connected to an outbound
trunk or tie-line with no inbound call in progress.
trunk or tie-line with no inbound call in progress.
OutCallTime
PK, FK NOT NULL
DBSMALLINT
An ICM software identifier for the ACD.
PeripheralID
NOT NULL
DBINT
The time zone for the ACD. The value is the offset in minutes from
UTC (formerly called GMT).
UTC (formerly called GMT).
PeripheralTimeZone
NOT NULL
DBSMALLINT
The ACD port to which the agent is connected.
PortID
NOT NULL
DBSMALLINT
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.
calls, and overflow/diversion-in calls connected to the agent while
primarily assigned to the gate.
PriCallsHandled
NOT NULL
DBSMALLINT
Total time, in seconds, the agent spent in wrap-up after primary
assignment external, internal gate transfer, overflow/diversion-in,
and internal gate calls.
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