Guidance
File format
Updated 31 March 2025
Download CSV 5 KB
| Field name | Description | Position | Validation Regular Expression | Description of regular expression |
|---|---|---|---|---|
| ReportingDate | Date the file was due to be submitted to Ofqual regardless of when it was actually uploaded (this date will be made available by Ofqual) | A | ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
| CentreURN | Centre’s Unique Reference Number as assigned by the Department for Education at the time of data submission. -2 accepted where the centre does not have an URN | B | ^\d{1,6}$ | Valid Centre URN. Up to 6-digit integer accepted. -2 also accepted where centre does not have a URN |
| CentreNCN | Centre’s National Centre Number as allocated by the Joint Council for Qualifications (JCQ) at the time of data submission. -2 accepted where the centre does not have an NCN | C | ^\d{1,5}$ | Valid NCN code. Up to 5-digit integer accepted. -2 also accepted where centre does not have a NCN |
| CentreIdentifierOther | Any other number allocated to the centre or assessment venue by individual awarding organisations at the time of data submission. Must be provided if neither CentreURN nor CentreNCN are available | D | ^{1,15}$ | 1 to 15 characters accepted. -2 permitted where at least one of NCN or URN have been provided or for candidates who are not registered to a centre |
| Centre_name | Name of centre | E | ^.{1,150}$ | 1 to 150 characters accepted. -2 accepted for unknown |
| Postcode | Postcode of centre | F | ^.{1,10}$ | 1 to 10 characters accepted. -2 accepted for unknown |
| Country | Country where the centre is located | G | ^(England)$ | 1 to 150 characters accepted. -2 accepted for unknown |
| CentreType | The type code of the centre | H | ^\{1,14}$ | Up to 2 characters between 1-14 see Apnnex A - Centre Type Codes for more information |
| UniqueLearnerNumber | Unique Learner Number (ESFA code) provided by the Learning Records Service. Please provide this identifier wherever possible. -2 accepted where the learner does not have a ULN | I | ^\d{1,10}$ | 1 to 10 digits accepted. -2 accepted where the candidate does not have a ULN |
| UniqueCandidateIdentifier | Unique Candidate Identifier (JCQ code), assigned to the candidate. -2 accepted where the learner does not have a UCI | J | ^.{1,13}$ | A valid UCI. Alpha numeric 13 characters accepted -2 accepted where the candidate does not have a UCI |
| CandidateIdentifierOther | Any other unique candidate number allocated by individual awarding organisation. Must be provided where neither UCI or ULN are available. -2 accepted where at least one of UCI or ULN have been provided | K | ^.{1,20}$ | 1 to 20 characters accepted. -2 permitted where at least one of UCI or ULN have been provided |
| FirstName | Candidate’s forename(s) | L | ^.{1,150}$ | 1 to 150 characters accepted |
| MiddleNames | Candidate’s middle name(s), if able to separate out from first names. Can be left blank if not known or unavailable, or if middle names cannot be separated from first names | M | ^.{0,150}$ | 0 to 150 characters accepted |
| Surname | Candidate’s surname or family name | N | ^.{1,150}$ | 1 to 150 characters accepted |
| DateOfBirth | Candidate’s date of birth | O | ^(19|20|29)\d\d[- ](0[1-9]|1[012])[- ](0[1-9]|[12][0- 9]|3[01])$ | Date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits). 2999-12-31 accepted if DOB unknown |
| Gender | Candidate’s gender | P | ^(M|F|-2)$ | Accepted values: M, F. -2 accepted for other/unknown |
| QualificationNumber | This should be the unique identifier for the final qualification awarded as it appears in Ofqual’s Register of Regulated qualifications | Q | ^.{1,10}$ | Valid Qualification Number. 1 to 10 |
| QualificationTitle | Title of qualification | R | ^.{1,150}$ | 1 to 150 characters accepted |
| QualificationLevel | This should be the level of the qualification on the Regulated Qualifications Framework (RQF) | S | ^(L1/2|L2|L3)$ | Accepted values: L1/2, L2 or L3 |
| AdditionalInformation | Any additional information about the candidate, centre of qualification | T | ^.{0,255|-2}$ | Up to 255 characters -2 accepted if no additional information |
| ExpectingResult | If candidate is expecting a result | U | ^(Y|YL)$ | Accepted values: Y, YL See Annex B - Further guidance for completing the Expecting Result field for more information. |
| SeniorContactConfirmed | Senior designated contact status | V | ^(Y|N|NCN|NCNA)$ | Accepted values: Y, N, NCN, NCNA See Annex C - Further guidance for completing the Senior Contact Confirmed field for more information. |
| ResultStatus | Status of result at the time of reporting. -2 accepted at Part One of the collection and at Part Three if AO was not selected for close monitoring | W | ^(S1|S2|S3|S4|-2)$ | Accepted values: S1, S2, S3, S4, -2 See Annex D - Result status values for more information |
| ResultIssued | Status of result issued at the time of reporting -2 accepted at Part One of the collection and at Part Two if AO is selected for close monitoring | X | ^(RE|NW|NN|NDE|NPM|NP|RDF|RI|AC|-2)$ | Accepted values: RE, NW, NN, NDE, MP, RDF, RI, AC, -2 See Annex E - Result issued values for more information |