Technical References

Keys and
Null
Option:
Data Type:Description:Field Name:
NULLDBINT
Number of calls currently queued for the agent at the CallRouter.
RouterCallsQueueNow
NULLDBDATETIME
The time when the longest call in queue was queued for the agent.
RouterLongestCallQ
NULLDBINT
Identifies the service for the call the agent is currently working on.
ServiceSkillTargetID
If this agent is not working on a task in this MRD, this field is zero.
If the agent is working on only one task in this MRD, this field is the ID
of the service associated with that task.
If the agent is working on more than one task in this MRD, and at least
one of these tasks is ACTIVE, this field is the ID of the service associated
with one of those active tasks.
Otherwise, this field is the ID of the service associated with one of the
tasks the agent is working on.
NULLDBINT
Identifies the skill group for the call the agent is currently working on.
SkillGroupSkillTargetID
If this agent is not working on a task in this MRD, this field is zero.
If the agent is working on only one task in this MRD, this field is the ID
of the skill group associated with that task.
If the agent is working on more than one task in this MRD, and at least
one of these tasks is ACTIVE, this field is the ID of the skill group
associated with one of those active tasks.
Otherwise, this field is the ID of the skill group associated with one of
the tasks the agent is working on.
PK, FK NOT
NULL
DBINT
Identifies the agent.
SkillTargetID
Agent_Skill_Group_Half_Hour Table
This table is in the Skill Target category (page 456). To see database rules for these tables, click
here (page 510).
Central database only.
Each row provides half-hour statistics for a member of a skill group. If an individual agent is a
member of multiple skill groups, multiple Agent Skill Group Half Hour rows are created for
that agent each half-hour.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
34
Chapter 2: All Tables
Agent_Skill_Group_Half_Hour Table