Guidance
File format
Updated 13 December 2024
Download CSV 3.82 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular Expression |
|---|---|---|---|---|
| Exam Series | Exam series data relates to, for example June 2024 | 1 | ^(January|June)([ ][0-9][0-9][0-9][0-9])$ | Full month name of exam series and year. |
| Reporting date | 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). |
| Awarding organisation | Name of the awarding organisation | 3 | ^.{1,100}$ | 1 to 100 characters accepted |
| Malpractice case identifier | Unique malpractice case identifier (allocated by individual awarding organisations). Acts of malpractice which are explicitly linked (for example, two candidates suspected of colluding together or committing disruptive acts together, or a centre staff member and candidate suspected of working together to commit malpractice) should be allocated the same malpractice case identifier. Acts of malpractice which are not explicitly linked should be allocated different malpractice case identifiers. Where it is unclear whether malpractice acts are linked, awarding organisations should exercise their judgement in assigning case identifiers based on the evidence provided. Must be unique across all years of data. If you reuse identifiers each year, please prefix the identifier with the year, for example, 202324/12345 | 4 | ^.{1,25}$ | 1, to 25 characters accepted |
| Centre No. | Centre number (NCN) | 5 | ^\d{1,5}$ | Up to five digit integer accepted |
| Type of malpractice | To indicate type of malpractice | 6 | ^(Candidate|Centre|Centre staff)$ | Accepted values: Candidate, Centre, Centre staff. |
| Unique Candidate Identifier | Unique Candidate Identifier (UCI) | 7 | ^.{1,13}$ | Alpha numeric 13 characters accepted. -2 also accepted for centre and centre staff malpractice. |
| Staff identifier | Unique centre staff identifier (allocated by individual awarding organisations). -2 accepted for candidate malpractice, or where number of staff involved in case is unknown. | 8 | ^.{1,50}$ | 1, to 50 characters accepted. -2 also accepted. |
| QAN | Qualification Accreditation Number,for example, 123/1234/1 | 9 | ^.{1,10}$ | 1, to 10 characters accepted. -2 also accepted for candidates not certificating, taking units that can be used against either AS or A level specifications. |
| Specification title | Specification title also known as subject title | 10 | ^.{1,150}$ | 1, to 150 characters accepted. -2 also accepted. |
| Specification code | Specification code also known as Subject Award Code and Cash-in Code | 11 | ^.{1,7}$ | 1, to 7 characters accepted. -2 also accepted. |
| Unit code | Unit code | 12 | ^.{1,10}$ | 1 to 10 characters accepted. -2 accepted where not available or not applicable |
| Qualification level | Level of qualification, for example, GCSE | 13 | ^(GCSE|GCSE linear|GCSE short course|GCSE full course|AS|A level||App A Level Dbl|App A Level Sgl|App AS Dbl|App AS Sgl|GCE A level|Project L3|AEA)$ | One of the following list: GCSE, GCSE linear, GCSE short course, GCSE full course, AS, A level, App A Level Dbl, App A Level Sgl, App AS Dbl, App AS Sgl, Project L3 or AEA. GCE A level also accepted for candidates not certificating, taking units that can be used against either AS or A level specifications. -2 also accpted. |
| Assessment type | To indicate type of assessment, internal or external. | 14 | ^(Internal|External)$ | Internal or External accepted. -2 accepted where not available or not applicable. |
| Type of offence | Description of offence as per pre-agreed list of offences. | 15 | Accepted values as per pre-agreed list of offences. | Accepted values list – See annex A |
| Type of penalty issued | Description of penalty as per pre-agreed list of penalties. | 16 | Accepted values as per pre-agreed list of penalties. | Accepted values list – See annex B |