Quality Rules Directory for C20054

QR.C20054.Course.TTCID.3

Course.TTCID must not equal F.

QR.C20054.CourseSubject.SBJPCNT.1

For each Course entity the sum of CourseSubject.SBJPCNT must equal 100.

QR.C20054.EntryProfile.DOMICILE.1

EntryProfile.DOMICILE has been coded as ZZ (Not known). Please review this data and allocate a more precise code where possible.

QR.C20054.EntryProfile.DOMICILE.3

EntryProfile.DOMICILE must not be coded XC or XL.

QR.C20054.EntryProfile.NUMHUS.1

The EntryProfile.NUMHUS returned must have a corresponding Instance.NUMHUS for the same Student.HUSID.

QR.C20054.EntryProfile.POSTCODE.1

EntryProfile.POSTCODE must exist where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM.

QR.C20054.EntryProfile.POSTCODE.2

EntryProfile.POSTCODE must not exist where EntryProfile.DOMICILE is not in (XF, XG, XH, XI, XK, XL, GG, JE or IM).

QR.C20054.EntryProfile.PREVINST.2

Where EntryProfile.PREVINST exists it must be either a valid UKPRN or one of the generic codes specified in the manual.

QR.C20054.EntryProfile.QUALENT3.1

EntryProfile.QUALENT3 cannot be coded X06 where QualificationsOnEntry entity exists.

QR.C20054.EntryProfile.QualificationsOnEntry.1

There are more than 30 occurrences of QualificationsOnEntry for an Entry Profile.

QR.C20054.InstancePeriod.DISALL.3

InstancePeriod.DISALL should not exist where the associated StudentEquality.DISABLE = 00.

QR.C20054.InstancePeriod.DISALL.4

InstancePeriod.DISALL must only be coded 4 where (the associated EntryProfile.DOMICILE exists and is coded GG, JE, XL, XK, IM, XF, XI, XH or XG) or StudentEquality.NATION = GB.

QR.C20054.InstancePeriod.EXCHIND.1

InstancePeriod.EXCHIND should be coded 3 where InstancePeriod.LOCSDY = 6 or 9

QR.C20054.InstancePeriod.EXCHIND.2

InstancePeriod.EXCHIND must be coded 1 where Course.COURSEAIM code ends with 91.

QR.C20054.InstancePeriod.EXCHIND.3

InstancePeriod.EXCHIND must be coded 3 where InstancePeriod.LOCSDY = S

QR.C20054.InstancePeriod.LOCSDY.1

InstancePeriod.LOCSDY must not be coded D or E where InstancePeriod.MODE is coded 01.

QR.C20054.InstancePeriod.LOCSDY.3

InstancePeriod.LOCSDY should be coded D, E, T, U or Z where InstancePeriod.MODE = 23, 24 or 25.

QR.C20054.InstancePeriod.LOCSDY.4

InstancePeriod.LOCSDY should be coded D, E or Z where InstancePeriod.EXCHIND = 1.

QR.C20054.InstancePeriod.LOCSDY.5

InstancePeriod.LOCSDY should be coded U or T where InstancePeriod.EXCHIND = 2.

QR.C20054.InstancePeriod.LOCSDY.6

InstancePeriod.LOCSDY = S where associated EntryProfile.DOMICILE is coded XF, XG, XH, XI, or XK. Where the student is abroad for the whole or a proportion of the year as part of a UK based course InstancePeriod.LOCSDY should be coded T or U.

QR.C20054.InstancePeriod.MODE.1

InstancePeriod.MODE cannot be coded 01 where Instance.UNITLGTH = 3 and Instance.SPLENGTH = 01 to 23.

QR.C20054.InstancePeriod.MODE.2

InstancePeriod.MODE cannot be coded 01 where Instance.UNITLGTH = 2 and Instance.SPLENGTH = 01 to 05.

QR.C20054.InstancePeriod.MODE.4

InstancePeriod.MODE should not be coded 01, 23 or 24 where Instance.COMDATE > Y2-02-13 and Instance.ENDDATE is null and only one InstancePeriod exists and is contained in the reporting year.

QR.C20054.InstancePeriod.MODE.5

InstancePeriod.MODE should be coded 31 where Course.TTCID = 5.

QR.C20054.InstancePeriod.MSTUFEE.6

InstancePeriod.MSTUFEE must not be 71 where InstancePeriod.STULOAD greater than 0

QR.C20054.InstancePeriod.MSTUFEE.7

InstancePeriod.MSTUFEE should not be coded 02, 03, 52 or 53 where (the associated incoming EntryProfile.DOMICILE exists and is coded XG).

QR.C20054.InstancePeriod.MSTUFEE.8

InstancePeriod.MSTUFEE should not be coded 02, 04, 52 or 54 where (the associated EntryProfile.DOMICILE exists and is coded XH).

QR.C20054.InstancePeriod.MSTUFEE.9

InstancePeriod.MSTUFEE should not be coded 03, 04, 53 or 54 where (the associated EntryProfile.DOMICILE exists and is coded XF or XI).

QR.C20054.InstancePeriod.NOTACT.1

InstancePeriod.NOTACT does not exist where InstancePeriod.STULOAD = 0 and Instance.ENDDATE is after Y1-07-31. Please consider whether the InstancePeriod is dormant or suspended, if so InstancePeriod.NOTACT must be returned.

QR.C20054.InstancePeriod.PERIODEND.2

Where InstancePeriod.PERIODEND does not equal Instance.ENDDATE or Instance.ENDDATE is null, the InstancePeriod should last longer than one month.

QR.C20054.InstancePeriod.PERIODEND.3

InstancePeriod.PERIODEND must be after Y1-07-31 unless InstancePeriod.STULOAD = 0 and (InstancePeriod.NOTACT exists or Instance.ENDDATE < Y1-08-01).

QR.C20054.InstancePeriod.PERIODSTART.1

InstancePeriod.PERIODSTART must not be before Instance.COMDATE

QR.C20054.InstancePeriod.PERIODSTART.3

Within an entity InstancePeriod.PERIODSTART must be before InstancePeriod.PERIODEND

QR.C20054.InstancePeriod.PERIODSTART.5

InstancePeriod.PERIODSTART must be before Y2-08-01.

QR.C20054.InstancePeriod.PRIPROV.1

InstancePeriod.PRIPROV should not be coded 4003 or 4004. The preferred coding of InstancePeriod.PRIPROV is a valid UKPRN.

QR.C20054.InstancePeriod.PRIPROV.2

InstancePeriod.PRIPROV must not equal Provider.UKPRN

QR.C20054.InstancePeriod.PRIPROV.4

Where InstancePeriod.PRIPROV exists and does not equal 4002, 4003 or 4004 it must contain a valid UKPRN.

QR.C20054.InstancePeriod.QualificationsAwarded.2

QualificationsAwarded entity should exist on the latest InstancePeriod where associated Instance.ENDDATE is not null and Instance.RSNEND = 01 unless Course.COURSEAIM ends with 99.

QR.C20054.InstancePeriod.STULOAD.1

The sum of InstancePeriod.STULOAD for the reporting period must be less than or equal to 300.

QR.C20054.InstancePeriod.STULOAD.2

The sum of InstancePeriod.STULOAD must be greater than 0 where Instance.COMDATE is after Y1-07-31 and any associated InstancePeriod entity has (InstancePeriod.LOCSDY <> S and InstancePeriod.EXCHIND = 2 or 3).

QR.C20054.InstancePeriod.STULOAD.4

InstancePeriod.STULOAD should be less than 100 where InstancePeriod.PERIODEND > Y2-07-31 and InstancePeriod.PERIODSTART > Y2-01-31

QR.C20054.InstancePeriod.STULOAD.5

InstancePeriod.STULOAD should be less than 100 where InstancePeriod.PERIODSTART < Y1-08-01 and InstancePeriod.PERIODEND < Y2-02-01

QR.C20054.InstancePeriod.YEARPRG.1

InstancePeriod.YEARPRG code 0 should have Course.COURSEAIM beginning with H or I.

QR.C20054.InstancePeriod.YEARPRG.3

InstancePeriod.YEARPRG must not equal 0 if (Instance.UNITLGTH = 1 and Instance.SPLENGTH = 1) or (Instance.UNITLGTH = 2 and Instance.SPLENGTH < 13) or (Instance.UNITLGTH = 3 and Instance.SPLENGTH < 53).

QR.C20054.InstancePeriod.YEARPRG.5

InstancePeriod.YEARPRG should not equal 99 where Instance.UNITLGTH = 1, 2, 3, 4 or 5.

QR.C20054.InstancePeriod.YEARSTU.1

InstancePeriod.YEARSTU value cannot be greater than the difference in years between Y2-07-31 and the 01 August before Instance.COMDATE.

QR.C20054.QualificationsOnEntry.QUALSBJ.1

QualificationsOnEntry.QUALSBJ code 'U01' (unknown subject) used more than once so may not be counted in the tariff score.

QR.C20054.QualificationsOnEntry.QUALSBJ.3

QualificationsOnEntry.QUALSBJ must be coded 'T33' where QualificationsOnEntry.QUALTYPE = IE

QR.C20054.QualificationsOnEntry.QUALSBJ.4

QualificationsOnEntry.QUALSBJ must be coded 'B29' where QualificationsOnEntry.QUALTYPE = ID

QR.C20054.QualificationsOnEntry.QUALTYPE.1

QualificationsOnEntry.QUALTYPE = IE must only occur once within an EntryProfile entity.

QR.C20054.QualificationsOnEntry.QUALYEAR.1

QualificationsOnEntry.QUALYEAR should be 1951 or later where QualificationsOnEntry.QUALTYPE is A.

QR.C20054.QualificationsOnEntry.QUALYEAR.10

QualificationsOnEntry.QUALYEAR should be 2005 or later where QualificationsOnEntry.QUALTYPE is WB.

QR.C20054.QualificationsOnEntry.QUALYEAR.11

QualificationsOnEntry.QUALYEAR should be 2006 or later where QualificationsOnEntry.QUALTYPE is AD.

QR.C20054.QualificationsOnEntry.QUALYEAR.12

QualificationsOnEntry.QUALYEAR should be 2007 or later where QualificationsOnEntry.QUALTYPE is DA.

QR.C20054.QualificationsOnEntry.QUALYEAR.13

QualificationsOnEntry.QUALYEAR should be less than or equal to Instance.COMDATE year.

QR.C20054.QualificationsOnEntry.QUALYEAR.14

Where Student.BIRTHDTE is not null and QualificationsOnEntry.QUALTYPE not coded M6, M7, M8, 6M, 7M or 8M, QualificationsOnEntry.QUALYEAR must be greater than (Student.BIRTHDTE + 13) years.

QR.C20054.QualificationsOnEntry.QUALYEAR.15

Where Student.BIRTHDTE is not null and QualificationsOnEntry.QUALTYPE is not coded M6, M7, M8, 6M, 7M, 8M or SS, QualificationsOnEntry.QUALYEAR should be greater than (Student.BIRTHDTE + 15) year

QR.C20054.QualificationsOnEntry.QUALYEAR.16

Where Student.BIRTHDTE is not null more than 10 students ( Student.HUSID ) have at least one QualificationsOnEntry.QUALYEAR (for QualificationsOnEntry.QUALTYPE other than M6, M7, M8, 6M, 7M, 8M or SS) less than (Student.BIRTHDTE + 16) year.

QR.C20054.QualificationsOnEntry.QUALYEAR.2

QualificationsOnEntry.QUALYEAR should be 1986 or later where QualificationsOnEntry.QUALTYPE is SS.

QR.C20054.QualificationsOnEntry.QUALYEAR.3

QualificationsOnEntry.QUALYEAR should be 1987 or later where QualificationsOnEntry.QUALTYPE is A1 or AS.

QR.C20054.QualificationsOnEntry.QUALYEAR.4

QualificationsOnEntry.QUALYEAR should be 2000 or later where QualificationsOnEntry.QUALTYPE is H, HK, IK, I2, K2, K3 or K4.

QR.C20054.QualificationsOnEntry.QUALYEAR.5

QualificationsOnEntry.QUALYEAR should be 2001 or later where QualificationsOnEntry.QUALTYPE is CA, or AC, FA, V1 or AH.

