Technical References

Local database only. Each row in the table is for an agent/MRD pair currently logged in. For
example, if the agent was logged into three (3) MRDs, then the agent will have three (3) rows
in the table.
Table 13: Related tables for Agent_Real_Time
Device Target (page 155) (via NetworkTargetID)Agent (page 15) (via SkillTargetID)
Service (page 325) (ServiceSkillTargetID maps to
Service.SkillTargetID)
Media Routing Domain (page 234) (via MRDomainID)
Skill Group (page 364) (SkillGroupSkillTargetID maps to SkillGroup.SkillTargetID)
Table 14: Index - Agent_Real_Time Table
index_keysindex_descriptionindex_name
SkillTargetID, MRDomainIDclustered, unique, primary key
located on PRIMARY
XPKAgent_Real_Time
Fields in Agent_Real_Time Table :
Keys and
Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Reserved for future use.
AgentStatus
NULLDBINT
The current real time state of the agent with respect to this MRD.
AgentState
To see Agent State values, click here (page 465).
NULLDBINT
The agent’ s availability status with respect to the Media Routing Domain:
AvailableInMRD
• 0 = Not Available
• 1 = ICM Available
• 2 = Application Available
NULLDBINT
The number of tasks associated with this Media Routing Domain on
which this agent is currently working.
CallInProgress
NULLDBINT
The campaign ID for the campaign associated with this call. This field
is populated when the call is answered by an agent.
CampaignID
This field is applicable to Outbound Option only
NULLvarchar(32)
The account number of the caller with whom the agent is speaking. This
field is populated when the call is answered by an agent.
CustomerAccountNumber
This field is applicable to Outbound Option only.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
30
Chapter 2: All Tables
Agent_Real_Time Table