Guidance
TQ Appeals - file format
Updated 19 July 2021
Download CSV 7.71 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular Expression / Accepted values |
|---|---|---|---|---|
| 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) | 1 | ^ (0[1-9]|[12][0-9]|3[01]) [/](0[1-9]|1[012])[/] (20)\d\d$ or ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: day (2 digits), forward slash, month (2 digits), forward slash, year (4 digits), or: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) for example, 15/01/2020 or 2020-01-15 |
| AssessmentSeries | Assessment series data relates to, for example June 2023 | 2 | ^(June)([][0-9][0-9][0-9][0-9])$ | Full month name and year of Assessment series for example June 2023 |
| AwardingOrganisation | Acronym of the awarding organisation (AO) | 3 | ^.{1,100}$ | A valid AO Acronym Note: value must be consistent within the file |
| QualificationNumber | Unique identifier for the TQ as it appears in Ofqual’s Register of Regulated qualifications | 4 | ^.{1,10}$ | A valid qualification number |
| ComponentCode | Unique identifier for the component which the assessment relates to (assigned by the awarding organisation) | 5 | ^.{1,10}$ | 1 to 10 characters |
| SubComponentType | TQ sub-component which the assessment falls under | 6 | ^(Core Exam|Core Project|Occupational Specialism)$ | Accepted values: • Core Exam • Core Project • Occupational Specialism |
| AssessmentCode | Unique identifier for the assessment (assigned bythe awarding organisation) | 7 | ^.{1,10}$ | 1 to 10 characters |
| ULN | Unique Learner Number | 8 | ^.{0000000001,99999 99999}$ | A numeric value between 0000000001 and 9999999999 |
| UCI | Unique Candidate Identifier | 9 | ^.{1,13}$ | A valid Unique Candidate Identifier Note: enter -2 if not available |
| UKPRN | UK Provider Reference Number | 10 | ^.{10000000,9999999 9}$ | A numeric value between 10000000 and 99999999 |
| NCN | Centre ID – National Centre Number | 11 | ^\d{1,5}$ | Up to 5-digit integer Note: enter -2 if not available |
| CaseReferenceNumber | Unique reference number for the appeal case assigned by the awarding organisation | 12 | ^.{1,25}$ | 1 to 25 characters |
| NatureOfAppeal | The nature of the appeal | 13 | ^(Provider error appeal (provider)|AO error appeal (provider)|AO error appeal (student)|Provider process appeal (student)|Provider academic judgement appeal - range of evidence (student)|Provider academic judgement appeal - grade (student))$ | Accepted values: • Provider error appeal (provider) • AO error appeal (provider) • AO error appeal (student) • Provider process appeal (student) • Provider academic judgement appeal - range of evidence (student) • Provider academic judgement appeal - grade (student) See the Annex for more description of these values |
| CurrentStageOfAppeal | The current stage of the appeal (at the time of data submission) | 14 | ^(Stage 1|Stage 2)$ | Accepted values: • Stage 1 • Stage 2 |
| StageAppealResolved | The stage the appeal was resolved | 15 | ^(Stage 1|Stage 2| With AO but inprocess)$ | Accepted values: • Stage 1 • Stage 2 • With AO but in process |
| AppealUpheld | Was the appeal upheld? | 16 | ^(Yes|No|TBC)$ | Accepted values: • Yes • No • TBC |
| PreAppealAssessmentRawMark | Pre-appeal Assessment Raw mark | 17 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PostAppealAssessmentRawMark | Post-appeal assessment raw mark | 18 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PreAppealAssessmentUMSMark | Pre-appeal assessment UMS mark | 19 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PostAppealAssessmentUMSMark | Post-appeal assessment UMS mark | 20 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PreAppealSubComponentRawMark | Pre-appeal Sub-component Raw mark | 21 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PostAppealSubComponentRawMark | Post-appeal sub-component raw mark | 22 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PreAppealSubComponentUMSMark | Pre-appeal sub-component UMS mark | 23 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PostAppealSubComponentUMSMark | Post-appeal sub-component UMS mark | 24 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PreAppealComponentRawMark | Pre-appeal component raw mark | 25 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PostAppealComponentRawMark | Post-appeal component raw mark | 26 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PreAppealComponentUMSMark | Pre-appeal component UMS mark | 27 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PostAppealComponentUMSMark | Post-appeal component UMS mark | 28 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals Note: enter -2 if not applicable |
| PreAppealAssessmentGrade | Pre-appeal assessment grade | 29 | ^(A*|A|B|C|D|E|Q|U|X|Distinction|Merit|Pass|-2)$ | Accepted values: • A* • A • B • C • D • E • Q • U • X • Distinction • Merit • Pass Note: enter -2 if not applicable |
| PostAppealAssessmentGrade | Post-appeal assessment grade | 30 | ^(A*|A|B|C|D|E|Q|U|X|Distinction|Merit|Pass|-2)$ | Accepted values: • A* • A • B • C • D • E • Q • U • X • Distinction • Merit • Pass Note: enter -2 if not applicable |
| PreAppealSubComponentGrade | Pre-appeal sub-component grade | 31 | ^(A*|A|B|C|D|E|Q|U|X|Distinction|Merit|Pass|-2)$ | Accepted values: • A* • A • B • C • D • E • Q • U • X • Distinction • Merit • Pass Note: enter -2 if not applicable |
| PostAppealSubComponentGrade | Post-appeal sub- component grade | 32 | ^(A*|A|B|C|D|E|Q|U|X|Distinction|Merit|Pass|-2)$ | Accepted values: • A* • A • B • C • D • E • Q • U • X • Distinction • Merit • Pass Note: enter -2 if not applicable |
| PreAppealComponentGrade | Pre-appeal component grade | 33 | ^(A*|A|B|C|D|E|Q|U|X|Distinction|Merit|Pass|-2)$ | Accepted values: • A* • A • B • C • D • E • Q • U • X • Distinction • Merit • Pass Note: enter -2 if not applicable |
| PostAppealComponentGrade | Post-appeal component grade | 34 | ^(A*|A|B|C|D|E|Q|U|X|Distinction|Merit|Pass|-2)$ | Accepted values: • A* • A • B • C • D • E • Q • U • X • Distinction • Merit • Pass Note: enter -2 if not applicable |
| DateReceived | Date when the appeal request is received | 35 | ^ (0[1-9]|[12][0-9]|3[01]) [/](0[1-9]|1[012])[/] (20)\d\d$ or ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: day (2 digits), forward slash, month (2 digits), forward slash, year (4digits), or: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
| DateCompleted | Date when the appeal is completed and decision letter is sent | 36 | ^ (0[1-9]|[12][0-9]|3[01]) [/](0[1-9]|1[012])[/] (20)\d\d$ or ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: day (2 digits), forward slash, month (2 digits), forward slash, year (4digits), or: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
| DateScriptOrEquivalentRequested | Date when a script isrequested at any stage during the post-results service process | 37 | ^ (0[1-9]|[12][0-9]|3[01]) [/](0[1-9]|1[012])[/] (20)\d\d$ or ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: day (2 digits), forward slash, month (2 digits), forward slash, year (4digits), or: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
| DateReasonRequested | Date reason requested | 38 | ^ (0[1-9]|[12][0-9]|3[01]) [/](0[1-9]|1[012])[/] (20)\d\d$ or ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: day (2 digits), forward slash, month (2 digits), forward slash, year (4digits), or: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |