Access to scripts: guide to the data submission process
Updated 27 October 2023
Download CSV 2.54 KB
Name | Description | Position | Validation Regular Expression | Description of Regular Expression |
---|---|---|---|---|
ExamSeries | Exam series data relates to e.g. June 2020 | 1 | ^(January|March|June|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 one hundred characters accepted |
CentreNo | Centre number (NCN) | 4 | ^\d{1,5}$ | Up to five digit integer accepted |
UniqueCandidateIdentifier | Unique Candidate Identifier (UCI) | 5 | ^.{1,13}$ | Alpha numeric 13 characters accepted |
QualificationLevel | Level of qualification e.g. GCSE | 6 | ^(GCSE|GCSE linear|GCSE short course|GCSE full course|AS|A level|A-level|App A Level Dbl|App A Level Sgl|App AS Dbl|App AS Sgl|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, AEA. |
QAN | Qualification Accreditation Number e.g. 123/1234/1 | 7 | ^.{1,10}$ | One, to ten characters accepted. -2 accepted if unknown e.g. cases where candidate is not certificating |
SpecificationTitle | Specification title also known as subject title | 8 | ^.{1,150}$ | One, to one hundred and fifty characters accepted. Not Certificating also accepted. |
SpecificationCode | Specification code also known as Subject Award Code and Cash-in Code | 9 | ^.{1,7}$ | One, to seven characters accepted. -2 also accepted |
UnitCode | Unit code | 10 | ^.{1,10}$ | One, to ten characters accepted |
UnitTitle | Unit title | 11 | ^.{1,150}$ | One, to one hundred and fifty characters accepted |
DateScriptRequested | Date script requested | 12 | ^(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). |
DateScriptProvided | Date script provided | 13 | ^(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). 2999-12-31 accepted where script not provided |
Outcome | Script request decision | 14 | ^(Accepted|Rejected)$ | One of the following: Accepted, Rejected. |
ReasonForRejection | Reason request rejected | 15 | ^( Not applicable|Script lost|Other reasons)$ | One of the following list: Not applicable, Script lost, Other reasons. |