UC San Diego SearchMenu

Override Worksheet

Use the Override Worksheet to move hours across jobs, distributions and to reclassify overtime hours.

The override worksheet allows you to override and redistribute the calculated work hours to REG, OTS or OTP. It also allow you to move hours accross appointments (jobs) and distributions.

The override worksheet contains three sections.

  • Manage Totals: use to redistribute hours between REG, OTS and OTP.
  • Manage Jobs: use to move hours across appointments.
  • Manage Distributions:  use to move hours across distributions.

The workflow on this page is done from top to bottom.

Note: Entered hours cannot be modified by Supervisor or Timekeeper. Time entered can only be modified by employee. This worksheet is helpful to reclass hours entered and redistribute hours entered.

  • Use the Override Totals Summary button from the Calculate Spread to get to the Override Worksheet.

Expand all

Manage Totals Section

Use this section to override the calculated REG, OTS, OTP or holiday hours if needed.

  1. Enter the hours into the correct OTS, OTP or Holiday box. If no hours are entered hours will be reclass as REG.
  2. Click the "Update Worksheet" button to apply the changes to the entire worksheet.
  3. The "Update Totals Summary Only" applies the changes to this section but not the entire worksheet.

Manage Jobs Section

Use this section to override reported hours, overtime and holiday across jobs. You can move hours from one to another, or change the amount of overtime and holiday. 

  1. Enter the hours reported to the appropriate job.  Total number of hours must equal what was reported by employee.
  2. Click "Update Worksheet" button to apply change to the entire worksheet.
  3. The "Update Job Summary Only" applies the changes to this section only but not the entire worksheet.

Manage Distributions Section

Use this section to manage hours in distributions.

  1. Spread hours reported in Job Summary section to the corresponding appointment distributions.
  2. Hours can be spread manually by entering the amounts in the corresponding boxes or by using the spread % column and using the "Update Distribution Spread by Spread %" button to apply changes.

Example scenarios

To see example scenarios on how to use the override worksheet see documents below.

Expand all