Technical References

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
Skill Group Member (page 392) (SkillTargetID + SkillGroupSkillTargetID maps to
Skill_Group_Member.AgentSkillTargetID + Skill_Group_Member.SkillGroupSkillTargetID)
Table 16: Indexes for Agent_Skill_Group_Half_HourTable
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Agent_Skill_Group_Half_Hou
DbDateTimenonclustered located on PRIMARYXIE1Agent_Skill_Group_Half_Hou
DateTime, SkillTargetID,
SkillGroupSkillTargetID, TimeZone
clustered, unique, primary key
located on PRIMARY
XPKAgent_Skill_Group_Half_Hour
Fields in Agent_Skill_Group_Half_Hour Table :
Keys
and Null
Option:
Data Type:Description:Field Name:
NULLDBINT
During the half-hour interval, the total number of ACD calls that
were abandoned while being held at an agent position. This value is
AbandonHoldCallsToHalf
counted at the time the call disconnects, and the database is updated
every half hour.
NULLDBINT
During the half-hour interval, the total number of Outgoing calls that
were abandoned while on hold.
AbandonHoldOutCallsToHalf
NULLDBINT
During the half-hour interval, the total number of ACD calls that
abandoned while ringing at an agent’s position. The value is
incremented at the time the call disconnects.
AbandonRingCallsToHalf
NULLDBINT
During the half-hour interval, the total ring time associated with ACD
calls that were abandoned while alerting an agent's position. RingTime
AbandonRingTimeToHalf
occurs after any DelayTime and LocalQTime. The value is counted
at the time the call disconnects, and the database is updated every
half hour.
NULLDBINT
During the half-hour interval, the total number of seconds outbound
ACD calls were placed on hold by an agent associated with this skill
AgentOutCallsOnHoldTimeToHalf
group. This value updated in the database when after-call work
associated with the call (if any) is completed.
NULLDBINT
During the half-hour interval, the total number of outbound ACD
calls an agent associated with this skill group ended and that were
AgentOutCallsOnHoldToHalf
placed on hold at least once during the life of the call. The value is
counted when the after-call work associated with the call (if any) is
completed, and the database is updated every half hour.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
35
Chapter 2: All Tables
Agent_Skill_Group_Half_Hour Table