Interval Workgroup Statistics Facts View

DQStatistics_viw View

Interval Workgroup Statistics Facts View

The fact table for the interval workgroup statistics. This comprises workgroup queue statistics data for the IWrkgrpQueueStats view. See IWrkgrpQueueStats for further information.

  • Last Changed Version - 17.4.0.0
  • Last Changed Reason - Added for data extraction from DQStatistics table.

Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
StatisticsSet int (4) False No

A unique identifier representing this row.

17.4.0.0 Added for data extraction from DQStatistics table.
nEnteredAcd int (4) False No

The number of ACD related queue interactions that entered this queue during the interval. An interaction is considered ACD related if it has been operated upon by any of the ACD interaction handling tools. nEnteredAcd includes interactions whose end condition is not yet determined. Any interactions that are not answered or abandoned in the current interval might be answered or might abandon in the next interval. An interaction is only counted as having entered once relative to this queue assignment.

17.4.0.0 Added for data extraction from DQStatistics table.
nAbandonedAcd int (4) False No

The number of ACD related queue interactions that abandoned this queue during the interval. Interactions that transfer from one to another distribution queue where no agent ever answers the interaction in the first distribution queue will not show up in nAbandonedACD or nTransferACD. They will only show in nFlowOutAcd. See the section in the Interval Queue Data summary section earlier in this document for more information on abandons.

17.4.0.0 Added for data extraction from DQStatistics table.
nGrabbedAcd int (4) False No

This value is not currently supported.

17.4.0.0 Added for data extraction from DQStatistics table.
nLocalDisconnectAcd int (4) False No

Number of ACD queue interactions that were disconnected locally. A local disconnect is defined as a disconnect by a CIC agent/user or the CIC system. A remote disconnect comes from the external party or phone company.

17.4.0.0 Added for data extraction from DQStatistics table.
nLocalDisconnectAgentAlertAcd int (4) False No

The same as nLocalDisconnectAcd but only for those interactions that were alerting in an agent queue while being locally disconnected.

17.4.0.0 Added for data extraction from DQStatistics table.
nLocalDisconnectAgentAcd int (4) False No

The same as nLocalDisconnectAcd but only for those interactions that were in an agent queue while being locally disconnected.

17.4.0.0 Added for data extraction from DQStatistics table.
nAlertedAcd int (4) False No

Number of ACD related queue interactions that were in an 'Alerting' state while in this queue (interactions which transition to 'Alerting' more than once are only counted once).

17.4.0.0 Added for data extraction from DQStatistics table.
nAnsweredAcd int (4) False No

Number of ACD related queue interactions that were answered by agents that were members of this queue. Answered interactions are interactions that reached a 'Client_Connected' state with an agent. An interaction is only counted as answered once relative to this queue assignment. If the interaction is transferred to another agent within the same distribution queue and is answered by another agent, it is still only counted once. Voice mail interactions are considered abandons and do not count towards nAnsweredAcd. This value can exceed nEnteredACD for a distribution queue because interactions can enter the queue in the previous interval and be answered in the current interval.

17.4.0.0 Added for data extraction from DQStatistics table.
nAnswered int (4) False No

Number of all interactions (ACD and non-ACD) that were answered by the agents that were members of this queue. Answered interactions are interactions that reached a 'Client_Connected' state with an agent. See nAnsweredAcd for more information.

17.4.0.0 Added for data extraction from DQStatistics table.
nAcdSvcLvl int (4) False No

Number of seconds in the first service level. For more information, see the description of service levels in the Interval Queue Data summary section above.

17.4.0.0 Added for data extraction from DQStatistics table.
nAnsweredAcdSvcLvl int (4) False No

The number of ACD interactions answered in the target service level. This column does not usually apply for agents.

17.4.0.0 Added for data extraction from DQStatistics table.
nAnsweredAcdSvcLvl1 int (4) False No

Number of ACD interactions answered in first service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
nAnsweredAcdSvcLvl2 int (4) False No

Number of ACD interactions answered in second service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
nAnsweredAcdSvcLvl3 int (4) False No

Number of ACD interactions answered in third service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
nAnsweredAcdSvcLvl4 int (4) False No

Number of ACD interactions answered in fourth service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
nAnsweredAcdSvcLvl5 int (4) False No

