Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
Page of 404
 
2-105
Cisco ICM Software Database Schema Handbook
78-11677-04
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:
Peripheral (via PeripheralID)
Galaxy_Trunk_Call_Count Table
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides call counts for a trunk configured 
on a Galaxy ACD.
Table 2-84 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.
datetime
PK, NOT NULL
PeripheralID
The ICM software identifier for the ACD.
smallint
PK, FK, NOT 
NULL
TransactionCodeNumber
Identifier for the transaction.
int
PK, NOT NULL
TimeZone
The time zone for the Central Controller. The value is 
the offset in minutes from GMT.
int
PK, NOT NULL
SecondsInPeriod
Number of seconds in the reporting period.
smallint
NOT NULL
PeripheralTimeZone
The time zone in which the ACD is located. The value 
is the offset in minutes from GMT.
int
NOT NULL
TransactionCount
Number of transactions that occurred.
smallint
NOT NULL
Description
A description of the transaction type.
varchar(32)
NULL
RecoveryKey
A value used internally by the ICM software to track 
virtual time.
float
AK1, NOT 
NULL
Table 2-85 Galaxy_Trunk_Call_Count Table
Field Name
Description
Data Type
Keys and Null 
Option
DateTime
The Central Controller date and time at the 
beginning of the reporting interval.
datetime
PK, NOT NULL
PeripheralID
The ICM software identifier for the ACD.
smallint
PK, FK, NOT 
NULL
PortID
Galaxy port assignment for the trunk.
smallint
PK, NOT NULL