Guidance

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.