Jump to: navigation, search

Core Fact Tables

The iWD Data Mart contains the following groups of fine-grained facts:

Each group of facts includes intraday tables, historical tables, and blended views. Each entity within the group holds two types of fields:

  • Foreign keys that join each of the table’s records to appropriate values in dimension tables.
  • Measures that provide individual facts about the tasks, such as the number of seconds that an agent worked on task.

Each section illustrates the star schemas, or subject areas, that support the core tables and views and provides a data dictionary that lists the data types of each column for the MySQL relational database management system (RDBMS).

This page was last edited on February 24, 2015, at 17:50.
Comments or questions about this documentation? Contact us for support!