Cisco Cisco E-Mail Manager Unity Integration Option 技术参考
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.
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.
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.
offset in minutes from GMT.
int
NOT NULL
ValidType
Valid options include:
0 = Valid DNIS number
1 = Invalid DNIS number
1 = Invalid DNIS number
smallint
NOT NULL
NumberCallsAnswered
Number of calls with this DNIS that were
answered.
answered.
smallint
NOT NULL
NumberCallsAbandoned
Number of calls with this DNIS that were
abandoned.
abandoned.
smallint
NOT NULL
TimeToAnswer
Total answer time, in seconds, for calls with this
DNIS.
DNIS.
int
NOT NULL
CallDuration
Total call time, in seconds, for calls to this
DNIS.
DNIS.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to
track virtual time.
track virtual time.
float
AK1, NOT
NULL
NULL
Table 2-78 Galaxy_DNIS Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-79 Galaxy_Gate 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