Cisco Cisco IP Contact Center Release 4.6.2 기술 참조

다운로드
페이지 404
 
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.
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
DateTime
The date and time at which the state change 
occurred.
smalldatetime
IE1, NOT NULL
SkillTargetID
Identifies the agent.
int
IE1, FK, NOT 
NULL
TimeZone
The time zone for the date and time. The value is the 
offset in minutes from GMT.
int
NOT NULL
MRDomainID
The identifier for the Media Routing Domain 
associated with the agent state change.
int
PK, FK NOT 
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.
int
NULL
SkillGroupSkillTargetID
Identifies the skill group the event is associated 
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.
int
FK, NULL
ICRCallKey
A unique number generated at the PG. Values are 
reused after about 250 million calls.
int
NULL
PeripheralCallKey
Key assigned by the peripheral to the call associated 
with the event.
int
NULL
RecoveryKey
A value used internally by the ICM software to track 
virtual time.
float
AK1, NOT 
NULL
Direction
The direction for talking states. 
int
NULL