QR.C20054.QualificationsOnEntry.QUALYEAR.6

QualificationsOnEntry.QUALYEAR should be 2002 or later where QualificationsOnEntry.QUALTYPE is AE, FM, FS or V.

QR.C20054.QualificationsOnEntry.QUALYEAR.7

QualificationsOnEntry.QUALYEAR should be 2003 or later where QualificationsOnEntry.QUALTYPE is B, BE or OE (for extended diploma).

QR.C20054.QualificationsOnEntry.QUALYEAR.8

QualificationsOnEntry.QUALYEAR should be 2008 or later where QualificationsOnEntry.QUALTYPE is OC (for Certificate) or OD (for Diploma).

QR.C20054.QualificationsOnEntry.QUALYEAR.9

QualificationsOnEntry.QUALYEAR should be 2004 or later where QualificationsOnEntry.QUALTYPE is CO.

QR.C20054.Student.BIRTHDTE.1

Student.BIRTHDTE cannot be before (Y1-99)-08-01.

QR.C20054.Student.BIRTHDTE.2

Student.BIRTHDTE is null. If known, please complete this data.

QR.C20054.Student.BIRTHDTE.5

Student.BIRTHDTE should be after (Y1-70)-07-31.

QR.C20054.Student.BIRTHDTE.6

Student.BIRTHDTE must be before (Y1-14)-08-01.

QR.C20054.Student.BIRTHDTE.7

Student.BIRTHDTE must be before Y1-08-01

QR.C20054.Student.EntryProfile.1

EntryProfile entity must exist where the corresponding Instance.COMDATE is in the current reporting year.

QR.C20054.Student.HUSID.1

Student.HUSID must not contain all zeros.

QR.C20054.Student.HUSID.3

Student.HUSID must pass the checksum test given in the coding manual.

QR.C20054.Student.SSN.1

Student.SSN must pass the checksum test given in the coding manual.

QR.C20054.Student.SSN.3

Student.SSN must exist where any associated InstancePeriod.MSTUFEE = 02, 03, 04, 52, 53 or 54.

QR.C20054.Student.SURNAME.1

Student.SURNAME should begin with A to Z (case insensitive)

QR.C20054.Student.SURNAME.2

Student.SURNAME must not be a single space

QR.C20054.Student.ULN.1

Student.ULN must pass the checksum test.

QR.C20054.Student.ULN.2

Student.ULN (where exists) must be unique within submitted file.

QR.C20054.StudentEquality.DISABLE.3

StudentEquality.DISABLE should be coded 08, 51-96 where any associated InstancePeriod.DISALL exists.

QR.C20054.StudentEquality.NATION.2

StudentEquality.NATION must not be coded XC or XL.

QR.C20054.Instance.FUNDCODE.14

Where a year-on-year link has been made to the Continuity Register, InstancePeriod.LOCSDY has changed from studying abroad (S) to distance Learning (6), where Instance.FUNDCODE has changed from not fundable by funding council/body (2) to fundable by funding council/body (1).

QR.C20054.CourseSubject.SBJCA.10

Where the student was returned last year with the same Course.COURSEID, the grouping of HECoS (based on second level grouping XCAH02) differs.

QR.C20054.Student.BIRTHDTE.10

More than 1% of active students (and more than 5 students) have a null Student.BIRTHDTE.

QR.C20054.Student.BIRTHDTE.11

All students have had the same day and month returned for Student.BIRTHDTE.

QR.C20054.Student.BIRTHDTE.4

Student.BIRTHDTE should be less than (Y1-17)-08-01 where Course.COURSEAIM = H11, H12, I11 or I12.

QR.C20054.Student.BIRTHDTE.3

Student.BIRTHDTE should be earlier than (Y1-20)-08-01 where Course.COURSEAIM = M71, M73 or H71.

QR.C20054.Student.BIRTHDTE.9

Where a year-on-year link has been made to the Continuity Register, Student.BIRTHDTE differs (exclude unknown to known value changes and records identified in QR.Student.BIRTHDTE.8 (known to unknown value)).

QR.C20054.Student.BIRTHDTE.8

Where a year-on-year link has been made to the Continuity Register, Student.BIRTHDTE has changed from a known date to null.

QR.C20054.Student.EntryProfile.2

EntryProfile entity must exist where the corresponding Instance has not been previously reported (it cannot be found on the Continuity Register).

QR.C20054.Student.HUSID.4

There are multiple occurrences of Student.BIRTHDTE, StudentEquality.SEXID, soundex (Student.SURNAME) and soundex (Student.FNAMES), with different Student.HUSIDs. An individual student must not have multiple HESA Unique Student Identifiers.

QR.C20054.Student.HUSID.6

More than 50% of new entrants (and more than 10 students) have a Student.HUSID where characters 3-6 are not the provider's INSTID plus 1000.

QR.C20054.Student.HUSID.5

Where a year-on-year link has been made to the Continuity Register (Student name differs from NAMECAT (Concatenation of Student.SURNAME and Student.FNAMES)) and (where BIRTHDTE exists it differs from Student.BIRTHDTE) and (where SEXID exists it differs from StudentEquality.SEXID).

QR.C20054.Student.SSN.4

Student.SSN (where exists) must be unique within the submitted file.

QR.C20054.Student.SSN.6

No Student.SSN has been returned for more than 80% of instances (and more than 80 instances) where the latest Instance Period is for a designated course and Course.COURSEAIM not (equal to M71, H60, H61, H62, I60, I61 or ends with 90 or 99) and, for the latest Instance Period, (InstancePeriod.MODE = 31 and InstancePeriod.SSELIG = 1).

QR.C20054.Student.SSN.9

Where a year-on-year link has been made to the Continuity Register and SSN is not null, the incoming Student.SSN exists and the two differ.

QR.C20054.Student.SURNAME.3

Where a year-on-year link has been made to the Continuity Register, student name differs in NAMECAT (Concatenation of Student.SURNAME and Student.FNAMES). Exclude records identified in QR.Student.SURNAME.5, or where NAMECAT changes from an unknown to a known value.

QR.C20054.Student.FNAMES.1

More than 25% of students have FNAMES blank or missing

QR.C20054.Student.FNAMES.2

More than 4% of students and more than 5 students have FNAMES blank or missing.

QR.C20054.Student.HUSID.2

If characters 1-4 are not 0000 then chars 3-6 of Student.HUSID must be a valid INSTID plus 1000.

QR.C20054.Student.SSN.8

Where a year-on-year link has been made to the Continuity Register, the associated Student.SSN has changed from exists to not exists [exclude where (all incoming Course.COURSEAIMs for the Instance end with 90 or 99) or (incoming XINACT01 = 1)].

QR.C20054.Student.StudentEquality.1

The StudentEquality entity must exist where any Instance Period associated with the student is designated.

QR.C20054.Student.SURNAME.5

Where a year-on-year link has been made to the Continuity Register, Student name differs on NAMECAT (Concatenation of Student.SURNAME and Student.FNAMES), and the first character of Student.SURNAME on input is equal to the first character of Student.FNAMES on the Continuity Register, and the first character of Student.FNAMES on input is equal to the first character of Student.SURNAME on the Continuity Register.

QR.C20054.Student.UCASPERID.1

Student.UCASPERID must exist where any EntryProfile.UCASSCHEMECODE exists and is a 4 character code.

QR.C20054.QualificationsOnEntry.QUALYEAR.17

QualificationsOnEntry.QUALYEAR should be 2022 or later where QualificationsOnEntry.QUALTYPE is TL.

QR.C20054.QualificationsOnEntry.QUALSBJ.2

QualificationsOnEntry.QUALSBJ must be coded ('WBA' where QualificationsOnEntry.QUALTYPE = WB or WE) or ('SCC' where QualificationsOnEntry.QUALTYPE = WS).

QR.C20054.QualificationsOnEntry.QUALTYPE.3

Where Instance.COMDATE > Y1-07-31 and EntryProfile.QUALENT3 = P50, there should be at least one occurrence of QualificationsOnEntry.QUALTYPE = A, AD, AN, AS, A1, DA, V, V1, V2, 1D, 1E, D1, RE, RN, RW or 9U.

QR.C20054.QualificationsOnEntry.QUALTYPE.2

QualificationsOnEntry.QUALTYPE = WB, WS or WE must only occur once within an EntryProfile entity.

QR.C20054.QualificationsOnEntry.QUALGRADE.2

QualificationsOnEntry.QUALGRADE is invalid for the HESA non-tariff bearing qualification in QualificationsOnEntry.QUALTYPE.

QR.C20054.QualificationsOnEntry.QUALGRADE.3

Where Course.COURSEAIM is begins H, I, J or C or is M22, M26, M28)and Instance.COMDATE is later than Y1-07-31 and latest InstancePeriod.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 begins with P or is equal to X00 or X01), then, across the submission, more than 2% of QualificationsOnEntry records (and more than 5 records) for level 3 tariff bearing qualifications have no QualificationsOnEntry.QUALGRADE.

QR.C20054.QualificationsOnEntry.QUALGRADE.4

Where Course.COURSEAIM begins H, I, J, C, or is M22, M26 or M28, and Instance.COMDATE is later than Y1-07-31 and any InstancePeriod.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 begins with P or is equal to X00 or X01), then, across the submission, more than 1% of QualificationsOnEntry records (and more than 5 records) for level 3 tariff bearing qualifications have no QualificationsOnEntry.QUALGRADE.

QR.C20054.QualificationsOnEntry.QUALGRADE.1

QualificationsOnEntry.QUALGRADE is invalid for the HESA tariff bearing qualification in QualificationsOnEntry.QUALTYPE.

QR.C20054.QualificationsAwarded.CLASS.9

QualificationsAwarded.CLASS must be coded 01 - 14 or 91 - 95 where QualificationsAwarded.QUAL = M22, M26 or M28.

QR.C20054.QualificationsAwarded.CLASS.7

QualificationsAwarded.CLASS must be coded 12-14 where QualificationsAwarded.QUAL is coded J30 or C30.

QR.C20054.QualificationsAwarded.CLASS.3

QualificationsAwarded.CLASS must be coded 01 - 11 or 91 - 95 where QualificationsAwarded.QUAL = H00, H11, H12, H16, H18, H22, H23, H50.

QR.C20054.QualificationsAwarded.CLASS.2

QualificationsAwarded.CLASS must exist where QualificationsAwarded.QUAL exists.

QR.C20054.QualificationsAwarded.CLASS.8

Description: More than 70% of QualificationsAwarded.CLASS are coded 91-95 where QualificationsAwarded.QUAL is coded M22, M26, M28, H00, H11, H12, H16, H18, H22, H23, H50, I00, I11, I12, I16.

QR.C20054.QualificationsAwarded.CLASS.5

All QualificationsAwarded.CLASS are coded 14 where QualificationsAwarded.QUAL exists and is not coded (M22, M26, M28, H00, H11, H12, H16, H18, H22, H23, H50, I00, I11, I12, I16). Please check this is genuine or is code 14 being incorrectly used as a default code?

QR.C20054.QualificationsAwarded.CLASS.6

QualificationsAwarded.CLASS must be coded 14 or 16 where QualificationsAwarded.QUAL is ending in 90.

QR.C20054.QualificationsAwarded.CLASS.4

QualificationsAwarded.CLASS must be coded 07 - 11 where QualificationsAwarded.QUAL = I00, I11, I12 or I16.

QR.C20054.QualificationsAwarded.QUAL.1

QualificationsAwarded.QUAL must be coded M22, M26, M28, H00, H11, H12, H16, H18, H22, H23, H50, I00, I11, I12 or I16 where QualificationsAwarded.CLASS is coded 01 - 11 or 91 - 95.

QR.C20054.QualificationsAwarded.QUAL.15

The number of qualifications awarded is <25% of the Student instance profile SIN1 + SIN2 table total. Have all the awards been returned? Exclude where Instance.RSNEND = 98.

QR.C20054.QualificationsAwarded.QUAL.13

Where QualificationsAwarded.QUAL = H12, I12 or I73, Course.TTCID must equal Q.

QR.C20054.QualificationsAwarded.QUAL.11

QualificationsAwarded.QUAL should not begin D, E, L or M (excluding M22, M26, M28) where Course.COURSEAIM begins H, I, J or C.

