40 Employee Scheduling

Employee Scheduling allows you to perform a variety of scheduling activities:

• Create and maintain employee work shifts

• Schedule and maintain employee time-off events such as vacations and other times when employees may not be available for work

• Assign employees to defined work shifts

Employees can view and print their schedules at the Register Login screen. They may also view a list of other employees who are assigned to work on a specific day. Refer to View Schedule and Timecard for more information.

Work Shifts

Work shifts may be created to define a specific set of working hours or days (weekday mornings, weekend evenings, and so on), or with the intent that individuals who belong to a particular group (day managers, night managers, and so on.) may be assigned to it. After a shift has been created, an individual employee may be assigned to it. See Maintaining Employee Shifts.

Time Off

Use the Maintain Employee Time Off function to define times when an employee is not available to work. These times can be set up as recurring events that span several days or as single events. See Maintaining Employee Time-Off Schedules.

Reports

Figure 40-1 Employee Schedule Reports

The following scheduling reports are available:

• Employee Performance Report - This report shows the scheduled hours for an employee or all employees, the hours actually worked, and the difference between scheduled and worked hours. The employee's total sales and average sales for the period are also shown.

  Figure 40-2 Employee Performance Report

  
  

• Employee Schedule Detail - This report shows the employees who are scheduled for each day in the selected week. Each day of the week is listed, the employees scheduled, their individual start and end times, and the total hours for each day. This report also includes the total scheduled hours for the week.

  Figure 40-3 Employee Schedule Detail Report

  
  

• Employee Time Off Summary Report - This report lists all employees who have time off scheduled for the selected week, and it shows the time-off days, hours (if less than a full day), and the reason for the time-off.

  Figure 40-4 Time Off Summary Report

  
  

Note: Refer to the Oracle Retail Xstore Point of Service Reports Guide for detailed information about these reports.

Creating An Employee Schedule

Use this procedure to create an employee schedule for a designated week.

1. After logging in, select Employee from the Main Menu. See Figure 1-5.

   Figure 40-5 Employee Menu

   
   

2. At the Employee Menu, select Employee Scheduling Maintenance.

3. Select the Employee Schedule option.

   Figure 40-6 Employee Scheduling Maintenance Menu

   
   

4. Oracle Retail Xstore Mobile POS prompts for the week to be scheduled. Select the week you want to schedule.

   Figure 40-7 Schedule Weeks List

   
   
   
   

   Note: The current week is selected by default.

   
   

5. Oracle Retail Xstore Mobile POS displays the Employee Schedule screen for the selected week. This is the view used to create an employee schedule.

   Select the Edit option to begin creating a new employee schedule.

   Figure 40-8 Employee Schedule Screen Showing Context Menu

   
   

Oracle Retail Xstore Mobile POS provides several options for creating a new schedule:

• Create New Schedule Options

• Copying a Day Schedule

• Copying a Week Schedule

• Adding a Manual Shift

• Adding a Pre-Defined Shift

• Adding Time-Off Periods

• Removing an Employee Time-Off Period

• Creating a New Shift

Create New Schedule Options

• Copy Day Schedule - Use this option to copy an existing schedule from one day to a day (or days) in this new schedule. See Copying a Day Schedule.

• Copy Week Schedule - Use this option to copy an existing weekly schedule from one week to this new weekly schedule. See Copying a Week Schedule.

  
  

  Note: Scheduling Exceptions... If you schedule a shift for an employee with approved time off for the period, Oracle Retail Xstore Mobile POS displays a prompt alerting you to the conflict. Select the Add to Schedule option to schedule the employee and override the time-off event. <OR> Select the Remove From Schedule option to remove the conflicted shift(s) from the schedule. You cannot edit records for any date that precedes the current date.

  
  
  
  

  Note: You can assign multiple shifts to the same employee, on the same day. This is useful if you employ many part-time employees. If desired, you can schedule multiple shorter shifts during the day for just one employee. For example a three-hour INVENTORY/ STOCK shift in the morning and a two-hour CASHIER shift in the afternoon. See Figure 40-16 for an example of an employee (Frank, Fern) with 2 shifts in a single day.

  
  

• Add Manual Shift - Use this option to create a shift to apply to a specific employee/day on the schedule. See Adding a Manual Shift.

