For the import to work, the file must be in the following format. If no data is found for the mandatory columns, no records will be imported. Any records that cannot be imported will be reported back to the user.
The importer looks for matching OTJ Hours records in PICS using the derived Episode Ident, Start Date, and Start Time. Any matches found in PICS will be updated with data from the import file.
As per ILR
Learner Reference Number as on the ILR. This is used in combination with the StartDateTime to derive a PICS Episode Ident.
Session start date and time
This or DurationHours
Planned duration of the session in hours and fraction of an hour. For example, 2.25 = 2 hours an 15 minutes.
This or PlannedHours
Duration of the session in hours and fraction of an hour. For example, 1.5 = 1 hours 30 minutes.
You must specify the Code or Description of an entry in the Contact Hours Types list
Apprentice, Employer or blank
If the word Apprentice is found, it will be categorised as being recorded by the Learner so that approval can be completed in eAssessor.
If the word Employer is found it will be categorised as being recorded by the Employer so that approval can be completed in eAssessor.
Any other notes
Example Data File
The file below is an example of a valid OTJ import CSV.