Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.2
  5. Technical References

Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Download
Page of 548
   
2-175
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
Chapter 2      Table Details
Galaxy_Transaction_Code Table
Galaxy_Transaction_Code Table
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a transaction 
on a Galaxy ACD.
Related tables:
 (via PeripheralID)
Table 2-169 Galaxy_Transaction_Code Table Constraints
Constraint
Field Name(s)
PK
DateTime
PeripheralID
TransactionCodeNumber
TimeZone
AK-1
RecoveryKey
FK
PeripheralID
Table 2-170 Galaxy_Transaction_Code Table
Field Name
Description
Data Type
Keys and 
Null Option
DateTime
The Central Controller date and time at the 
beginning of the reporting interval.
DBDATETIME
PK
NOT NULL
Description
A description of the transaction type.
VNAME32
NULL
PeripheralID
The ICM software identifier for the ACD.
DBSMALLINT
PK, FK
NOT NULL
PeripheralTimeZone
The time zone in which the ACD is located. The 
value is the offset in minutes from GMT.
DBINT
NOT NULL
RecoveryKey
A unique ID assigned to each record and used 
internally by the ICM/IPCC Enterprise software to 
track the record.
DBFLT8
AK-1
NOT NULL
SecondsInPeriod
Number of seconds in the reporting period.
DBSMALLINT
NOT NULL
TimeZone
The time zone for the Central Controller. The 
value is the offset in minutes from GMT.
DBINT
PK
NOT NULL
TransactionCodeNumber
Identifier for the transaction.
DBINT
PK
NOT NULL
TransactionCount
Number of transactions that occurred.
DBSMALLINT
NOT NULL