Guidance
File format
Updated 14 November 2023
Download CSV 3.1 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular Expression | ||
|---|---|---|---|---|---|---|
| Exam Series | Exam series data relates to e.g. June 2018 | 1 | ^(January|June)([ ][0-9][0-9][0-9][0-9])$ | Full month name of exam series and year. | Not set | Not set |
| 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). | Not set | Not set |
| Awarding organisation | Name of the awarding organisation | 3 | ^.{1,100}$ | 1 to 100 characters accepted | Not set | Not set |
| Malpractice case identifier | Unique case identifier Note: what makes this unique | 4 | ^.{1,25}$ | 1, to 25 characters accepted | Not set | Not set |
| Centre No. | Centre number (NCN) | 5 | ^\d{1,5}$ | Up to five digit integer accepted | Not set | Not set |
| Type of malpractice | To indicate type of malpractice | 6 | ^(Candidate|Centre|Centre staff)$ | Accepted values: Candidate, Centre, Centre staff. | Not set | Not set |
| Unique Candidate Identifier | Unique Candidate Identifier (UCI) | 7 | ^.{1,13}$ | Alpha numeric 13 characters accepted. -2 also accepted for centre and centre staff malpractice. | Not set | Not set |
| 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. | Staff identifier | Staff identifier |
| QAN | Qualification Accreditation Number e.g. 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. | Not set | Not set |
| Specification title | Specification title also known as subject title | 10 | ^.{1,150}$ | 1, to 150 characters accepted. -2 also accepted. | Not set | Not set |
| 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. | Not set | Not set |
| Unit code | Unit code | 12 | ^.{1,10}$ | 1 to 10 characters accepted. -2 accepted where not available or not applicable | Not set | Not set |
| Qualification level | Level of qualification e.g. 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. | Not set | Not set |
| 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. | Not set | Not set |
| 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 | Not set | Not set |
| 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 | Not set | Not set |