Technical References

index_keysindex_descriptionindex_name
DateTime, PeripheralID, PortID, TimeZonenonclustered, 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 NULLDBSMALLINT
Time the trunk became busy (used to calculate busy times).
BusyTimer
PK NOT NULLDBDATETIME
The Central Controller date and time at the beginning of the
reporting interval.
DateTime
NOT NULLDBSMALLINT
Number of ISDN trunk rejections.
ISDNCallByCallLimitRejects
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
Total number of calls on inbound, outbound, and combination
trunks (whether connected to an ACD gate or not).
SeizureCount
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 NULLDBINT
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 NULLDBSMALLINT
The ICM software identifier of the trunk group containing the
trunk.
TrunkGroup
NOT NULLDBSMALLINT
Galaxy Trunk Information Group identifier.
TrunkIGroup
Galaxy_Transaction_Code 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)
203
Chapter 2: All Tables
Galaxy_Transaction_Code Table