Page tree
Skip to end of metadata
Go to start of metadata

Question

Why can’t I extract zero hour timesheets that were in the COMPLETED status in Unanet?

Solution

The time export is derived from the person_time_data table. If you have no entries on that table, the main export SQL statement will not pick up any entries, and that timesheet does not get included in the export.

In Unanet, attempting to extract a timesheet with zero hours that has been SUBMITTED and COMPLETED leaves the timesheet in the COMPLETED status.

An option is to navigate to Admin > Setup > Time Periods. Edit a time period and selection the check box for ADMIN ONLY ACCESS to close out time periods, ensuring that no one can add hours to historic timesheets.

Additional Information

Help Docs - Timesheet Statuses

Help Docs - Time Period Setup