Report Dump

The Report Dump consists of three packages: an Adherence Dump, a lightweight version of the Adherence Dump, and a Timeoff Dump.

  • The Adherence Report Dump is mainly for the Adherence and Staffing Reports. But it can also affect other reports (some Time Off Reports). Basically, it affects any report (or ad hoc model) that uses the PLANNEDEVENTTIMELINE, ACTUALEVENTTIMELINE, or ADHERENCEEXCEPTIONS tables. A specific adapter is assigned to this data dump. By default, the Report Dump software retrieves data for the last 30 days. This setting can be modified.

    The Adherence Report Dump software is installed by default. It has two main functions for Workforce Management:

    1. It converts Planned and Actual Event data to a timeline, so the data can be queried more easily by report writers. (Writing queries on hierarchical events is possible, but difficult and time-consuming.)

    2. It computes the adherence Measure used in Workforce Management (WFM) to determine how well an employee’s scheduled activities match their actual, real-time activities. timeline. The adherence timeline calculation is complex and cannot be performed within a query.

  • The lightweight Adherence Report Dump is also for Adherence and Staffing reports. The lightweight dump focuses on a smaller set of data than the Adherence Report Dump and so can be run multiple times a day. The maximum amount of time the software can retrieve data for is the last 7 days.

  • The Time Off Report Dump is only for the two Time Off Summary reports. It dumps the Used, Scheduled, Remaining, Carryover, and Pending hours into the EMPLOYEETIMEOFFALLOTMENT table for Time Off Summary reports. A specific adapter is assigned to this data dump. By default, the Report Dump software retrieves data for the last 30 days. This setting can be modified.