Technical References

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.
Related table
Peripheral (page 250) (via PeripheralID)
Table 95: Indexes for Galaxy_Alarm Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Galaxy_Alarm
DateTime, PeripheralID, TimeZonenonclustered, unique, primary key
located on PRIMARY
XPKGalaxy_Alarm
Fields in Galaxy_Alarm Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBSMALLINT
Three-digit alarm code.
AlarmCode
NULLVNAME32
Additional data the Galaxy provided in the alarm message.
AlarmData1
NULLVNAME32
Additional data the Galaxy provided in the alarm.
AlarmData2
NULLVNAME32
Processor that output the alarm: Call or Reports.
AlarmProcessor
NULLVNAME32
Processor that output the alarm: Call or Reports.
AlarmProcessor
NULLVNAME32
A subcode, if any, the Galaxy provided for the alarm.
AlarmSubcode
NOT NULLDBSMALLINT
Galaxy time that the alarm occurred.
AlarmTime
PK NOT NULLDBDATETIME
The date and time at the end of the reporting interval.
DateTime
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
PK NOT NULLDBINT
The time zone for the date and time. The value is the offset in
minutes from UTC (formerly called GMT).
TimeZone
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
188
Chapter 2: All Tables
Galaxy_Alarm Table