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.

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

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.. [+]

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 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.. [+]

This page was last edited on February 3, 2020, at 22:49.
Comments or questions about this documentation? Contact us for support!