Page History

...

Partitions records only for which an AcdStatisticsPartB record exists, and for which it is not a group transfer or group overflow.

The condition used is:

( AcdStatisticsPartB.ID IS NOT NULL ) AND ( AcdStatisticsPartB.AcdOriginGroupsID IS NULL )

Queue_* Fields

Further partitions records which have entered the ACD, only calls which enter the queue.

The additional condition used is:

( AcdStatisticsPartB.dtQueueStart IS NOT NULL )

Queue_Serviced_* Fields

Further partition on calls which entered the queue, only calls answered by an agent are considered. The condition used is:

The additional condition used is:

( StatisticsPartA.dtCallConnect IS NOT NULL ) AND ( AcdStatisticsPartB.dtAgentConnect IS NOT NULL )

Queue_NotServiced_* Fields

Further partition on calls which entered the queue, only calls not answered by an agent are considered. The condition used is:

( StatisticsPartA.dtCallConnect IS NOT NULL ) AND ( AcdStatisticsPartB.dtAgentConnect IS NULL )

AgentCalls_*, GroupTransfer_*, AgentTransfer_*, NumberTransfer_* Fields

Only records for which:

StatisticsPartB.ID IS NOT NULL

...