Guidance
TQ Assessment Template - file format
Updated 2 December 2021
Download CSV 3.6 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 | ^ (0[1-9]|[12][0-9]|3[01])[/](0[1- 9]|1[012])[/](20)\d\d $ or ^(20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01])$ | The date in the following format: day (2 digits), forward slash, month (2 digits), forward slash, year (4 digits) Or year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
| AssessmentSeries | Assessment series data relates to, for example June 2023 | 2 | ^(June)([][0-9][0-9][0-9][0-9])$ | Full month name and year of Assessment series. For example June 2023. Note: enter -2 where applications are not restricted to an individual assessment series |
| AwardingOrganisation | Acronym of the awarding organisation | 3 | ^.{1,100}$ | A valid AO Acronym. 1 to 100 characters accepted. Note: value must be consistent within the file |
| QualificationNumber | Acronym of the awarding organisation | 4 | ^.{1,10}$ | Valid Qualification Number. 1 to 10 characters accepted |
| ComponentCode | Unique identifier for the component which the assessment relates to (assigned by the awarding organisation) | 5 | ^.{1,10}$ | 1 to 10 characters accepted |
| SubComponentType | TQ sub-component which the assessment falls under. | 6 | ^(Core Exam|Core Project|Occupational Specialism)$ | Accepted values: Core Exam, Core Project, Occupational Specialism |
| AssessmentCode | Unique identifier for the assessment (assigned by the awarding organisation) | 7 | ^.{1,10}$ | 1 to 10 characters |
| AssessmentTitle | AO-assigned name for the assessment | 8 | ^.{1,300}$ | String value between 1 and 300 characters |
| MaximumAssessmentRawMark | Maximum raw mark for the assessment | 9 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals. Note: enter -2 if not applicable |
| MaximumAssessmentUMSMark | Maximum UMS mark for the assessment | 10 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals. Note: enter -2 if not applicable |
| MaximumSubComponentRawMark | Maximum Raw mark at the sub-component level | 11 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals. Note: enter -2 if not applicable |
| MaximumSubComponentUMSMark | Maximum UMS mark at the sub-component level | 12 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals. Note: enter -2 if not applicable |
| MaximumComponentRawMark | Maximum Raw mark at the component level | 13 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals. Note: enter -2 if not applicable |
| MaximumComponentUMSMark | Maximum UMS mark at the component level | 14 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals. Note: enter -2 if not applicable |
| AssessmentComponentWeighting | Percentage contribution of the assessment mark to the component UMS | 15 | ^([0-9]|[1-9][0-9]|100)$. | Number between 0 and 999 allowing decimals |
| ComponentGuidedLearningHours | GLH for the component | 16 | ^\d{1,3}$ | Number between 0 and 999 allowing decimals |
| CentresAllocatedToExaminersForMarking | Do examiners have allocated centres? | 17 | ^(Yes|No|Mixed)$ | Accepted values: Yes, No, Mixed |
| DateAssessmentResultIssued | Date when assessment results are issued to candidates | 18 | ^ (0[1-9]|[12][0-9]|3[01]) [/](0[1-9]|1[012])[/](20)\d\d $ or ^(20)\d\d[-](0[1-9]|1[012])[-](0[1- 9]|[12][0-9]|3[01])$ | The date in the following format: day (2 digits), forward slash, month (2 digits), forward slash, year (4 digits), or: year (4 digits), a dash, month (2 digits), a dash, day (2 digits) |
| TotalNumberOfExaminersOrModerators | The total number of examiner/moderator posts for this assessment in this assessment series | 19 | ^\d{1,6}$ | A numeric value between 0 and 999,999 |