Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 548
   
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
AK-1
RecoveryKey
FK
PeripheralID
Table 2-168 Galaxy_Single_Trunk Table
Field Name
Description
Data Type
Keys and 
Null Option
BusyTimer
Time the trunk became busy (used to calculate 
busy times).
DBSMALLINT
NOT NULL
DateTime
The Central Controller date and time at the 
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.
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.
DBFLT8
AK-1
NOT NULL
SeizureCount
Total number of calls on inbound, outbound, and 
combination trunks (whether connected to an 
ACD gate or not).
DBSMALLINT
NOT NULL