Cisco Cisco IP Contact Center Release 4.6.1 Technical References
index_keys
index_description
index_name
SkillGroupSkillTargetID,
AgentSkillTargetID
AgentSkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKSkill_Group_Members
Fields in Skill_Group_Member Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, FK, IE-1 NOT NULL
DBINT
The agent’s SkillTargetID value.
AgentSkillTargetID
PK, FK NOT NULL
DBINT
The skill group’s SkillTargetID value.
SkillGroupSkillTargetID
Skill_Group_Real_Time Table
This table is in the
. To see database rules for these tables, click
Local database only. Contains real time information about each skill group.
The ICM software generates a Skill_Group_Real_Time record for each skill group.
Related table
(via SkillTargetID)
Table 198: Indexes for Skill_Group_Real_Time Table
index_keys
index_description
index_name
SkillTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKSkill_Group_Real_Time
Fields in Skill_Group_Real_Time Table:
Keys
and Null
Option:
and Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The total handle time, in seconds, for outbound ACD
calls associated with this skill group that ended during
calls associated with this skill group that ended during
AgentOutCallsTimeTo5
the rolling five-minute interval. Handle time includes
WorkTime, TalkTime, and HoldTime. The
AgentOutCallsTime value includes the time spent from
the call being initiated by the agent to the time the agent
completes after-call work time for the call. The value
is updated in the database when the after-call work time
associated with the call (if any) is completed.
WorkTime, TalkTime, and HoldTime. The
AgentOutCallsTime value includes the time spent from
the call being initiated by the agent to the time the agent
completes after-call work time for the call. The value
is updated in the database when the after-call work time
associated with the call (if any) is completed.
NULL
DBINT
The total number of outbound ACD calls associated
with this skill group that ended during the current
with this skill group that ended during the current
AgentOutCallsTo5
fi
ve-minute interval. The value is updated in the
database when the after-call work time associated with
the call (if any) is completed.
the call (if any) is completed.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
335
Chapter 2: All Tables
Skill_Group_Real_Time Table