Cisco Cisco IPCC Web Option Technical References

NULL

DBINT

Number of calls currently queued for the agent at the CallRouter.

RouterCallsQueueNow

NULL

DBDATETIME

The time when the longest call in queue was queued for the agent.

RouterLongestCallQ

NULL

DBINT

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.

NULL

DBINT

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

. To see database rules for these tables, click

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)