Guidance

VTQ Late results: File Format

Updated 14 November 2023
Download CSV 5.94 KB

Name Description Position Validation Regular Expression Description of Regular Expression/Accepted values
ReportingDate Date the file was due to be submitted to Ofqual regardless of when it was actually uploaded (this date will be made available by Ofqual) 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)
AcademicYear The academic year which this data submission relates to (defined as 1 September to 31 August). 2 ^(20)\d\d[-](20)\d\d $ The academic year in the following format: start year (4 digits), a dash, end year (4 digits) Format accepted yyyy-yyyy
AwardingOrganisation Name of the awarding organisation 3 ^.{1,100}$ 1 to 100 characters accepted
QualificationNumber This should be the unique identifier for the final qualification awarded as it appears in Ofqual’s Register of Regulated qualifications, e.g. 123/1234/1. 4 ^.{1,10}$ Valid Qualification Number. 1 to 10 characters accepted
UniqueLearnerNumber Unique Learner Number (ESFA code) provided by the Learning Records Service 5 ^\d{1,10}$ 1 to 10 digits accepted -2 accepted where the candidate does not have a ULN
UniqueCandidateIdentifier Unique Candidate Identifier (JCQ code), assigned to the candidate 6 ^.{1,13}$ A valid UCI. Alpha numeric 13 characters accepted -2 accepted where the candidate does not have a UCI
CandidateIdentifierOther Any other unique candidate number allocated by individual awarding organisation. 7 ^.{1,20}$ 1 to 20 characters accepted -2 permitted where at least one of UCI or ULN have been provided
FirstName Candidate's forenames 8 ^.{1,150}$ 1 to 150 characters accepted
MiddleNames Candidate's middle names(s) 9 ^.{1,150}$ 0 to 150 characters accepted
Surname Candidate's surname or family name 10 ^.{1,150}$ 1 to 150 characters accepted
DOB Candidate's date of birth 11 ^(19|20|29)\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
Gender Candidate's gender 12 ^(M|F|-2)$ Accepted values: M, F -2 accepted for other/unknown
CentreURN Centre’s Unique Reference Number as assigned by the Department for Education at the time of data submission. 13 ^\d{1,6}$ Valid Centre URN. Up to 6-digit integer accepted -2 also accepted where centre does not have a URN
CentreNCN Centre’s National Centre Number as allocated by the Joint Council for Qualifications (JCQ) at the time of data submission 14 ^\d{1,5}$ Valid NCN code. Up to 5-digit integer accepted -2 also accepted where centre does not have a NCN
CentreIdentifierOther Any other number allocated to the centre or assessment venue by individual awarding organisations at the time of data submission 15 ^.{1,15}$ 1 to 15 characters accepted -2 permitted where at least one of NCN or URN have been provided or for candidates who are not registered to a centre
Postcode Postcode of the centre 16 ^.{1,10}$ 1 to 10 characters accepted -2 accepted for unknown
Centre_name Name of the centre 17 ^.{1,150}$ 1 to 150 characters accepted -2 accepted for unknown
Country Country where the centre is located 18 ^(England)$ Accepted values: England
RegistrationDate Date when the candidate originally registered/entered for the qualification 19 ^(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)
QualificationClaimDate Date when the candidate (or the centre on their behalf) claimed the qualification. 20 ^(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)
Reason Whether the grade was delayed (issued after results days) or issued incorrect or expected but not issued (because either deferred or withdrawn). 21 ^(Delayed|Incorrect|Expected)$ Accepted values: • Delayed • Incorrect • Expected
AwardDate_first The date that the first result was issued to the centre (or candidate if result issued directly to candidate) 22 ^(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)
QualificationGrade_first First grade for the qualification, including fail 23 See Annex A See Annex A for accepted grades
AwardDate_last The date that the last result was issued to the centre (or candidate if result issued directly to candidate) 24 ^(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)
QualificationGrade_last Last grade for the qualification, including fail 25 See Annex A See Annex A for accepted grades
Reason2023 Whether the reason for the not issuing of results, delays or incorrect results being issued was due to the specific circumstances and assessment arrangements for 2023 26 ^(Yes|No)$ Accepted values: • Yes • No
ReasonExtended_1 Reason why the grade was not issued, delayed or incorrect 27 See Annex B Accepted values: • N1 • N2 • N3 • N4 • L1 • L2 • L3 • L4 • L5 • L6 • L7 • L8 • L9 • L10 • L11 • P1 • P2 • I1 • I2 • I3 • I4 See Annex B
ReasonExtended_2 Reason why the grade was not issued, delayed or incorrect 28 See Annex B Accepted values: • N1 • N2 • N3 • N4 • L1 • L2 • L3 • L4 • L5 • L6 • L7 • L8 • L9 • L10 • L11 • P1 • P2 • I1 • I2 • I3 • I4 See Annex B
ReasonExtended_3 Reason why the grade was not issued, delayed or incorrect 29 See Annex B Accepted values: • N1 • N2 • N3 • N4 • L1 • L2 • L3 • L4 • L5 • L6 • L7 • L8 • L9 • L10 • L11 • P1 • P2 • I1 • I2 • I3 • I4 See Annex B
ReasonExtended_4 Reason why the grade was not issued, delayed or incorrect 30 See Annex B Accepted values: • N1 • N2 • N3 • N4 • L1 • L2 • L3 • L4 • L5 • L6 • L7 • L8 • L9 • L10 • L11 • P1 • P2 • I1 • I2 • I3 • I4 See Annex B