Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Administrative Workstation
  5. Technical References

Cisco Cisco Administrative Workstation Technical References

Download
Page of 404
 
2-10
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Agent_Real_Time Table
Related tables:
Agent (via SkillTargetID)
Device Target (via NetworkTargetID)
Media Routing Domain (via MRDomainID)
Agent_Real_Time Table 
Local database only.
Each row provides real-time statistics for an agent who is currently logged in. The ICM software 
generates an Agent_Real_Time record for each agent.
ReasonCode
Reason code returned by the peripheral for the agent 
logout.
int
NULL
NetworkTargetID
The device target the agent was logged on to. This 
applies for enterprise agents only.
int
FK, NULL
Table 2-6
Agent_Logout Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-7
Agent_Real_Time Table
Field Name
Description
Data Type
Keys and Null 
Option
SkillTargetID
Identifies the agent.
int
PK, FK, NOT 
NULL
MRDomainID
The identifier for the Media Routing Domain 
associated with this peripheral.
int
FK, NOT NULL
DateTime
The date and time when the row was generated.
datetime
NOT NULL
SkillGroupSkillTargetID
Identifies the skill group for the call the agent is 
currently working on.
int
NULL
ServiceSkillTargetID
Identifies the service for the call the agent is 
currently working on.
int
NULL
AgentState
The current real time state of the agent:
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
int
NULL