Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-103
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Galaxy_Single_Trunk Table
Related tables:
Peripheral (via PeripheralID)
Galaxy_Single_Trunk Table
Central database only.
This table applies to Rockwell Galaxy ACDs only.
Each row provides information about a trunk configured on a Galaxy ACD.
AbandonedNoAnswer
Number of calls to the destination that were
abandoned.
abandoned.
smallint
NULL
TollCalls
Number of toll calls placed from the extension.
smallint
NOT NULL
CallDuration
Total number of seconds for all incoming calls
(counted from time of answer or end of dialing until
disconnect.
(counted from time of answer or end of dialing until
disconnect.
int
NOT NULL
SecondCallDuration
Total number of seconds that second calls were on the
phone.
phone.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NOT
NULL
NULL
Table 2-82 Galaxy_PBX Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-83 Galaxy_Single_Trunk 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
PortID
Galaxy port assignment for the trunk.
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
PeripheralTimeZone
The time zone in which the ACD is located. The
value is the offset in minutes from GMT.
value is the offset in minutes from GMT.
int
NOT NULL