Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
 (via TrunkID)
Table 102: Indexes for Galaxy_Trunk_Call_Count Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
XAK1Galaxy_Galaxy_Trunk_Call_Count
DateTime, PeripheralID, PortID, TimeZone
nonclustered, 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 NULL
DBSMALLINT
Number of calls counted on the trunk.
CallCount
PK NOT NULL
DBDATETIME
The Central Controller date and time at the
beginning of the reporting interval.
DateTime
PK, FK NOT NULL
DBSMALLINT
The ICM software identifier for the ACD.
PeripheralID
NOT NULL
DBINT
The time zone in which the ACD is located. The
value is the offset in minutes from UTC (formerly
called GMT).
PeripheralTimeZone
PK NOT NULL
DBSMALLINT
Galaxy port assignment for the trunk.
PortID
AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
RecoveryKey
NOT NULL
DBSMALLINT
For valid options, click 
TerminationType
PK NOT NULL
DBINT
The time zone for the Central Controller. The value
is the offset in minutes from UTC (formerly called
GMT).
TimeZone
NOT NULL
DBSMALLINT
Galaxy identifier for the Trunk Information Group
that contains this trunk.
TrunkIGroup
Galaxy_Trunk_IGroup Table
This table is in the 
. For database rules, click 
.
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a trunk
information group con
figured on a Galaxy ACD.
Related table
 (via PeripheralID)
 (via TrunkID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
167
Chapter 2:  All Tables
Galaxy_Trunk_IGroup Table