File format
Updated 30 April 2024
Download CSV 10.2 KB
Field name | Description | Accepted values | Posit ion | Validation Regular Expression |
---|---|---|---|---|
AcademicYear | Academic year that the assessment or decision being appealed was taken | Academic year in the format: Year (4 digits), a dash, year (4 digits), for example 2023-2024 | 1 | ^(20)\d\d[-](20)\d\d$ |
ReportingDate | Date the file was due to be submitted to Ofqual regardless of when it was actually uploaded | The date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) yyyy-mm-dd | 2 | ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9][12][0-9]|3[01])$ |
AwardingOrganisation | Name of the awarding organisation | 1 to 100 characters accepted | 3 | ^.{1,100}$ |
CaseReferenceNumber | Unique reference number for the appeal case assigned by the awarding organisation | 1 to 25 characters accepted | 4 | ^.{1,25}$ |
QualificationNumber | Qualification number as recorded in the Register | 1 to 10 characters accepted, for example 123/1234/1. -2 accepted for not applicable, for example appeals that are not specific to a single qualification, where a candidate has not cashed-in or where CurrentStageOfAppeal is ‘Application not proceeded’ | 5 | ^.{1,10}$ |
QualificationTitle | The qualification title as it appears on Ofqual’s Register | 1 to 100 characters accepted. -2 accepted for not applicable, for example appeals that are not specific to a single qualification, where a candidate has not cashed-in or where CurrentStageOfAppeal is ‘Application not proceeded’ | 6 | ^.{1,100}$ |
SpecificationCode | Specification code, if relevant may also be known as subject code or pathway code | 1 to 7 characters accepted. -2 accepted for not applicable, for example appeals that are not specific to a single assessment, or where CurrentStageOfAppeal is ‘Application not proceeded’ | 7 | ^.{1,7}$ |
SpecificationTitle | Specification title, if relevant must be provided if specification code is provided | 1 to 150 characters accepted. -2 accepted for not applicable, for example appeals that are not specific to a single assessment, or where CurrentStageOfAppeal is ‘Application not proceeded’ | 8 | ^.{1,150}$ |
AssessmentCode | Unique AO-assigned identifier for the assessment. When one unit is assessed by one assessment, please provide the URN (Unit Reference Number) | 1 to 50 characters accepted. -2 accepted for not applicable, for example appeals that are not specific to a single assessment, or where CurrentStageOfAppeal is ‘Application not proceeded’ | 9 | ^.{1,50}$ |
UCI | Unique Candidate Identifier | Alpha numeric 13 characters accepted. This field can also be used for unique centre staff identifier where relevant (see point 3 of general completion guidelines) | 10 | ^.{1,13}$ |
ULN | Unique Learner Number | A numeric value between 0000000001 and 9999999999. -2 accepted where ULN is unknown or CurrentStageOfAppeal is ‘Application not proceeded’ | 11 | ^.{1,10}$ |
CandidateIdentifierOther | Any other unique candidate number allocated by individual awarding organisation. Must be provided where neither UCI or ULN are available | 1 to 20 characters accepted. -2 permitted where at least one of UCI or ULN have been provided, or CurrentStageOfAppeal is ‘Application not proceeded’ | 12 | ^.{1,20}$ |
FirstName | Candidate first name | 0 to 150 characters accepted. -2 accepted where appeal does not relate to a candidate or CurrentStageOfAppeal is ‘Application not proceeded’ | 13 | ^.{0,150}$ |
MiddleNames | Candidate’s middle name(s), if able to separate out from first names | 0 to 150 characters accepted. Can be left blank if not known or unavailable, or if middle names cannot be separated from first names | 14 | ^.{0,150}$ |
Surname | Candidate surname | 0 to 150 characters accepted. -2 accepted where appeal does not relate to a candidate or CurrentStageOfAppeal is ‘Application not proceeded’ | 15 | ^.{0,150}$ |
DateOfBirth | Candidate date of birth | The date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits). 2999-12-31 is accepted where appeal does not relate to a candidate or CurrentStageOfAppeal is ‘Application not proceeded’ | 16 | ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9][12][0-9]|3[01])$ |
CentreNCN | Centre’s National Centre Number as allocated by the Joint Council for Qualifications (JCQ) | Up to 5-digit integer accepted. -2 accepted where the centre number is unknown, centre is not on the NCN register, candidate is not registered to a centre, or CurrentStageOfAppeal is ‘Application not proceeded’ | 17 | \d{1,5}$ |
CentreURN | Centre ID – Unique Reference Number as assigned by the Department for Education | Up to 6-digit integer accepted. -2 accepted where the centre number is unknown, centre is not on the URN register, candidate is not registered to a centre, or CurrentStageOfAppeal is ‘Application not proceeded’ | 18 | ^\d{1,6}$ |
CentreIdentifierOther | Any other number allocated to the centre or assessment venue by individual awarding organisations. Must be provided if neither CentreNCN nor CentreURN are available | 1 to 15 characters accepted. -2 accepted where at least one of NCN or URN have been provided or for candidates who are not registered to a centre, candidate is not registered to a centre, or CurrentStageOfAppeal is ‘Application not proceeded’ | 19 | ^.{0,15}$ |
CentreName | Name of the centre | 1 to 100 characters accepted. -2 accepted where candidate is not registered to a centre, or CurrentStageOfAppeal is ‘Application not proceeded’ | 20 | ^.{0,100}$ |
CentrePostcode | Postcode of the centre. Must be provided if neither CentreNCN nor CentreURN are available | 1 to 10 characters accepted. -2 accepted where candidate is not registered to a centre, or CurrentStageOfAppeal is ‘Application not proceeded’ | 21 | ^.{0,10}$ |
TypeOfDecisionAppealed | The type of decision that is being appealed | Accepted values: * Component or qualification result * Malpractice or maladministration * Reasonable adjustment * Special consideration Definitions of stages provided in Annex A | 22 | ^(Component or qualification result|Malpractice or maladministration|Reasonable adjustment|Special consideration)$ |
GroundOfAppeal | Ground of appeal | Accepted values: *Administrative error - centre *Administrative error - AO *Procedural inconsistency - centre * Procedural inconsistency - AO *Unreasonable exercise of academic judgement - centre *Unreasonable exercise of academic judgement - AO Definitions provided in Annex A | 23 | ^(Administrative error - centre|Administrative error - AO|Procedural inconsistency - centre|Procedural inconsistency - AO|Unreasonable exercise of academic judgement - centre|Unreasonable exercise of academic judgement - AO)$ |
CurrentStageOfAppeal | Current stage of appeal at the time data reported | Accepted values: *Application not proceeded *Preliminary appeal *Independent review *Independent review – no preliminary appeal. Definitions of stages provided in Annex A | 24 | ^(Application not proceeded|Preliminary appeal|Independent review|Independent review – no preliminary appeal)$ |
StageAppealResolved | Stage the appeal was resolved | Accepted values: *Application not proceeded *Preliminary appeal *Independent review *Independent review – no preliminary appeal *Still in process Definitions of stages provided in Annex A | 25 | ^(Application not proceeded|Preliminary appeal|Independent review|Independent review – no preliminary appeal|Still in process)$ |
ReasonNotProceeded | For ‘Application not proceeded’appeals only, to indicate the reason why the appeal did not progress | Accepted values: * Withdrawn by centre * Invalid grounds * No ROMM application * Cancelled by AO Invalid application -2 expected where CurrentStageOfAppeal is not ‘Application not proceeded’ | 26 | ^(Withdrawn by centre|Invalid grounds|No ROMM application|Cancelled by AO|Invalid application|-2)$ |
AppealUpheld | Whether appeal was upheld at the CurrentStageOfAppeal reported | Accepted values: * Yes * No * TBC (to be confirmed). -2 expected where CurrentStageOfAppeal is ‘Application not proceeded’ | 27 | ^(Yes|No|TBC|-2)$ |
PreAppealAssessmentGrade | Pre-Appeal Assessment Grade at the beginning of the CurrentStageOfAppeal | Accepted values provided in Annex B (given below). -2 if not applicable, grade is not captured when appeal is not upheld, or CurrentStageOfAppeal is ‘Application not proceeded’ | 28 | Annex B |
PostAppealAssessmentGrade | Post-Appeal Assessment Grade at the end of the CurrentStageOfAppeal | Accepted values provided in Annex B. -2 if not applicable, grade is not captured when appeal is not upheld, or CurrentStageOfAppeal is ‘Application not proceeded’ | 29 | Annex B |
PreAppealAssessmentRawMark | Pre-Appeal Assessment Raw Mark at the beginning of the CurrentStageOfAppeal | Number between 0 and 999. -2 if not applicable, mark is not captured when appeal is not upheld, or CurrentStageOfAppeal is ‘Application not proceeded’ | 30 | ^\d{1,3}$ |
PostAppealAssessmentRawMark | Post-Appeal Assessment Raw Mark at the end of the CurrentStageOfAppeal | Number between 0 and 999. -2 if not applicable, mark is not captured when appeal is not upheld, or CurrentStageOfAppeal is ‘Application not proceeded’ | 31 | ^\d{1,3}$ |
PreAppealQualificationGrade | Pre-Appeal Qualification Grade originally appealed | Accepted values provided in Annex B. -2 if not applicable, grade is not yet known (for example for mid-flight learners), grade is not captured when appeal is not upheld, or CurrentStageOfAppeal is ‘Application not proceeded’ | 32 | Annex B |
PostAppealQualificationGrade | Post-Appeal Qualification Grade once all stages of appeal are complete | Accepted values provided in Annex B. -2 if not applicable, grade is not yet known (for example for mid-flight learners), grade is not captured when appeal is not upheld, or CurrentStageOfAppeal is ‘Application not proceeded’ | 33 | Annex B |
DateReceived | Date when the appeal request is received | Date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) | 34 | ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9][12][0-9]|3[01])$ |
DateCompleted | Date when the appeal is completed. For appeals progressed to Preliminary appeal or Independent review, defined as the date when an appeal is completed and decision letter is sent. For ‘Application not proceeded’ appeals, the date when a response was sent to the parent, candidate or centre. | Date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits). 2999-12-31 accepted if appeal not yet completed | 35 | ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9][12][0-9]|3[01])$ |