Cisco Cisco IP Contact Center Release 4.6.2 Technical References

NOT NULL

DBSMALLINT

The number of calls handled by the agent.

CallCount

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

NOT NULL

DBSMALLINT

Agent’s phone number. Invalid if TerminationType is Voice
Operated Relay.

PhoneNumber

PK NOT NULL

DBSMALLINT

The identifier of the Galaxy port associated with the agent.

PortID

PK NOT NULL

DBFLT8

A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.

RecoveryKey

NOT NULL

DBSMALLINT

For the list of valid options, click 

.

TerminationType

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_Agent_IGroup 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 an
agent information group configured on a Galaxy ACD.

 (via PeripheralID)

RecoveryKey

nonclustered, unique, unique key
located on PRIMARY

XAK1Galaxy_Agent_IGroup

DateTime, PeripheralID, IGroupID,
TimeZone

nonclustered, unique, primary key
located on PRIMARY

XPKGalaxy_Agent_IGroup

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)