• Add Shift From List - Use this option to apply a pre-defined shift to a specific employee/day on the schedule. See Adding a Pre-Defined Shift.

  
  

  Note: To define the shifts, see Creating a New Shift.

  
  

Copying a Day Schedule

Use this option if your daily schedules are consistent within the week you are currently scheduling. For example, if your Monday through Wednesday staffing needs are similar, use this option to simply set up one day's schedule (Monday) and copy it to the other days (Tuesday and Wednesday) in the current week.

Note: This option copies the schedule that every employee has on the selected day and duplicates it to the additional days that are selected. Therefore, any employee's cell may be selected, as long as it is in the correct day from which the schedule is copied.

For example, Bob works sales from 9:00 a.m. to noon on Monday, and Mary works inventory from 1:00 p.m. to 5:00 p.m. on Monday. If the Copy Day Schedule duplicates the Monday schedule to Tuesday and Wednesday, then Bob works from 9:00 a.m. to noon on Monday, Tuesday and Wednesday. Mary works inventory from 1:00 p.m. to 5:00 p.m. on Monday, Tuesday and Wednesday.

...continued from step 5.

1. Select the day you want to copy the schedule from. Navigate among the days on the scheduling screen grid. The highlighted area indicates the selected cell and day in the grid. In Figure 40-9, the Tuesday schedule is selected.

   
   

   Note: Touch-screen users, tap the desired cell to select the day you want to copy the schedule from.

   
   

2. Select the Copy Day Schedule option from the Edit menu.

3. Oracle Retail Xstore Mobile POS prompts for the day (or days) you want to copy the selected day schedule to. In this example, select the day or days you want to copy the schedule.

   Figure 40-9 Copy Day Schedule Form

   
   
   
   

   Tip: You can select multiple days. In this example, the schedule is copied to Wednesday, and Saturday.

   
   

   Oracle Retail Xstore Mobile POS copies the schedule to each day you selected. Oracle Retail Xstore Mobile POS totals the scheduled hours for the week as you build the schedule and the scheduled budgeted amount (if configured for your store).

   Figure 40-10 Copied Day Schedule

   
   

4. Continue scheduling all employees for the week as needed. Select Save Changes on the Context Menu to save your schedule.

   
   

   Note: If configured, Oracle Retail Xstore Mobile POS warns of an attempt to schedule an employee when it conflicts with your store's hourly constraints or other restrictions.

   
   

Copying a Week Schedule

Use this option if your weekly schedules are relatively consistent from week to week. For example, if your weekly summer staffing needs are similar, use this option to set up one week's schedule and copy it from week to week. Once the existing schedule is copied to the week you are scheduling, you can easily make adjustments to the schedule as needed.

1. At the Employee Scheduling Maintenance Menu select Employee Schedule. See Figure 40-6.

2. At the Schedule Weeks form, select the week that you want to schedule.

3. At the Weekly Summary screen, select the Edit option from the Context Menu.

4. Select the Copy Week Schedule option.

   Figure 40-11 Copy Week Schedule Option

   
   

5. Oracle Retail Xstore Mobile POS displays a list of weeks that have been scheduled previously. Select a week from the list.

   Oracle Retail Xstore Mobile POS copies the schedule from the displayed week to the selected week. Oracle Retail Xstore Mobile POS totals the scheduled hours for the week as you build the schedule and the scheduled budgeted amount (if that is configured for your store).

   Figure 40-12 Copied Week Schedule

   
   

6. Continue scheduling all employees for the week and make any edits as needed. Select the Save Changes option to save your schedule. Refer to Editing a Schedule for more information about changing schedule information.

Adding a Manual Shift

Use this option to create a new shift for a specific employee/day on the schedule.

...continued from step 5.

1. Select the employee and the day you want to schedule. The highlighted area indicates the selected cell in the grid.

   
   

   Note: Touch-screen users, tap the desired cell to select the employee and the day you want to schedule.

   
   

   Figure 40-13 Selecting the Cell to Schedule

   
   

2. From the Edit Menu, select the Add Manual Shift option.

   Figure 40-14 Edit Menu Options

   
   
   
   

   Tip: Make sure you have a valid shift selected, not a cell in the Total Hours column.

   
   