Number of ACD interactions answered in fifth service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
nAnsweredAcdSvcLvl6 int (4) False No

Number of ACD interactions answered in sixth service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
nAbandonAcdSvcLvl int (4) False No

The number of ACD interactions abandoned in the target service level. This column does not usually apply for agents.

17.4.0.0 Added for data extraction from DQStatistics table.
nAbandonAcdSvcLvl1 int (4) False No

Number of ACD interactions abandoned in first service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
nAbandonAcdSvcLvl2 int (4) False No

Number of ACD interactions abandoned in second service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
nAbandonAcdSvcLvl3 int (4) False No

Number of ACD interactions abandoned in third service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
nAbandonAcdSvcLvl4 int (4) False No

Number of ACD interactions abandoned in fourth service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
nAbandonAcdSvcLvl5 int (4) False No

Number of ACD interactions abandoned in fifth service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
nAbandonAcdSvcLvl6 int (4) False No

Number of ACD interactions abandoned in sixth service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
tGrabbedAcd int (4) False No

This value is not currently supported.

17.4.0.0 Added for data extraction from DQStatistics table.
tAnsweredAcd int (4) False No

The sum of the time, in seconds, of all ACD interactions that were in queue before entering 'Client_Connected' state. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue.

17.4.0.0 Added for data extraction from DQStatistics table.
mtAnsweredAcd int (4) False No

The maximum time, in seconds, an ACD interaction was in the queue before entering a 'Client_Connected' state. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue.

17.4.0.0 Added for data extraction from DQStatistics table.
tAbandonedAcd int (4) False No

The sum of the time, in seconds, all abandoned ACD interactions were in queue before they abandoned during this interval. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue.

17.4.0.0 Added for data extraction from DQStatistics table.
tTalkAcd int (4) False No

The sum of the time, in seconds, all ACD interactions spent from when they first entered a 'Client_Connected' state until the time the ACD interactions went inactive or flowed out of the queue. It is possible to have talk time appear in an interval without having any new ACD interactions for that interval. The time comes from ACD interactions that connected in that interval. Interactions might have entered the queue in the previous interval.

It is possible to have talk time on a chat. Think of tTalkAcd as the time an interaction is active with an agent.

Note: tTalkACD is the time an interaction is active with an agent, including any Hold time with the agent during the interaction.

17.4.0.0 Added for data extraction from DQStatistics table.
tTalkCompleteAcd int (4) False No

Counts the total talk time of a call in the period in which it completed, unlike tTalkAcd which counts the talk time for each period it is counted in.

17.4.0.0 Added for data extraction from DQStatistics table.
nHoldAcd int (4) False No

Number of ACD related interactions that were placed on hold while in this queue.

17.4.0.0 Added for data extraction from DQStatistics table.
tHoldAcd int (4) False No

The sum of the time, in seconds, all ACD interactions spent on hold while in this queue.

17.4.0.0 Added for data extraction from DQStatistics table.
nSuspendedAcd int (4) False No

For future changes.

17.4.0.0 Added for data extraction from DQStatistics table.
tSuspendedAcd int (4) False No

For future changes.

17.4.0.0 Added for data extraction from DQStatistics table.
nHeldSpanAcd int (4) False No

For future changes.

17.4.0.0 Added for data extraction from DQStatistics table.
nAcw int (4) False No

Counts the number of ACW sessions completed in the given period except manually initiated ACW sessions.

17.4.0.0 Added for data extraction from DQStatistics table.
tAcw int (4) False No

The sum of the time, in seconds, agents spent in an After Call Work status (also known as wrap up time). The count starts when an interaction goes inactive (usually due to a local or remote disconnect) and ends when the agent leaves the 'After Call Work' status. This value may or may not include non-ACD interactions depending on how the statuses are setup.

Note: tACW is the time in follow-up that is directly associated with an interaction. Follow-up without an ACD interaction (agent selected with no previously disconnected ACD interaction) will not be in tACW. The tACW value will only be recorded in rows of queue statistics directly associated with the interaction. It will not be in any other workgroup, media type, or skill associated rows.

17.4.0.0 Added for data extraction from DQStatistics table.
tAcwComplete int (4) False No

Counts the total ACW Time for the completed ACW sessions. This includes the total time for each session even if it spanned multiple statistic intervals.

