Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Skill_Group_Half_Hour Table
This table is in the
. To see database rules for these tables, click
Central database only. Contains statistics about each skill group during the last 30-minute
interval.
interval.
The ICM generates Skill_Group_Half_Hour records for each skill group.
Related table
(via SkillTargetID)
Table 196: Indexes for Skill_Group_Half_Hour Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Skill_Group_Half_Hour
DbDateTime
nonclustered located on PRIMARY
XIE1Skill_Group_Half_Hour
DateTime, SkillTargetID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKSkill_Group_Half_Hour
Fields in Skill_Group_Half_Hour Table:
Keys
and
Null
Option:
and
Null
Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The number of outbound calls that abandon while
on hold. This will be reported by OPC.
on hold. This will be reported by OPC.
AbandonHoldCallsOutToHalf
NULL
DBINT
The total number of ACD calls to the skill group
that abandoned while being held at an agent’s
that abandoned while being held at an agent’s
AbandonHoldCallsToHalf
position. The value is counted at the time the call
disconnects, and the database is updated every half
hour.
disconnects, and the database is updated every half
hour.
NULL
DBINT
Total number of ACD calls to the skill group that
were abandoned while ringing at an agent's
were abandoned while ringing at an agent's
AbandonRingCallsToHalf
position. The value is counted at the time the call
disconnects, and the database is updated every half
hour.
disconnects, and the database is updated every half
hour.
NULL
DBINT
Total ring time associated with ACD calls to the
skill group that were abandoned while alerting an
skill group that were abandoned while alerting an
AbandonRingTimeToHalf
agent's position. RingTime occurs after any
DelayTime and LocalQTime. The value is counted
at the time the call disconnects, and the database
is updated every half hour.
DelayTime and LocalQTime. The value is counted
at the time the call disconnects, and the database
is updated every half hour.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
320
Chapter 2: - All Tables
Skill_Group_Half_Hour Table