Guidance
File format
Updated 1 May 2024
Download CSV 11.3 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 see Annex B – Centre Codes | H | ^\{1,14}$ | Up to 2 characters between 1-14 |
| 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 Accepted values: M F -2 accepted for other or not stated | 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 |
| ExpectingResult | At this point in the collection all candidates would be expecting a result. Your checkpoint activities with centres should have enabled you to identify which students are expecting a result in August for the purposes of progression. This means that all students at this stage should have a ‘Y’ for this field. As progression towards results takes place, the status of individual learners may change and this will be captured in data returns for Part Two (if you are selected for the close monitoring activities) and/or Part Three of the data returns. For AOs selected for close monitoring ONLY: if a centre confirms additional students will be expecting a result in August after the checkpoint activity has taken place, these students can be added to this field during the close monitoring submissions. Please submit YL (Yes Late) for these students. Please also ensure that you add a note in the AdditionalInformation field in position X to identify these students as late entries. These students’ results should be categorised along with the others from the checkpoint activity and NOT categorised as AC (Additional Certification). When submitting data returns for Part Three (Results Issued) please include any additional students who were not included in the checkpoint submission in Part One B in this field and identify them as YL (Yes Late). Please also ensure that you add a note in the AdditionalInformation field in position X to identify these students as late entries. These students’ results should be categorised as AC (Additional Certification) | U | ^(Y|YL)$ | Y (or YL if selected for close monitoring) |
| SeniorContactConfirmed | This is confirmation that the AO has senior designated contact details and has processes to ensure such contacts are kept up to date when key centre staff change. It does not matter if this has been collected through a collaborative process or at AO level. This field is intended to provide Ofqual with assurance that you are confident you could contact an appropriate senior member of centre staff in the event that this becomes necessary. • AOs who have their SDC details collected for them via the NCN process ONLY should submit NCN in this field. • AOs who have their SDC details collected for them via the NCN process AND collect their own SDC data for all their centres in addition to NCN should submit NCNA. • Where an AO collects SDC data through the NCN process for most centres, they should submit NCN for the centres where the data is collected through NCN and for the centres where the AO collects SDC data through their own processes, they should submit a Y (yes) or N (no). • All other AOs should submit a Y (yes) or N (no) | V | ^(Y|N|NCN|NCNA)$ | Y, N, NCN or NCNA |
| ResultStatus | OnTrackToReceiveResult_ AllAssessmentsMarkedAnd_OrModerated - The candidate has all the evidence required for certification to take place and for the result to be issued. All examinations have been marked and moderation has taken place. Any EQA reports have been received and the marks for each unit have been agreed so that results can be issued and certification can take place. OnTrackToReceiveResult_ AllEvidenceReceived - All evidence other than examination scripts required for a certification has been received. Moderation and EQA visits are not yet complete. Any EQA visits should have been booked by centres. If any of this evidence is missing, not yet received or EQA visits not confirmed then the student should be considered as ‘StatusNotConfirmed’. NoLongerExpectingResult - The candidate is no longer expecting a result. The centre has confirmed that this candidate is no longer expecting a result. The centre may have withdrawn the candidate or have decided not to certificate at this time. StatusNotConfirmed - There is insufficient evidence for the AO to award a result. The AO is unable to award a result as there may be insufficient evidence as there are units still to be sat or evidence still has to be received and the centre has not confirmed its intentions or booked an EQA visit | W | ^(S1|S2|S3|S4|-2)$ | S1 S2 S3 S4 -2 only allowed when submitting Part One data collection (and Part Three if AO is NOT selected for close monitoring) |
| ResultIssued | ResultIssued_AsExpected - The candidate received the result as expected at the term-time checkpoint. (RE) • AOs selected for close monitoring who included additional students in the progress towards results data collections in Part Two should continue to submit results data for those students in these fields and NOT as an additional certification • If a student received a result but was NOT included in the term-time checkpoint data return OR in the progress towards results data, they should NOT be included here but instead, as AC (AdditionalCertification). ResultNotIssued_Withdrawn - Centre has withdrawn student from the qualification (e.g. student has changed courses or left centre.) Please note, in this field, the student has not received a result because of an action or decision made by the centre. (NW). ResultNotIssued-NotClaimed - Centre deferred or confirmed its intention not to claim/cash in certification for student. Please note, in this field, the student has not received a result because of an action or decision made by the centre. (NN). ResultNotIssued_Deferred - AO did not certificate candidate because the centre did not confirm its intention or did not submit sufficient evidence for the AO to be able to certificate. This would also include where a candidate was absent without good reason or where the reason has not been shared by the centre. Please note, in this field, the student has not received a result because of an action or decision made by the AO (which could be due to lack of engagement from the centre). (ND). ResultNotIssued_Pending - The candidate has not yet had the result or had the result issued late due to ongoing malpractice/maladministration/late claims. Please note, in this field, the student has not received a result because of an action or decision made by the AO (which could be due to lack of engagement from the centre). (NP). ResultIssued_Different - The candidate has certificated for a different course to that expected at the term-time checkpoint. They may have achieved better than expected results or a greater number of units and were able to ‘top up’ to a larger qualification than expected OR may have had lower results, or fewer units completed than expected and therefore ‘stepped down’ and claimed for a smaller qualification. (RDF). ResultIssued_Incorrect - The candidate received an incorrect result. This could have been due to an error in processing the candidate results by the AO OR an error by the centre, for example submitting results incorrectly. This is NOT an attempt to collect reviews of marking queries which are considered BAU. (RI). Additional Certification - The candidate received a result but was not included in the term-time checkpoint. They were not expected at the time of the term-time checkpoint to receive a result but the centre has made a late claim. Any candidate that was added during the Part Two data submission (Progress Towards Results – close monitoring group) should NOT be included here but should be categorised as ‘ResultIssued_AsExpected or whichever code is appropriate. (AC) | X | ^(RE|NW|NN|NDE|NP|RDF|RI|AC|-2)$ | Accepted values: * RE * NW * NN * NDE * NP * RDF * RI * AC. -2 only allowed when submitting Part One and Part Two data collections |