Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-89
Cisco ICM Software Database Schema Handbook
78-11677-04
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-76 Galaxy_Agent_Performance Table
Field Name
Description
Data Type
Keys and Null
Option
Option
SignInTime
The Central Controller date and time when the agent
signed in.
signed in.
datetime
PK, NOT NULL
PeripheralID
An ICM software identifier for the ACD.
smallint
PK, FK, NOT
NULL
NULL
AgentID
The Galaxy identifier for the agent.
int
PK, NOT NULL
TimeZone
The time zone for the Central Controller. The value is the
offset in minutes from GMT.
offset in minutes from GMT.
int
PK, NOT NULL
SkillTargetID
The ICM software identifier for the agent.
int
FK, NULL
PeripheralTimeZone
The time zone for the ACD. The value is the offset in
minutes from GMT.
minutes from GMT.
int
NOT NULL
SerialNumber
A sequential counter maintained by the ACD.
smallint
NOT NULL
TerType
Termination type:
1 = agent
2 = digital agent
6 = station master agent
32 = enhanced agent
33 = digital enhanced agent
55 = directory assistance billing agent
56 = directory assistance digital billing agent
57 = enhanced directory assistance billing agent
58 = enhanced directory assistance digital billing agent
2 = digital agent
6 = station master agent
32 = enhanced agent
33 = digital enhanced agent
55 = directory assistance billing agent
56 = directory assistance digital billing agent
57 = enhanced directory assistance billing agent
58 = enhanced directory assistance digital billing agent
tinyint
NOT NULL
PriGate
Gate number of the agent’s primary assignment.
tinyint
NOT NULL
SecGate
Gate number of the agent’s secondary assignment.
tinyint
NOT NULL
PriCallsHandled
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.
internal gate calls, and overflow/diversion-in calls
connected to the agent while primarily assigned to the
gate.
smallint
NOT NULL
SecCallsHandled
Number of external calls, internal gate transfer calls,
internal gate calls, and overflow/diversion-in calls
connected to the agent while secondarily assigned to the
gate.
internal gate calls, and overflow/diversion-in calls
connected to the agent while secondarily assigned to the
gate.
smallint
NOT NULL
OutCalls
Number of out calls by this agent on an outbound trunk
or dial tandem tie-line.
or dial tandem tie-line.
smallint
NOT NULL
AvailTime
Total time, in seconds, the agent was in the Available
state.
state.
smallint
NOT NULL