/mcpTable 20: Indexes for Agent_Skill_Group_Interval Table index_keys index_description index_name DateTime, SkillTargetID, SkillGroupSkillTargetID, PrecisionQueueID, Timezone Primary key XPKAgent_Skill_Group_Interval RecoveryKey Unique key XAK1Agent_Skill_Group_Interval DbDateTime Inversion key XIE1Agent_Skill_Group_Interval Table 21: Fields in Agent_Skill_Group_Interval Table Keys and NULL Option Data Type Description Name NULL DBINT During the reporting interval, the total number of Outgoing calls that were abandoned while on hold. AbandonHoldOutCalls NULL DBINT During the reporting interval, the total number of ACD calls that abandoned while ringing at an agent position. The value is incremented at the time the call disconnects. AbandonRingCalls NULL DBINT During the reporting interval, the 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 counted at the time the call disconnects, and the database is updated every reporting. AbandonRingTime NULL DBINT During the reporting interval, the total number of ACD calls that were abandoned while being held at an agent position. This value is counted at the time the call disconnects, and the database is updated every reporting. AbandonHoldCalls NULL DBINT The total handle time, in seconds, for outbound ACD calls handled by an agent associated with this skill group that ended during the reporting interval. Handle time includes WorkTime, TalkTime, and HoldTime. The AgentOutCallsTime value includes the time spent from the call being initiated by the agent to the time the agent completes after-call work time for the call. The value is counted when the after-call work time associated with the call is completed, and the database is updated for every reporting. AgentOutCallsTime Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 49 All Tables Agent_Skill_Group_Interval