3. Oracle Retail Xstore Mobile POS prompts for schedule information for the selected employee and date. Enter the information as required, then select OK to continue:

   Figure 40-15 Employee Schedule Data Form

   
   

   • Shift Start Time - Enter the starting time for this shift.

   • Shift End Time - Enter the ending time for this shift.

   • Work Code - Select a work code for this shift.

   • Number of Non-Working Hours - Enter the hours and/or minutes that are counted as non-working hours, such as meal breaks.

   Oracle Retail Xstore Mobile POS totals the scheduled hours for the week and calculates the scheduled budget amount (if it is configured for your store) as you build the schedule. The total scheduled hours and scheduled dollar amount is shown in the top panel of the screen. It is updated automatically each time you add or remove a shift.

   Oracle Retail Xstore Mobile POS displays the Weekly Summary Scheduling screen that shows the shift you created for the employee on the scheduled day.

   Information on this screen includes the starting and ending times, the work code, break times, and the amount of working time.

   Figure 40-16 Weekly Summary Scheduling Screen - Employees Scheduled

   
   

4. Continue scheduling all employees for the week as needed and select the Save Changes option to save your schedule.

   
   

   Note: Depending on your system's configuration, Oracle Retail Xstore Mobile POS may provide a warning if you schedule an employee who has a conflict with restrictions defined by your store's policy. For example, there may be a maximum number of scheduled hours that cannot be exceeded.

   
   

Adding a Pre-Defined Shift

Use this option to apply an existing shift type to the schedule for a selected employee/ day.

...continued from step 5.

Note: To create these pre-defined shifts, refer to Creating a New Shift.

1. Select the employee and the day you want to schedule. The highlighted area indicates the selected cell in the grid.

   
   

   Note: Touch-screen users, tap the desired cell to select the employee and the day you want to schedule.

   
   

2. On the Edit Menu, select the Add Shift From List option. See Figure 40-14.

   
   

   Tip: Make sure you have a valid shift selected, not a cell in the Total Hours column.

   
   

3. Oracle Retail Xstore Mobile POS displays the list of pre-defined shifts. Select a shift from the list that you want to apply to the selected employee and day, then select OK to continue.

   Figure 40-17 List of Pre-Defined Shifts

   
   

   Oracle Retail Xstore Mobile POS displays the Weekly Summary Scheduling screen showing the shift you applied to the employee/day. Information shown here includes the pre-defined starting and ending times, the work code, the time allotted for breaks, and the amount of working time. Oracle Retail Xstore Mobile POS also totals the scheduled hours for the week as you build the schedule and the scheduled budgeted dollar amount (if configured for your store).

   Figure 40-18 Pre-defined Shift Added

   
   

4. Continue scheduling all employees for the week, and select the Save Changes option to save your schedule.

Editing a Schedule

Use this function to make changes to an existing employee schedule for a designated week.

Note: Schedule records from previous days cannot be edited.

1. After logging in, select Employee from the Main Menu. See Figure 1-5.

2. At the Employee Menu, select Employee Scheduling Maintenance. See Figure 40-5.

3. Select the Employee Schedule option. See Figure 40-6.

4. Oracle Retail Xstore Mobile POS prompts for a schedule week. Select the week that you want to edit. See Figure 40-7.

   
   

   Note: The current week is selected by default. You cannot edit a record from a date that is earlier than the current date.

   
   

5. Oracle Retail Xstore Mobile POS displays the Employee Schedule screen for the selected week. This is the view used to edit the existing employee schedule. Select the Edit option from the Context Menu to begin editing this employee schedule. See Figure 40-8.

   
   

   Note: You can select the Print Schedule option to print the displayed schedule on the report printer.

   
   

6. Xstore provides several options for editing an existing schedule.

Edit Existing Schedule Menu Options

• Change Shift - Use this option to edit an existing shift on the schedule. See Changing a Shift.

• Delete Shift - Use this option to remove a shift from the schedule. See Deleting a Shift.

• You can also add shifts to the schedule as needed. Refer to Adding a Manual Shift Adding a Pre-Defined Shift, Copying a Day Schedule, and Copying a Week Schedule for more information.

Changing a Shift

Use this option to edit an existing shift for an employee on the schedule.

1. In edit mode, select the shift you want to change. The highlighted area indicates the selected shift in the grid.

   
   

   Note: Touch-screen users, tap the desired cell to select the shift you want to change.

   
   

2. Select the Change Shift option.

