Cisco Cisco IPCC Web Option Technical References

Page of 404
 
2-86
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Galaxy_Agent_Call_Count Table
Related tables:
Peripheral (via PeripheralID)
PortID
The identifier of the Galaxy port associated with 
the agent.
smallint
PK, NOT NULL
TimeZone
The time zone for the date and time. The value 
is the offset in minutes from GMT.
int
PK, NOT NULL
PeripheralTimeZone
The time zone in which the ACD is located. The 
value is the offset in minutes from GMT.
int
NOT NULL
TerminationType
Valid options include:
1 = Agent
2 = Digital Agent
4 = Audio Response Unit (ARU)
32 = Enhanced Agent
33 = Digital Enhanced Agent
42 = Tone PBX
45 = Voice Operated Relay (VOR)
48 = Voice Response Unit (VRU)
49 = Gate PBX
55 = Directory Assistance Billing Agen
56 = Directory Assistance Digital Billing Agent
57 = Enhanced D.A. Billing Agent
58 = Enhanced Directory Assistance Digital 
Billing Agent
60 = Directory Assistance Audio Response Unit 
(DAARU)
smallint
NOT NULL
AgentIGroupID
The Galaxy identifier for the I-Group of the 
agent.
smallint
NOT NULL
PhoneNumber
Agent’s phone number. Invalid if 
TerminationType is Voice Operated Relay.
smallint
NOT NULL
CallCount
The number of calls handled by the agent.
smallint
NOT NULL
RecoveryKey
A value used internally by the ICM software to 
track virtual time.
float
AK1, NOT 
NULL
Table 2-74
Galaxy_Agent_Call_Control Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option