Guidance
PTQ Timetable file format
Updated 6 September 2022
Download CSV 3.07 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. This date to be provided by Ofqual. Format accepted 120 ODBC canonical yyyymm-dd | 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). |
| ExamSeries | Exam series that the data relates to | 2 | ^(Autumn|Winter|Summer|Spring)([ ][0-9][0-9][0-9][0-9])$ | Exam series and year For example, “Autumn 2022”, “Winter 2022”, “Spring 2023”, “Summer 2023” |
| 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 | Title of qualification | 5 | ^.{1,150}$ | 1 to 150 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 (for example the earliest date on which the learners may take the assessment). Format accepted 120 ODBC canonical yyyymm-dd | 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) |
| AssessmentEndDate | End date of assessment window or date of assessment if it is a single day (for example the final date on which the learners may take the assessment). Format accepted 120 ODBC canonical yyyymm-dd | 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). Repeat the start date value for assessments which are only taken on one day |
| 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, pleaseuse the value “Mixed” | 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 |