Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 620
index_keys
index_description
index_name
DateTime, PeripheralID, PortID, TimeZone
nonclustered, unique, primary key
located on PRIMARY
XPKGalaxy_Single_Trunk
Fields in Galaxy_Single_Trunk Table:
Keys and Null
Option:
Data Type:
Description:
Field Name:
NOT NULL
DBSMALLINT
Time the trunk became busy (used to calculate busy times).
BusyTimer
PK NOT NULL
DBDATETIME
The Central Controller date and time at the beginning of the
reporting interval.
DateTime
NOT NULL
DBSMALLINT
Number of ISDN trunk rejections.
ISDNCallByCallLimitRejects
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
Total number of calls on inbound, outbound, and combination
trunks (whether connected to an ACD gate or not).
SeizureCount
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
DBINT
Total number of seconds the trunk was busy for inbound or
outbound calls. For an incoming call, busy time is from when
TotalBusyTime
a valid call is detected to disconnect. For an outbound call,
busy time is circuit selection to disconnect.
NOT NULL
DBSMALLINT
The ICM software identifier of the trunk group containing the
trunk.
TrunkGroup
NOT NULL
DBSMALLINT
Galaxy Trunk Information Group identifier.
TrunkIGroup
Galaxy_Transaction_Code Table
This table is in the 
. For database rules, click 
.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
203
Chapter 2:  All Tables
Galaxy_Transaction_Code Table