Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Keys and
Null
Option:
Null
Option:
Data Type:
Description:
Field Name:
PK, FK
NOT
NULL
NOT
NULL
DBINT
Identifies the agent.
SkillTargetID
Agent_Skill_Group_Half_Hour Table
This table is in the
. 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.
member of multiple skill groups, multiple Agent Skill Group Half Hour rows are created for
that agent each half-hour.
The software generates an Agent_Skill_Group_Half_Hour records for each skill group member.
Table 15: Related Table for Agent_Skill_Group_Half_Hour
(SkillTargetID + SkillGroupSkillTargetID maps to
Skill_Group_Member.AgentSkillTargetID + Skill_Group_Member.SkillGroupSkillTargetID)
Table 16: Indexes for Agent_Skill_Group_Half_HourTable
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Agent_Skill_Group_Half_Hou
DbDateTime
nonclustered located on PRIMARY
XIE1Agent_Skill_Group_Half_Hou
DateTime, SkillTargetID,
SkillGroupSkillTargetID, TimeZone
SkillGroupSkillTargetID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKAgent_Skill_Group_Half_Hour
Fields in Agent_Skill_Group_Half_Hour Table :
Keys
and
Null
Option:
and
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
During the half-hour interval, the total number of
ACD calls that were abandoned while being held
ACD calls that were abandoned while being held
AbandonHoldCallsToHalf
at an agent position. This value is counted at the
time the call disconnects, and the database is
updated every half hour.
time the call disconnects, and the database is
updated every half hour.
NULL
DBINT
During the half-hour interval, the total number of
Outgoing calls that were abandoned while on hold.
Outgoing calls that were abandoned while on hold.
AbandonHoldOutCallsToHalf
NULL
DBINT
During the half-hour interval, the total number of
ACD calls that abandoned while ringing at an
ACD calls that abandoned while ringing at an
AbandonRingCallsToHalf
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
37
Chapter 2: All Tables
Agent_Skill_Group_Half_Hour Table