Guidance

File format

Updated 19 March 2021
Download CSV 1.01 KB

Name Description Position Validation Regular Expression Description of Regular Expression
Exam series Exam series data relates to e.g. June 2016 1 ^(January|March|June|November)([ ][0-9][0-9][0-9][0-9])$ Full month name of exam series and year.
Awarding organisation Awarding organisation name 2 ^.{1,100}$ One, to one hundred characters accepted
Reporting date Date the file was due to be submitted regardless of when it was actually uploaded. Format accepted either 103 British/French dd/mm/yyyy, or 120 ODBC canonical yyyy-mm-dd. 3 ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ "The date in the following format: day (two digits), forward slash, month (two digits), forward slash, year (four digits), or: year (four digits), a dash, month (two digits), a dash, day (two digits)."
Qualification Level and type of qualification e.g. GCSE 4 ^(GCSE|AS|A level)$ One of the following list: GCSE, AS, A level
Number of referrals Number of referrals 5 ^.{1,4}$ A numeric value between 0 and 9,999 accepted