Cisco Cisco IP Contact Center Release 4.6.1 Références techniques
•
(via SkillTargetID)
•
Table 21: Indexes for Agent_State_Trace Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Agent_State_Trace
DateTime, SkillTargetID, TimeZone,
MRDomainID
MRDomainID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKAgent_State_Trace
Fields in Agent_State_Trace Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
FK NULL
DBINT
The new agent state. To see the list of Agent States, click
AgentState
PK NOT NULL
DBDATETIME
The date and time at which the state change occurred.
DateTime
NULL
DBINT
The direction for talking states.
Direction
NOT NULL
DBINT
A code indicating the event that has occurred.
EventName
• 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
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
50
Chapter 2: All Tables
Agent_State_Trace Table