QR.C20054.QualificationsAwarded.QUAL.17

The same highest qualification obtained has been returned in a previous submission of an Instance Period.

QR.C20054.QualificationsAwarded.QUAL.16

QualificationsAwarded.QUAL cannot be coded C13, J13, H13, M13 or E13 where Institution.UKPRN is not a Tier 4 provider

QR.C20054.QualificationsAwarded.QUAL.19

Where QualificationsAwarded.QUAL = Course.COURSEAIM, Instance.ENDDATE and Instance.RSNEND must not be NULL

QR.C20054.QualificationsAwarded.QUAL.18

Where QualificationsAwarded.QUAL = Course.COURSEAIM, Instance.RSNEND should be = 01.

QR.C20054.QualificationsAwarded.QUAL.2

QualificationsAwarded.QUAL should not begin D, E, L or M (excluding M22, M26, M28) where Course.COURSEAIM begins H, I, J or C.

QR.C20054.QualificationsAwarded.QUAL.3

QualificationsAwarded.QUAL should not begin I where Course.COURSEAIM begins J or C

QR.C20054.QualificationsAwarded.QUAL.4

QualificationsAwarded.QUAL must not be coded M73, M71, H12, H71, I12, I73, I78 where Course.TTCID = 0.

QR.C20054.QualificationsAwarded.QUAL.5

Multiple identical occurrences of QualificationsAwarded.QUAL appear for a single Student.HUSID and Instance.NUMHUS where (first character of QualificationsAwarded.QUAL = D, E, L, M, and second and third characters of QualificationsAwarded.QUAL are not 90)

QR.C20054.QualificationsAwarded.QUAL.7

Where QualificationsAwarded.QUAL = H11 or I11, Course.TTCID must equal 1.

QR.C20054.QualificationsAwarded.QUAL.6

Multiple identical occurrences of QualificationsAwarded.QUAL appear for a single Student.HUSID and Instance.NUMHUS where (first character of QualificationsAwarded.QUAL = H, I, J or C and second and third characters of QualificationsAwarded.QUAL are not 90)

QR.C20054.QualificationsAwarded.QUAL.10

Where QualificationsAwarded.QUAL = D00, Course.COURSEAIM must begin with D or L.

QR.C20054.QualificationsAwarded.QUAL.9

QualificationsAwarded.QUAL should not begin with H where Course.COURSEAIM begins I, J or C

QR.C20054.QualificationsAwarded.QUAL.8

Where QualificationsAwarded.QUAL is coded M00, M01, M02, M10, M11, M16, M41, M42, M44 or M73 the provider must have degree awarding powers

QR.C20054.Provider.UKPRN.2

For providers with designation at course level, UKPRN, COURSEID and LOCATION combinations exist in the designated course look up file but have no corresponding combination of Provider.UKPRN, InstancePeriod.COURSEID and InstancePeriod.LOCATION in the submitted file.

QR.C20054.Provider.UKPRN.3

For providers with designation at provider level, UKPRN and LOCATION combinations exist in the designated course look up file but have no corresponding combination of Provider.UKPRN and InstancePeriod.LOCATION in the submitted file.

QR.C20054.InstancePeriod.CAMPID.1

Where exists, InstancePeriod.CAMPID must have been submitted in the Provider profile collection.

QR.C20054.InstancePeriod.CAMPID.2

InstancePeriod.CAMPID must exist for all instances at registered providers.

QR.C20054.InstancePeriod.CAMPID.4

Where a campus has been submitted in the Provider Profile collection, it must be returned in InstancePeriod.CAMPID. Have you returned all InstancePeriod.CAMPID?

QR.C20054.InstancePeriod.CAMPID.3

InstancePeriod.CAMPID must not exist for instances at Limited designation or Teach-out designation providers

QR.C20054.InstancePeriod.COURSEID.2

Where (InstancePeriod.YEARPRG is greater than 1 and less than 99) or (InstancePeriod.YEARPRG is 99 and InstancePeriod.YEARSTU is greater than 1) then Course.REGBODY (associated with the latest InstancePeriod.COURSEID) should not be coded 06.

QR.C20054.InstancePeriod.COURSEID.1

Where Instance.RSNEND = (01 or 98) then Course.REGBODY (associated with the latest InstancePeriod.COURSEID) must not be coded '06'.

QR.C20054.InstancePeriod.DISALL.2

InstancePeriod.DISALL must exist where the associated StudentEquality.DISABLE = 08, 51 - 96 unless the instance is inactive for the entire reporting period.

QR.C20054.InstancePeriod.DISALL.7

