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

Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Download
Page of 404
 
2-91
Cisco ICM Software Database Schema Handbook
78-11677-04
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.
Related tables:
Peripheral (via PeripheralID)
Galaxy_DNIS Table
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a DNIS 
configured on a Galaxy ACD.
Table 2-77 Galaxy_Alarm Table
Field Name
Description
Data Type
Keys and Null 
Option
DateTime
The date and time at the end of the reporting interval.
datetime
PK, NOT NULL
PeripheralID
The ICM software identifier for the ACD.
smallint
PK, FK, NOT 
NULL
TimeZone
The time zone for the date and time. The value is the 
offset in minutes from GMT.
int
PK, NOT NULL
PeripheralTimeZone
The time zone in which the ACD is located. The value 
is the offset in minutes from GMT.
int
NOT NULL
AlarmTime
Galaxy time that the alarm occurred.
smallint
NOT NULL
AlarmCode
Three-digit alarm code.
smallint
NOT NULL
AlarmProcessor
Processor that output the alarm: Call or Reports.
varchar(32)
NULL
AlarmSubcode
A subcode, if any, the Galaxy provided for the alarm.
varchar(32)
NULL
AlarmData1
Additional data the Galaxy provided in the alarm 
message.
varchar(32)
NULL
AlarmData2
Additional data the Galaxy provided in the alarm.
varchar(32)
NULL
RecoveryKey
A value used internally by the ICM software to track 
virtual time.
float
AK1, NOT 
NULL
Table 2-78 Galaxy_DNIS 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