17.4.0.0 Added for data extraction from DQStatistics table.
nExternToInternCalls int (4) False No

Number of interactions, ACD and non-ACD, originating from external locations and connecting to internal extensions. Calls that leave a queue without a connect or disconnect event, also called flowouts, will not be counted in this statistic.

17.4.0.0 Added for data extraction from DQStatistics table.
nExternToInternAcdCalls int (4) False No

Number of ACD interactions from external locations to internal extensions. Calls that leave a queue without a connect or disconnect event, also called flowouts, will not be counted in this statistic.

17.4.0.0 Added for data extraction from DQStatistics table.
nInternToExternCalls int (4) False No

Number of all interactions from internal extension to external locations. If a call does not connect to a remote system (for example, Insufficient Dialing Privileges), it will not count toward this statistic.

17.4.0.0 Added for data extraction from DQStatistics table.
nInternToExternAcdCalls int (4) False No

Number of ACD interactions from internal extension to external locations. If a call does not connect to a remote system (for example, Insufficient Dialing Privileges), it will not count toward this statistic.

17.4.0.0 Added for data extraction from DQStatistics table.
nInternToInternCalls int (4) False No

Number of all interactions from internal extensions to internal extensions. Internal to internal calls are counted as inbound calls whether the agent placed or received the call because CIC has no way of determining the direction of internal calls.

17.4.0.0 Added for data extraction from DQStatistics table.
nInternToInternAcdCalls int (4) False No

Number of ACD interactions from internal extensions to internal extensions. This includes ACD Calls transferred between agents in the same distribution queue. Both agents are credited with the ACD call. Calls that leave a queue without a connect or disconnect event, also called flowouts, will not be counted in this statistic.

17.4.0.0 Added for data extraction from DQStatistics table.
tExternToInternCalls int (4) False No

Sum of seconds for all interactions from external locations to internal extensions.

17.4.0.0 Added for data extraction from DQStatistics table.
tExternToInternAcdCalls int (4) False No

Sum of seconds for ACD interactions from external locations to internal extensions.

17.4.0.0 Added for data extraction from DQStatistics table.
tInternToExternCalls int (4) False No

Sum of seconds for all interactions from internal extensions to external locations.

17.4.0.0 Added for data extraction from DQStatistics table.
tInternToExternAcdCalls int (4) False No

Sum of seconds for ACD interactions from internal extensions to external locations.

17.4.0.0 Added for data extraction from DQStatistics table.
tInternToInternCalls int (4) False No

Sum of seconds for all interactions from internal extensions to internal extensions.

17.4.0.0 Added for data extraction from DQStatistics table.
tInternToInternAcdCalls int (4) False No

Sum of seconds for ACD interactions from internal extensions to internal extensions. This includes ACD Interactions transferred between agents in the same distribution queue. Both agents are credited with the ACD interaction.

17.4.0.0 Added for data extraction from DQStatistics table.
nAcwCalls int (4) False No

Number of outbound interactions made by agents during After Call Work time. If an agent places an interaction after handling an ACD interaction, that interaction, or any other interaction placed during the ACW time, is considered a nACWcall. nACWCall is also accumulated when an agent puts an ACD interaction on hold and places a consult call with another party. It is assumed that any call placed with an ACD interaction on hold is nACWCall activity.

CIC actually caches the last set of containers associated with the agent's last ACD interaction. This cache is reset any time the agent answers another ACD interaction. When CIC sees ACD or conditions on the agent that would count as an AcwCall, it processes the time and the count against the cached container list. It is done this way because the ACD interaction that made this association might actually be dead and gone from the system by the time the AcwCall event occurs.

17.4.0.0 Added for data extraction from DQStatistics table.
tAcwCalls int (4) False No

Sum of time, in seconds, the agent spent on outbound interactions during 'After Call Work' time. Also see nAcwCalls.

17.4.0.0 Added for data extraction from DQStatistics table.
nTransferedAcd int (4) False No

Number of ACD interactions transferred while on this queue. The destination could have been another agent in the same distribution queue, an agent outside of the distribution queue, or a call that was transferred from one workgroup queue to another workgroup queue by a user without being connected to a user.

Only set for Call interaction types.

17.4.0.0 Added for data extraction from DQStatistics table.
nNotAnsweredAcd int (4) False No

