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 |