Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-173
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Galaxy_Single_Trunk Table
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.
Table 2-167 Galaxy_Single_Trunk Table Constraints
Constraint
Field Name(s)
PK
DateTime
PeripheralID
PortID
TimeZone
PeripheralID
PortID
TimeZone
AK-1
RecoveryKey
FK
PeripheralID
Table 2-168 Galaxy_Single_Trunk Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
BusyTimer
Time the trunk became busy (used to calculate
busy times).
busy times).
DBSMALLINT
NOT NULL
DateTime
The Central Controller date and time at the
beginning of the reporting interval.
beginning of the reporting interval.
DBDATETIME
PK
NOT NULL
ISDNCallByCallLimitRejects
Number of ISDN trunk rejections.
DBSMALLINT
NOT NULL
PeripheralID
The ICM software identifier for the ACD.
DBSMALLINT
PK, FK
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.
DBINT
NOT NULL
PortID
Galaxy port assignment for the trunk.
DBSMALLINT
PK
NOT NULL
RecoveryKey
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT NULL
SeizureCount
Total number of calls on inbound, outbound, and
combination trunks (whether connected to an
ACD gate or not).
combination trunks (whether connected to an
ACD gate or not).
DBSMALLINT
NOT NULL