Jump to: navigation, search

Query examples

This topic provides examples for the three types of queries that are used in the Workforce Management (WFM) ETL Database schema.

Adherence queries

Agent Adherence Totals Query (Daily Granularity) Show query.. [+]
Team Adherence Totals Query (Daily Granularity) Show query.. [+]

Schedule Queries

Schedule States Query Show query.. [+]
Agent Schedule State Totals Query Show query.. [+]
Team Schedule State Totals Query Show query.. [+]
Schedule Marked Time Report Query Show query.. [+]
Schedule Marked Time Totals Query (Daily Granularity) Show query.. [+]
Schedule Marked Time Totals Query (Time Step Granularity) Show query.. [+]
Weekly Schedule Report Query Show query.. [+]
Schedule State Group (SSG) Totals Query Show query.. [+]
Activity Schedule Coverage Query Show query.. [+]

Performance Statistics Queries

Schedule Daily Summary for Activity Show query.. [+]
Schedule Daily Summary for Multi-Site Activity (MSA) Show query.. [+]
Schedule Daily Summary for Activity Group (AG) Show query.. [+]
Schedule Daily Summary for Site Show query.. [+]
Schedule Intraday Summary for Activity Show query.. [+]
Schedule Intraday Summary for Activity Show query.. [+]
Schedule Intraday Summary for Multi-Site Activity (MSA) Show query.. [+]
Schedule Intraday Summary for Activity Group (AG) Show query.. [+]
Schedule Intraday Summary for Site Show query.. [+]
Contact Center Performance Report for Activity Show query.. [+]

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on August 10, 2017, at 05:39.