Schedule Xpress includes a report to review changes made to shift data by anybody at anytime. This answers questions surrounding who may have created, updated or deleted a shift.

Note: The Audit Schedule Changes report is only available to users who have user capability.

In this article, we'll be looking at the following for the Shift Change Audit Report in Schedule Xpress:

Accessing the Shift Change Audit Report

Understanding your shift audit records

To access the Shift Change Audit Report, select the Reports button on the left edge of the Schedule Xpress window. Then select Audit Schedule Changes at the top of the page.

Once inside, the audit report will look as below. You'll need to fill in parameters to find records.

Now let's look at defining your parameters to find that all-important information.

You need to use the Options panel to set your parameters.

It's likely at this point you'll have a shift or set of shifts in mind, so this process can be used to narrow down and keep your search as succinct as possible.

One of the most important factors in finding the change you're looking for is to define your date range. The first step you'll need to take is to make sure these are correct.

When you enter the Shift Change Audit Report in Schedule Xpress, the Changes From and Changes To will default to the period covering the current day. To find changes in any given period, you must ensure you enter the formatting correctly to reflect a specific period. See the formatting below.

Changes From: 2022-09-12T00:00:00.000 = (Year, month, day / hours, minutes, seconds, thousandths of a second)

Changes To: 2022-09-12T23:59:59.999

All timestamps in the audit report will display in the time zone your database is set in.

Changed By gives you the opportunity to choose the username associated with the change(s) made. This is highlighted in the Created, Updated and Deleted strips above.

Note: As stated, it must be the username of the user's account, not the user's name.

Changed by will default as an asterisk, which means the search is for all users.

This section is where you determine a search based on which fields of the shifts have changed.

Note: If a field is not listed, then even if the field was changed, the shift will not be included in the report.

You can press and hold on the black mark below the fields and use it to drag down and open all the fields available for selection.

You'll also see the options All, None and Inverse. Here's what they mean:

The Events are relating the the shift change type. Do you want to look for shifts that have been Created, Updated or Deleted?

All, None and Inverse works the same as in the Fields section.

Shift Date From and Shift Date To works the same way as Changes from and Changes to. However, this time, you're searching for shifts that we're dated and timed between this period.

You need to use the same date formatting. See below examples.

Shift Date From: 2022-09-01T00:00:00.000 = (Year, month, day / hours, minutes, seconds, thousandths of a second)

Shift Date To: 2022-09-30T23:59:59.999

These four fields can be used to find specific shifts relating to IDs. This will be useful if you're trying to find information on a single employee, customer, site or service.

This section can be used to search for specific words relating to your Reference field 1.

If you use references, it will be present in any shift form in your Schedule.

You can use the Shift ID section to fill out a Shift ID if your looking for updates on one specific shift.

Note: This will default as an asterisk to ensure you search for as many shifts as your previous parameters can find.

You can only retrieve the Shift ID from the Shift Change Audit Report. It is located in shift record, in the top-right corner.

The Apply button is the final step in processing your search through the parameters you've entered and selected.

The Reset button will reset any current parameters to the default selections.

Now let's look at how you can read these records to understand the data.

When you use specific parameters to find records, the records will display on the right-hand side.

You can distinguish which shift has been changed at the top of each record. These will highlight in blue if their current, or brown if they're deleted.

These contain shift details for Date, Start, End, Employee, Customer, Site Service and State (Current or Deleted). These will also show in the record itself.

It will then contain a line to represent the change type; Created, Updated or Deleted.

Shift changes are shown in reverse chronological sequence, in a block of records related to that shift. Here's a few other things to know about the sequencing:

When you're searching for shift audit records, you'll be looking for either Created, Updated or Deleted shifts. These are all distinguished by different colors.

See the image below.

These strips contain the type of change, who the change was made by, on what date and at what time.

You can toggle through records by clicking the arrows in the top-right corner. The single arrows are to left and right per page, and the double arrows are to move to the beginning and end of all the pages.

It's likely that you'll want to search for key words if you can't set specific parameters to find a single record. You can use the search report section to input key wording.

In this example, we've chosen to search for the name Dinesh. You'll notice that the first record containing the word Dinesh will be highlighted in yellow.

You can toggle with the arrows on the right of the key word to filter through all records that contain the word Dinesh.

You can zoom in and out to gain a view that is suitable to you.

When reviewing the details in real-time, press the refresh button to re-run the report without re-entering parameters.

To export a report, you can click icon containing a page and right-facing arrow. This will dropdown a selection of report types.

We'll use a PDF and Excel spreadsheet as an example.

This will provide a clearer view of all your records.

Once you've clicked Enable Editing, your data will be editable if adjustment are required.

For more information on the Shift Change Audit Report, please Contact Support now!