Instance.DISALL = 9 (Information about Disabled Students' Allowance is not known/not sought) for more than 2% of instances (5 instances) in the HE standard registration population where StudentEquality.DISABLE is in the range 08-96.

QR.C20054.InstancePeriod.HEAPESPOP.1

Where the course has current designation the associated InstancePeriod.HEAPESPOP values across the submission for this InstancePeriod.COURSEID and InstancePeriod.LOCATION(s) combination should have at least one occurrence of InstancePeriod.HEAPESPOP = 1 or NA.

QR.C20054.InstancePeriod.HEAPESPOP.15

Where QUALENT3 begins with H, M, D and course is not ELQ exempt then HEAPESPOP must not equal 1.

QR.C20054.InstancePeriod.HEAPESPOP.16

Where QUALENT3 = JUK and COURSEAIM begins with I, J, C (and course is not ELQ exempt) then HEAPESPOP must not equal 1.

QR.C20054.InstancePeriod.HEAPESPOP.17

Where QUALENT3 begins with J (excluding JUK) and COURSEAIM begins with J, C and course is not ELQ exempt (XEXEMPT01 = 0) then HEAPESPOP must not equal 1.

QR.C20054.InstancePeriod.HEAPESPOP.18

Where QUALENT3 begins with C and COURSEAIM begins with C and course is not ELQ exempt (XEXEMPT01 = 0) then HEAPESPOP must not equal 1.

QR.C20054.InstancePeriod.HEAPESPOP.19

InstancePeriod.HEAPESPOP must not equal 1 where the corresponding EntryProfile.DOMICILE previously sent for the student = IM, XL, GG or JE

QR.C20054.InstancePeriod.HEAPESPOP.22

More than 2% of InstancePeriods (and more than 5 InstancePeriods) where InstancePeriod.HEAPESPOP = 1 with an associated EntryProfile have EntryProfile.DOMICILE not in (XK, XL, GG, JE, IM, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, ZZ, EE, LV, LT, SI, SK, RO, BG, YT)

QR.C20054.InstancePeriod.HEAPESPOP.24

For providers who submit a HEAPES return InstancePeriod.HEAPESPOP must not be coded NA

QR.C20054.InstancePeriod.HEAPESPOP.26

InstancePeriod.HEAPESPOP must not equal 1 where the associated Course.COURSEAIM begins with D, E, L or M (excluding M22, M26, M28, M71 and M73).

QR.C20054.InstancePeriod.HEAPESPOP.25

For providers who do not submit a HEAPES return InstancePeriod.HEAPESPOP, where it exists, must be coded NA

QR.C20054.InstancePeriod.HEAPESPOP.27

InstancePeriod.HEAPESPOP exists and is not required. The field will be removed for the 2019/20 collection C19054.

QR.C20054.InstancePeriod.INITIATIVES.10

Where Instance.INITIATIVES is coded 15 Institution.UKPRN must be one from the list of expected providers

QR.C20054.InstancePeriod.INITIATIVES.11

Where InstancePeriod.INITIATIVES = 16 and ​the length of programme of study is between 1 and 2 years and the associated Course.COURSEAIM = H00 and InstancePeriod.STULOAD is not greater than 100.

QR.C20054.InstancePeriod.INITIATIVES.12

Where InstancePeriod.INITIATIVES = 16 and InstancePeriod.STULOAD is not over 100.

QR.C20054.InstancePeriod.INITIATIVES.13

Where InstancePeriod.INITIATIVES = 16 and InstancePeriod.MODE = 02, 31, 44.

QR.C20054.InstancePeriod.INITIATIVES.14

Where there are three occurrences of Instance.INTITATIVES one must be coded 16.

QR.C20054.InstancePeriod.INITIATIVES.3

InstancePeriod.INITIATIVES codes U, 15 and 16 must only be used by HE providers in England.

QR.C20054.InstancePeriod.INITIATIVES.2

Where there are two or three occurrences of Instance.INITIATIVES they must not be identical.

QR.C20054.InstancePeriod.HEAPESPOP.12

Where the Instance Period is for a teach out designated course InstancePeriod.HEAPESPOP, where it exists, must be coded 2 or NA

QR.C20054.InstancePeriod.HEAPESPOP.14

Where a year on year link has been made to the Continuity Register and InstancePeriod.MODE is consistent (MODEs both equal to 31 or both not equal to 31) then InstancePeriod.HEAPESPOP must not equal 1.

QR.C20054.InstancePeriod.INITIATIVES.1

Where InstancePeriod.INITIATIVES = U the associated Course.COURSEAIM must be coded D00, E00, L00, L99, M00, M01, M02, M10, M11, M16, M76 or M88.

QR.C20054.InstancePeriod.HEAPESPOP.21

InstancePeriod.HEAPESPOP should not be coded 1 where the associated EntryProfile.DOMICILE exists and is not in (XK, XL, GG, JE, IM, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, ZZ, EE, LV, LT, SI, SK, RO, BG, YT)

QR.C20054.InstancePeriod.HEAPESPOP.23

Where InstancePeriod.MSTUFEE = 02, 03, 04, 52, 53 or 54 and Instance.COMDATE >= Y1-08-01 then InstancePeriod.HEAPESPOP should not equal 2 for more than 50 instances. Exclude postgraduate non-ITT courseaims.

QR.C20054.InstancePeriod.HEAPESPOP.20

InstancePeriod.HEAPESPOP must not equal 1 where (associated EntryProfile.DOMICILE exists and is coded IM, XL, GG or JE).

QR.C20054.InstancePeriod.INITIATIVES.4

The latest Instance Period should not have InstancePeriod.INITIATIVES coded U where the associated InstancePeriod.MODE = 01, 02, 23, 24, 25 or 43 and Course.COURSEAIM=M00, M01, M02, M10, M11, M16, M76 or L00 and the length of programme of study is less than 1 or more than 2 years.

QR.C20054.InstancePeriod.INITIATIVES.6

Where the latest InstancePeriod.INITIATIVES = U and the associated InstancePeriod.MODE = 31 or 44, then the length of programme of study should not be greater than 3 years when there are no full-time students (InstancePeriod.MODE = 01, 02, 23, 24, 25 or 43) studying postgraduate taught courses (Course.COURSEAIM = M00, M01, M02, M10, M11, M16, M76 or L00) in this submission.

QR.C20054.InstancePeriod.INITIATIVES.5

The latest Instance Period should not have InstancePeriod.INITIATIVES coded U where the associated InstancePeriod.MODE = 31 or 44 and Course.COURSEAIM=M00, M01, M02, M10, M11, M16, M76, M88 or L00 and the length of programme of study is less than 2 or more than 4 years.

QR.C20054.InstancePeriod.INITIATIVES.8

Where InstancePeriod.INITIATIVES is coded U and the associated Course.COURSEAIM is coded M88, then InstancePeriod.MODE should be coded 31 or 44.

QR.C20054.InstancePeriod.INITIATIVES.7

Where ​InstancePeriod.INITIATIVES = U and the Instance Period is at a Limited Designation or Teach-Out provider, the associated Course.COURSEID and InstancePeriod.LOCATION must exist for the provider in the OfS Designation file and the combined course and location must be eligible for a postgraduate loan for masters study

QR.C20054.InstancePeriod.INITIATIVES.9

The latest Instance Period should not have InstancePeriod.INITIATIVES coded U where the associated Course.COURSEAIM= D00, E00 or L99 and the length of programme of study is less than 3 or more than 8 years.

QR.C20054.InstancePeriod.LOCSDY.10

InstancePeriod.LOCSDY should be coded Z where InstancePeriod.INITIATIVES = K

QR.C20054.InstancePeriod.LOCSDY.9

Where the Instance Period is for a designated course and InstancePeriod.LOCSDY = 6 then the course(s) in the course designation file provided by OfS must be distance learning.

QR.C20054.InstancePeriod.MODE.12

Where Course.COURSEAIM begins D or L, no instance periods have been coded with InstancePeriod.MODE = 43 or 44. Please check it is correct that no postgraduate research students have been writing-up during this reporting year.

QR.C20054.InstancePeriod.MODE.11

InstancePeriod.Mode must not be coded 23, 24 or 25 where Course.COURSEAIM begins with D, E, L or M (excluding M22, M26, M28).

QR.C20054.InstancePeriod.MODE.13

There are more than 10% of instances that have InstancePeriod.MODE coded as 01 where Course.COURSEAIM begins D or L and InstancePeriod.YEARSTU > 4 and Instance.ENDDATE is null. Please check it is correct that these students are studying full-time and are not writing-up.

QR.C20054.InstancePeriod.MODE.14

InstancePeriod.MODE should not be coded 01 where (Course.COURSEAIM begins D, E, L or M (excluding M22, M26 and M28)) and (Instance.COMDATE < Y2-04-01) and (InstancePeriod.STULOAD less than or equal to 10) and (Instance.ENDDATE is null) and (InstancePeriod.EXCHANGE = N, Y or Z) and (InstancePeriod.LOCSDY not equal to S). It is expected that these students will be in writing-up mode.

QR.C20054.InstancePeriod.MODE.15

InstancePeriod.MODE must not be coded 23, 24, or 25 where Course.COURSEAIM = E13, M13, H13, J13 , C30 or C13.

QR.C20054.InstancePeriod.MODE.3

InstancePeriod.MODE should not be coded 23, 24 or 25 where Course.COURSEAIM is H16, H62, I16, M16, M26, or M86 and the CourseSubject.SBJCA is in '100270, 100267, 100271, 100276, 101334, 101336, 100748, 101339, 101338, 101337, 101331, 101309, 101327, 100261, 101324, 101325, 100131, 100266, 100268, 100275 '.

QR.C20054.InstancePeriod.MODE.6

InstancePeriod.MODE should not be coded 01, 23 or 24 where Instance.RSNEND = 01 and (Instance.ENDDATE > the anniversary of Instance.COMDATE + 14 days) and (Instance.ENDDATE < the anniversary of Instance.COMDATE + 24 weeks). Where a student has successfully completed the course, they have to study for at least 24 weeks within the year of instance to be returned as full-time or sandwich.

QR.C20054.InstancePeriod.MODE.7

Where the Instance Period is for a designated course and InstancePeriod.MODE = 31 then the course(s) in the designation list provided by OfS must be identified as part time.

QR.C20054.InstancePeriod.MODE.8

Where the Instance Period is for a designated course and InstancePeriod.MODE = 01, 02, 23, 24 or 25 then the course(s) in the designation list provided by OfS must be identified as full time.

QR.C20054.InstancePeriod.MODE.10

Where InstancePeriod.MODE is coded 43 or 44, Course.CourseAim must begin D, E, L or M (excluding M22, M26, M28, M71 and M73).

QR.C20054.InstancePeriod.MODE.9

InstancePeriod.MODE must be coded 01, 02 or 31 where Course.TTCID = 1 or Q.

QR.C20054.InstancePeriod.MSTUFEE.13

More than 2% of active Instances (and more than 5 Instances) have at least one related InstancePeriod.MSTUFEE = 99.

QR.C20054.InstancePeriod.MSTUFEE.12

InstancePeriod.MSTUFEE should not be coded 03, 04, 53 or 54 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = XF or XI.

QR.C20054.InstancePeriod.MSTUFEE.11

InstancePeriod.MSTUFEE should not be coded 02, 03, 52 or 53 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = XG.

QR.C20054.InstancePeriod.MSTUFEE.10

InstancePeriod.MSTUFEE should not be coded 02, 04, 52 or 54 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = XH.

QR.C20054.InstancePeriod.MSTUFEE.15

For a designated course, at least one instance should be coded as InstancePeriod.MSTUFEE 02, 03, 04, 52, 53, 54

QR.C20054.InstancePeriod.MSTUFEE.14

For a designated course, InstancePeriod.MSTUFEE should be coded 01-04, 52-54, 71 or 81.

QR.C20054.InstancePeriod.MSTUFEE.17

For providers in England InstancePeriod.MSTUFEE should not be coded 31 where Instance.COMDATE is after 31/07/2017 and the associated Course.REGBODY is coded 06, 42, 44, 46 - 48, 50, 52, 55 - 57 or 61 - 65.

QR.C20054.InstancePeriod.MSTUFEE.16

InstancePeriod.MSTUFEE valid entry codes 30 or 96 must not be used. These codes will be removed for the 2017/18 collection C17054.

QR.C20054.InstancePeriod.PERIODEND.1

InstancePeriod.PERIODEND must not be after Instance.ENDDATE (where Instance.ENDDATE is not null).

QR.C20054.InstancePeriod.PERIODEND.4

For full-time students, the latest InstancePeriod.PERIODEND reported for this instance (where InstancePeriod.NOTACT and Instance.RSNEND are null) is before Y2-03-01. Either a subsequent InstancePeriod must be submitted to show the student s continued academic activity, or the student s instance must be recorded as not in active study (Instance.NOTACT) - with a reduction in InstancePeriod.STULOAD. If the student has left, Instance.ENDDATE and Instance.RSNEND should be completed.

QR.C20054.InstancePeriod.PERIODEND.5

For full-time students, the latest InstancePeriod.PERIODEND reported for this instance (where InstancePeriod.NOTACT and Instance.RSNEND are null) is before Y2-05-01. Either a subsequent InstancePeriod should be submitted to show the student s continued academic activity, or the student s instance should be recorded as not in active study (Instance.NOTACT) - with a reduction in InstancePeriod.STULOAD. If the student has left, Instance.ENDDATE and Instance.RSNEND should be completed.

QR.C20054.InstancePeriod.PERIODSTART.2

Where Instance.COMDATE is after Y1-07-31, the earliest InstancePeriod.PERIODSTART returned must equal Instance.COMDATE.

QR.C20054.InstancePeriod.PRIPROV.5

For Information only: Counts of InstancePeriod.PRIPROV submitted

QR.C20054.InstancePeriod.QualificationsAwarded.1

QualificationsAwarded entity must exist on at least one InstancePeriod (preferably the latest) where associated Instance.ENDDATE is not null and Instance.RSNEND = 01 unless Course.COURSEAIM ends with 99.

QR.C20054.InstancePeriod.SSELIG.13

InstancePeriod.SSELIG exists and is not required. The field will be removed for the 2017/18 collection C17054.

QR.C20054.InstancePeriod.SSELIG.9

InstancePeriod.SSELIG must be coded 2 where the corresponding EntryProfile.DOMICILE previously sent for the student = IM, XL, GG or JE.

QR.C20054.InstancePeriod.HEAPESPOP.13

More than 5% of Instance Periods (and more than 5 Instance Periods) where the associated course has current designation and InstancePeriod.HEAPESPOP = 2 have Instance.COMDATE >= Y1-08-01. (Exclude InstancePeriod.INITIATIVES=K (Higher Apprenticeship)).

QR.C20054.InstancePeriod.DISALL.6

Where the associated StudentEquality.DISABLE does not equal 00 more than 5% of active Instances (and more than 5 instances) have at least one related InstancePeriod.DISALL = 9.

QR.C20054.InstancePeriod.DISALL.5

Where InstancePeriod.DISALL = 4 there must be an associated EntryProfile.DOMICILE (including those previously sent for the student) = GG, JE, XL, XK, IM, XF, XI, XH or XG or Student.NATION = GB.

QR.C20054.InstancePeriod.HEAPESPOP.2

The Instance Period is not for a designated course and InstancePeriod.HEAPESPOP equals 1.

QR.C20054.InstancePeriod.HEAPESPOP.3

InstancePeriod.HEAPESPOP must be returned where the Instance Period is for a designated course unless ((InstancePeriod.STULOAD = 0 or does not exist) and (Instance.ENDDATE is before 01-08-Y1 or InstancePeriod.NOTACT = 1 or 2)).

QR.C20054.InstancePeriod.HEAPESPOP.4

Where InstancePeriod.HEAPESPOP = 1 Instance.COMDATE should be later than Y1-07-31.

QR.C20054.InstancePeriod.HEAPESPOP.6

Where InstancePeriod.HEAPESPOP = 1 and Instance.ENDDATE is not null the difference between Instance.ENDDATE and Instance.COMDATE is less than 14 days.

QR.C20054.InstancePeriod.HEAPESPOP.7

Where Course.TTCID = 1, 5, D, F or Q and InstancePeriod.HEAPESPOP exists, it must be coded 2 or NA.

QR.C20054.InstancePeriod.LOCATION.1

InstancePeriod.LOCATION combined with Provider.UKPRN and InstancePeriod.COURSEID is not in the OfS designation list. Therefore the Instance Period will be categorised as non-designated.

QR.C20054.InstancePeriod.LOCATION.2

Where the combination of (Provider.UKPRN and InstancePeriod.COURSEID) appear in the designated course list no InstancePeriod.LOCATION code has been returned.

QR.C20054.InstancePeriod.LOCSDY.2

Where a student has not been active on an instance in the current reporting period InstancePeriod.LOCSDY should not be coded D, E, T or U.

QR.C20054.InstancePeriod.SSELIG.2

More than 2% of InstancePeriods (and more than 5 InstancePeriods) where InstancePeriod.SSELIG = 1 have the associated EntryProfile.DOMICILE exists and is not in (XK, XL, GG, JE, IM, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, ZZ, EE, LV, LT, SI, SK, RO, BG)

QR.C20054.InstancePeriod.STULOAD.12

For an instance the sum of all InstancePeriod.STULOAD < 50 where Course.COURSEAIM is not M71 or M73and all InstancePeriod.MODE = 01 and Instance.COMDATE between Y1-11-01 and Y2-01-31 inclusive and Instance.ENDDATE is null and for latest InstancePeriod, InstancePeriod.NOTACT does not exist. Please check that the correct FTE has been reported for these instances.

QR.C20054.InstancePeriod.STULOAD.13

Sum of InstancePeriod.STULOAD > 80 for an instance where any InstancePeriod.MODE = 31. Please check that the correct FTE has been reported for these instances.

QR.C20054.Instance.STULOAD.10

More than 5% of instances (and more than 5 instances) have sum of all InstancePeriod.STULOAD greater than or equal to 100 where earliest InstancePeriod.PERIODSTART < Y1-08-01 and Instance.ENDDATE > Y1-07-31.

QR.C20054.InstancePeriod.STULOAD.14

Where both InstancePeriod.PERIODSTART and InstancePeriod.PERIODEND are in the current reporting year, InstancePeriod.STULOAD should not be greater than 5 times the number of elapsed weeks between InstancePeriod.PERIODSTART and InstancePeriod.PERIODEND (inclusive).

QR.C20054.InstancePeriod.SSELIG.6

InstancePeriod.SSELIG must be coded 2 for non-designated courses.

QR.C20054.InstancePeriod.PRIPROV.3

Where the associated course is designated InstancePeriod.PRIPROV must not exist.

QR.C20054.InstancePeriod.MSTUFEE.2

Where the associated course is designated InstancePeriod.MSTUFEE should not be coded 99.

QR.C20054.InstancePeriod.MSTUFEE.1

InstancePeriod.MSTUFEE must exist for all instances except for when InstancePeriod.EXCHIND = 1.

QR.C20054.InstancePeriod.LOCSDY.8

Where the associated course is designated InstancePeriod.LOCSDY should not be coded D or T.

QR.C20054.InstancePeriod.LOCSDY.7

Where the associated course is designated InstancePeriod.LOCSDY should not be coded 9 or S.

QR.C20054.InstancePeriod.DISALL.1

InstancePeriod.DISALL must not exist where the Instance Period is not designated.

QR.C20054.InstancePeriod.STULOAD.16

InstancePeriod.STULOAD should not be 0 where associated Course.COURSEAIM begins D or L and InstancePeriod.MODE = 01 or 02 and InstancePeriod.YEARSTU = 01, 02 or 03.

QR.C20054.InstancePeriod.STULOAD.3

InstancePeriod.STULOAD must be greater than 0 unless (Instance.ENDDATE is before Y1-08-01 or InstancePeriod.LOCSDY = S or InstancePeriod.EXCHIND = 1 or InstancePeriod.NOTACT exists).

QR.C20054.Instance.STULOAD.8

Where both Instance.COMDATE and Instance.ENDDATE are in this reporting year, the sum of all InstancePeriod.STULOAD must not be greater than 5 times the number of elapsed weeks between Instance.COMDATE and Instance.ENDDATE (inclusive).

QR.C20054.Instance.STULOAD.7

Where Instance.COMDATE < Y1-08-01 and Instance.ENDDATE > Y1-07-31, the sum of all InstancePeriod.STULOAD must not be greater than 5 times the number of elapsed weeks between Y1-08-01 and Instance.ENDDATE (inclusive).

QR.C20054.Instance.STULOAD.6

Where Instance.COMDATE > Y1-07-31 and Instance.ENDDATE is null, the sum of all InstancePeriod.STULOAD must not be greater than 5 times the number of elapsed weeks between Instance.COMDATE and Y2-07-31 (inclusive).

QR.C20054.Instance.STULOAD.11

For an instance the sum of all InstancePeriod.STULOAD < 100 where Course.COURSEAIM is not M71 or M73 and all InstancePeriod.MODE = 01 and Instance.COMDATE between Y1-08-31 and Y1-10-31 inclusive and Instance.ENDDATE is null and for latest InstancePeriod, InstancePeriod.NOTACT does not exist. Please check that the correct FTE has been reported for these instance periods.

QR.C20054.InstancePeriod.PERIODSTART.6

Where a year on year link has been made to the Continuity Register and the latest Instance Period from last year crossed reporting periods, the earliest InstancePeriod.PERIODSTART date differs.

QR.C20054.InstancePeriod.YEARPRG.2

InstancePeriod.YEARPRG must be less than or equal to Instance.SPLENGTH where Instance.UNITLGTH = 1 and InstancePeriod.YEARPRG is not coded 99.

QR.C20054.InstancePeriod.YEARPRG.4

Where InstancePeriod.YEARPRG is not equal to 99 and Instance.UNITLGTH = 2, InstancePeriod.YEARPRG must be less than or equal to Instance.SPLENGTH divided by 12.

QR.C20054.InstancePeriod.YEARPRG.7

InstancePeriod.YEARPRG should = 1 when ((Instance.UNITLGTH = 2 and Instance.SPLENGTH < 12) or (Instance.UNITLGTH = 3 and Instance.SPLENGTH< 52) ) or InstancePeriod.EXCHIND = 1

QR.C20054.InstancePeriod.YEARSTU.2

InstancePeriod.YEARSTU should not equal 1 where Instance.COMDATE is before Y1-08-01 and InstancePeriod.PERIODEND is after anniversary of Instance.COMDATE + 14 days and InstancePeriod.NOTACT does not exist.

QR.C20054.InstancePeriod.YEARSTU.3

More than 5% of instance periods (and more than 5 InstancePeriods) where InstancePeriod.PERIODSTART > Y1-07-31 and InstancePeriod.PERIODEND < Y2-08-01 have InstancePeriod.YEARSTU less than the difference in years between Instance.COMDATE and Y2-07-31.

QR.C20054.InstancePeriod.YEARSTU.5

InstancePeriod.YEARSTU minus InstancePeriod.YEARPRG is greater than 2 where InstancePeriod.YEARSTU > InstancePeriod.YEARPRG.

QR.C20054.InstancePeriod.YEARSTU.4

InstancePeriod.YEARSTU is greater than 10 where the programme of study is full-time (InstancePeriod.MODE = 01 or 02).

QR.C20054.InstancePeriod.YEARPRG.6

More than 9% of active Instances (and more than 9 Instances) have at least one related InstancePeriod.YEARPRG = 99.

QR.C20054.InstancePeriod.YEARSTU.6

InstancePeriod.YEARPRG minus InstancePeriod.YEARSTU is greater than 2 where InstancePeriod.YEARPRG > InstancePeriod.YEARSTU and InstancePeriod.YEARPRG is not equal to 99.

QR.C20054.InstancePeriod.YEARSTU.7

All instances have been returned as first years.

QR.C20054.InstancePeriod.YEARSTU.9

No non-designated student instances have been returned.

QR.C20054.InstancePeriod.YEARSTU.8

No non-designated first-year students have been returned. A spread across years is expected.

QR.C20054.InstancePeriod.STULOAD.15

InstancePeriod.STULOAD must not be greater than 10.0 where Course.COURSEAIM begins D, E, L or M (excluding M22, M26 and M28) and InstancePeriod.MODE = 43 or 44.

QR.C20054.Instance.STULOAD.9

More than 5% of instances (and more than 5 instances) have sum of all InstancePeriod.STULOAD greater than or equal to 100 where any InstancePeriod.PERIODEND > Y2-07-31 and Instance.COMDATE > Y1-07-31.

QR.C20054.InstancePeriod.HEAPESPOP.10

More than 5% of Instance Periods (and more than 5 Instance Periods) where InstancePeriod.HEAPESPOP = 1 have Instance.COMDATE < Y1-08-01.

QR.C20054.InstancePeriod.HEAPESPOP.9

Where InstancePeriod.HEAPESPOP = 1 then InstancePeriod.SSELIG must be coded 1.

QR.C20054.InstancePeriod.LOCATION.3

Within an InstancePeriod, more than 3 InstancePeriod.LOCATION codes have been submitted for one InstancePeriod.COURSEID.

QR.C20054.EntryProfile.QualificationsOnEntry.17

A qualification present in the UCAS (*J) data is not present in the HESA return for an instance where (Course.COURSEAIM begins H, I, J or C or is M22, M26 or M28) and (InstancePeriod.MODE = 01, 23 or 24) and (Instance.COMDATE > Y1-07-31) and (EntryProfile.DOMICILE = XK, XF, XI, XH or XG) and (EntryProfile.QUALENT3 begins with P or is equal to X00 or X01).

QR.C20054.EntryProfile.PARED.5

EntryProfile.PARED must not exist where (Instance.FUNDCODE= 2, 5 or NULL) or (Course.COURSEAIM begins with D, E, L, or M, or is equal to H50, H60, H61, H62, H78, H81, I60, I61 or I81, excluding M22, M26, M28, M71, M73 or M88) or (Instance.COMDATE < 2020-08-01) or (InstancePeriod.EXCHIND = 1 or 2) or ( all InstancePeriod.STULOAD = 0)

QR.C20054.EntryProfile.PARED.2

More than 10% of students (10 instances) have EntryProfile.PARED = 97 or 99 (Not known/Not available)

QR.C20054.EntryProfile.QUALENT3.26

EntryProfile.QUALENT3 is unknown (X06), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.

QR.C20054.EntryProfile.UCASSCHEMECODE.7

More than 20% of instances (and more than 10 instances) where Instance.COMDATE is in the current reporting year and InstancePeriod.MODE is in (01, 23, 24) and InstancePeriod.LOCSDY not equal to S and Course.COURSEAIM (begins H, I, J, C or is M22, M26 or M28) and EntryProfile.DOMICILE is in (XK, XF, XI, XH, XG) and EntryProfile.UCASSCHEMECODE does not exist.

QR.C20054.EntryProfile.UCASSCHEMECODE.2

Where EntryProfile.UCASSCHEMECODE digits 1-8 are in ranges (06000999 to 06009996 inclusive or 06690999 to 06692257 inclusive), this field must pass either the checksum test as applied to Student.HUSID or the 'incorrectly calculated checksum' test.

QR.C20054.EntryProfile.UCASSCHEMECODE.4

EntryProfile.UCASSCHEMECODE must not contain all zeros.

QR.C20054.EntryProfile.UCASSCHEMECODE.1

EntryProfile.UCASSCHEMECODE must pass the checksum test as applied to Student.HUSID where it is nine characters long and (digits 1-8 are not in ranges 06000999 to 06009996 inclusive or 06690999 to 06692257 inclusive).

QR.C20054.EntryProfile.SEC.1

EntryProfile.SEC must exist where EntryProfile.UCASSCHEMECODE exists and (Course.COURSEAIM begins H, I, J or C or is M22, M26 or M28) and EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM.

QR.C20054.EntryProfile.APELCRD.1

EntryProfile.APELCRD has not been returned for any instances where EntryProfile.CRDPTSTU exists. Please check and return this field where the credits recorded in EntryProfile.CRDPTSTU are as a result of APEL.

QR.C20054.EntryProfile.CARELEAVER.2

EntryProfile.CARELEAVER must not exist where (Instance.FUNDCODE= 2, 5 or NULL) or (Course.COURSEAIM begins with D, E, L, or M, or is equal to H50, H60, H61, H62, H78, H81, I60, I61 or I81, excluding M22, M26, M28, M71, M73 or M88) or (Instance.COMDATE < 2020-08-01) or (InstancePeriod.EXCHIND = 1 or 2) or ( all InstancePeriod.STULOAD = 0)

QR.C20054.EntryProfile.CARELEAVER.1

EntryProfile.CARELEAVER must exist where (Instance.FUNDCODE= 1 or 7) and (Course.COURSEAIM begins with H, I, J, C or is M22, M26, M28, M71, M73 or M88, excluding H50, H60, H61, H62, H78, H81, I60, I61 or I81) and(Instance.COMDATE > 2020-07-31) and (InstancePeriod.EXCHIND = 3 or Null) and (any InstancePeriod.STULOAD is not equal to 0).

QR.C20054.EntryProfile.CRDPTSTU.1

EntryProfile.CRDPTSTU must exist when EntryProfile.CRDSCM exists.

QR.C20054.EntryProfile.CRDPTSTU.2

EntryProfile.CRDPTSTU and EntryProfile.CRDSCM must exist where EntryProfile.APELCRD exists.

QR.C20054.EntryProfile.CRDPTSTU.3

Where EntryProfile.CRDPTSTU exists, it must be greater than 0.

QR.C20054.EntryProfile.CRDPTSTU.4

EntryProfile.CRDPTSTU should not exceed 300.

QR.C20054.EntryProfile.CRDPTSTU.5

EntryProfile.CRDPTSTU has not been returned for any students. Please check and return this field where any students have entered with transfer credits.

QR.C20054.EntryProfile.CRDSCM.2

Where exists, EntryProfile.CRDSCM have all been returned as the same code. Is that as expected?

QR.C20054.EntryProfile.CRDSCM.1

EntryProfile.CRDSCM must exist when EntryProfile.CRDPTSTU exists.

QR.C20054.EntryProfile.DOMICILE.12

All instances have been returned as an UK domicile.

QR.C20054.EntryProfile.CARELEAVER.3

More than 3% of instances (minimum of 10 instances) have EntryProfile.CARELEAVER = 01 or 04. This appears to be a higher than expected level of care leavers, please check this is correct.

QR.C20054.EntryProfile.DOMICILE.7

More than 2% of entry profiles (and more than 5 entry profiles) have EntryProfile.DOMICILE = XK.

QR.C20054.EntryProfile.DOMICILE.6

More than 5% of entry profiles (and more than 5 entry profiles) have EntryProfile.DOMICILE = XK.

QR.C20054.EntryProfile.PARED.1

EntryProfile.PARED must exist where (Instance.FUNDCODE= 1 or 7), and (Course.COURSEAIM begins with H, I, J, C or is M22, M26, M28, M71, M73 or M88, excluding H50, H60, H61, H62, H78, H81, I60, I61 or I81) and (Instance.COMDATE > 2020-07-31) and (InstancePeriod.EXCHIND = 3 or Null) and (any InstancePeriod.STULOAD is not equal to 0).

QR.C20054.EntryProfile.POSTCODE.10

EntryProfile.POSTCODE is not known (null) for more than 2% of instances (and 5 instances) where Instance.COMDATE later than Y1-07-31 and EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM and Course.COURSEAIM begins D, E, L or M (excluding M22, M26, M28).

QR.C20054.EntryProfile.QUALENT3.16

More than 20% (and more than 5 instances) of full-time, other-year, undergraduate students do not have an OUG or level 3 qualification as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.14

More than 20% (and more than 5 instances) of part-time, first-year, undergraduate students do not have an OUG or level 3 qualification as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.13

More than 20% (and more than 5 instances) of full-time, first-year, undergraduate students do not have an OUG or level 3 qualification as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.15

More than 20% (and more than 5 instances) of part-time, other-year, undergraduate students do not have an OUG or level 3 qualification as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.17

Where the QualificationsOnEntry entity has been returned and QualificationsOnEntry.QUALTYPE is a UK qualification, then a EntryProfile.QUALENT3 code of P80 should not typically be used. Please check if another P code is applicable.

QR.C20054.EntryProfile.QUALENT3.18

More than 20% (and more than 5 instances) of full-time, first year students, studying at postgraduate taught level, do not have a first or higher degree as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.19

More than 20% (and more than 5 instances) of part-time, first year students, studying at postgraduate taught level, do not have a first or higher degree as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.2

EntryProfile.QUALENT3 must not be coded P92 or begin with Q, R or X (excluding X00 and X01) when the tariff score is greater than 0.

QR.C20054.EntryProfile.QUALENT3.20

More than 20% (and more than 5 instances) of full-time, first year students, studying at postgraduate research level, do not have a first or higher degree as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.21

More than 20% (and more than 5 instances) of part-time, first year students, studying at postgraduate research level, do not have a first or higher degree as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.22

More than 20% (and more than 5 instances) of full-time, other year students, studying at postgraduate taught level, do not have a first or higher degree as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.23

More than 20% (and more than 5 instances) of part-time, other year students, studying at postgraduate taught level, do not have a first or higher degree as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.24

More than 20% (and more than 5 instances) of full-time, other year students, studying at postgraduate research level, do not have first degree or higher as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.25

More than 20% (and more than 5 instances) of part-time, other year students, studying at postgraduate research level, do not have first degree or higher as their highest qualification on entry.

QR.C20054.EntryProfile.QUALENT3.7

Where a year-on-year link has been made to the Continuity Register, EntryProfile.QUALENT3 (using XQUALENT01) differs [exclude records identified in QR.EntryProfile.QUALENT3.6 (change from known to unknown), and unknown to known value].

QR.C20054.EntryProfile.DOMICILE.4

EntryProfile.DOMICILE must not be coded ZZ (Not known) when corresponding InstancePeriod.HEAPESPOP = 1.

QR.C20054.EntryProfile.DOMICILE.8

Where a Year on Year link has been made to the Continuity Register, EntryProfile.DOMICILE has changed from known to unknown (ZZ) value.

QR.C20054.EntryProfile.DOMICILE.10

Where a Year on Year link has been made to the Continuity Register, EntryProfile.DOMICILE differs [exclude records identified in QR.EntryProfile.DOMICILE.8 and QR.EntryProfile.DOMICILE.9 and unknown (ZZ) to known value].

QR.C20054.EntryProfile.DOMICILE.9

Where a Year on Year link has been made to the Continuity Register, EntryProfile.DOMICILE has changed from a UK (XF, XG, XH, XI, XK) code to a non-UK OR from a non-UK code to a UK (XF, XG, XH, XI, XK) code (excluding unknown [ZZ] to known).

QR.C20054.EntryProfile.POSTCODE.7

Where a Year on Year link has been made to the Continuity Register, EntryProfile.POSTCODE has changed from known full postcode to an outward postcode only, or no longer exists [exclude known to not exists where most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE or IM]

QR.C20054.EntryProfile.POSTCODE.4

Where EntryProfile.POSTCODE is not null it must contain a valid full postcode or a valid outward part of a postcode (excluding BF1 postcodes)

QR.C20054.EntryProfile.POSTCODE.5

More than 10 full-time, undergraduate students returned with identical non-null EntryProfile.POSTCODE.

QR.C20054.EntryProfile.POSTCODE.6

Where exists EntryProfile.POSTCODE should be located in the country of EntryProfile.DOMICILE. (excluding BF1 postcodes)

QR.C20054.EntryProfile.POSTCODE.8

A matching record has been found on the Continuity Register and the Postcode has been changed. (This excludes those from a known to an unknown postcode; from a full to an incomplete postcode; or where postcode is removed when the most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE or IM).

QR.C20054.EntryProfile.POSTCODE.9

A year on year link has been made to the Continuity Register however the POSTCODE data is missing. Resubmission of the full Entry Profile entity is required for these Instances including EntryProfile.POSTCODE (and EntryProfile.PREVINST where applicable).

QR.C20054.EntryProfile.PREVINST.1

EntryProfile.PREVINST must exist where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM, and a student is at a registered provider or at least one Instance Period is for a designated course at a teach out or limited designation provider, and has a related Course.COURSEAIM = M22, M26, M28, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20 or C30.

QR.C20054.EntryProfile.DOMICILE.2

More than 2% of entry profiles (and more than 5 entry profiles) have EntryProfile.DOMICILE = ZZ (Not known).

QR.C20054.EntryProfile.PREVINST.3

Where a year on year link has been made to the Continuity Register, and EntryProfile.PREVINST is not null, EntryProfile.PREVINST exists but differs from the Register. [Exclude where a generic code has changed to a UK provider reference number (UKPRN)].

QR.C20054.EntryProfile.PREVINST.4

There are more than 2% (and more than 5) EntryProfile.PREVINST coded as 9999 (not known).

QR.C20054.EntryProfile.PREVINST.5

A year-on-year link has been made to the Continuity Register, however PREVINST data is missing. Resubmission of the full Entry Profile entity is requested for these Instances including EntryProfile.PREVINST.

QR.C20054.EntryProfile.QUALENT3.4

EntryProfile.QUALENT3 must not be coded P92 where at least one of the associated QualificationsOnEntry.QUALTYPE is a tariff bearing qualification in either the HESA or UCAS definition of the tariff score.

QR.C20054.EntryProfile.QUALENT3.3

EntryProfile.QUALENT3 must not be coded P94 where all of the associated QualificationsOnEntry.QUALTYPE are non-tariff bearing qualifications in either the HESA or UCAS definition of the tariff score.

QR.C20054.EntryProfile.QUALENT3.5

EntryProfile.QUALENT3 should not be coded P93 where any associated QualificationsOnEntry.QUALTYPE is a non-tariff bearing level 3 qualification in either the HESA or UCAS definition of the tariff score.

QR.C20054.EntryProfile.QUALENT3.12

More than 5% of active Instances (and more than 5 Instances) have EntryProfile.QUALENT3 = X05.

QR.C20054.EntryProfile.QUALENT3.11

More than 5% of active Instances (and more than 5 Instances) have EntryProfile.QUALENT3 = X04.

QR.C20054.EntryProfile.QUALENT3.10

More than 20% of active Instances (and more than 5 Instances) have EntryProfile.QUALENT3 = X02.

QR.C20054.EntryProfile.QUALENT3.6

Where a year-on-year link has been made to the Continuity Register, EntryProfile.QUALENT3 has changed from a known to an unknown value.

QR.C20054.EntryProfile.QUALENT3.8

More than 3% of active first year Instances (and more than 5 Instances) have EntryProfile.QUALENT3 = X06.

QR.C20054.EntryProfile.QUALENT3.9

More than 10% of active non-first year Instances (and more than 10 Instances) have EntryProfile.QUALENT3 = X06.

QR.C20054.EntryProfile.QualificationsOnEntry.10

There are more than 10% of instances (and more than 10 instances) where Instance.COMDATE < Y1-08-01 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and latest InstancePeriod.MODE is in (01, 23, 24, 31) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG, XL, GG, JE or IM) and EntryProfile.QUALENT3 in (P41, P42, P46, P47, P50, P51, P53, P54, P62, P63, P64, P65, P68, P93, P94, X00 or X01) with no QualificationsOnEntry entity.

