Guidance
File format
Updated 30 June 2023
Download CSV 2.11 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular Expression |
|---|---|---|---|---|
| ExamSeries | Exam series data relates to, for example June 2019. | 1 | ^(June)([ ][0-9][0-9][0-9][0-9])$ | Full month name of exam series and year. |
| ReportingDate | Date the file was due to be submitted regardless of when it was actually uploaded. Format accepted 120 ODBC canonical yyyy-mm-dd. | 2 | ^(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). |
| AwardingOrganisation | Name of the awarding organisation. | 3 | ^.{1,100}$ | 1 to 100 characters accepted. |
| QAN | Qualification Accreditation Number, for example 123/1234/1 | 4 | ^.{1,10}$ | 1 to 10 characters accepted. |
| QualificationLevel | Level of qualification e.g. GCSE | 5 | ^(GCSE|AS|A level|Project L3)$ | One of the following list: GCSE, AS, A level, Project L3. |
| UnitOrComponentCode | Unit or component code as designated in the specification. | 6 | ^.{1,10}$ | 1 to 10 characters accepted. |
| UnitOrComponentTitle | Unit or component title. | 7 | ^.{1,150}$ | 1 to 150 characters accepted |
| SpecificationCode | Specification code. | 8 | ^.{1,7}$ | 1 to 7 characters accepted. |
| SpecificationTitle | Specification title also known as subject title. | 9 | ^.{1,150}$ | 1 to 150 characters accepted. |
| AssessmentStartDate | Date of exam or start date of assessment window. Format accepted 120 ODBC canonical yyyy-mm-dd. | 10 | ^(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 | Date of exam or end of assessment window. Format accepted 120 ODBC canonical yyyy-mm-dd. | 11 | ^(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). |
| Session | To indicate if the exam is taken in the morning or afternoon session | 12 | ^(AM|PM)$ | Accepted values: AM or PM. |
| Tier | To indicate tier if applicable. | 13 | ^(F|H|F&H|-2)$ | One of the following list: F, H, F&H, -2. |
| ResitOnly | To indicate if resit only. | 14 | ^(Y|N)$ | One of the following list: Y, N. |