Cisco Cisco IPCC Web Option Technical References
Galaxy_DNIS Table
This table is in the
. For database rules, click
.
Central database only.
This table applies to Rockwell Galaxy ACDs only. Each row provides information about a DNIS
configured on a Galaxy ACD.
configured on a Galaxy ACD.
Related table
(via PeripheralID)
Table 96: Indexes for Galaxy_DNIS Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Galaxy_DNIS
DateTime, PeripheralID, DNIS, TimeZone
nonclustered, unique, primary key
located on PRIMARY
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.
reporting interval.
DateTime
PK NOT NULL
VNAME32
The DNIS value (0000 through 9999).
DNIS
NOT NULL
DBSMALLINT
Number of calls with this DNIS that were abandoned.
NumberCallsAbandoned
NOT NULL
DBSMALLINT
Number of calls with this DNIS that were answered.
NumberCallsAnswered
PK, FK NOT NULL
DBSMALLINT
The ICM software identifier for the ACD.
PeripheralID
NOT NULL
DBINT
The time zone for the ACD. The value is the offset in minutes
from UTC (formerly called GMT).
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.
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NOT NULL
DBSMALLINT
Number of seconds in the reporting period.
SecondsInPeriod
NOT NULL
DBINT
Total answer time, in seconds, for calls with this DNIS.
TimeToAnswer
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
189
Chapter 2: All Tables
Galaxy_DNIS Table