QR.C20054.EntryProfile.QualificationsOnEntry.12

Where a Year on Year link has been made to the Continuity Register, QualificationsOnEntry total tariff score is lower [exclude unknown to known].

QR.C20054.EntryProfile.QualificationsOnEntry.13

Where a year-on-year link has been made to the Continuity Register, QualificationsOnEntry total tariff score is higher [exclude unknown to known].

QR.C20054.EntryProfile.QualificationsOnEntry.14

More than 5% of instances (and more than 5 instances) where Student.BIRTHDTE later than (Y1-21)-08-31 and StudentEquality.NATION = GB have EntryProfile.QUALENT3 = P80.

QR.C20054.EntryProfile.QualificationsOnEntry.15

More than 15% of instances (and more than 15 instances) where Student.BIRTHDTE earlier than (Y1-21)-09-01 and StudentEquality.NATION = GB have EntryProfile.QUALENT3 = P80.

QR.C20054.EntryProfile.QualificationsOnEntry.2

There are multiple identical qualifications on entry for an entry profile. That is, the combination of QualificationsOnEntry.QUALTYPE, QualificationsOnEntry.QUALSBJ, QualificationsOnEntry.QUALGRADE, QualificationsOnEntry.QUALYEAR and QualificationsOnEntry.QUALSIT all occur more than once.

