Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLDBTINYINT
Gate number of the agent’s primary assignment.
PriGate
NOT NULLDBSMALLINT
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.
PriTalkTime
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NOT NULLDBSMALLINT
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.
SecCallsHandled
NOT NULLDBSMALLINT
Total time, in seconds, the agent spent in wrap-up after secondary
assignment external, internal gate transfer, overflow/diversion-in,
and internal gate calls.
SecCallworkTime
NOT NULLDBTINYINT
Gate number of the agent’s secondary assignment.
SecGate
NOT NULLDBSMALLINT
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.
SecTalkTime
NOT NULLDBSMALLINT
A sequential counter maintained by the ACD.
SerialNumber
NOT NULLDBINT
Number of seconds elapsed since the agent signed in.
SignedInSeconds
PK NOT NULLDBDATETIME
The Central Controller date and time when the agent signed in.
SignInTime
FK NULLDBINT
The ICM software identifier for the agent.
SkillTargetID
NOT NULLDBTINYINT
Termination type. For valid options, click here (page 475).
Tertype
PK NOT NULLDBINT
The time zone for the Central Controller. The value is the offset in
minutes from UTC (formerly called GMT).
TimeZone
Galaxy_Alarm Table
This table is in the Galaxy category (page 445). For database rules, click here (page 506).
Central database only.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
187
Chapter 2: All Tables
Galaxy_Alarm Table