For information about outages and scheduled maintenance, click here

How do I create an absence analysis extract?

Modified on Tue, 10 Dec, 2024 at 2:24 PM

How do I create an absence analysis extract?

  1. Go to: Tools > Absence Reporting > Absence Analysis. The Absence Analysis Definition window appears. 
  2. Select the relevant Absence Analysis definition.
  3. Click the Extract button. The Absence Analysis Extract window appears.
    Extract_button.png
  4. Select the relevant period.
    Select_a_time_period.png
  5. Click the Extract button.

      Note:

    If it is not the first time the Extract has been run, a warning appears stating: Data has already been extracted for [date]. Do you want to continue? (By doing so, you will overwrite the existing extracted data.) The Absence Analysis - Edit Extract Data window appears.

  6. Continue to save the Extract as a .pdf file or click the OK button to exit.

      Note:

    If you need to edit the Extract, click OK to save the changes.

Overlapping Data

As an extract is a 'snapshot' of data at the time it is taken, there may be additional absence data not included in the existing extract. Always consider if you need to refresh an extract in this way, or your analysis may not contain all the relevant data. If data does over lap, a message appears stating: There are [#] Employees with overlapping extract rows. Please see highlighted rows. The employees are [employment id + name].

This means that the employee belongs to two different ‘dimensions’ within the time period of the extract. If this message appears, find the highlighted row/s and edit them.

  Example:

Katherine Coombe has two rows, one shows an Organisational Unit of Easington Lane, the other is Cramlington. This is because Katherine holds two posts, in different Org. Units. The problem here is that the Extract does not know how to allocate the person's absence between the two Org. Units, and the figures are doubled up.

To solve this problem you can edit these rows, and either re-assign absence figures between the rows (for example, you may want to split it between the two Org. Units, or delete one row, leaving the absence attributed to only one of the Org. Units.

  Note:

You can resize the columns in the The Absence Analysis - Edit Extract Data window by dragging column lines at the top (ensure you have Show Stack Grids enabled, in the View menu), and move the split bar by clicking on it at the bottom, where the scroll bars are. You will see a split-drag mouse icon ( ) if you hover the mouse in-between the chevrons of the scroll bars. Click and drag right or left when you see this icon.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article