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.