Guidance

Apprenticeship service - Apprentice bulk upload template Version 7: Effective 30 November 2023

Updated 3 October 2023
Download CSV 1.47 KB

CohortRef AgreementID ULN FamilyName GivenNames DateOfBirth EmailAddress StdCode StartDate EndDate TotalPrice EPAOrgID ProviderRef RecognisePriorLearning TrainingTotalHours TrainingHoursReduction IsDurationReducedByRPL DurationReducedBy PriceReducedBy
V6RRJV AB12C3 1234567891 Jones Louise 03/10/1998 Name@domain.com 57 01/05/2017 2018-05 2000 Not set CX768 TRUE 9000 20 TRUE 10 250
V6RRJV AB12C3 1234567891 Smith Mark 03/10/1998 person@domain.com 57 01/05/2017 2018-05 2000 EPA0001 PG513 TRUE 9000 20 FALSE Not set 250
V6RRJV AB12C3 9875463215 Dolan James 04/10/1998 an.other@domain.co.uk 57 10/06/2017 2019-06 2000 EPA0045 ZB657 FALSE Not set Not set Not set Not set Not set
** GUIDANCE NOTES** You must DELETE these rows before saving and uploading the file Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set
- The ULN is mandatory and the value of 9999999999 cannot be used Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set
- The Date of Birth must be saved with the format of yyyy-mm-dd Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set
- If you open this file using Excel to view or edit it then it will show the default date format of dd/mm/yyyy. You will need to reformat this before you save and close the file Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set
- If you want to view and check the file before uploading then you can do this using Notepad which will not adjust the date format Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set
- The start date must be saved with the format of yyyy-mm-dd Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set
- The end date is month and year - not a full date and is not formatted as a date in Excel Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set
- The CSV file is limited to 100 rows Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set Not set