Cisco Cisco IPCC Web Option Technical References
2-96
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Galaxy_Gate_Delayed_Call Table
Galaxy_Gate_Delayed_Call Table
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides delayed call information about a
gate configured on a Galaxy ACD.
gate configured on a Galaxy ACD.
Table 2-80 Galaxy_Gate_Delayed_Call Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
The Central Controller date and time at the
beginning of the reporting interval.
beginning of the reporting interval.
datetime
PK, NOT NULL
PeripheralID
The ICM software identifier for the ACD.
smallint
PK, FK, NOT
NULL
NULL
GateID
The Galaxy identifier for the gate.
smallint
PK, NOT NULL
TimeZone
The time zone for the Central Controller. The
value is the offset in minutes from GMT.
value is the offset in minutes from GMT.
int
PK, NOT NULL
SkillTargetID
The ICM software identifier for the service.
int
FK, NULL
PeripheralTimeZone
The time zone for the ACD. The value is the
offset in minutes from GMT.
offset in minutes from GMT.
int
NOT NULL
SecondsInPeriod
Number of seconds in the reporting period.
smallint
NOT NULL
Abandoned0
Number of abandoned calls were abandoned
time was less than 1 second.
time was less than 1 second.
smallint
NOT NULL
Abandoned5
Number of abandoned calls were abandon
time was greater than or equal to 1 second, but
less than 5 seconds.
time was greater than or equal to 1 second, but
less than 5 seconds.
smallint
NOT NULL
Abandoned10
Number of abandoned calls were abandon
time was greater than or equal to 5 seconds,
but less than 10 seconds.
time was greater than or equal to 5 seconds,
but less than 10 seconds.
smallint
NOT NULL
Abandoned15
Number of abandoned calls were abandon
time was greater than or equal to 10 seconds,
but less than 15 seconds.
time was greater than or equal to 10 seconds,
but less than 15 seconds.
smallint
NOT NULL
Abandoned20
Number of abandoned calls were abandon
time was greater than or equal to 15 seconds,
but less than 20 seconds.
time was greater than or equal to 15 seconds,
but less than 20 seconds.
smallint
NOT NULL
Abandoned25
Number of abandoned calls were abandon
time was greater than or equal to 20 seconds,
but less than 25 seconds.
time was greater than or equal to 20 seconds,
but less than 25 seconds.
smallint
NOT NULL
Abandoned30
Number of abandoned calls were abandon
time was greater than or equal to 25 seconds,
but less than 30 seconds.
time was greater than or equal to 25 seconds,
but less than 30 seconds.
smallint
NOT NULL
Abandoned40
Number of abandoned calls were abandon
time was greater than or equal to 30 seconds,
but less than 40 seconds.
time was greater than or equal to 30 seconds,
but less than 40 seconds.
smallint
NOT NULL