Cisco Cisco Administrative Workstation Technische Referenzen
2-11
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Agent_Real_Time Table
AgentState
(continued)
(continued)
10 = Call Held
11 = Call Retrieved
12 = Call Transferred
13 = Call Conferenced
14 = Unknown
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.
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:
supervisor assistance:
1 = Yes, the agent requested assistance.
0 = No, the agent did not request assistance.
0 = No, the agent did not request assistance.
int
NULL
Destination
Destination type of outbound call the agent is
currently working on:
currently working on:
0 = None
1 = ACD
2 = Direct
1 = ACD
2 = Direct
int
NULL
Direction
Direction of call agent is currently working on:
NULL = None
1 = In
2 =Out
3 = Other
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.
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.
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.
agent is speaking.
varchar(20)
NULL
CustomerAccountNumber
The account number of the caller with whom the
agent is speaking.
agent is speaking.
varchar(32)
NULL
CampaignID
The campaign ID for the campaign associated with
this call.
this call.
int
NULL
QueryRuleID
The query rule belonging to the campaign identified
by the CampaignID.
by the CampaignID.
int
NULL
Table 2-7
Agent_Real_Time Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option