Cisco Cisco IP Contact Center Release 4.6.1 Technical References
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a
transaction on a Galaxy ACD.
transaction on a Galaxy ACD.
Related table
(via PeripheralID)
Table 101: Indexes for Galaxy_Transaction_Code Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Galaxy_Galaxy_Transaction_Code
DateTime, PeripheralID,
TransactionCodeNumber, TimeZone
TransactionCodeNumber, TimeZone
nonclustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKGalaxy_Galaxy_Transaction_Code
Fields in Galaxy_Transaction_Code Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBDATETIME
The Central Controller date and time at the
beginning of the reporting interval.
beginning of the reporting interval.
DateTime
NULL
VNAME32
A description of the transaction type.
Description
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).
value is the offset in minutes from UTC
(formerly called GMT).
PeripheralTimeZone
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.
internally by the ICM/IPCC Enterprise software
to track the record.
RecoveryKey
NOT NULL
DBSMALLINT
Number of seconds in the reporting period.
SecondsInPeriod
PK NOT NULL
DBINT
The time zone for the Central Controller. The
value is the offset in minutes from UTC
(formerly called GMT).
value is the offset in minutes from UTC
(formerly called GMT).
TimeZone
PK NOT NULL
DBINT
Identifier for the transaction.
TransactionCodeNumber
PK NOT NULL
DBSMALLINT
Number of transactions that occurred.
TransactionCount
Galaxy_Trunk_Call_Count Table
. For database rules, click
.
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides call counts for a trunk
configured on a Galaxy ACD.
configured on a Galaxy ACD.
Related table
(via PeripheralID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
166
Chapter 2: - All Tables
Galaxy_Trunk_Call_Count Table