Schedule Quality

Technical Name: 0RC_C01_Q0006

Based on the InfoCube: 0RC_C01


This query evaluates the labor schedule. It highlights areas that are seriously overstaffed or understaffed. Overstaffing means that too many employees are scheduled compared to the expected activity load. Problems resulting from overstaffing include high payroll costs, employee boredom and employee theft. Understaffing is the opposite problem and means that a store has too few employees. Problems that result are poor customer service, poor store appearance and higher customer theft. Since a number of these areas are difficult to measure individually, this query can indicate where and when these problems are likely to arise.

This query is designed to identify how skilled the store user is in applying the SAP StaffWorks system or how well modeled the store is for scheduling. The query shows the relative number of edits and rule violations that store personnel are making with the software. Edits are manual overrides to the suggested schedule. High levels of edits indicate the user has a poorly staffed store, it is incorrectly modeled by the SAP StaffWorks system administrator or they are simply ignoring the suggestions. Stores with high numbers of edits typically stop using the software after a while since it simply takes too long to evaluate the schedule and make changes, especially in a big store. These stores should be provided with additional training, incentive or configuration services as soon as possible to enable them to use the software correctly.

Stores with low levels of overstaffing and understaffing are often the best-run stores with the best management team in charge. The report indicates proper staffing levels for all positions and expertise in using the SAP StaffWorks system.

Rule violations occur when a rule set up by the SAP StaffWorks system administrator or the user is broken. High numbers of rule violations indicate that the store needs more training, is poorly staffed or is not keeping up with the weekly maintenance required to make the product work successfully. Stores with high rule violations are also more likely to violate union or other legal rules set by the governing authority of the store. This can lead to financial penalties as well as high employee turnover situations. In these stores employees' contracts tend to be routinely broken and employees are more likely to leave the store or the company.

Reporting is usually done on a daily basis. Primary target groups for this report: field management, software administration.




No filter criteria have been preset for this query.

Free Characteristics




Fiscal year/period


Calendar day








Store type



0FISCPER enables users to navigate within the fiscal time periods covered by the system. As a rule, these periods are weeks or months, with week usually being used as fiscal period. The query always selects data of the current, the previous and the successive period.

Users can filter one or several fiscal periods by clicking 0FISCPER with the right mouse button and choosing Select filter value.



Description of the InfoObject (and restriction or calculation formula)







Description of the InfoObject (and restriction or calculation formula)

Schedule Effectiveness

The number of effective hours compared with the scheduled hours (minus the scheduled event hours) plus understaffed hours. This value is used as a general measure of schedule quality. A rating of zero would indicate the worst possible schedule where all shifts were scheduled outside the workload. A rating of 100 would indicate a perfect schedule with all shifts scheduled exactly within the workload.

Overstaffing Percentage

Percentage of scheduled overstaffed hours compared with the total number of scheduled hours (minus event hours, for example, spent in training or meetings). This will indicate whether the schedule effectiveness was most affected by too many or too few hours.

Understaffing Percentage

Percentage of scheduled hours understaffed compared with the total number of scheduled hours. This will indicate whether the schedule effectiveness was most affected by too many or too few hours.

Edits per 100 Scheduled Hours

Number of schedule days that have been manually edited per 100 scheduled hours

Rule Violations per 100 Scheduled Hours

Number of employees with rule violations counted towards the employees primary job per 100 scheduled hours