3. Oracle Retail Xstore Mobile POS displays the Employee Scheduling Data form that shows the current schedule information for the selected shift. Change the information as required:

   Figure 40-19 Employee Scheduling Data Form

   
   

   • Shift Start Time - Enter the starting time for this shift.

   • Shift End Time - Enter the ending time for this shift.

   • Work Code - Select a work code for this shift.

   • Number of Non-Working Hours - Enter the hours and/or minutes that are counted as non-working hours, such as meal breaks.

4. Select OK to continue.

   Oracle Retail Xstore Mobile POS displays the Weekly Summary Scheduling screen showing the shift you changed for the employee/day. Information shown here includes the starting and ending times, the work code, the time allotted for breaks, and the amount of working time. Oracle Retail Xstore Mobile POS also totals the scheduled hours for the week as you build the schedule and the scheduled budget amount (if configured for your store).

5. Make additional schedule changes as needed and select the Save Changes option to save the edited schedule.

   
   

   Note: If configured, Oracle Retail Xstore Mobile POS warns you if an employee's schedule conflicts with hourly constraints or other restrictions as determined by your store.

   
   

Deleting a Shift

Use this option to remove a shift from the schedule for a selected employee/day.

1. Select the shift you want to remove from the schedule. The highlighted area indicates the selected shift in the grid.

   
   

   Note: Touch-screen users, tap the desired cell to select the shift you want to remove.

   
   

2. Select the Delete Shift option. Oracle Retail Xstore Mobile POS displays a prompt to verify that the selected shift is the one you want to delete.

3. Press Yes to delete the shift from the schedule.

   Oracle Retail Xstore Mobile POS displays the Weekly Summary Scheduling screen, removing the shift you deleted for the employee/day. Oracle Retail Xstore Mobile POS also recalculates the scheduled hours for the week and the scheduled budget amount (if configured for your store) as you edit the schedule.

4. Continue making any changes to the schedule as needed and select the Save Changes option to save the edited schedule.

Maintaining Employee Time-Off Schedules

To create and edit time-off events, Oracle Retail Xstore Mobile POS prompts you for information such as the type of time-off period (whole day, half day, partial day), whether the time-off period spans multiple days or a single day, and the dates and times of the time-off period. This information is shown during the employee scheduling process, alerting you to scheduling exceptions if you try to schedule an employee with previously-approved time off for the time period you are scheduling.

Adding Time-Off Periods

Use this function to add employees' time-off requests to the schedule.

1. At the Employee Scheduling Maintenance Menu select Maintain Employee Time Off. See Figure 40-6.

2. Oracle Retail Xstore Mobile POS prompts you to select a schedule week. Select the week for the time-off event.

   Figure 40-20 Schedule Weeks List - Time Off

   
   
   
   

   Note: The current week is selected by default.

   
   

3. Oracle Retail Xstore Mobile POS displays the Employee Time Off Scheduling screen showing any previously scheduled time-off events for this week.

   Figure 40-21 Employee Time Off Scheduling Screen

   
   

4. Select the Add Time Off option from the Context Menu to create a new time-off event for an employee.

   Figure 40-22 Employee Time Off Scheduling

   
   
   
   

   Tip: Select Previous Week to view time-off from the week before the week that is displayed. Select the Next Week option to view time-off for the week after the week that is displayed. To view any other time-off schedule, select the Change Week option to select a specific schedule date from the list of weeks.

   
   

5. Oracle Retail Xstore Mobile POS prompts for the employee's information. Enter the employee's information and select Process to continue.

   Figure 40-23 Employee Search Form

   
   

6. Oracle Retail Xstore Mobile POS displays a list of employees who match the search criteria. Select an employee from the list.

   Figure 40-24 List of Matching Employees

   
   

7. After the employee has been selected, Oracle Retail Xstore Mobile POS prompts for the type of time-off event information. Select the time-off type to continue:

   Figure 40-25 Time-off Event Type Prompt

   
   

   • Select the Full Day option if the employee has requested time off for the entire day or days.

   • Select the Half Day option if the employee has requested half of the day off, such as morning or afternoon.

   • Select the Partial Day option if the employee has requested part of the day, such as 2 hours off.

