Guidance
File format
Updated 6 March 2024
Download CSV 3.52 KB
| Name | Description | Position | Validation Regular Expression | Description of Regular Expression |
|---|---|---|---|---|
| ReportingDate | Date the file was due to be submitted regardless of when it was actually uploaded. Format accepted 120 ODBC canonical yyyy-mm-dd | 1 | ^(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 | 2 | ^.{1,100}$ | One to 100 characters accepted |
| QualificationNumber | Qualification Accreditation Number as it appears in Ofqual’s Register of Regulated qualifications, for example 123/1234/1 | 3 | ^.{1,10}$ | One to 10 characters accepted |
| QualificationLevel | Level of qualification, for example GCSE | 4 | ^(GCSE|AS|A level)$ | One of the following list: GCSE, AS, A level |
| SpecificationCode | Specification code also known as Subject Award Code and Cash-in Code | 5 | ^.{1,7}$ | One to 7 characters accepted |
| SpecificationTitle | Specification title, also known as subject title | 6 | ^.{1,150}$ | One to 150 characters accepted |
| ULN | Unique Learner Number | 7 | ^.{1,10}$ | One to 10 characters accepted. -2 accepted if not available |
| UCI | Unique Candidate Identifier | 8 | ^.{1,14}$ | One to 14 characters accepted. -2 accepted if not available |
| FirstName | Candidate’s first name. If middle name cannot be separated from first name, please provide both names in the FirstName field | 9 | ^.{0,150}$ | One to 150 characters accepted |
| Surname | Candidate’s surname | 10 | ^.{0,50}$ | One to 50 characters accepted |
| DOB | To indicate candidate’s date of birth. Format accepted 120 ODBC canonical yyyy-mm-dd | 11 | ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | Date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits). 2999-12-31 accepted if DOB unknown |
| UKPRN | UK Provider Reference Number. "-2" if not known | 12 | ^.{1,8}$ | One to 8 characters accepted. -2 accepted if not known |
| NCN | Centre ID – National Centre Number | 13 | ^.{1,5}$ | One to 5 characters accepted |
| ReferenceNumber | Application for grade to be awarded using alternative assessment evidence reference number | 14 | ^.{1,50}$ | One to 50 characters accepted |
| RequestDate | Date when the request for grade to be awarded using alternative assessment evidence was made | 15 | ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | Date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
| DecisionDate | Date when the application was accepted or rejected | 16 | ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | Date in the following format: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
| Status | Status of the application Possible values: • Approved • Rejected • Pending | 17 | ^(Approved|Rejected|Pending)$ | Accepted values: • Approved • Rejected • Pending |
| RejectionReason | Reason for rejection (where applicable) Possible values: • Ineligible • Insufficient evidence | 18 | ^(Ineligible|Insufficient evidence)$ | Accepted values: • Ineligible • Insufficient evidence. -2 accepted if not known |
| ExamSeries | Exam series when the request for a grade to be awarded using alternative assessment evidence was made for | 19 | ^(June)([ ][0-9][0-9][0-9][0-9])$ | Full month name of exam series and year |
| Grade | Grade awarded using alternative assessment evidence. “-2” if application was rejected | 20 | ^(A*|A|B|C|D|E|U|X|Q|1|2|3|4|5|6|7|8|9|1-1|2- 1|2-2|3-2|3-3|4-3|4-4|5-4|5-5|6-5|6-6|7-6|7-7|8-7|8-8|9-8|9-9|-2)$ | One of the following list: A*, A, B, C, D, E, U, X, Q, 9 to 1, 9-9 to 1-1. -2 accepted for unknown value |