Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Administrative Workstation
  5. Technical References

Cisco Cisco Administrative Workstation Technical References

Download
Page of 548
   
2-158
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2      Table Details
Galaxy_DNIS Table
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-157 Galaxy_DNIS Table Constraints
Constraint
Field Name(s)
PK
DateTime
DNIS
PeripheralID
TimeZone
AK-1
RecoveryKey
FK
PeripheralID
Table 2-158 Galaxy_DNIS Table
Field Name
Description
Data Type
Keys and 
Null Option
CallDuration
Total call time, in seconds, for calls to this DNIS. DBINT
NOT NULL
DateTime
The Central Controller date and time at the 
beginning of the reporting interval.
DBDATETIME
PK
NOT NULL
DNIS
The DNIS value (0000 through 9999).
VNAME32
PK
NOT NULL
NumberCallsAbandoned
Number of calls with this DNIS that were 
abandoned.
DBSMALLINT
NOT NULL
NumberCallsAnswered
Number of calls with this DNIS that were 
answered.
DBSMALLINT
NOT NULL
PeripheralID
The ICM software identifier for the ACD.
DBSMALLINT
PK, FK
NOT NULL
PeripheralTimeZone
The time zone for the ACD. The 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.
DBFLT8
AK-1
NOT NULL
SecondsInPeriod
Number of seconds in the reporting period.
DBSMALLINT
NOT NULL
TimeToAnswer
Total answer time, in seconds, for calls with this 
DNIS.
DBINT
NOT NULL