8. Oracle Retail Xstore Mobile POS prompts for the time-off event date. Enter the starting time-off date and select Save Changes to continue.

   Figure 40-26 Time Off Date Prompt

   
   

   • FULL DAY - If you chose the full day option, Oracle Retail Xstore Mobile POS prompts for the number of days for this time-off event. Enter the number of full days the employee has requested off and select Save Changes to continue. Go to step 8.

     Figure 40-27 Number of Days Prompt

     
     

   • HALF DAY - If you chose the half day option, Oracle Retail Xstore Mobile POS prompts for the part of day. Select whether the time off is morning (AM) or afternoon (PM). Go to step 8.

     Figure 40-28 Half Day Time-Off Prompt

     
     
     
     

     Note: The number of hours allotted for the half-day time-off option is determined by your store's policy.

     
     

   • PARTIAL DAY - If you chose the partial day option, Oracle Retail Xstore Mobile POS prompts for the start and end times. Enter the information as required and select Save Changes. Go to step 8.

     Figure 40-29 Partial Time-Off Prompt

     
     

9. Oracle Retail Xstore Mobile POS prompts for the time-off reason. Select a reason for the time-off event from the list.

   Figure 40-30 List of Time-Off Reasons

   
   

   Oracle Retail Xstore Mobile POS adds the employee's time-off event to the Employee Time Off Scheduling screen for the selected week.

   Figure 40-31 Employee Time Off Scheduling Screen

   
   
   
   

   Note: Time Off Exception If the employee has already been scheduled to work on that day (or days), the system prompts you that there is a time-off exception. Select the Add to Schedule option to schedule the employee's time off as requested. Select Back to cancel the request.

   
   

Removing an Employee Time-Off Period

Use this function when an employee wants to cancel a previously-scheduled time-off. This function removes the time-off event from the schedule.

1. At the Employee Scheduling Maintenance Menu select Maintain Employee Time Off. See Figure 40-6.

2. Oracle Retail Xstore Mobile POS prompts you to select a schedule week. Select the week for the time-off event.

   Figure 40-32 Schedule Weeks List - Time Off

   
   
   
   

   Note: The current week is selected by default.

   
   

3. Oracle Retail Xstore Mobile POS displays the Employee Time Off Scheduling screen showing the previously scheduled time-off events. Select the employee time-off event you want to remove from the schedule, and select the Remove Time Off option.

   
   

   Tip: Select the Previous Week and the Next Week options to view the time-off schedule for the week before, or after, the current week you are viewing. To view any other time-off schedule, select the Change Week option to select a specific schedule date from the list of weeks displayed.

   
   

4. Oracle Retail Xstore Mobile POS prompts you to confirm the time-off event to be removed from the schedule. Press Yes to remove the selected employee time-off event. Oracle Retail Xstore Mobile POS removes the selected time-off event from the schedule.

Editing an Employee Time-Off Period

Use this option to change an employee's previously scheduled time-off request. You can change the type of time off (full day, half day, or part of day), change the time-off date, the number of days for the time-off period, the time-off hour duration, and the time-off reason.

1. At the Employee Scheduling Maintenance Menu select Maintain Employee Time Off. See Figure 40-6.

2. Oracle Retail Xstore Mobile POS prompts for a schedule week. Select the week for the time-off event. See Figure 40-32.

   
   

   Note: The current week is selected by default.

   
   

3. Oracle Retail Xstore Mobile POS displays the Employee Time Off Scheduling screen showing the previously scheduled time-off events. Select the employee time- off event you want to change and select the Edit Time Off option.

   Figure 40-33 Employee Time Off Scheduling Screen

   
   
   
   

   Note: Select the Previous Week and the Next Week options to view the time-off schedule for the week before, or after, the current week you are viewing. To view any other time-off schedule, select the Change Week option to select a specific schedule date from the list of weeks displayed.

   
   

4. Oracle Retail Xstore Mobile POS prompts for the type of time off (full day, half day or partial day), the time off date, and other information as required. Refer to Adding Time-Off Periods for detailed information about the time-off prompts.

   Enter/select the time-off information as required. Oracle Retail Xstore Mobile POS replaces the employee's original time-off event on the schedule with the updated request.

Printing the Time-Off Schedule

You can print the Employee Time-off Summary Report from both the Employee Time Off Scheduling screen and from the Employee Scheduling Maintenance menu.

