Cisco Cisco IP Contact Center Release 4.6.2 Referências técnicas

Página de 404
 
2-11
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Agent_Real_Time Table
AgentState
(continued)
10  =  Call Held
11  =  Call Retrieved
12  =  Call Transferred
13  =  Call Conferenced
14  =  Unknown
int
NULL
ReasonCode
Code received from the peripheral indicating the 
reason for the agent’s last state change.
int
NULL
Extension
Extension the agent is currently working on.
varchar(32)
NULL
DateTimeLastStateChange
Date and time of the agent’s last state change.
datetime
NULL
DateTimeLogin
Date and time the agent logged on.
datetime
NULL
RequestedSupervisorAssist
Indicates whether the agent has requested 
supervisor assistance:
1 = Yes, the agent requested assistance.
0 = No, the agent did not request assistance.
int
NULL
Destination
Destination type of outbound call the agent is 
currently working on:
0 = None
1 = ACD
2 = Direct
int
NULL
Direction
Direction of call agent is currently working on:
NULL = None
1 = In
2 =Out
3 = Other
int
NULL
OnHold
Indicates whether the call is currently on hold: 
1 = Yes, the call is on hold.
0 = No, the call is not on hold.
int
NULL
NetworkTargetID
The device target the agent is logged on to. This 
applies for enterprise agents only.
int
FK, NULL
Agent Status
Reserved for future use.
int
NULL
CustomerPhoneNumber
The phone number of the caller with whom the 
agent is speaking.
varchar(20)
NULL
CustomerAccountNumber
The account number of the caller with whom the 
agent is speaking.
varchar(32)
NULL
CampaignID
The campaign ID for the campaign associated with 
this call.
int
NULL
QueryRuleID
The query rule belonging to the campaign identified 
by the CampaignID.
int
NULL
Table 2-7
Agent_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option