Guidance

Template 1ab - Grade boundary information for units and components

Updated 16 April 2024
Download CSV 2.62 KB

Name Description Position Validation Regular Expression Description of Regular Expression
ExamSeries Exam series data relates to 1 ^(June)([ ][0- 9][0-9][0- 9][0-9])$ Full month name of exam series and year.
ReportingDate Date the file was due to be submitted regardless of when it was actually uploaded. Format accepted 120 ODBC canonical yyyy-mm-dd. 2 ^(20)\d\d[- ](0[1- 9]|1[012])[- ](0[1- 9]|[12][0- 9]|3[01])$ The date in the following format: year (four digits), a dash, month (two digits), a dash, day (two digits).
AwardingOrganisation Name of the awarding organisation 3 ^.{1,100}$ One, to one hundred characters accepted
QualificationLevel Level of qualification, for example GCSE 4 ^(GCSE|AS|A level)$ One of the following list: GCSE, AS, A level.
UnitOrComponentCode Unit or component code as designated in the specification. 5 ^.{1,10}$ One, to ten characters accepted
SpecificationCode Specification code also known as Subject Award Code and Cash-in Code 6 ^.{1,7}$ One, to seven characters accepted
SpecificationTitle Specification title also 7 ^.{1,150}$ One, to one hundred and fifty characters accepted
Tier To indicate the tier if applicable. F for Foundation H for Higher 8 ^(F|H|-2)$ One of the following list: F, H. -2 accepted where not applicable.
MaxUniformMark Maximum uniform mark available for the unit. In unitised specifications where units may contain multiple components, only provide the unit maximum mark. 9 ^\d{1,3}$ A numeric value between 0 and 999 accepted. -2 accepted for nonUMS specifications
MaxRawUnweightedMark Maximum raw unweighted mark available for the unit or component. 10 ^\d{1,3}$ A numeric value between 0 and 999 accepted.
WeightingFactor Multiplier applied to the component mark to determine the contribution to the subject mark. To three decimal places. 11 ^\d{1,3}\.\d{0 ,3}$|^\d{1,3}$ A numeric value between 0 and 999 with up to three decimal places accepted. -2 accepted if not applicable.
Grade Unit or component grade 12 ^(A*|A|B|C|D|E |7|4|1||7-7|4- 4|1-1|-2)$ One of the following list: A*, A, B, C, D, E, 7, 4, 1, 7-7, 4-4, 1-1. -2 also accepted for unknown value.
Boundary Raw mark boundary (or A level A* conversion point). 13 ^\d{1,3}$ A numeric value between 0 and 999 accepted. -2 accepted where not applicable.
CarryForward To indicate if the row of data relates to a carry forward option 14 ^(1|0)$ For OCR and Pearson: one of the following list: 1, 0 For all other awarding organisations, please submit a blank column with just the column name.