QR.C20054.EntryProfile.QualificationsOnEntry.3

Where EntryProfile.QualificationsOnEntry exist the total tariff score for an instance is greater than 1000 points.

QR.C20054.EntryProfile.QualificationsOnEntry.4

More than 3% of instances (and more than 5 instances) where Instance.COMDATE > Y1-07-31 and Student.BIRTHDTE later than (Y1-21)-08-31 and latest InstancePeriod.MODE is in (01, 23, 24, 31) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG, XL, GG, JE or IM) and EntryProfile.QUALENT3 in (P41, P42, P46, P47, P50, P51, P53, P54, P62, P63, P64, P65, P68, P93, P94, X00 or X01) with no QualificationsOnEntry entity.

QR.C20054.EntryProfile.QualificationsOnEntry.6

There are more than 5% of instances (and more than 5 instances) where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and latest InstancePeriod.MODE is in (01, 23, 24, 31) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG, XL, GG, JE or IM) and EntryProfile.QUALENT3 in (P41, P42, P46, P47, P50, P51, P53, P54, P62, P63, P64, P65, P68, P93, P94, X00 or X01) with no QualificationsOnEntry entity.

QR.C20054.EntryProfile.QualificationsOnEntry.8

More than 5% of instances (and more than 5 instances) where Instance.COMDATE < Y1-08-01 and Student.BIRTHDTE later than (Y1-21)-08-31 and latest InstancePeriod.MODE is in (01, 23, 24, 31) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG, XL, GG, JE or IM) and EntryProfile.QUALENT3 in (P41, P42, P46, P47, P50, P51, P53, P54, P62, P63, P64, P65, P68, P93, P94, X00 or X01) with no QualificationsOnEntry entity.

QR.C20054.EntryProfile.UCASSCHEMECODE.3

Where EntryProfile.UCASSCHEMECODE exists it must be nine characters long where Student.UCASPERID does not exist

QR.C20054.EntryProfile.UCASSCHEMECODE.5

EntryProfile.UCASSCHEMECODE should be four characters long where Student.UCASPERID exists.

QR.C20054.EntryProfile.UCASSCHEMECODE.6

EntryProfile.UCASSCHEMECODE must be four characters long when Instance.COMDATE > 2011-07-31

QR.C20054.EntryProfile.DOMICILE.11

All instances have been returned as an unknown domicile.

QR.C20054.StudentEquality.CARELEAVER.4

EntryProfile.CARELEAVER is coded as not known (99) but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.

QR.C20054.StudentEquality.DISABLE.1

StudentEquality.DISABLE must not exist where no Instance Periods associated with the student are designated.

QR.C20054.StudentEquality.DISABLE.2

StudentEquality.DISABLE must exist where any Instance Period associated with the student is designated.

QR.C20054.StudentEquality.DISABLE.4

More than 10% of students (and more than 10 students) have StudentEquality.DISABLE = 00 where InstancePeriod.DISALL exists.

QR.C20054.StudentEquality.DISABLE.5

StudentEquality.DISABLE is coded as no known disability (00) but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.

QR.C20054.StudentEquality.ETHNIC.1

StudentEquality.ETHNIC must not exist where no Instance Periods associated with the student are designated.

QR.C20054.StudentEquality.ETHNIC.10

StudentEquality.ETHNIC is unknown (90) or information refused (98), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.

