Cisco Cisco ICM Web Tools Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
The time zone for the Central Controller. The value is the offset
in minutes from UTC (formerly called GMT).
in minutes from UTC (formerly called GMT).
TimeZone
PK NOT NULL
DBSMALLINT
Valid options include:
ValidType
• 0 = Valid DNIS number
• 1 = Invalid DNIS number
Galaxy_Gate Table
. For database rules, click
.
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a gate
configured on a Galaxy ACD.
configured on a Galaxy ACD.
Related table
(via PeripheralID)
(via SkillTargetID)
Table 97: Indexes for Galaxy_Gate Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Galaxy_Gate
DateTime, PeripheralID, GateID, TimeZone
nonclustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKGalaxy_Gate
Fields in Galaxy_Gate Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
DBSMALLINT
Number of external, internal gate transfer, and internal gate calls
for the gate that were lost before being connected to an agent
position.
for the gate that were lost before being connected to an agent
position.
CallsAbandoned
NOT NULL
DBSMALLINT
Number of external, internal gate transfer, internal gate, and
overflow/diversion-in calls that were either abandoned or held
beyond a specific system threshold.
overflow/diversion-in calls that were either abandoned or held
beyond a specific system threshold.
CallsHeld
NOT NULL
DBINT
Number of calls directly transferred to primary agents for this gate.
CallsTransferredIn
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
190
Chapter 2: All Tables
Galaxy_Gate Table