Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
VNAME32
Processor that output the alarm: Call or Reports.
AlarmProcessor
NULL
VNAME32
A subcode, if any, the Galaxy provided for the
alarm.
AlarmSubcode
NOT NULL
DBSMALLINT
Galaxy time that the alarm occurred.
AlarmTime
PK NOT NULL
DBDATETIME
The date and time at the end of the reporting interval.
DateTime
PK, FK NOT NULL
DBSMALLINT
The ICM software identifier for the ACD.
PeripheralID
NOT NULL
DBINT
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 NULL
DBFLT8
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
RecoveryKey
PK NOT NULL
DBINT
The time zone for the date and time. The value is
the offset in minutes from UTC (formerly called
GMT).
TimeZone
Galaxy_DNIS Table
. For database rules, click 
.
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a DNIS
con
figured on a Galaxy ACD.
Related table
 (via PeripheralID)
Table 95: Indexes for Galaxy_DNIS Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
XAK1Galaxy_DNIS
DateTime, PeripheralID, DNIS, TimeZone
nonclustered, unique, primary key
located on PRIMARY
XPKGalaxy_DNIS
Fields in Galaxy_DNIS Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
Total call time, in seconds, for calls to this DNIS.
CallDuration
PK NOT NULL
DBDATETIME
The Central Controller date and time at the
beginning of the reporting interval.
DateTime
PK NOT NULL
VNAME32
The DNIS value (0000 through 9999).
DNIS
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
152
Chapter 2: -  All Tables
Galaxy_DNIS Table