Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-157
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Galaxy_Alarm Table
Galaxy_Alarm Table
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a system alarm
output by the Call or Reports processor on a Galaxy ACD.
output by the Call or Reports processor on a Galaxy ACD.
Related tables:
(via PeripheralID)
Table 2-155 Galaxy_Alarm Table Constraints
Constraint
Field Name(s)
PK
DateTime
PeripheralID
TimeZone
PeripheralID
TimeZone
AK-1
RecoveryKey
FK
PeripheralID
Table 2-156 Galaxy_Alarm Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AlarmCode
Three-digit alarm code.
DBSMALLINT
NOT NULL
AlarmData1
Additional data the Galaxy provided in the alarm
message.
message.
VNAME32
NULL
AlarmData2
Additional data the Galaxy provided in the alarm. VNAME32
NULL
AlarmProcessor
Processor that output the alarm: Call or Reports.
VNAME32
NULL
AlarmSubcode
A subcode, if any, the Galaxy provided for the
alarm.
alarm.
VNAME32
NULL
AlarmTime
Galaxy time that the alarm occurred.
DBSMALLINT
NOT NULL
DateTime
The date and time at the end of the reporting
interval.
interval.
DBDATETIME
PK
NOT 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.
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.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT NULL
TimeZone
The time zone for the date and time. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
DBINT
PK
NOT NULL