Number of ACD interactions that were not answered when presented to agents as an 'Alerting' interaction.

The nNotAnsweredAcd column is only incremented when an interaction that is presented to an agent as an 'Alerting' interaction is not answered and the interaction is removed from the queue without reaching an inactive state. For example, when a call enters a marketing queue and alerts agent1 and then agent--and neither agent answers the call--and agent3 is alerted and answers the call, nNotAnsweredAcd is incremented by 1 for agent1 and agent2, but is not incremented for agent3 and the marketing workgroup queue.

17.4.0.0 Added for data extraction from DQStatistics table.
tAlertedAcd int (4) False No

Sum of the time, in seconds, ACD interactions spent in an 'Alerting' state on agent queues. Also referred to as Ring time.

17.4.0.0 Added for data extraction from DQStatistics table.
nFlowOutAcd int (4) False No

The number of ACD interactions that flowed out during this interval. Flow outs are defined as queue interactions that were removed from a queue without reaching an inactive state. Queue interactions have an inactive state that is used to mark the interaction for deletion by the ACD subsystem after the interaction has either been answered or abandoned. The most common reason for an interaction to not reach an inactive state, and thus flow out, would be a queue interaction that is transferred. nNotAnsweredAcd interactions will also count towards nFlowOutAcd

17.4.0.0 Added for data extraction from DQStatistics table.
tFlowOutAcd int (4) False No

Sum of seconds ACD interactions were in queue before being counted in nFlowOutAcd. See nFlowOutAcd for more information. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue.

17.4.0.0 Added for data extraction from DQStatistics table.
nStartWaitAlertAcdCalls int (4) False No

Number of ACD interactions that were waiting to be answered or were alerting to be answered at the start of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
nStartActiveAcdCalls int (4) False No

Number of ACD interactions that were active with an agent at start of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
nStartHeldAcdCalls int (4) False No

Number of ACD interactions that were held at start of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
nEndWaitAlertAcdCalls int (4) False No

Number of ACD interactions that are waiting to be answered or were alerting to be answered at the end of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
nEndActiveAcdCalls int (4) False No

Number of ACD interactions that are active with an agent at the end of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
nEndHeldAcdCalls int (4) False No

Number of ACD interactions that are held at the end of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
nTransferWithinAcdCalls int (4) False No

Not implemented for this release.

17.4.0.0 Added for data extraction from DQStatistics table.
nTransferOutAcdCalls int (4) False No

Not implemented for this release.

17.4.0.0 Added for data extraction from DQStatistics table.
nDisconnectAcd int (4) False No

Number of ACD interactions that disconnected while still on the queue, or were transferred to another queue while connected to an agent. Interactions that abandon while in the queue are included, whereas interactions that leave the queue before being connected to an agent (flow outs) are not. The main utility of this value is in validating that all interactions that entered the queue were counted correctly.

17.4.0.0 Added for data extraction from DQStatistics table.
CustomValue1 int (4) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
CustomValue2 int (4) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
CustomValue3 int (4) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
CustomValue4 int (4) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
CustomValue5 int (4) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
CustomValue6 int (4) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
nSecuredIVR int (4) True No

Not currently implemented.

17.4.0.0 Added for data extraction from DQStatistics table.
tSecuredIVR int (4) True No

Not currently implemented.

17.4.0.0 Added for data extraction from DQStatistics table.
tAgentTalk int (4) True No

Sum of time, in seconds, the agent was on ACD interactions from first Client_Connected until end of ACW for this queue.

Note: tAgentTalk is tTalkACD + tACW, and should be thought of as tHandleTime.

17.4.0.0 Added for data extraction from DQStatistics table.
dIntervalStartUTC datetime (8) True No

Holds dIntervalStart time UTC.

17.4.0.0 Added for data extraction from DQStatistics table.
SiteId smallint (2) False No

Site identifier of the source for this record. Used in multi-site installations to distinguish the origin of the record. Configured when setting up CIC.

17.4.0.0 Added for data extraction from DQStatistics table.
Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
STATISTICSSET number (22) False No

A unique identifier representing this row.

17.4.0.0 Added for data extraction from DQStatistics table.
NENTEREDACD number (22) False No

