Reduced Support Availability: 18th July 2024 from 12pm

Just to let you know, our team is attending the OneFile all company meeting on 18th July  2024 from 12pm, so we won't be as responsive as usual!

You can still access our help guides - just search the Help Centre to find the answers you need. Otherwise, you can submit a ticket and we'll get back to you as soon as possible. If you have an urgent issue, set the priority accordingly.

Help centre

Submit a ticket Log in

Confirmation of field changes to multiple files in data exports - 14/12/2022

On 14/12/2022, we will be releasing a software update which will change the fields available in the data exports. These changes will be visible in the data exports from 15 December 2022.

The full list of changes can be found below:

NEW: Additional Fields

User

  • Default Assessor Email Address
  • Default Assessor UserID
  • Default Employer UserID

AllUsers

  • Username
  • Email Address
  • Placement ID
  • Telephone
  • Address
  • Company
  • Work Address
  • DateArchived
  • ULN
  • Suspended

VisitEvents

  • Assessor UserID
  • Learner UserID
  • ReviewID
  • PlanID

Timesheet

  • TimesheetID
  • Time Spend By User ID
  • Time Recorded By User ID
  • IsTrainingActivity

Removed Fields

Timesheets

  • Total Contracted Hours
  • Target Off-The-Job %
  • Target Off-The-Job Hours

  • Method of Calculating Min OTJ

  • Planned OTJ (Hrs)

  • Minimum OTJ (Hrs)

  • Duration (Wks)

  • % of Planned OTJ

These fields have been removed, as they are duplicated (for each timesheet entry for a learner) within the Timesheets csv file. The same data can be found in the Users.csv file.



1 person likes this
Login to post a comment