Cisco Cisco E-Mail Manager Unity Integration Option Riferimenti tecnici
2-25
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Agent_State_Trace Table
Agent_State_Trace Table
Each row describes a change of state for an agent. By examining Agent State Trace rows you can trace
all the state changes that have occurred for an agent.
all the state changes that have occurred for an agent.
The ICM software generates an Agent_State_Trace records for each agent for which tracing is enabled.
Table 2-11
Agent_State_Trace Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
The date and time at which the state change
occurred.
occurred.
smalldatetime
IE1, NOT NULL
SkillTargetID
Identifies the agent.
int
IE1, FK, NOT
NULL
NULL
TimeZone
The time zone for the date and time. The value is the
offset in minutes from GMT.
offset in minutes from GMT.
int
NOT NULL
MRDomainID
The identifier for the Media Routing Domain
associated with the agent state change.
associated with the agent state change.
int
PK, FK NOT
NULL
NULL
EventName
Code indicating the event that has occurred.
int
NOT NULL
ReasonCode
Code received from the peripheral indicating the
reason for the state change.
reason for the state change.
int
NULL
SkillGroupSkillTargetID
Identifies the skill group the event is associated
with.
with.
int
NULL
AgentState
The new agent trace state:
0 = Logged Off
1 = Logged On
2 = Not Ready
3 = Ready
4 = Talking
5 = Work Not Ready
6 = Work Ready
7 = Busy Other
8 = Reserved
9 = Call Initiated
10 = Call Held
11 = Call Retrieved
12 = Call Transferred
13 = Call Conferenced
14 = Unknown.
1 = Logged On
2 = Not Ready
3 = Ready
4 = Talking
5 = Work Not Ready
6 = Work Ready
7 = Busy Other
8 = Reserved
9 = Call Initiated
10 = Call Held
11 = Call Retrieved
12 = Call Transferred
13 = Call Conferenced
14 = Unknown.
int
FK, NULL
ICRCallKey
A unique number generated at the PG. Values are
reused after about 250 million calls.
reused after about 250 million calls.
int
NULL
PeripheralCallKey
Key assigned by the peripheral to the call associated
with the event.
with the event.
int
NULL
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NOT
NULL
NULL
Direction
The direction for talking states.
int
NULL