Guidance
TQ Malpractice: guide to the data submission process file format
Updated 2 September 2022
Download CSV 2.87 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) e.g. 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 | 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 Note: enter -2 if not applicable |
| SubComponentType | TQ sub-component which the assessment falls under (Core ExamCore ProjectOccupational Specialism) | 6 | ^(Core Exam|Core Project|Occupational Specialism|-2)$ | Accepted values: • Core Exam • Core Project • Occupational Specialism Note: enter -2 if not applicable |
| AssessmentCode | Unique identifier for the assessment (assigned by the awarding organisation) | 7 | ^.{1,10}$ | 1 to 10 characters Note: enter -2 if not applicable |
| MalpracticeCaseIdentifier | Unique case identifier assigned by the awarding organisation | 8 | ^.{1,25}$ | 1 to 25 characters |
| TypeOfMalpractice | Candidate/Centre/Centre Staff/Examiner | 9 | ^(Candidate|Centre |Centre staff|Examiner)$ | Accepted values: • Candidate • Centre • Centre staff • Examiner |
| UKPRN | Centre ID – UK Provider Reference Number | 10 | ^.{10000000,99999999}$ | A numeric value between 10000000 and 99999999 |
| NCN | Centre ID – National Centre Number | 11 | ^\d{1,5}$ | Up to 5-digit integer accepted Note: enter -2 if not available |
| ULN | Unique Learner Number | 12 | ^.{0000000001,9999999999}$ | A numeric value between 0000000001 and 9999999999 |
| UCI | Unique Candidate Identifier | 13 | ^.{1,13}$ | Alpha-numeric 13 characters Note: enter -2 if not available |
| StaffIdentifier | Unique identifier for staff member (assigned by an awarding organisations) whether examiner or centre staff member | 14 | ^.{1,25}$ | 1 to 25 characters |
| TypeOfOffence | Description of offence from pre-set categories | 15 | Accepted values as per pre-agreed list of offences. | Accepted values (see annex A) |
| TypeOfPenalty | Description of penalty from pre-set categories | 16 | Accepted values as per pre-agreed list of offences. | Accepted values (see annex B) |