Cisco Cisco IP Contact Center Release 4.6.2 Technical References
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.
the agent.
smallint
PK, NOT NULL
TimeZone
The time zone for the date and time. The value
is the offset in minutes from GMT.
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.
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)
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.
agent.
smallint
NOT NULL
PhoneNumber
Agent’s phone number. Invalid if
TerminationType is Voice Operated Relay.
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.
track virtual time.
float
AK1, NOT
NULL
NULL
Table 2-74
Galaxy_Agent_Call_Control Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option