The Actual vs. Scheduled Hours Report |
|
The following provides important information about the Actual vs. Scheduled Hours report.
[Not Specified] label — In the Worked / Non-Worked version of the report, a [Not Specified] label is displayed in the Earnings Code column in some instances. This label refers to hours for which no earnings code was entered for a time pair. This label usually refers to regular time or overtime hours.
Schedule Data — You can only view schedule data in the Actual vs. Scheduled Hours Report that was entered after the report was implemented with ezLaborManager v11.15. Any schedule data that was in your company's database prior to ezLaborManager v11.15 is not displayed in the report.
Time Pair Errors Label — In some instances, a Time Pair Errors label is displayed to the right of a value in the Variance column. This label indicates that an employee’s time pair has an error on it (such as a missing in or out punch). If this label is displayed, you must go into the Timecard Manager and correct all time pairs that contain errors.
”r;Scheduled Hours (rounded)” Column — All versions of the Actual vs. Scheduled Hours report include a Scheduled Hours (rounded) column. If your company rounds employees’ actual time, all scheduled hours in the report are also rounded to prevent an incorrect variance between actual and scheduled hours in the report.
For example, if an employee is scheduled to work 8:00 A.M. to 5:15 P.M. and the employee clocks in at 8:00 A.M. and clocks out at 5:15 P.M., then the Time & Attendance module rounds the ”r;actual” out time to 5:18 P.M. When the report is generated, the scheduled time is also rounded up to 5:18 P.M. This prevents an incorrect variance due to the difference caused by the rounding of actual hours. (This example assumes a company is rounding up to 6-minute intervals.) Also note that the scheduled hours in the report may not match those displayed on the schedule pages or in the Daily Schedule Report. Neither of these areas of the application use rounding.
Report Headings — You can include optional headings in the Employee Detail report and the Employee Summary report. For the Employee Detail report, you can select a maximum of six headings. For the Employee Summary report, you can select a maximum of 3 headings. The headings that can be selected include last name, first name, company code, and other options. You cannot select any headings for the Worked/Non-Worked Summary report.
Filters in the Report — When you generate the Actual vs. Scheduled Hours Report, you can include one or more filters to narrow the information that is returned. The most common type of filter used with this report is the Variance filter. This filter allows you to include only those records that have a difference between the actual and scheduled hours. You can specify a value for the variance and then select whether you want to view records that are equal to, greater than, greater than or equal to, less than, or less than or equal to the specified value. The Variance filter and any other available filter can be added to the report by clicking the Edit Report button () in the list of Administrator Reports or Supervisor Reports.
Multiple Versions in a Single Report — If your company uses a version of the Actual vs. Scheduled Hours Report that includes more than one of the three versions of the report, and the report also includes a variance filter, the report applies the variance to the lowest level of detail. The other versions of the report are then based on this lowest level. The hierarchy of detail level for the report (from lowest to highest) is: Employee Detail, Employee Summary, and Worked/Non-Worked Time. (Note that company must request that a version of the report includes multiple versions in a single report.)
For example, suppose you create an Actual vs. Scheduled Hours Report that includes all three versions of the report and a filter is set to include only variances greater than nine hours. In this case, the Employee Detail version only includes data that has a variance greater than nine hours. The Employee Summary and Worked/Non-Worked Time versions are then based only on the data included from the Employee Detail version.
Two-Year Limitation Functionality — An Actual vs. Scheduled Hours Report can display data for a maximum of two years in the past. However, a full two years of data will not be available until your company has been using the Time & Attendance module for two years.