Guidance
File format
Updated 14 August 2023
Download CSV 5.35 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular Expression | Example | Notes |
|---|---|---|---|---|---|---|
| Awarding Body ID | Acronym of the awarding organisation | 1 | ^.{1,50}$ | 1 to 50 characters accepted | XYZ Exams | All existing values in the spreadsheet provided by Ofqual should not be altered |
| QAN | Qualification Number | 2 | ^.{8,10}$ | 8 to 10 characters accepted. Must be a valid qualification number | 601/2977/3 | All existing values in the spreadsheet provided by Ofqual should not be altered |
| Qualification Title | Title of qualification | 3 | ^.{1,255}$ | 1 to 255 characters accepted | XYZ Exams Level 1 Award In Dance | All existing values in the spreadsheet provided by Ofqual should not be altered |
| Level | Level of qualification | 4 | ^.{1,20}$ | 1 to 20 characters accepted | Level 1 | All existing values in the spreadsheet provided by Ofqual should not be altered |
| Type | Type of qualification | 5 | ^.{1,255}$ | 1 to 255 characters accepted | Functional Skills | All existing values in the spreadsheet provided by Ofqual should not be altered |
| Certification End Date | The date when certificates cease to be awarded for the qualification | 6 | ^(0[1-9]|[12][0-9]|3[01])[\/](0[1-9]|1[012])[\/](20)\d\d$ | A valid date (dd/mm/yyyy) | 31/12/2012 | All existing values in the spreadsheet provided by Ofqual should not be altered |
| Quarter | The calendar quarter for which data is being collected | 7 | ^(20)[2-9][1-9][.]([1-4])$ | The quarter of the current data collection | 2012.1 | All existing values in the spreadsheet provided by Ofqual should not be altered |
| Month | The calendar month for which data is being reported | 8 | ^(January|February|March|April|May|June|July|August|September|October|November|December)$ | The calendar month, in full (not abbreviated) | January | All existing values in the spreadsheet provided by Ofqual should not be altered |
| Registrations Total | Number of registrations received in the month | 9 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of registrations or 0 (zero) if none to report |
| Certificates Totals | Number of certificates awarded in the month | 10 | ^\d{1,8}$ | Number between 0 and 99999999. Must be the sum of the certificates in the country breakdown (columns K – O) | 50 | Enter number of certifications or 0 (zero) if none to report |
| England Certificates | Number of certificates awarded in England for the month | 11 | ^\d{1,8}$ | Number between 0 and 99999999. Must be the sum of the certificates in the region breakdown (columns P – X) unless the sum is zero. | 50 | Enter number of certifications or 0 (zero) if none to report |
| Wales Certificates | Number of certificates awarded in Wales for the month | 12 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| Northern Ireland Certificates | Number of certificates awarded in Northern Ireland for the month | 13 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| Other Uk Certificates | Number of certificates awarded in other UK regions for the month. This includes: Scotland, the Isle of Man, and the Channel Islands | 14 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| Non-Uk Certificates | Number of certificates awarded in non-UK regions (including BFPO) for the month | 15 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| England (North East) Certificates | Number of certificates awarded in England (NE region) for the month | 16 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| England (North West) Certificates | Number of certificates awarded in England (NW region) for the month | 17 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| England (Yorkshire and the Humber) Certificates | Number of certificates awarded in England (Yorkshire and Humberside region) for the month | 18 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| England (West Midlands) Certificates | Number of certificates awarded in England (WM region) for the month | 19 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| England (East Midlands) Certificates | Number of certificates awarded in England (EM region) for the month | 20 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| England (Eastern Region) Certificates | Number of certificates awarded in England (Eastern region) for the month | 21 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| England (South West) Certificates | Number of certificates awarded in England (SW region) for the month | 22 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| England (South East) Certificates | Number of certificates awarded in England (SE region) for the month | 23 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| England (London) Certificates | Number of certificates awarded in England (London region) for the month | 24 | ^\d{1,8}$ | Number between 0 and 99999999 | 50 | Enter number of certifications or 0 (zero) if none to report |
| Status | Current status of qualification | 25 | ^.{1,255}$ | Between 1 and 255 characters | Available to learners | Values should not be altered |