/mcpKeys and NULL Option Data Type Description Name YES DBINT The number of calls associated with this skill group that the Central Controller routed. This field is incremented for calls sent to skill group or service and it is incremented in the following ways: Skill Group: The Router increments this field when the call is routed or queued to a skill group. Service: The Router increments this field using the agent real time data when the call is answered, or using TCD when the agent abandons the call. CallsOfferedRouted YES DBINT Calls offered to a skill group that the Router did not route. It happens in TDM and PG Gateway deployments where the ACD routes the call to a Skill Group different from the original routed Skill Group. CallsOfferedNotRouted YES DBINT The number of calls placed on hold at least once for the call type associated with the skill group during the reporting interval. CallsOnHold PK1, NOT NULL DBSMALLDATE The Central Controller date and time at the start of the interval when the row was generated. DateTime IE1, YES DBDATETIME The current date and time stamp when the records are written to the HDS database. The logger database has NULL for this column. DbDateTime YES DBINT For the reporting interval, the total time spent by all calls for this call type associated with this skill group that abandoned at the agent's desktop before being answered. This time is not reset if the CallType changes. Does not include short calls. DelayAgentAbandTime YES DBINT The total time spend by all calls associated with this skill group for this call type that abandoned while in the queue, for this reporting interval. DelayQAbandTime YES DBINT During the reporting interval, the number of calls associated with this skill group that resulted in an error condition. A few examples of error condition are: • CCE Script implementation is unable to find a target for the call due to any scripting or configuration error. • The system is unable to route the call to the identified Agent for any error in the network or device. • Calls with mis-configured labels do not use default routing; for example, when a route has not been defined. Translation-routed calls are abandoned while en route to destination target. Calls with mis-configured labels do not use default routing; for example, when a route has not been defined. See Router Error Codes for the complete list of RouterError codes. ErrorCount Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 135 All Tables Call_Type_SG_Interval