/mcpTable 412: Indexes for Skill_Group_Five_Minute Table index_keys index_description index_name RecoveryKey Nonclustered, unique, unique key located on PRIMARY XAK1Skill_Group_Five_Minute DateTime, SkillTargetID, TimeZone Clustered, unique, primary key located on PRIMARY XPKSkill_Group_Five_Minute Table 413: Fields in Skill_Group_Five_Minute Table Keys and NULL Option Data Type Description Name NULL DBINT Number of agents in group in the Available state at the end of the five-minute interval. Avail NULL DBINT The total time, in seconds, that agents in the skill group were in the Available state for any skill group during the five-minute interval. AvailTime is included in the calculation of LoggedOnTime. AvailTimeTo5 NULL DBINT Average talk time in seconds for calls counted as handled by the skill group during the five-minute window. This value is calculated as follows: HandledCallsTalkTimeTo5 / CallsHandledTo5 AvgHandledCallsTalkTime is calculated only for handled calls, which are calls that are finished (that is, any after-call work associated with the call has been completed). This field is updated in the database when any after-call work associated with the call is completed. AvgHandledCallsTalkTimeTo5 NULL DBINT Average talk time in seconds for calls counted as handled by the skill group during the five-minute window. This value is calculated as follows: HandledCallsTalkTimeTo5 / CallsHandledTo5 The AvgHandledCallsTime value is updated in the database when any after-call work time associated with the call is completed. AvgHandledCallsTimeTo5 NULL DBINT Number of agents in the BusyOther state at the end of the five-minute interval. BusyOther NULL DBINT Number of seconds agents spent in the BusyOther state during the five-minute window. BusyOtherTime is included in the calculation of LoggedOnTime. BusyOtherTimeTo5 Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 498 All Tables Skill_Group_Five_Minute