Guidance
Example of template B for FSQ outcomes
Updated 4 March 2022
Download CSV 5.26 KB
| Name | Description | Position | Valid Regular Expression | Description of Regular Expression |
|---|---|---|---|---|
| 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) |
| AwardingOrganisation | Name of the awarding organisation | 2 | ^.{1,100}$ | 1 to 100 characters accepted |
| CentreNCN | Centre’s National Centre Number as allocated by the Joint Council for Qualifications (JCQ) | 3 | ^\d{1,5}$ | Valid NCN code. Up to 5-digit integer accepted -2 also accepted where centre does not have a NCN |
| CentreURN | Centre’s Unique Reference Number as assigned by the Department for Education | 4 | ^\d{1,6}$ | Valid Centre URN. Up to 6-digit integer accepted -2 also accepted where centre does not have a URN |
| CentreIdentifierOther | Any other number allocated to the centre or assessment venue by individual awarding organisations. It must be provided if a candidate is registered to a centre and neither CentreURN nor CentreNCN are available | 5 | ^.{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 |
| UniqueCandidateIdentifier | Unique Candidate Identifier (JCQ code), where available | 6 | ^.{1,13}$ | A valid UCI. Alpha numeric 13 characters accepted -2 accepted where the candidate does not have a UCI |
| UniqueLearnerNumber | Unique Learner Number (ESFA code), where available | 7 | ^.{1,10}$ | 1 to 10 characters accepted -2 accepted where the candidate does not have a ULN |
| UniquePupilNumber | Unique Pupil Number (UPN) for the candidate provided by the Department for Education | 8 | ^.{1,13}$ | A valid UPN. Alpha numeric 13 characters accepted -2 accepted where the candidate does not have a UPN |
| CandidateIdentifierOther | Any other unique candidate number allocated by individual awarding organisationMust be provided where UCI, ULN and UPN are not available | 9 | ^.{1,20}$ | 1 to 20 characters accepted -2 permitted where at least one of UCI, ULN or UPN have been provided |
| FirstName | Candidate first name | 10 | ^.{0,150}$ | 0 to 150 characters accepted |
| MiddleNames | Candidate middle name(s), where able to be separated from first namesCan be left blank where middle names are not known or cannot be separated out from first names. | 11 | ^.{0,150}$ | 0 to 150 characters accepted |
| Surname | Candidate surname or family name | 12 | ^.{0,150}$ | 0 to 150 characters accepted |
| DOB | Candidate’s date of birth | 13 | ^(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 |
| QualificationNumber | This should be the unique identifier for the qualification as it appears in Ofqual’s Register of Regulated Qualifications, e.g. 123/1234/1. | 14 | ^.{1,10}$ | Valid Qualification Number. 1 to 10 characters accepted. |
| AssessmentTitle | Title of the assessment. Either:‘Reading’, ‘Writing’, 'SLC’ or ‘Maths’ | 15 | ^(Reading|Writing|SLC|Maths)$ | Accepted values: Reading, Writing, SLC, Maths |
| AssessmentID | Unique identifier for the assessmentused. Where there are multiple test versions available these must be identified by the assessment ID (at the unit level for English and the qualification/component level for maths). For sessional assessments, assessment ID should also reveal the session.Values used in this field should match those given in Template C (pass thresholds). This field will be primarily used to link information between the 2 templates-2 accepted where not known (e.g., where centres do not report the exact assessment used for internal assessments such as the SLC) | 16 | ^.{1,50}$ | 1 to 50 characters accepted -2 accepted where not known (e.g., where centres do not report the exact assessment used for internal assessments such as the SLC) |
| AssessmentMode | Sessional – the assessment can only be taken once in the lifetime of a qualification, typically in one session only on demand – where the same assessment is used more than once, either in a typical on-demand setting or in more than one session | 17 | (Sessional|Ondemand)$ | Accepted values: Sessional, On-demand |
| AssessmentDate | The date the candidate sat the component assessmentOr the date the final sub-component assessment was sat for maths Or the submission date for a TAGOr the submission date for an SLC result | 18 | ^(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) |
| ResultDate | The date that the result was issued to the centre (or candidate if result issued directly to candidate) | 19 | ^(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) |
| Mark | Mark awarded to the learner-2 accepted for not applicable or not known (e.g., for internal assessments and/or where assessments are graded, not marked) | 20 | ^\d{1,3}$ | Three-digit integer. -2 accepted where not applicable (e.g., for internal assessments and/or where assessments are graded, not marked) |
| Grade | Grade awarded to the learner | 21 | ^\d{1,3}$ | Pass or Fail |