Cisco Cisco E-Mail Manager Unity Integration Option Technical References

Page of 404
 
2-90
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Galaxy_Agent_Performance Table
Related tables:
Agent (via SkillTargetID)
Peripheral (via PeripheralID)
PriTalkTime
Total time, in seconds, the agent was connected as a 
primary assignment to external calls, internal gate 
transfer calls, overflow/diversion-in calls, or internal 
gate calls.
smallint
NOT NULL
SecTalkTime
Total time, in seconds, the agent was connected as a 
secondary assignment to external calls, internal gate 
transfer calls, overflow/diversion-in calls, or internal 
gate calls.
smallint
NOT NULL
PriCallworkTime
Total time, in seconds, the agent spent in wrap-up after 
primary assignment external, internal gate transfer, 
overflow/diversion-in, and internal gate calls.
smallint
NOT NULL
SecCallworkTime
Total time, in seconds, the agent spent in wrap-up after 
secondary assignment external, internal gate transfer, 
overflow/diversion-in, and internal gate calls.
smallint
NOT NULL
OutCallTime
Total time, in seconds, the agent spent connected to an 
outbound trunk or tie-line with no inbound call in 
progress.
smallint
NOT NULL
SignedInSeconds
Number of seconds elapsed since the agent signed in.
int
NOT NULL
AssistQueueCount
Number of times the agent used the Supervisor key to 
request assistance.
smallint
NOT NULL
ActivityIndicator
A yes/no indicator.
tinyint
NOT NULL
BreakTime
Total time, in seconds, the agent spent in the Break state. smallint
NOT NULL
PortID
The ACD port to which the agent is connected.
smallint
NOT NULL
AgentPhoneNumber
Four-digit extension number.
smallint
NOT NULL
AgentName
The agent’s name, as known to the ACD.
varchar(32)
NULL
 RecoveryKey
A value used internally by the ICM software to track 
virtual time.
float
AK1, NOT 
NULL
Table 2-76 Galaxy_Agent_Performance Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option