Guidance
Entries by year group: guide to the data submission process
Updated 2 September 2022
Download CSV 2.97 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular Expression | ||||
|---|---|---|---|---|---|---|---|---|
| ExamSeries | Exam series data relates to, for example June 2016 | 1 | ^(June|November)([ ][0-9][0-9][0-9][0-9])$ | Full month name of exam series and year. | Not set | Not set | Not set | Not set |
| 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 (four digits), a dash, month (two digits), a dash, day (two digits). | Not set | Not set | Not set | Not set |
| AwardingOrganisation | Name of the awarding organisation | 3 | ^.{1,100}$ | One, to one hundred characters accepted | Not set | Not set | Not set | Not set |
| QAN | Qualification Accreditation Number, for example 123/1234/1 | 4 | ^.{1,10}$ | One, to ten characters accepted | Not set | Not set | Not set | Not set |
| QualificationLevel | Level of qualification, for example GCSE | 5 | ^(GCSE|AS|A level|Project L3, AEA)$ | One of the following list: GCSE, AS, A level, Project L3 or AEA. | Not set | Not set | Not set | Not set |
| SpecificationCode | Specification code also known as Subject Award Code and Cash-in Code | 6 | ^.{1,7}$ | One, to seven characters accepted | Not set | Not set | Not set | Not set |
| SpecificationTitle | Specification title also known as subject title | 7 | ^.{1,150}$ | One, to one hundred and fifty characters accepted | Not set | Not set | Not set | Not set |
| FullOrShortCourse | To indicate if subject is full or short course for applicable qualifications, for example GCSE. -2 accepted where not applicable, for example A level. | 8 | ^(Full Course|Short Course|-2)$ | Full course, short course or -2 accepted. -2 accepted where not applicable, for example A level. | Not set | Not set | Not set | Not set |
| RouteOfAssessment | To indicate if assessment is modular or linear for applicable qualifications, for example GCSE. -2 accepted where not applicable, for example A level. | 9 | ^(Modular|Linear|-2)$ | Modular, linear or -2 accepted. | Not set | Not set | Not set | Not set |
| QualificationStatus | To indicate if subject is reformed or legacy, for applicable qualifications. | 10 | ^(Reformed|Legacy|)$ | Reformed or legacy accepted. | Not set | Not set | Not set | Not set |
| Country | For AO's to enter the specific country the data relates to, for example England, Wales, Northern Ireland. | 11 | ^(England|Wales|Northern Ireland)$ | England, Wales, Northern Ireland will be accepted. -2 accepted where a specification has a nil return. | Not set | Not set | Not set | Not set |
| YearGroup | To indicate the year group of entry | 12 | ^(Year 9-|Year 10|Year 11|Year 12|Year 13+|Year 11-|Year 13|Year 14+|-2)$ | Accepted values for GCSE: Year 9-, Year 10, Year 11, Year 12, Year 13+. -2 accepted where the year group is unknown or where a specification has a nil return. Accepted values for AS, A level, Project L3 and AEA: Year 11-, Year 12, Year 13, Year 14+ | Not set | Not set | Not set | Not set |
| CentreType | To indicate centre type based on centre codes detailed on page 4 of this document | 13 | ^\d{1,2}$ | A numeric value between 1 and 15 accepted. -2 accepted where a specification has a nil return. | Not set | Not set | Not set | Not set |
| NumberOfCandidates | Number of candidates by qualification level, specification code, country, year group and centre type specified. | 14 | ^\d{1,8}$ | A numeric value between 0 and 99,999,999 accepted. | Not set | Not set | Not set | Not set |
| Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set |
| Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set |
| Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set | Not set |