Guidance
File format
Updated 15 June 2022
Download CSV 2.58 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular Expression |
|---|---|---|---|---|
| ExamSeries | Exam series data relates to, for example June 2017 | 1 | ^(January|June|March|November)([ ][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 (four digits), a dash, month (two digits), a dash, day (two digits) |
| AwardingOrganisation | Name of the awarding organisation | 3 | ^.{1,100}$ | One to 100 characters accepted |
| QAN | Qualification Accreditation Number, for example 123/1234/1 | 4 | ^.{1,10}$ | One to 10 characters accepted -2 also accepted |
| QualificationLevel | Level of qualification, for example GCSE | 5 | ^(GCSE|AS|A level |GCE A level)$ | One of the following list: GCSE, AS, A level, GCE A level. GCE A level accepted as a value for candidates not certificating, taking units that can be used to certificate against more than one specification, which could be either AS or A level. |
| UnitOrComponentCode | Unit or component code as designated in the specification | 6 | ^.{1,10}$ | One to 10 characters accepted |
| SpecificationCode | Specification code, also known as Subject Award Code and Cash-in Code | 7 | ^.{1,7}$ | One to 7 characters accepted -2 also accepted |
| SpecificationTitle | Specification title, also known as subject title | 8 | ^.{1,150}$ | One to 150 characters accepted -2 also accepted |
| CentreNo | NCN number of centre at time of certification | 9 | ^.{1,5}$ | One to 5 characters accepted |
| UniqueCandidateIdentifier | Unique Candidate Identifier (UCI) | 10 | ^.{1,13}$ | One to 13 characters accepted |
| StageScriptLost | To indicate when script was lost | 11 | ^(before marking|postmarking)$ | Accepted values: before marking post-marking |
| Cause | To indicate how the script was lost | 12 | See accepted values | Accepted values: lost in post - centre to AO lost in post - centre to scanning centre lost in post - centre to examiner lost in post - examiner to AO lost in post - AO to examiner lost in post - examiner to examiner lost within AO lost within courier premises lost within centre destroyed stolen cannot retrieve from examiner scanning issue other IT issue |
| Outcome | To indicate action taken | 13 | ^(estimated marks|use marks already entered by assessors|retake assessment)$ | Accepted values: estimated marks use marks already entered by assessors retake assessment |
| WholeCentreCohortAffected | To indicate whether the whole cohort from the centre was affected | 14 | ^(Y|N)$ | Accepted values: Y N |