Guidance
File format
Updated 22 September 2023
Download CSV 4.95 KB
| Name | Description | Position | Validation 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) Format accepted yyyy-mm-dd |
| AcademicYear | The academic year which this data submission relates to (defined as 1 September to 31 August). For example, “2022-2023” | 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 qualification as it appears in Ofqual’s Register of Regulated qualifications, for example 123/1234/1. ‘-2’ accepted if not applicable. ‘-2’ also accepted for cases where the assessment can be used for more than one qualification and the qualification is not yet known | 4 | ^.{1,10}$ | Valid Qualification Number. 1 to 10 characters accepted. ‘-2’ accepted if not applicable or not known |
| AssessmentCode | Unique identifier for the assessment, generated by the AO. This could be the URN, for example. Codes should not be shared across different assessments. For Tech Awards, Tech Certs, Tech Levels and Applied Generals, this should match the assessment codes used for the ‘PTQ outcomes’ data submissions. ‘-2’ accepted for special consideration applied at the qualification level | 5 | ^.{1,50}$ | 1 to 50 characters accepted ‘-2’ accepted for special consideration applied at the qualification level |
| SpecialConsiderationType | To indicate the type of special consideration applied for | 6 | ^(Present but disadvantaged| Absent with good reason)$ | Accepted values: • Present but disadvantaged • Absent with good reason |
| DisadvantageCategory | To indicate the disadvantage category. See Annex A for further guidance. For cases where a special consideration request relates to multiple categories, please use the ‘Other causes’ category. Disadvantage categories should be given where possible. Where not possible (e.g., where disadvantage categories are not recorded for absent leaners), please give ‘-2’ | 7 | ^(Illness or injury| Crisis or incident| Bereavement| Other causes| -2)$ | Accepted values: • Illness or injury • Crisis or incident • Bereavement • Other causes • ‘-2’ accepted where disadvantage category is not recorded (e.g., for absent learners) See Annex A for further guidance |
| TotalNumberOfRequests | The total number of requests made of the type outlined in Fields 7 for the qualification/assessment given in Field 4/5. Values in this field should equal the sum of Fields 9 to 12. For group applications (where a centre submits one application covering multiple learners) please reflect the total number of learners affected in the counts in Fields 8 to 12, rather than just counting these as a single request and outcome. Where applications cover multiple assessments, please include these on separate rows | 8 | ^\d{1,5}$ | Five-digit integer |
| RequestsPending | The number of requests given in Field 8 that have not yet been rejected or approved or withdrawn. For group applications (where a centre submits one application covering multiple learners) please reflect the total number of learners affected in the counts in Fields 8 to 12, rather than just counting these as a single request and outcome. Where applications cover multiple assessments, please include these on separate rows | 9 | ^\d{1,5}$ | Five-digit integer |
| RequestsRejected | The number of requests given in Field 8 that have been rejected. For group applications (where a centre submits one application covering multiple learners) please reflect the total number of learners affected in the counts in Fields 8 to 12, rather than just counting these as a single request and outcome. Where applications cover multiple assessments, please include these on separate rows | 10 | ^\d{1,5}$ | Five-digit integer |
| RequestsApproved | The number of requests given in Field 8 that have been approved For group applications (where a centre submits one application covering multiple learners) please reflect the total number of learners affected in the counts in Fields 8 to 12, rather than just counting these as a single request and outcome. Where applications cover multiple assessments, please include these on separate rows | 11 | ^\d{1,5}$ | Five-digit integer |
| RequestsWithdrawn | The number of requests given in Field 8 that have been withdrawn For group applications (where a centre submits one application covering multiple learners) please reflect the total number of learners affected in the counts in Fields 8 to 12, rather than just counting these as a single request and outcome. Where applications cover multiple assessments, please include these on separate rows | 12 | ^\d{1,5}$ | Five-digit integer |