• Printing the schedule from the Employee Time Off Scheduling screen (Print Schedule option) prints the current schedule shown on the screen.

• Printing the schedule from the Employee Scheduling Maintenance Context Menu prompts you to select a week to be printed.

Note: Refer to the Oracle Retail Xstore Point of Service Reports Guide for detailed information about running reports.

Maintaining Employee Shifts

To make employee scheduling easier, you can create and edit pre-defined shifts that may be applied during the employee scheduling function.

Creating a New Shift

Use this procedure to create a new shift to be used during employee scheduling.

1. At the Employee Scheduling Maintenance Menu select Shift Maintenance. See Figure 40-6.

2. Oracle Retail Xstore Mobile POS prompts for the shift information. Select the New option to create a new shift type.

   Figure 40-34 Shift Criteria Prompt

   
   

3. Oracle Retail Xstore Mobile POS prompts for the shift detail information. Enter the information for the new shift:

   Figure 40-35 Shift Detail Prompt

   
   

   • Shift Name - Enter a name for this shift. This is the label that is shown in the list of pre-defined shifts.

   • Shift Description - Enter a short description for this shift.

   • Start Time - Enter the starting time for this shift. If you enter the time as military time, it is converted to a.m. or p.m. For example: 16:00 is converted to 04:00 PM.

   • End Time - Enter the ending time for this shift. If you enter the time as military time, it is converted to a.m. or p.m. For example: 16:00 is converted to 04:00 PM.

   • Number of Non-Working Hours - Enter the hours and minutes that are counted as non-working hours, such as meal breaks.

   • Work Code - Select a work code for this shift.

4. Select the Save Changes option to create the new shift.

   
   

   Note: During employee scheduling, this new shift is available as an option in the pre-defined list of shifts. See Adding a Pre-Defined Shift for detailed information about using the Add Shift From List schedule option.

   
   

Editing an Existing Shift

Use this procedure to change the information for a pre-defined shift.

1. After logging in, select Employee from the Main Menu. See Figure 1-5.

2. At the Employee Menu, select Employee Scheduling Maintenance. See Figure 40-5.

3. From the Employee Scheduling Maintenance Menu, select the Shift Maintenance option. See Figure 40-6.

4. Oracle Retail Xstore Mobile POS prompts for the shift information. Enter the required information and select the Process option to continue. If you do not enter any information, Xstore displays a list of all shifts.

   Figure 40-36 Shift Maintenance Form

   
   

   If more than one pre-defined shift matches the search criteria you entered, Oracle Retail Xstore Mobile POS displays a list of shifts. Select the shift you want to change from the list and press Enter to continue.

   Figure 40-37 Shift List

   
   

5. Oracle Retail Xstore Mobile POS displays the shift's detail information.

   Figure 40-38 Shift Detail

   
   
   
   

   Note: To delete the shift entirely, select the Delete Shift option here. The deleted shift will no longer available as an option when setting up employee schedules.

   
   

6. Change the shift information as needed and select the Save Changes option to continue.

Schedule Reports

Note: Refer to the Oracle Retail Xstore Point of Service Reports Guide for detailed information about creating these reports.

Schedule reports are available from the Schedule Reports menu.

1. Select Reporting. See Figure 1-5.

2. At the Reporting menu, select Employee Reports.

3. At the Employee Reports menu, select Employee Schedule Reports.

4. Select a report from the Schedule Reports list.

Employee Time Off Summary Report

The Employee Time Off Summary Report provides a listing of employees who have scheduled time off during the weekly period selected for the report. For every employee selected, the report shows the date, amount of time off, and the reason for the time off.

See Printing the Time-Off Schedule for more information.

Employee Performance Report Overview

This report shows employee performance information within a selected date range for a specified work code (or all codes), for an individual employee, or for all employees.

This report includes the following employee information:

• Total scheduled hours for an employee or all employees

• The hours actually worked by the employee

• The difference between the scheduled hours and the hours worked

• The employee's total sales amount for the period

• The number of sales for the period

• The average dollar amount per sale

• The average number of sales per hours worked

Schedule Detail Report Overview

This report shows employees scheduled for each day in a selected week. It contains the following information:

• Date

• Employee name

• Work Code

• The individual start and end times and hours scheduled for sales and non-sales (work code)

• Total hours for each employee per day

• A report total for the schedule week is shown on the last page of the report