Guidance

File format

Updated 19 March 2021
Download CSV 2.69 KB

Name Description Position Validation Regular Expression Description of Regular Expression
ExamSeries Exam series data relates to for example June 2023 1 ^(June)([ ][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 (4 digits), a dash, month (2 digits), a dash, day (2 digits)
AwardingOrganisation Name of the awarding organisation 3 ^.{1,100}$ 1 to 100 characters accepted
QAN Qualification Accreditation Number for example 123/1234/1 4 ^.{1,10}$ 1 to 10 characters accepted
SpecificationTitle Specification title also known as subject title 5 ^.{1,150}$ 1 to 150 characters accepted
SpecificationCode Specification code 6 ^.{1,7}$ 1 to 7 characters accepted
CertificationCode Entry or option code to which candidates certificate 7 ^.{1,7}$ 1 to 7 characters accepted
QualificationLevel Level of qualification for example GCSE 8 ^(GCSE|AS|A level)$ One of the following list: GCSE, AS, A level
UnitOrComponentCode Unit or component identifier 9 ^.{1,10}$ 1 to 10 characters accepted
UnitOrComponentTitle Unit or component title 10 ^.{1,150}$ 1 to 150 characters accepted
AssessmentMaterialsType To indicate type of assessment material, for example question paper, supporting materials, NEA 11 ^(QP|Supporting materials|NEA)$ Accepted values: * QP * Supporting materials * NEA
DeliveryType To indicate the type of delivery for each of the assessment materials, for example Standard QP, Modified QP, etc. 12 ^(Standard|Modified|Online|On-screen)$ Accepted values: * Standard * Modified * Online * On-screen
TotalNoOfVersionsPerDeliveryType To indicate number of versions per delivery type 13 ^\d{1,3}$ A numeric value between 0 and 999 accepted
IssuedFreeFromError To indicate if paper, supporting materials, etc. issued without error 14 ^\d{1,3}$ A numeric value between 0 and 999 accepted
ErrataIssuedBeforeStartOfExam To indicate if an errata notice was issued 15 ^\d{1,3}$ A numeric value between 0 and 999 accepted
ErrorIdentifiedAfterExamStart To indicate if an error was identified after the assessment had started 16 ^\d{1,3}$ A numeric value between 0 and 999 accepted
ErrorIntroducedByCentre To indicate if error was introduced by centre during modification process. 0 equals no, 1 equals yes 17 ^([0|1|-2)$ Accepted values: * 0 equals no * 1 equals yes * -2 equals not applicable
NumberOfCandidates To indicate number of candidates taking delivery type specified 18 ^\d{1,7}$ A numeric value between 0 and 9,999,999 accepted