Guidance
PTQ Outcomes: Assessment Outcomes file format
Updated 4 August 2023
Download CSV 5.06 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 |
| AssessmentCode | Unique identifier for the assessment, generated by the AO. Should match the codes given in the Assessment Reference Information template. | 4 | ^.{1,50}$ | 1 to 50 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 assessment code, please use a common value for this field in both the assessment outcomes and assessment grade boundaries templates. For sessional or series-based assessments, this could be the series name. For on-demand assessments, this could be the test version -2 accepted where boundaries and maximum marks information do not change throughout the academic year | 5 | ^.{1,50}$ | 1 to 50 characters accepted |
| UniqueLearnerNumber | Unique Learner Number (ESFA code) provided by the Learning Records Service. Please provide this identifier wherever possible -2 accepted where the learner does not have a ULN | 6 | ^\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. -2 accepted where the learner does not have a UCI | 7 | ^.{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. Must be provided where neither UCI or ULN are available. -2 accepted where at least one of UCI or ULN have been provided | 8 | ^.{1,20}$ | 1 to 20 characters accepted -2 permitted where at least one of UCI, ULN or UPN have been provided |
| AssessmentDate | Date assessment was taken or submission deadline/claim dates for non-exam assessment. For windowed assessments, please provide the date based on the last date of the window. For assessments which take place over multiple days, please provide the date it was submitted for marking/grading. If no date is available please provide the date the result was entered. | 9 | ^(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) |
| AssessmentRawMark | Final raw mark for the assessment By raw mark, we mean the summed number of marks achieved by a learner without any weighting, scaling or other conversion applied. -2 accepted for not applicable | 10 | ^\d{1,3}$ | Three-digit integer. -2 accepted where not applicable |
| AssessmentScaledScore | Final scaled mark/score for the assessment, where used. This would include any numerical score applied to the assessment 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 | 11 | ^\d{1,3}$ | Three-digit integer. -2 accepted where not applicable |
| AssessmentGrade | Assessment grade, where given including fail and near pass grades if relevant. -2 accepted for not applicable | 12 | ^(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 |