Technical References

Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a
transaction on a Galaxy ACD.
Related table
Peripheral (page 250) (via PeripheralID)
Table 102: Indexes for Galaxy_Transaction_Code Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Galaxy_Galaxy_Transaction_Code
DateTime, PeripheralID,
TransactionCodeNumber, TimeZone
nonclustered, unique, primary key
located on PRIMARY
XPKGalaxy_Galaxy_Transaction_Code
Fields in Galaxy_Transaction_Code Table:
Keys and Null Option:Data Type:Description:Field Name:
PK NOT NULLDBDATETIME
The Central Controller date and time at the beginning of the
reporting interval.
DateTime
NULLVNAME32
A description of the transaction type.
Description
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
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
Number of seconds in the reporting period.
SecondsInPeriod
PK NOT NULLDBINT
The time zone for the Central Controller. The value is the offset
in minutes from UTC (formerly called GMT).
TimeZone
PK NOT NULLDBINT
Identifier for the transaction.
TransactionCodeNumber
PK NOT NULLDBSMALLINT
Number of transactions that occurred.
TransactionCount
Galaxy_Trunk_Call_Count Table
This table is in the Galaxy category (page 445). For database rules, click here (page 506).
Central database only.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
204
Chapter 2: All Tables
Galaxy_Trunk_Call_Count Table