Cisco Cisco IPCC Web Option Technical References

Page of 404
 
2-98
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Galaxy_Overflow Table
Related tables:
Peripheral (via PeripheralID)
Service (via SkillTargetID)
Galaxy_Overflow Table
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.
Handled60
Number of handled calls were wait time was 
greater than or equal to 50 seconds, but less 
than 60 seconds.
smallint
NOT NULL
Handled90
Number of handled calls were wait time was 
greater than or equal to 60 seconds, but less 
than 90 seconds.
smallint
NOT NULL
Handled120
Number of handled calls were wait time was 
greater than or equal to 90 seconds, but less 
than 120 seconds.
smallint
NOT NULL
Handled180
Number of handled calls were wait time was 
greater than or equal to 120 seconds, but less 
than 180 seconds.
smallint
NOT NULL
HandledOver180
Number of handled calls were wait time was 
greater than or equal to 180 seconds.
smallint
NOT NULL
LongestDelay
Maximum number of seconds that any call 
waited before being either answered or 
abandoned.
smallint
NOT NULL
MaximumDelayQueueLength
Maximum number of calls in any agent’s 
queue.
smallint
NOT NULL
 RecoveryKey
A value used internally by the ICM software 
to track virtual time.
float
AK1, NOT 
NULL
Table 2-80 Galaxy_Gate_Delayed_Call Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-81 Galaxy_Overflow Table
Field Name
Description
Data Type
Keys and Null 
Option
DateTime
The Central Controller date and time at the beginning of 
the reporting interval.
datetime
PK, NOT NULL
PeripheralID
The ICM software identifier for the ACD.
smallint
PK, FK, NOT 
NULL
GateID
The Galaxy identifier for the gate.
smallint
PK, NOT NULL