Technical References

Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBSMALLINT
The number of calls handled by the agent.
CallCount
PK NOT NULLDBDATETIME
The date and time at the end of the reporting interval..
DateTime
PK, FK NOT NULLDBSMALLINT
The ICM software identifier for the ACD.
PeripheralID
NOT NULLDBINT
The time zone in which the ACD is located. The value is the offset
in minutes from UTC (formerly called GMT).
PeripheralTimeZone
NOT NULLDBSMALLINT
Agent’s phone number. Invalid if TerminationType is Voice
Operated Relay.
PhoneNumber
PK NOT NULLDBSMALLINT
The identifier of the Galaxy port associated with the agent.
PortID
PK NOT NULLDBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NOT NULLDBSMALLINT
For the list of valid options, click here (page 475).
TerminationType
PK NOT NULLDBINT
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 Galaxy category (page 445). For database rules, click here (page 506).
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.
Related table
Peripheral (page 250) (via PeripheralID)
Table 93: Indexes for Galaxy_Agent_IGroup Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, 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)
183
Chapter 2: All Tables
Galaxy_Agent_IGroup Table