Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-21
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Agent_Skill_Group_Half_Hour Table
Agent_Skill_Group_Half_Hour Table
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.
of multiple skill groups, multiple Agent Skill Group Half Hour rows are created for that agent each
half-hour.
The ICM software generates an Agent_Skill_Group_Half_Hour records for each skill group member.
Table 2-17 Agent_Skill_Group_Half_Hour Table Constraints
Constraint
Field Name(s)
PK
DateTime
SkillGroupSkillTargetID
SkillTargetID
TimeZone
SkillGroupSkillTargetID
SkillTargetID
TimeZone
AK-1
RecoveryKey
FK
SkillGroupSkillTargetID
SkillTargetID
SkillTargetID
IE-1
DbDateTime
Table 2-18 Agent_Skill_Group_Half_Hour Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AbandonHoldCallsToHalf
Total number of ACD calls that were abandoned
while being held at an agent position. This value is
updated in the database at the time the call
disconnects.
while being held at an agent position. This 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 that were abandoned
while ringing at an agent's position. The value is
updated in the database at the time the call
disconnects.
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 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.
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