The number of ACD related queue interactions that entered this queue during the interval. An interaction is considered ACD related if it has been operated upon by any of the ACD interaction handling tools. nEnteredAcd includes interactions whose end condition is not yet determined. Any interactions that are not answered or abandoned in the current interval might be answered or might abandon in the next interval. An interaction is only counted as having entered once relative to this queue assignment.

17.4.0.0 Added for data extraction from DQStatistics table.
NABANDONEDACD number (22) False No

The number of ACD related queue interactions that abandoned this queue during the interval. Interactions that transfer from one to another distribution queue where no agent ever answers the interaction in the first distribution queue will not show up in nAbandonedACD or nTransferACD. They will only show in nFlowOutAcd. See the section in the Interval Queue Data summary section earlier in this document for more information on abandons.

17.4.0.0 Added for data extraction from DQStatistics table.
NGRABBEDACD number (22) False No

This value is not currently supported.

17.4.0.0 Added for data extraction from DQStatistics table.
NLOCALDISCONNECTACD number (22) False No

Number of ACD queue interactions that were disconnected locally. A local disconnect is defined as a disconnect by a CIC agent/user or the CIC system. A remote disconnect comes from the external party or phone company.

17.4.0.0 Added for data extraction from DQStatistics table.
NLOCALDISCONNECTAGENTALERTACD number (22) False No

The same as nLocalDisconnectAcd but only for those interactions that were alerting in an agent queue while being locally disconnected.

17.4.0.0 Added for data extraction from DQStatistics table.
NLOCALDISCONNECTAGENTACD number (22) False No

The same as nLocalDisconnectAcd but only for those interactions that were in an agent queue while being locally disconnected.

17.4.0.0 Added for data extraction from DQStatistics table.
NALERTEDACD number (22) False No

Number of ACD related queue interactions that were in an 'Alerting' state while in this queue (interactions which transition to 'Alerting' more than once are only counted once).

17.4.0.0 Added for data extraction from DQStatistics table.
NANSWEREDACD number (22) False No

Number of ACD related queue interactions that were answered by agents that were members of this queue. Answered interactions are interactions that reached a 'Client_Connected' state with an agent. An interaction is only counted as answered once relative to this queue assignment. If the interaction is transferred to another agent within the same distribution queue and is answered by another agent, it is still only counted once. Voice mail interactions are considered abandons and do not count towards nAnsweredAcd. This value can exceed nEnteredACD for a distribution queue because interactions can enter the queue in the previous interval and be answered in the current interval.

17.4.0.0 Added for data extraction from DQStatistics table.
NANSWERED number (22) False No

Number of all interactions (ACD and non-ACD) that were answered by the agents that were members of this queue. Answered interactions are interactions that reached a 'Client_Connected' state with an agent. See nAnsweredAcd for more information.

17.4.0.0 Added for data extraction from DQStatistics table.
NACDSVCLVL number (22) False No

Number of seconds in the first service level. For more information, see the description of service levels in the Interval Queue Data summary section above.

17.4.0.0 Added for data extraction from DQStatistics table.
NANSWEREDACDSVCLVL number (22) False No

The number of ACD interactions answered in the target service level. This column does not usually apply for agents.

17.4.0.0 Added for data extraction from DQStatistics table.
NANSWEREDACDSVCLVL1 number (22) False No

Number of ACD interactions answered in first service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
NANSWEREDACDSVCLVL2 number (22) False No

Number of ACD interactions answered in second service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
NANSWEREDACDSVCLVL3 number (22) False No

Number of ACD interactions answered in third service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
NANSWEREDACDSVCLVL4 number (22) False No

Number of ACD interactions answered in fourth service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
NANSWEREDACDSVCLVL5 number (22) False No

Number of ACD interactions answered in fifth service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
NANSWEREDACDSVCLVL6 number (22) False No

Number of ACD interactions answered in sixth service level. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue. For more information, see the description of service levels in the Interval Queue Data summary section earlier in this document.

17.4.0.0 Added for data extraction from DQStatistics table.
NABANDONACDSVCLVL number (22) False No

The number of ACD interactions abandoned in the target service level. This column does not usually apply for agents.

17.4.0.0 Added for data extraction from DQStatistics table.
NABANDONACDSVCLVL1 number (22) False No

Number of ACD interactions abandoned in first service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
NABANDONACDSVCLVL2 number (22) False No

Number of ACD interactions abandoned in second service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
NABANDONACDSVCLVL3 number (22) False No

