Cisco Cisco E-Mail Manager Unity Integration Option Riferimenti tecnici
2-154
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Galaxy_Agent_Performance Table
Galaxy_Agent_Performance Table
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides performance information about
an agent configured on a Galaxy ACD.
an agent configured on a Galaxy ACD.
Table 2-153 Galaxy_Agent_PerformanceTable Constraints
Constraint
Field Name(s)
PK
AgentID
PeripheralID
SignInTime
TimeZone
PeripheralID
SignInTime
TimeZone
AK-1
RecoveryKey
FK
PeripheralID
SkillTargetID
SkillTargetID
Table 2-154 Galaxy_Agent_Performance Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ActivityIndicator
A yes/no indicator.
DBTINYINT
NOT NULL
AgentID
The Galaxy identifier for the agent.
DBINT
PK
NOT NULL
AgentName
The agent’s name, as known to the ACD.
varchar(32)
NULL
AgentPhoneNumber
Four-digit extension number.
DBSMALLINT
NOT NULL
AssistQueueCount
Number of times the agent used the Supervisor
key to request assistance.
key to request assistance.
DBSMALLINT
NOT NULL
AvailTime
Total time, in seconds, the agent was in the
Available state.
Available state.
DBSMALLINT
NOT NULL
BreakTime
Total time, in seconds, the agent spent in the Break
state.
state.
DBSMALLINT
NOT NULL
OutCalls
Number of out calls by this agent on an outbound
trunk or dial tandem tie-line.
trunk or dial tandem tie-line.
DBSMALLINT
NOT NULL
OutCallTime
Total time, in seconds, the agent spent 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.
DBSMALLINT
NOT NULL
PeripheralID
An ICM software identifier for the ACD.
DBSMALLINT
PK, FK
NOT NULL
PeripheralTimeZone
The time zone for the ACD. The value is the offset
in minutes from GMT.
in minutes from GMT.
DBINT
NOT NULL
PortID
The ACD port to which the agent is connected.
DBSMALLINT
NOT NULL