Guidance
PTQ Outcomes: Qualification Maximum Marks and Grade Boundaries file format
Updated 4 August 2023
Download CSV 4 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) |
| AcademicYear | The academic year which this data submission relates to (defined as 1 September to 31 August). For example, ?2021-2022?. | 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, e.g. 123/1234/1 | 4 | ^.{1,10}$ | Valid Qualification Number. 1 to 10 characters accepted. |
| MaxMarkAndBoundaryID | Identifier used to link information between the outcomes and grade boundaries templates. Where grade boundaries and/or maximum marks change for this qualification number, please use a common value for this field in both the qualification outcomes and qualification grade boundaries templates. This could be based on the series name or assessment test versions, for example -2 accepted where boundaries and maximum marks information do not change throughout the academic year | 5 | ^.{1,50}$ | 1 to 50 characters accepted |
| MaximumRawMark | Maximum aggregated raw mark for the qualification. By raw mark, we mean the summed number of marks available to a learner without any weighting, scaling or other conversion applied. -2 accepted for not applicable | 6 | ^\d{1,3}$ | Three-digit integer. -2 accepted where not applicable |
| MaximumScaledScore | Maximum scaled mark/score for the qualification, where used. This would include any numerical score applied to the qualification that would not be considered a raw mark (see definition above) or a ?grade?. This can include, for example, percentage scores, Uniform Mark Scale (UMS) marks or Grade Points or Grade Credits -2 accepted for not applicable | 7 | ^\d{1,3}$ | Three-digit integer. -2 accepted where not applicable |
| Grade | The grade the boundary relates to (e.g., ?A?, ?Merit?, ?DD*?) | 8 | ^(FAIL|-2|1|2|3|4|5|6|7|8|9|*|A*|A|B|C|D*|D|E|F|G|J|K|M|N|P|Q|U|X|AC1|C1|E1|E2|E3|D1|D2|D3|D4|D5|D6|M1|M2|M3|P1|P2|P3|**|*1|*2|*D|D*D*|D*D|DD|DM|HM|LM|HP|LP|MD|MM|MP|PM|PP|***|D*D*D*|**D|D*D*D|D**|DD*D*|*DD|D*DD|DD*|DDD*|DD*D|DDD|DDM|DMM|MDD|MMD|MMM|MMP|MPP|PMM|PPM|PPP|24B|25B|26B|27B|28B|29B|30B|31B|32B|33B|34B|35B|36B|37B|38B|39B|40B|41B|42B|43B|44B|45B|24D|25D|26D|27D|28D|29D|30D|31D|32D|33D|34D|35D|36D|37D|38D|39D|40D|41D|42D|43D|44D|45D|24F|25F|26F|27F|28F|29F|30F|31F|32F|33F|34F|35F|36F|37F|38F|39F|40F|41F|42F|43F|44F|45F)$ | Accepted values: FAIL -2, 1, 2, 3, 4, 5, 6, 7, 8, 9 *, A*, A, B, C, D*, D, E, F, G, J, K, M, N, P, Q, U, X AC1, C1, E1, E2, E3 D1, D2, D3, D4, D5, D6, M1, M2, M3, P1, P2, P3 **, *1, *2, *D, D*D*, D*D, DD, DM, HM, LM, HP, LP, MD, MM, MP, PM, PP ***, D*D*D*, **D, D*D*D, D**, DD*D*, *DD, D*DD, DD*, DDD*, DD*D, DDD, DDM, DMM, MDD, MMD, MMM, MMP, MPP, PMM, PPM, PPP 24B, 25B, 26B, 27B, 28B, 29B, 30B, 31B, 32B, 33B, 34B, 35B, 36B, 37B, 38B, 39B, 40B, 41B, 42B, 43B, 44B, 45B 24D, 25D, 26D, 27D, 28D, 29D, 30D, 31D, 32D, 33D, 34D, 35D, 36D, 37D, 38D, 39D, 40D, 41D, 42D, 43D, 44D, 45D 24F, 25F, 26F, 27F, 28F, 29F, 30F, 31F, 32F, 33F, 34F, 35F, 36F, 37F, 38F, 39F, 40F, 41F, 42F, 43F, 44F, 45F -2 accepted for not applicable |
| RawMarkGradeBoundary | Raw mark grade boundary for that grade. See the definition in Field 6 above. -2 accepted for not applicable | 9 | ^\d{1,3}$ | Three-digit integer. -2 accepted for not applicable |
| ScaledScoreGradeBoundary | Scaled score grade boundary for that grade. See the definition in Field 7 above. -2 accepted for not applicable | 10 | ^\d{1,3}$ | Three-digit integer. -2 accepted for not applicable |