Number of ACD interactions abandoned in third service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
NABANDONACDSVCLVL4 number (22) False No

Number of ACD interactions abandoned in fourth service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
NABANDONACDSVCLVL5 number (22) False No

Number of ACD interactions abandoned in fifth service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
NABANDONACDSVCLVL6 number (22) False No

Number of ACD interactions abandoned in sixth service level. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue. For more information, see the description of service levels and abandoned interactions in the Interval Queue Data summary section.

17.4.0.0 Added for data extraction from DQStatistics table.
TGRABBEDACD number (22) False No

This value is not currently supported.

17.4.0.0 Added for data extraction from DQStatistics table.
TANSWEREDACD number (22) False No

The sum of the time, in seconds, of all ACD interactions that were in queue before entering 'Client_Connected' state. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue.

17.4.0.0 Added for data extraction from DQStatistics table.
MTANSWEREDACD number (22) False No

The maximum time, in seconds, an ACD interaction was in the queue before entering a 'Client_Connected' state. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue.

17.4.0.0 Added for data extraction from DQStatistics table.
TABANDONEDACD number (22) False No

The sum of the time, in seconds, all abandoned ACD interactions were in queue before they abandoned during this interval. The time tracked begins from the point the interaction becomes an ACD interaction, which is not necessarily the same as when it enters the queue.

17.4.0.0 Added for data extraction from DQStatistics table.
TTALKACD number (22) False No

The sum of the time, in seconds, all ACD interactions spent from when they first entered a 'Client_Connected' state until the time the ACD interactions went inactive or flowed out of the queue. It is possible to have talk time appear in an interval without having any new ACD interactions for that interval. The time comes from ACD interactions that connected in that interval. Interactions might have entered the queue in the previous interval.

It is possible to have talk time on a chat. Think of tTalkAcd as the time an interaction is active with an agent.

Note: tTalkACD is the time an interaction is active with an agent, including any Hold time with the agent during the interaction.

17.4.0.0 Added for data extraction from DQStatistics table.
TTALKCOMPLETEACD number (22) False No

Counts the total talk time of a call in the period in which it completed, unlike tTalkAcd which counts the talk time for each period it is counted in.

17.4.0.0 Added for data extraction from DQStatistics table.
NHOLDACD number (22) False No

Number of ACD related interactions that were placed on hold while in this queue.

17.4.0.0 Added for data extraction from DQStatistics table.
THOLDACD number (22) False No

The sum of the time, in seconds, all ACD interactions spent on hold while in this queue.

17.4.0.0 Added for data extraction from DQStatistics table.
NSUSPENDEDACD number (22) False No

For future changes.

17.4.0.0 Added for data extraction from DQStatistics table.
TSUSPENDEDACD number (22) False No

For future changes.

17.4.0.0 Added for data extraction from DQStatistics table.
NHELDSPANACD number (22) False No

For future changes.

17.4.0.0 Added for data extraction from DQStatistics table.
NACW number (22) False No

Counts the number of ACW sessions completed in the given period except manually initiated ACW sessions.

17.4.0.0 Added for data extraction from DQStatistics table.
TACW number (22) False No

The sum of the time, in seconds, agents spent in an After Call Work status (also known as wrap up time). The count starts when an interaction goes inactive (usually due to a local or remote disconnect) and ends when the agent leaves the 'After Call Work' status. This value may or may not include non-ACD interactions depending on how the statuses are setup.

Note: tACW is the time in follow-up that is directly associated with an interaction. Follow-up without an ACD interaction (agent selected with no previously disconnected ACD interaction) will not be in tACW. The tACW value will only be recorded in rows of queue statistics directly associated with the interaction. It will not be in any other workgroup, media type, or skill associated rows.

17.4.0.0 Added for data extraction from DQStatistics table.
TACWCOMPLETE number (22) False No

Counts the total ACW Time for the completed ACW sessions. This includes the total time for each session even if it spanned multiple statistic intervals.

17.4.0.0 Added for data extraction from DQStatistics table.
NEXTERNTOINTERNCALLS number (22) False No

Number of interactions, ACD and non-ACD, originating from external locations and connecting to internal extensions. Calls that leave a queue without a connect or disconnect event, also called flowouts, will not be counted in this statistic.