QR.C20054.StudentEquality.ETHNIC.2

StudentEquality.ETHNIC must exist where EntryProfile.DOMICILE exists and is coded XF, XG, XH, XI, XK, XL, GG, JE, IM

QR.C20054.StudentEquality.ETHNIC.3

Where a year-on-year link has been made to the Continuity Register, StudentEquality.ETHNIC exists and it has changed from a known to an unknown (90) value.

QR.C20054.StudentEquality.ETHNIC.4

Where a year-on-year link has been made to the Continuity Register and ETHNIC is not null, StudentEquality.ETHNIC exists and the two differ [exclude records identified in QR.StudentEquality.ETHNIC.3 (known to unknown) and (unknown [90] or information refused [98] to known value), and (exists to not exists where most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM)].

QR.C20054.StudentEquality.ETHNIC.5

StudentEquality.ETHNIC must exist where the EntryProfile.DOMICILE previously sent for the student exists and is coded XF, XG, XH, XI, XK, XL, GG, JE or IM.

QR.C20054.StudentEquality.ETHNIC.6

More than 2% of active students (and more than 5 students) who were home domiciled on entry have StudentEquality.ETHNIC = 98.

QR.C20054.StudentEquality.ETHNIC.7

More than 2% of active students (and more than 5 students) who were home domiciled on entry have StudentEquality.ETHNIC = 90.

QR.C20054.StudentEquality.ETHNIC.8

All students have been returned with the same StudentEquality.ETHNIC code. A spread of codes is expected.

QR.C20054.StudentEquality.ETHNIC.9

StudentEquality.ETHNIC codes 13 and 19 can only be returned by HE providers in Scotland.

QR.C20054.StudentEquality.GENDERID.1

StudentEquality.GENDERID must not exist where no Instance Periods associated with the student are designated.

QR.C20054.StudentEquality.GENDERID.2

Where StudentEquality.GENDERID has been returned, all occurrences are coded 98 or 99.

QR.C20054.StudentEquality.GENDERID.3

Where StudentEquality.GENDERID has been returned, more than 10% of students are coded as StudentEquality.GENDERID code 02. Please check the coding matches the collected data.

QR.C20054.StudentEquality.NATION.1

StudentEquality.NATION must exist where any Instance Period associated with the student is designated.

QR.C20054.StudentEquality.RELBLF.1

StudentEquality.RELBLF must not exist where no Instance Periods associated with the student are designated.

QR.C20054.StudentEquality.RELBLF.10

Where a year-on-year link has been made to the Continuity Register, StudentEquality.RELBLF differs [exclude (not exists to exists) and (not known (99) to a known code) and (information refused (98) to a known code)]. Please check whether this is correct.

QR.C20054.StudentEquality.RELBLF.11

Providers in England must not use StudentEquality.RELBLF = 05 or 09

QR.C20054.StudentEquality.RELBLF.12

Providers in England and Scotland must not use StudentEquality.RELBLF = 06, 07 or 08.

QR.C20054.StudentEquality.RELBLF.2

All occurrences of StudentEquality.RELBLF have been coded 98. Please check that code 98 is not being used as an unknown value where the question has not been answered, rather than indicating that the student preferred not to answer the question.

QR.C20054.StudentEquality.RELBLF.3

StudentEquality.RELBLF must exist where any Instance Period associated with the student is designated.

QR.C20054.StudentEquality.RELBLF.4

StudentEquality.RELBLF must not be coded 99 for more than 5% of students, where any of the associated Instance.COMDATEs are later than 2018-07-31 except where all associated InstancePeriod.EXCHIND are coded as 1.

QR.C20054.StudentEquality.RELBLF.5

Where a year-on-year link has been made to the Continuity Register, more than 1% of students have StudentEquality.RELBLF changed from a known code to not known (99) or information refused (98). Please check whether this is correct.

QR.C20054.StudentEquality.RELBLF.6

Where Student.RELBLF = 03 the provider must be in England

QR.C20054.StudentEquality.RELBLF.7

Where Student.RELBLF = 04 the institution must be in Scotland.

QR.C20054.StudentEquality.RELBLF.8

StudentEquality.RELBLF is coded 98 (Information refused) for more than 60% of new entrant instances in the HE standard registration population. Please check whether this is correct.

QR.C20054.StudentEquality.RELBLF.9

StudentEquality.RELBLF is coded 98 (Information refused) for more than 40% of new entrant instances in the HE standard registration population. Please check whether this is correct.

QR.C20054.StudentEquality.SEXID.5

StudentEquality.SEXID must exist.

QR.C20054.StudentEquality.SEXID.1

StudentEquality.SEXID must exist.

QR.C20054.StudentEquality.SEXID.2

It is not expected for there to be more than 2% of students (and more than 5 students) with StudentEquality.SEXID = 3. Please check that there are no systemic errors causing this field to be returned incorrectly.

QR.C20054.StudentEquality.SEXID.3

All students have been returned with the same StudentEquality.SEXID code. A spread of codes is expected.

QR.C20054.StudentEquality.SEXID.4

Where a Year on Year link has been made to the Continuity Register and SEXID is not null, StudentEquality.SEXID (where exists) differs.

QR.C20054.StudentEquality.SEXORT.1

StudentEquality.SEXORT must not exist where no Instance Periods associated with the student are designated.

QR.C20054.StudentEquality.SEXORT.2

Where StudentEquality.SEXORT has been returned, all occurrences are coded 98 and 99.

QR.C20054.StudentEquality.SEXORT.3

Where StudentEquality.SEXORT has been returned, it is not expected for there to be more than 5% of students (and more than 5 students) with StudentEquality.SEXORT = 02 and StudentEquality.SEXID = 2. Please check that there are no systemic errors causing this field to be returned incorrectly.

QR.C20054.StudentEquality.SEXORT.4

Where StudentEquality.SEXORT has been returned, it is not expected for there to be more than 5% of students (and more than 5 students) with StudentEquality.SEXORT = 03 and StudentEquality.SEXID = 1. Please check that there are no systemic errors causing this field to be returned incorrectly.

QR.C20054.DeliveryOrganisationAndLocation.DELORGPROP.1

For each Course entity, the sum of DeliveryOrganisationAndLocation.DELORGPROP must not exceed 100.

QR.C20054.DeliveryOrganisationAndLocation.DELORG.3

Where DeliveryOrganisationAndLocation.DELORG has been returned as a UKPRN, the same UKPRN must not be returned more than once for a Course entity.

QR.C20054.DeliveryOrganisationAndLocation.DELORG.1

Where DeliveryOrganisationAndLocation.DELORG is returned as a UKPRN, it must exist on the UKRLP.

QR.C20054.DeliveryOrganisationAndLocation.DELORG.2

Where DeliveryOrganisationAndLocation.DELORG is a UKPRN, it must not equal Provider.UKPRN.

QR.C20054.DeliveryOrganisationAndLocation.DELORG.4

A generic code (4002, 4003 or 4004) has been returned in DeliveryOrganisationAndLocation.DELORG. Please check whether DeliveryOrganisationAndLocation.DELORG can be coded more accurately.

QR.C20054.DeliveryOrganisationAndLocation.DELORGPROP.2

DeliveryOrganisationAndLocation.DELORGPROP must be greater than 0 where DeliveryOrganisationAndLocation.DELORG exists.

QR.C20054.DeliveryOrganisationAndLocation.PCODELOC.1

Where DeliveryOrganisationAndLocation.PCODELOC is not null, it must contain a valid full postcode or a valid outward part of a postcode

QR.C20054.DeliveryOrganisationAndLocation.PCODELOC.2

DeliveryOrganisationAndLocation.PCODELOC has not been returned where DeliveryOrganisationAndLocation.DELORG is a UKPRN or (4003 or 4004). Please check that this is correct.

QR.C20054.Course.DeliveryOrganisationAndLocation.2

Where the associated course is designated, Course.DeliveryOrganisationAndLocation must not exist.

QR.C20054.Course.DeliveryOrganisationAndLocation.3

Course.DeliveryOrganisationAndLocation entity has not been returned for a course where InstancePeriod.PRIPROV exists. Please check and return any other organisations involved in the delivery of this course

QR.C20054.Course.DeliveryOrganisationAndLocation.1

Where Course.DeliveryOrganisationAndLocation has not been returned for any courses, but at least one InstancePeriod.PRIPROV exists. Please check and return any other organisations involved in the delivery of any courses.

QR.C20054.FinancialSupport.APPSPEND.1

FinancialSupport.APPSPEND has not been returned for any instances, but the OfS is expecting this field to be returned. Please check your access and participation plan.

QR.C20054.Instance.ENDDATE.6

Instance.ENDDATE should not be null where any associated QualificationsAwarded.QUAL = H00, H11, H16, H22, H23, H50, M00, M01, M10, M11, M16, M22, M28, M50, M71, M73, M86, E00 or D00. Please check it is correct that there is no end date for these awards. (For UNISTATS - they will be excluded from the Graduate Outcomes population).

QR.C20054.Instance.ENDDATE.9

Instance.ENDDATE should not be completed where the latest Instance Period's InstancePeriod.NOTACT is coded '1'.

QR.C20054.Instance.ENDDATE.8

No year-on-year link on incoming data for an instance that was 'live' in the 2016/17 collection or earlier (using XYEARM01) and Instance.ENDDATE is null and Instance.NOTACT is null.

QR.C20054.Instance.ENDDATE.7

PERIODEND for the latest period submitted does not match the submitted ENDDATE.

QR.C20054.Instance.FinancialSupport.2

Instance.FinancialSupport entity has not been returned for any instances, but the OfS is expecting financial support to be returned as notified in your access and participation plan. Please check that any financial support has been returned.

QR.C20054.Instance.FinancialSupport.5

The total FinancialSupport.FINAMOUNT returned for instances where (Course.COURSEAIM begins with H, I, J, C or is M22, M26, M28, M71, M73 or M88) and (Instance.EXCHIND = 3) is less than the minimum value reported by OfS. Please check that all financial support has been returned.

QR.C20054.Instance.FinancialSupport.10

Instance.FinancialSupport must not exist where all associated instance periods have InstancePeriod.NOTACT = 1 and InstancePeriod.STULOAD = 0

QR.C20054.Instance.FinancialSupport.9

For one instance where Course.TTCID = 1 or Q, the sum of FinancialSupport.FINAMOUNT for all associated Instance.FinancialSupport entities is greater than 40,000.

QR.C20054.Instance.FinancialSupport.7

For one instance where Course.TTCID = 0, 2, 5, 9 or D, the sum of FinancialSupport.FINAMOUNT for all associated Instance.FinancialSupport entities is greater than 25,000.

QR.C20054.Instance.FinancialSupport.4

Instance.FinancialSupport entity exists where InstancePeriod.DISALL = 4. Please check that the Disabled Students Allowance has not been returned as Financial Support in error.

QR.C20054.Instance.FinancialSupport.8

For one instance where Course.TTCID = 1 or Q, the sum of FinancialSupport.FINAMOUNT for all associated Instance.FinancialSupport entities is greater than 30,000. As this is a high total please check that the values for FinancialSupport.FINAMOUNT are correct.

QR.C20054.Instance.FinancialSupport.6

For one instance where Course.TTCID = 0, 2, 5, 9, or D the sum of FinancialSupport.FINAMOUNT for all associated Instance.FinancialSupport entities is greater than 10,000. As this is a high total please check that the values for FinancialSupport.FINAMOUNT are correct.

QR.C20054.Instance.FinancialSupport.3

Where the Instance.FinancialSupport entity occurs more than once for an instance each FinancialSupport.FINTYPE must be unique.

QR.C20054.Instance.FUNDCODE.1

Instance.FUNDCODE must be returned by Approved (fee cap) providers

QR.C20054.Instance.FUNDCODE.10

More than 25 instances where Instance.FUNDCODE is coded 1 where (EntryProfile.DOMICILE exists and is not in (XK, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, ZZ, EE, LV, LT, SI, SK, RO, BG, IS, NO, LI, AI, BM, VG, KY, FK, MS, PN, SH, GS, TC, PF, YT, NC, BL, PM, WF, AW, BQ, GL, FO, SX, CW, CH, MQ, GP, GF, RE, MF, IC)).

