Technical References

This table applies to Rockwell Galaxy ACDs only. Each row provides call counts for a trunk
configured on a Galaxy ACD.
Related table
Peripheral (page 250) (via PeripheralID)
Trunk (page 419) (via TrunkID)
Table 103: Indexes for Galaxy_Trunk_Call_Count Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Galaxy_Galaxy_Trunk_Call_Count
DateTime, PeripheralID, PortID, TimeZonenonclustered, unique, primary key
located on PRIMARY
XPKGalaxy_Galaxy_Trunk_Call_Count
Fields in Galaxy_Trunk_Call_Count Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBSMALLINT
Number of calls counted on the trunk.
CallCount
PK NOT NULLDBDATETIME
The Central Controller date and time at the beginning of the
reporting interval.
DateTime
PK, FK NOT NULLDBSMALLINT
The ICM software identifier for the ACD.
PeripheralID
NOT NULLDBINT
The time zone in which the ACD is located. The value is the offset
in minutes from UTC (formerly called GMT).
PeripheralTimeZone
PK NOT NULLDBSMALLINT
Galaxy port assignment for the trunk.
PortID
AK-1 NOT NULLDBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NOT NULLDBSMALLINT
For valid options, click here (page 475)
TerminationType
PK NOT NULLDBINT
The time zone for the Central Controller. The value is the offset in
minutes from UTC (formerly called GMT).
TimeZone
NOT NULLDBSMALLINT
Galaxy identifier for the Trunk Information Group that contains
this trunk.
TrunkIGroup
Galaxy_Trunk_IGroup Table
This table is in the Galaxy category (page 445). For database rules, click here (page 506).
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
205
Chapter 2: All Tables
Galaxy_Trunk_IGroup Table