Guidance
File format
Updated 15 May 2023
Download CSV 3.55 KB
| Name | Description | Position | Validation Regular Expression | Description of regular expression |
|---|---|---|---|---|
| ReportingDate | Date the file was due to be submitted regardless of when it was actually uploaded | 1 | ^(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) Format accepted 120 ODBC canonical yyyy-mm-dd |
| ExamSeries | Exam series that the data relates to, for example Summer 2022 | 2 | ^(Autumn|Winter|Summer)([ ][0-9][0-9][0-9][0-9])$ | The exam series in the following format: Autumn, Winter or Summer, end year (4 digits) Format accepted yyyy-yyyy |
| AwardingOrganisation | Name of the awarding organisation | 3 | ^.{1,100}$ | 1 to 100 characters accepted |
| QualificationNumber | Qualification Number for example 123/1234/1 | 4 | ^.{1,10}$ | 1 to 10 characters accepted |
| QualificationTitle | The qualification title as it appears on Ofqual's Register | 5 | ^.{1,100}$ | 1 to 10 characters accepted |
| AssessmentCode | Unique identifier for the assessment When one unit is assessed by one assessment, it must be the URN (Unit Reference Number) | 6 | ^.{1,50}$ | 1 to 50 characters accepted |
| AssessmentTitle | Title of the assessment | 7 | ^.{1,150}$ | 1 to 150 characters accepted |
| AssessmentStartDate | Start date of assessment window or date of assessment if it is a single day, example the earliest date on which the learners may take the assessment | 8 | ^(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) Format accepted 120 ODBC canonical yyyy-mm-dd |
| AssessmentEndDate | End date of assessment window or date of assessment if it is a single day, example the final date on which the learners may take the assessment. Repeat the start date value for assessments which are only taken on one day. | 9 | ^(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) Format accepted 120 ODBC canonical yyyy-mm-dd |
| AssessmentType | Internal assessment or external assessment (external assessment means externally set and marked) | 10 | ^(Internal|External)$ | Accepted values: Internal External |
| AssessmentMethod | Description of the assessment method used for the component. If multiple assessment methods are used, please use the value “Mixed”. Please choose the most appropriate one | 11 | ^(Aural assessment|Coursework|E-assessment|Multiple choice examination|Oral examination|Portfolio of evidence|Practical demonstration/assignment|Practical examination|Task-based controlled assessment|Written examination|Mixed)$ | Accepted values: Aural assessment Coursework E-assessment Multiple choice examination Oral examination Portfolio of evidence Practical demonstration/assignment Practical examination Task-based controlled assessment Written examination Mixed |
| DeliveryMode | Mode of the primary assessment method used for the component Please choose the most appropriate one. | 12 | ^(Paper based|Computer based|Face to face|Remote|Product based|Mixed)$ | Accepted values: Paper based Computer based Face to face Remote Product based Mixed |
| AssessmentEntries | Number of entries received for each assessment taking place on specified date | 13 | ^.{1, 99999999}$ | Eight digit intiger is accepted |
| EntryCutOff | The date by which no more entries can be made by a centre | 14 | ^(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) Format accepted 120 ODBC canonical yyyy-mm-dd |