Cisco Cisco E-Mail Manager Unity Integration Option Technical References

Page of 404
 
2-92
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Galaxy_Gate Table
Related tables:
Peripheral (via PeripheralID)
Galaxy_Gate Table
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a gate 
configured on a Galaxy ACD.
DNIS
The DNIS value (0000 through 9999).
varchar(32)
PK, NOT NULL
TimeZone
The time zone for the Central Controller. The 
value is the offset in minutes from GMT.
int
PK, NOT NULL
SecondsInPeriod
Number of seconds in the reporting period.
smallint
NOT NULL
PeripheralTimeZone
The time zone for the ACD. The value is the 
offset in minutes from GMT.
int
NOT NULL
ValidType
Valid options include: 
0 = Valid DNIS number
1 = Invalid DNIS number
smallint
NOT NULL
NumberCallsAnswered
Number of calls with this DNIS that were 
answered.
smallint
NOT NULL
NumberCallsAbandoned
Number of calls with this DNIS that were 
abandoned.
smallint
NOT NULL
TimeToAnswer
Total answer time, in seconds, for calls with this 
DNIS.
int
NOT NULL
CallDuration
Total call time, in seconds, for calls to this 
DNIS.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to 
track virtual time.
float
AK1, NOT 
NULL
Table 2-78 Galaxy_DNIS Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-79 Galaxy_Gate 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
TimeZone
The time zone for the Central Controller. The 
value is the offset in minutes from GMT.
int
PK, NOT NULL