QR.C20054.Instance.FUNDCODE.11

No instances have Instance.FUNDCODE = 1 where (Course.COURSEAIM begins with D or L) and (EntryProfile.DOMICILE is in XK, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, EE, LV, LT, SI, SK, RO, BG, ZZ, IS, NO, LI, CH, AI, BM, VG, KY, FK, MS, PN, SH, GS, TC, PF, NC, BL, PM, WF, AW, BQ, GL, FO, SX, CW, YT, MQ, GP, GF, RE, MF, IC).

QR.C20054.Instance.FUNDCODE.12

Less than 80% of instances have Instance.FUNDCODE = 1 where (Course.COURSEAIM begins with D or L) and (EntryProfile.DOMICILE is in XK, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, EE, LV, LT, SI, SK, RO, BG, ZZ, IS, NO, LI, CH, AI, BM, VG, KY, FK, MS, PN, SH, GS, TC, PF, NC, BL, PM, WF, AW, BQ, GL, FO, SX, CW, YT, MQ, GP, GF, RE, MF, IC).

QR.C20054.Instance.FUNDCODE.13

Instance.FUNDCODE should not be coded 1 where (EntryProfile.DOMICILE exists and is not in (XK, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, ZZ, EE, LV, LT, SI, SK, RO, BG, IS, NO, LI, AI, BM, VG, KY, FK, MS, PN, SH, GS, TC, PF, YT, NC, BL, PM, WF, AW, BQ, GL, FO, SX, CW, CH, MQ, GP, GF, RE, MF, IC)).

QR.C20054.Instance.FUNDCODE.17

Where Course.COURSEAIM begins D, E, L or M (excluding M22, M26 and M28) and InstancePeriod.MODE changes from (01, 02, or 31) to (43 or 44) then Instance.FUNDCODE must stay the same.

QR.C20054.Instance.FUNDCODE.15

Instance.FUNDCODE must be coded 2 where Course.TTCID = Q

QR.C20054.Instance.FUNDCODE.16

More than 2% of instances (and more than 10 instances) have Instance.FUNDCODE = 1 where (EntryProfile.DOMICILE (including those previously sent for the student) is not in (XK, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, ZZ, EE, LV, LT, SI, SK, RO, BG, IS, NO, LI, AI, BM, VG, KY, FK, MS, PN, SH, GS, TC, PF, YT, NC, BL, PM, WF, AW, BQ, GL, FO, SX, CW, CH, MQ, GP, GF, RE, MF, IC).

QR.C20054.Instance.FUNDCODE.2

Providers that are not Approved (fee cap) must not return Instance.FUNDCODE.

QR.C20054.Instance.FUNDCODE.3

Instance.FUNDCODE must not be coded 5 or 7

QR.C20054.Instance.FUNDCODE.4

Instance.FUNDCODE must not be coded 2 where InstancePeriod.LOCSDY = 9.

QR.C20054.Instance.FUNDCODE.5

Instance.FUNDCODE should not be coded 1 where InstancePeriod.LOCSDY = 6 and Instance.COMDATE earlier than Y1-08-01 and EntryProfile.DOMICILE not in (XF, XG, XH, XI or XK).

QR.C20054.Instance.FUNDCODE.6

Instance.FUNDCODE code 1 must not have Course.TTCID = 1, 9, D or Q.

QR.C20054.Instance.FUNDCODE.7

Instance.FUNDCODE should not be coded 1 where Instance.FUNDLEV = 10 or 11 and Course.COURSEAIM begins C or J (excluding J10, J16) and EntryProfile.QUALENT3 begins with D, M, H, J.

QR.C20054.Instance.FUNDCODE.8

Instance.FUNDCODE should not be coded 1 where Instance.FUNDLEV = 20 or 21 and EntryProfile.QUALENT3 begins with D or M (excluding M41, M44 and M71).

QR.C20054.Instance.FUNDCODE.9

Instance.FUNDCODE should not be coded 1 where Instance.FUNDLEV = 10 or 11 and Course.COURSEAIM begins D, E, L, M, H or I and EntryProfile.QUALENT3 begins with D, M, H or is equal to JUK.

QR.C20054.Instance.FUNDCOMP.1

Instance.FUNDCOMP must be returned for Approved (fee cap) providers

QR.C20054.Instance.FUNDCOMP.2

Providers that are not Approved (fee cap) must not return Instance.FUNDCOMP

QR.C20054.Instance.FUNDCOMP.3

Instance.FUNDCOMP cannot be coded 3 where Instance.RSNEND exists.

QR.C20054.Instance.FUNDCOMP.4

More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with D or L (excluding L99) and InstancePeriod.MODE = 01, 02, 23, 24 or 25 and InstancePeriod.STULOAD is greater than or equal to 3 and InstancePeriod.EXCHIND is not equal to 1

QR.C20054.Instance.FUNDCOMP.5

More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with E or M (excluding M22, M26, M28 and M99) and InstancePeriod.MODE = 01, 02, 23, 24 or 25 and InstancePeriod.STULOAD is greater than or equal to 3 and InstancePeriod.EXCHIND is not equal to 1.

QR.C20054.Instance.FUNDCOMP.7

More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with D or L (excluding L99) and Instance.MODE = 31 and InstancePeriod.STULOAD is greater than or equal to 3 and InstancePeriod.EXCHIND is not equal to 1.

QR.C20054.Instance.FUNDCOMP.8

More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with E or M (excluding M22, M26, M28 and M99) and InstancePeriod.MODE = 31 and InstancePeriod.STULOAD is greater than or equal to 3 and InstancePeriod.EXCHIND is not equal to 1.

QR.C20054.Instance.FUNDCOMP.6

More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with H, I, J, C or is M22, M26 or M28 (excluding H99, I99, J99 and C99) and InstancePeriod.MODE = 01, 02, 23, 24 or 25 and InstancePeriod.STULOAD is greater than or equal to 3 and InstancePeriod.EXCHIND is not equal to 1

QR.C20054.Instance.FUNDCOMP.9

More than 10% of instances with Instance.FUNDCOMP = 9 where Course.COURSEAIM begins with H, I, J, C or is M22, M26 or M28 (excluding H99, I99, J99 and C99) and InstancePeriod.MODE = 31 and InstancePeriod.STULOAD is greater than or equal to 3 and InstancePeriod.EXCHIND is not equal to 1.

QR.C20054.Instance.FUNDLEV.1

Instance.FUNDLEV must exist for approved (fee-cap) providers.

QR.C20054.Instance.FUNDLEV.10

Instance.FUNDLEV must not be coded 30 or 31 where Course.COURSEAIM = E00, E90 or begins M, H, I.

QR.C20054.Instance.FUNDLEV.11

Instance.FUNDLEV must be coded 10, 11 or 99 where Course.COURSEAIM begins J, C.

QR.C20054.Instance.FUNDLEV.12

Instance.FUNDLEV must be coded 20, 21 or 99 where Course.COURSEAIM = H61, H62, H78, H81, H88, I61, I81 and Instance.FUNDCODE =1

QR.C20054.Instance.FUNDLEV.13

If any Instance.FUNDLEV = 20 or 21 for a Course.COURSEID then Instance.FUNDLEV must be 20, 21 or 99 for all other instances for the same Course.COURSEID.

QR.C20054.Instance.FUNDLEV.14

If any Instance.FUNDLEV = 10 or 11 for a Course.COURSEID then Instance.FUNDLEV must be 10, 11 or 99 for all other instances for the same Course.COURSEID.

QR.C20054.Instance.FUNDLEV.15

If any Instance.FUNDLEV = 30 or 31 for a Course.COURSEID then Instance.FUNDLEV must be 30, 31 or 99 for all other instances for the same Course.COURSEID.

QR.C20054.Instance.FUNDLEV.2

Instance.FUNDLEV should not be coded 10 or 11 where Course.COURSEAIM begins M and is not M22, M26 or M28.

QR.C20054.Instance.FUNDLEV.3

Instance.FUNDLEV must not be coded 11, 21 or 31 where InstancePeriod.MODE = 23 or 24 and InstancePeriod.LOCSDY = D, E, T or U

QR.C20054.Instance.FUNDLEV.4

Instance.FUNDLEV must be coded 20, 21 or 99 where Course.COURSEAIM = M73, M71 or H71

QR.C20054.Instance.FUNDLEV.5

Instance.FUNDLEV must be coded 30, 31 or 99 where Course.COURSEAIM begins D or L.

QR.C20054.Instance.FUNDLEV.6

Instance.FUNDLEV should be coded 20, 21 or 99 where Course.COURSEAIM begins E or M (excluding M22, M26 and M28) or equals H50, H60, H61, H62, H71, H78, H81, H88, I60, I61 and I81.

QR.C20054.Instance.FUNDLEV.7

Instance.FUNDLEV should be coded 10, 11 or 99 where Course.COURSEAIM begins H or I or equals M22, M26 or M28. This rule is not applied when the Course.COURSEAIM is one of the following H50, H60, H61, H62, H71, H78, H81, H88, I60, I61, I71 and I81

QR.C20054.Instance.FUNDLEV.8

Instance.FUNDLEV must not exist for Approved, Limited designation or Teach out providers.

QR.C20054.Instance.FUNDLEV.9

Instance.FUNDLEV must not be coded 10 or 11 where Course.COURSEAIM = D00, E00.

QR.C20054.Instance.GROSSFEE.42

For approved (fee-cap) providers, Instance.GROSSFEE must be less than or equal to the Office for Students agreed amount for accelerated first degrees where (Course.COURSEAIM = M22, M26, M28, H00, H11, H12, H13, H16, H18, H22, H23, H41, H42, H43, H70, H76, H80, H88, H90, H99, I00, I11, I12, I16, I70, I76, I80, I81, I90 or I99) and InstancePeriod.INITIATIVES = 16 and Instance.FUNDCODE = 1 and InstancePeriod.LOCSDY does not equal D and (InstancePeriod.MODE does not equal 02, 31 or 44).

QR.C20054.Instance.GROSSFEE.41

For approved (fee-cap) providers, Instance.GROSSFEE must be less than or equal to the OfS agreed amount for part-time sandwich years where ((Course.COURSEAIM = M22, M26, M28, H00, H11, H12, H16, H18, H22, H23, H41, H42, H43, H70, H76, H80, H88, H90, H99, I00, I11, I12, I16, I70, I76, I80, I81, I90, I99, J10, J16, J20, J26, J30, J41, J42, J43, J76, J80, J90, J99, C20, C30, C41, C42, C43, C80, C90 or C99) and Instance.FUNDCODE = 1 and InstancePeriod.LOCSDY = D and (InstancePeriod.MODE= 31, 44).

QR.C20054.Instance.GROSSFEE.40

For approved (fee-cap) providers, Instance.GROSSFEE must be less than or equal to the Office for Students agreed amount for part-time postgraduate ITT where (Course.COURSEAIM = M71, M73, H71, I71 or I73) and Course.TTCID = 1 and Instance.FUNDCODE = 2 and (EntryProfile.DOMICILE (including those previously sent for the student) = XK, XL, GG, JE, IM, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, EE, LV, LT, SI, SK, RO, BG or YT) and (InstancePeriod.MSTUFEE = 02, 03, 04, 52, 53 or 54) and (InstancePeriod.LOCSDY does not equal D) and (InstancePeriod.MODE = 31, 44).

QR.C20054.Instance.GROSSFEE.39

For approved (fee-cap) providers, Instance.GROSSFEE must be less than or equal to the Office for Student agreed amount for part-time HNC, HND, HE Certificates and HE Diplomas where (Course.COURSEAIM = J13, J20, J26, J30, J41, J42, J43, J76, J80, J90, J99, C13, C20, C30, C41, C42, C43, C80, C90 or C99) and Instance.FUNDCODE = 1 and (InstancePeriod.LOCSDY does not equal D) and (InstancePeriod.MODE = 31, 44).

QR.C20054.Instance.GROSSFEE.38

For approved (fee-cap) providers, Instance.GROSSFEE must be less than or equal to the Office for Students agreed amount for part-time foundation degrees where (Course.COURSEAIM = J10 or J16) and Instance.FUNDCODE = 1 and InstancePeriod.LOCSDY does not equal D and (InstancePeriod.MODE = 31, 44).