17.4.0.0 Added for data extraction from DQStatistics table.
NEXTERNTOINTERNACDCALLS number (22) False No

Number of ACD interactions from external locations to internal extensions. Calls that leave a queue without a connect or disconnect event, also called flowouts, will not be counted in this statistic.

17.4.0.0 Added for data extraction from DQStatistics table.
NINTERNTOEXTERNCALLS number (22) False No

Number of all interactions from internal extension to external locations. If a call does not connect to a remote system (for example, Insufficient Dialing Privileges), it will not count toward this statistic.

17.4.0.0 Added for data extraction from DQStatistics table.
NINTERNTOEXTERNACDCALLS number (22) False No

Number of ACD interactions from internal extension to external locations. If a call does not connect to a remote system (for example, Insufficient Dialing Privileges), it will not count toward this statistic.

17.4.0.0 Added for data extraction from DQStatistics table.
NINTERNTOINTERNCALLS number (22) False No

Number of all interactions from internal extensions to internal extensions. Internal to internal calls are counted as inbound calls whether the agent placed or received the call because CIC has no way of determining the direction of internal calls.

17.4.0.0 Added for data extraction from DQStatistics table.
NINTERNTOINTERNACDCALLS number (22) False No

Number of ACD interactions from internal extensions to internal extensions. This includes ACD Calls transferred between agents in the same distribution queue. Both agents are credited with the ACD call. Calls that leave a queue without a connect or disconnect event, also called flowouts, will not be counted in this statistic.

17.4.0.0 Added for data extraction from DQStatistics table.
TEXTERNTOINTERNCALLS number (22) False No

Sum of seconds for all interactions from external locations to internal extensions.

17.4.0.0 Added for data extraction from DQStatistics table.
TEXTERNTOINTERNACDCALLS number (22) False No

Sum of seconds for ACD interactions from external locations to internal extensions.

17.4.0.0 Added for data extraction from DQStatistics table.
TINTERNTOEXTERNCALLS number (22) False No

Sum of seconds for all interactions from internal extensions to external locations.

17.4.0.0 Added for data extraction from DQStatistics table.
TINTERNTOEXTERNACDCALLS number (22) False No

Sum of seconds for ACD interactions from internal extensions to external locations.

17.4.0.0 Added for data extraction from DQStatistics table.
TINTERNTOINTERNCALLS number (22) False No

Sum of seconds for all interactions from internal extensions to internal extensions.

17.4.0.0 Added for data extraction from DQStatistics table.
TINTERNTOINTERNACDCALLS number (22) False No

Sum of seconds for ACD interactions from internal extensions to internal extensions. This includes ACD Interactions transferred between agents in the same distribution queue. Both agents are credited with the ACD interaction.

17.4.0.0 Added for data extraction from DQStatistics table.
NACWCALLS number (22) False No

Number of outbound interactions made by agents during After Call Work time. If an agent places an interaction after handling an ACD interaction, that interaction, or any other interaction placed during the ACW time, is considered a nACWcall. nACWCall is also accumulated when an agent puts an ACD interaction on hold and places a consult call with another party. It is assumed that any call placed with an ACD interaction on hold is nACWCall activity.

CIC actually caches the last set of containers associated with the agent's last ACD interaction. This cache is reset any time the agent answers another ACD interaction. When CIC sees ACD or conditions on the agent that would count as an AcwCall, it processes the time and the count against the cached container list. It is done this way because the ACD interaction that made this association might actually be dead and gone from the system by the time the AcwCall event occurs.

17.4.0.0 Added for data extraction from DQStatistics table.
TACWCALLS number (22) False No

Sum of time, in seconds, the agent spent on outbound interactions during 'After Call Work' time. Also see nAcwCalls.

17.4.0.0 Added for data extraction from DQStatistics table.
NTRANSFEREDACD number (22) False No

Number of ACD interactions transferred while on this queue. The destination could have been another agent in the same distribution queue, an agent outside of the distribution queue, or a call that was transferred from one workgroup queue to another workgroup queue by a user without being connected to a user.

Only set for Call interaction types.

17.4.0.0 Added for data extraction from DQStatistics table.
NNOTANSWEREDACD number (22) False No

Number of ACD interactions that were not answered when presented to agents as an 'Alerting' interaction.

