Experiencing issues with the new Login/Keychain process?

Click here for an update and guidance 

Help centre

Submit a ticket Log in

Off-the-job Reporting

Off-the-shelf reports

There are several ways to report on off-the-job in OneFile. Firstly, there's the "Off-the-job" report, which can be found on the Reports page, in the "Learner Reports" section.

Please be aware that this report currently only shows the Legacy OTJ fields (for learners who started before Aug 2022). We will be updating the report in the coming weeks to show the new fields. In the time being, please use the learner database reports, as shown in the next section of this guide. 

  Top Tip

Clear the dates from the "Anticipated Completion Date" filter to view all learners regardless of their end dates.


Learner Database Reports

Within the learner database (learner view) reports, you can select which columns can be displayed. This report supports the legacy OTJ fields (pre-Aug 2022) and the current OTJ fields:

Legacy:

  • Total Contracted Hours
  • Target Off-the-job%
  • Actual Off-the-job hours
  • Off-the-job %

Current:

  • Method of Calculating Min OTJ
  • Planned OTJ (Hrs)
  • Minimum OTJ (Hrs)
  • Duration (Wks)
  • % of Planned OTJ

 Export to Excel

As with all OneFile reports, you can export these as csv files and open externally in excel to create your own insights and graphs. For more advanced reporting, see Data Exports below.


Data Exports (FTP)

All Off-the-job data is available in the Data Exports. The off-the-job data lives in the "User.csv" file and is updated every day, overnight. This data can be downloaded from the FTP area and processed to feed your Data Warehouse or simply just to download the files.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.