Cisco Cisco IPCC Web Option Technical References
2-361
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Skill_Group_Half_Hour Table
Skill_Group_Half_Hour Table
Central database only.
Contains statistics about each skill group during the last 30-minute interval.
The ICM generates Skill_Group_Half_Hour records for each skill group.
Table 2-359 Skill_Group_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
DateTime
SkillTargetID
TimeZone
SkillTargetID
TimeZone
AK-1
RecoveryKey
IE-1
DbDateTime
Table 2-360 Skill_Group_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AbandonHoldCallsToHalf
The total number of ACD calls to the skill group
that abandoned while being held at an agent’s
position. The value is updated in the database at
the time the call disconnects.
that abandoned while being held at an agent’s
position. The value is updated in the database at
the time the call disconnects.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
AbandonRingCallsToHalf
Total number of ACD calls to the skill group that
were abandoned while ringing at an agent's
position. The value is updated in the database at
the time the call disconnects.
were abandoned while ringing at an agent's
position. The value is updated in the database at
the time the call disconnects.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
AbandonRingTimeToHalf
Total ring time associated with ACD calls to the
skill group that were abandoned while alerting an
agent's position. RingTime occurs after any
DelayTime and LocalQTime. The value is updated
in the database at the time the call disconnects.
skill group that were abandoned while alerting an
agent's position. RingTime occurs after any
DelayTime and LocalQTime. The value is updated
in the database at the time the call disconnects.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL
AgentOutCallsOnHoldTimeToHalf
Total number of seconds outbound ACD calls
were placed on hold by agents associated with this
skill group. This value updated in the database
when after-call work associated with the call (if
any) is completed.
were placed on hold by agents associated with this
skill group. This value updated in the database
when after-call work associated with the call (if
any) is completed.
This field is applicable for both ICM and IPCC
Enterprise.
Enterprise.
DBINT
NULL