The nNotAnsweredAcd column is only incremented when an interaction that is presented to an agent as an 'Alerting' interaction is not answered and the interaction is removed from the queue without reaching an inactive state. For example, when a call enters a marketing queue and alerts agent1 and then agent--and neither agent answers the call--and agent3 is alerted and answers the call, nNotAnsweredAcd is incremented by 1 for agent1 and agent2, but is not incremented for agent3 and the marketing workgroup queue.

17.4.0.0 Added for data extraction from DQStatistics table.
TALERTEDACD number (22) False No

Sum of the time, in seconds, ACD interactions spent in an 'Alerting' state on agent queues. Also referred to as Ring time.

17.4.0.0 Added for data extraction from DQStatistics table.
NFLOWOUTACD number (22) False No

The number of ACD interactions that flowed out during this interval. Flow outs are defined as queue interactions that were removed from a queue without reaching an inactive state. Queue interactions have an inactive state that is used to mark the interaction for deletion by the ACD subsystem after the interaction has either been answered or abandoned. The most common reason for an interaction to not reach an inactive state, and thus flow out, would be a queue interaction that is transferred. nNotAnsweredAcd interactions will also count towards nFlowOutAcd

17.4.0.0 Added for data extraction from DQStatistics table.
TFLOWOUTACD number (22) False No

Sum of seconds ACD interactions were in queue before being counted in nFlowOutAcd. See nFlowOutAcd for more information. The time tracked begins from the point the interaction becomes an ACD interaction; which is not necessarily the same as when it enters the queue.

17.4.0.0 Added for data extraction from DQStatistics table.
NSTARTWAITALERTACDCALLS number (22) False No

Number of ACD interactions that were waiting to be answered or were alerting to be answered at the start of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
NSTARTACTIVEACDCALLS number (22) False No

Number of ACD interactions that were active with an agent at start of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
NSTARTHELDACDCALLS number (22) False No

Number of ACD interactions that were held at start of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
NENDWAITALERTACDCALLS number (22) False No

Number of ACD interactions that are waiting to be answered or were alerting to be answered at the end of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
NENDACTIVEACDCALLS number (22) False No

Number of ACD interactions that are active with an agent at the end of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
NENDHELDACDCALLS number (22) False No

Number of ACD interactions that are held at the end of the interval.

17.4.0.0 Added for data extraction from DQStatistics table.
NTRANSFERWITHINACDCALLS number (22) False No

Not implemented for this release.

17.4.0.0 Added for data extraction from DQStatistics table.
NTRANSFEROUTACDCALLS number (22) False No

Not implemented for this release.

17.4.0.0 Added for data extraction from DQStatistics table.
NDISCONNECTACD number (22) False No

Number of ACD interactions that disconnected while still on the queue, or were transferred to another queue while connected to an agent. Interactions that abandon while in the queue are included, whereas interactions that leave the queue before being connected to an agent (flow outs) are not. The main utility of this value is in validating that all interactions that entered the queue were counted correctly.

17.4.0.0 Added for data extraction from DQStatistics table.
CUSTOMVALUE1 number (22) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
CUSTOMVALUE2 number (22) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
CUSTOMVALUE3 number (22) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
CUSTOMVALUE4 number (22) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
CUSTOMVALUE5 number (22) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
CUSTOMVALUE6 number (22) False No

Custom value for customer use.

17.4.0.0 Added for data extraction from DQStatistics table.
NSECUREDIVR number (22) True No

Not currently implemented.

17.4.0.0 Added for data extraction from DQStatistics table.
TSECUREDIVR number (22) True No

Not currently implemented.

17.4.0.0 Added for data extraction from DQStatistics table.
TAGENTTALK number (22) True No

Sum of time, in seconds, the agent was on ACD interactions from first Client_Connected until end of ACW for this queue.

Note: tAgentTalk is tTalkACD + tACW, and should be thought of as tHandleTime.

17.4.0.0 Added for data extraction from DQStatistics table.
DINTERVALSTARTUTC date (7) True No

Holds dIntervalStart time UTC.

17.4.0.0 Added for data extraction from DQStatistics table.
SITEID number (22) False No

Site identifier of the source for this record. Used in multi-site installations to distinguish the origin of the record. Configured when setting up CIC.

17.4.0.0 Added for data extraction from DQStatistics table.