McDewey

Keys and NULL Option Data Type Description Name NULL DBINT ICM 5.x: Measures the cumulative time, in seconds, that the call spent queued at the local ACD and the time the call spent queued in the network VRU. ICM 6.x and 7.x: Measures only the cumulative time, in seconds, that the call spent queued at the local ACD. NetQTime (see below) measures the time that the call spends queued in the network VRU. Both: During its duration, a call can be queued to multiple answering resources (for example, a trunk, voice port, skill group, etc.). LocalQTime includes time that the call spent queued to any of these resources. LocalQTime does not include any DelayTime (before the call is queued), or RingTime (after the call leaves the queue). LocalQTime is a completed call time, not an agent state time. LocalQTime is used to calculate Duration in Termination_Call_Detail, and to calculate the following Service and Route values: • LongestCallDelayQTime • LongestCallAbandTime • DelayQAbandTime • DelayQTime • AnswerWaitTime LocalQTime is also used to calculate the AnswerWaitTime in the Skill Group and Agent Skill Group tables. LocalQTime NULL VARCHAR(128) Globally unique location identifier. LocationParamPKID NULL VARCHAR(50) Location name. LocationParamName FK NULL DBINT An identifier for the Media Routing Domain in the Unified ICM system configuration. MRDomainID NULL DBINT Represents the time that the call spent on Network Queue in the CallRouter. The LocalQTime field is used for local ACD queuing. NetQTime Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 577 All Tables Termination_Call_Detail