Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLDBSMALLINT
Number of handled calls were wait time was greater than or equal
to 90 seconds, but less than 120 seconds.
Handled120
NOT NULLDBSMALLINT
Number of handled calls were wait time was greater than or equal
to 120 seconds, but less than 180 seconds.
Handled180
NOT NULLDBSMALLINT
Number of handled calls were wait time was greater than or equal
to 180 seconds.
HandledOver180
NOT NULLDBSMALLINT
Maximum number of seconds that any call waited before being
either answered or abandoned.
LongestDelay
NOT NULLDBSMALLINT
Maximum number of calls in any agent’s queue.
MaximumDelayQueueLength
PK, FK NOT NULLDBSMALLINT
The ICM software identifier for the ACD.
PeripheralID
NOT NULLDBINT
The time zone for the ACD. The value is the offset in minutes
from UTC (formerly called GMT).
PeripheralTimeZone
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 seconds in the reporting period.
SecondsInPeriod
FK NULLDBINT
The ICM software identifier for the service.
SkillTargetID
PK NOT NULLDBINT
The time zone for the Central Controller. The value is the offset
in minutes from UTC (formerly called GMT).
TimeZone
Galaxy_Overflow Table
This table is in the Galaxy category (page 445). For database rules, click here (page 506).
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about calls
overflowed from a gate on the Galaxy ACD.
Related table
Peripheral (page 250) (via PeripheralID)
Service (page 325) (via SkillTargetID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
196
Chapter 2: All Tables
Galaxy_Overflow Table