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 (Daily granularity) Show query.. [+]
Team Adherence Totals (Daily granularity) Show query.. [+]

Schedule Queries

Schedule States Show query.. [+]
Agent Schedule State Totals Show query.. [+]
Team Schedule State Totals Show query.. [+]
Schedule Marked Time Report Show query.. [+]
Schedule Marked Time Totals (Daily granularity) Show query.. [+]
Schedule Marked Time Totals (Timestep granularity) Show query.. [+]
Weekly Schedule Report Show query.. [+]
Schedule State Group (SSG) Totals Show query.. [+]
Activity Schedule Coverage 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 June 27, 2017, at 11:33.