Skip to main content

Quality Rules Directory for C14054

Download all the C14054 rules

Filter

Keyword filter
Filter by stage
Filter by tolerance
Filter by status
Recently changed

QR.C14054.Course.REGBODY.1

Course.REGBODY must exist where Course.COURSEAIM = M26, H16, H62, H76, I16, I76, J26 or J76.
Business RuleErrorAdded
Plain English
A Regulatory Body must be identified where the course aim indicates eligibility to register with such a body.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.TTCID.1

Course.TTCID must not be coded 0 where Course.COURSEAIM is coded M71, H71, I11 or H11.
Business RuleErrorAdded
Plain English
PGCE, PGDE and B.Ed courses must be returned as teacher training.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.TTCID.2

Course.TTCID must be coded 2 where Course.COURSEAIM = H79, I79, C77 or C78.
Business RuleErrorAdded
Plain English
Courses leading to qualifications for teaching in the Lifelong Learning Sector must be coded as other ITT.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.CourseSubject.SBJCA.1

If CourseSubject.SBJCA begins with B82 and Course.COURSEAIM ends with '16' then CourseSubject.SBJCA should be coded B821 or B822.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.CourseSubject.SBJCA.2

If CourseSubject.SBJCA begins with B7 and Course.COURSEAIM ends with '16' then CourseSubject.SBJCA should be coded B720, B730, B740, B750, B760 or B761.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.CourseSubject.SBJCA.3

The first character of CourseSubject.SBJCA must be 'D' where Course.COURSEAIM is coded H16, H62, I16 or M26 and Course.REGBODY = 14.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.CourseSubject.SBJCA.4

The first character of CourseSubject.SBJCA must be 'A' or CourseSubject.SBJCA must equal B750, where Course.COURSEAIM is coded H16, H62, I16 or M26 and Course.REGBODY = 30-35.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.CourseSubject.SBJCA.7

Where the course is designated CourseSubject.SBJCA must not be coded Y000.
Business RuleErrorAdded
Plain English
Designated courses must not have a course subject of Combined/general subject unspecified (Y000)
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.CourseSubject.SBJPCNT.1

For each Course entity the sum of CourseSubject.SBJPCNT must equal 100.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.DOMICILE.1

EntryProfile.DOMICILE has been coded as ZZ (Not known). Please review this data and allocate a more precise code where possible.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.DOMICILE.3

EntryProfile.DOMICILE must not be coded XC or XL.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.DOMICILE.4

EntryProfile.DOMICILE must not be coded ZZ (Not known) when corresponding InstancePeriod.SSELIG = 1
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.NUMHUS.1

The EntryProfile.NUMHUS returned must have a corresponding Instance.NUMHUS for the same Student.HUSID.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.POSTCODE.1

EntryProfile.POSTCODE must exist where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.POSTCODE.2

EntryProfile.POSTCODE must not exist where EntryProfile.DOMICILE is not in (XF, XG, XH, XI, XK, XL, GG, JE or IM).
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.PREVINST.1

EntryProfile.PREVINST must exist where EntryProfile.DOMICILE = XF, XG, XH, XI, XK, XL, GG, JE or IM and Course.COURSEAIM = M22, M26, M28, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20 or C30 and associated Instance is for a designated course and Provider.SUBPURPOSE = 1 or 3.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.PREVINST.2

Where EntryProfile.PREVINST exists it must be either a valid UKPRN or one of the generic codes specified in the manual.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QUALENT3.1

EntryProfile.QUALENT3 cannot be coded X06 where QualificationsOnEntry entity exists.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QualificationsOnEntry.1

There are more than 30 occurrences of QualificationsOnEntry for an Entry Profile.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.COMDATE.1

Instance.COMDATE must not be before 2000-08-01.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.COMDATE.2

Instance.COMDATE must be before Y2-08-01.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.COMDATE.3

More than 100 instances where latest InstancePeriod.MODE in (02, 25, 31) and Course.COURSEAIM does not end with '90' have Instance.COMDATE earlier than (Y1-7)-07-31.
Business RuleErrorAdded
Plain English
More than 100 instances started more than 7 years ago where the mode is part time/Other full time/Other sandwich for qualifications other than credits only.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.COMDATE.4

More than 50 instances where latest InstancePeriod.MODE in (01, 23, 24) and CourseSubject.SBJCA does not begin with A have Instance.COMDATE earlier than (Y1-5)-07-31
Business RuleErrorAdded
Plain English
More than 50 instances started more than 5 years ago where the mode is full time/sandwich are on qualifications which are not medical or dental studies.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.ENDDATE.1

Instance.ENDDATE must not be null where Instance.RSNEND exists.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.ENDDATE.2

Where it is not null Instance.ENDDATE must be before Y2-08-01.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.ENDDATE.3

Where the sum of InstancePeriod.STULOAD for an Instance > 0 then Instance.ENDDATE (where exists) must be after Y1-07-31.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.ENDDATE.5

Where it is not null Instance.ENDDATE must be greater than or equal to Instance.COMDATE
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.ENDDATE.6

Instance.ENDDATE should not be null where any associated QualificationsAwarded.QUAL = H00, H11, H16, H22, H23, H50, M22, M28 or M71. Please check it is correct that there is no end date for these awards. (For UNISTATS - they will be excluded from the DLHE population).
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.HEAPESPOP.2

The course is not designated and one or more associated Instance.HEAPESPOP equals 1.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.HEAPESPOP.3

Instance.HEAPESPOP must be returned where the associated course is designated and Provider.SUBPURPOSE = 1 or 3.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.HEAPESPOP.4

Where Instance.HEAPESPOP = 1 Instance.COMDATE should be after Y1-07-31.
Business RuleWarningAdded
Plain English
The coding of HEAPESPOP indicates that the student is within the HEAPES population. Students who started prior to the current reporting year are not included in the HEAPES survey. Please check the coding is correct.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.HEAPESPOP.5

Instance.HEAPESPOP = 1 and all associated InstancePeriod.MODE are coded 31.
Business RuleErrorAdded
Plain English
The coding of HEAPESPOP indicates that the student is within the HEAPES population. Students who are part time must not be included in the HEAPES survey.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.HEAPESPOP.6

Instance.HEAPESPOP = 1 and, where Instance.ENDDATE is not null, difference between Instance.ENDDATE and Instance.COMDATE is less than 14 days.
Business RuleWarningAdded
Plain English
The coding of HEAPESPOP indicates that the student is within the HEAPES population. Students who study for less than 2 weeks (unless they have a confirmed attendance to the SLC) are not included in the HEAPES survey. Please check the coding is correct.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.HEAPESPOP.8

Instance.HEAPESPOP has been coded 1 and all associated InstancePeriod.LOCSDY are codes 6 or 9.
Business RuleErrorAdded
Plain English
The coding of HEAPESPOP indicates that the student is within the HEAPES population. Students studying by distance learning must not be included in the HEAPES survey.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.HEAPESPOP.9

Where Instance.HEAPESPOP = 1 InstancePeriod.SSELIG must be coded 1.
Business RuleErrorAdded
Plain English
Only students eligible for student support are in the HEAPES population.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.InstancePeriod.2

The number of days between the InstancePeriod.PERIODSTART and InstancePeriod.PERIODEND should not be more than 365.
Business RuleWarningAdded
Plain English
An Instance Period is not expected to last longer than 1 year.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.InstancePeriod.3

More than 3 InstancePeriod entities have been returned for a single Instance.
Business RuleWarningAdded
Plain English
It would not be expected for an Instance to contain more than 3 InstancePeriods.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.LOCATION.1

Where Provider.SUBPURPOSE = 1 or 3 and Instance.LOCATION has been returned the Course.COURSEID and Instance.LOCATION combination is not in the list of designated courses.
Business RuleErrorAdded
Plain English
Location data has been returned on the Instance entity, however the location identifier combined with course identifier cannot be found in the course designation list provided by HEFCE.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.LOCATION.3

Within an Instance, more than 3 Instance.LOCATION codes have been submitted for one Instance.COURSEID
Business RuleWarningAdded
Plain English
Although up to 10 location codes can be returned for a single Instance, more than 3 would not be expected.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.LOCATION.4

Where provider designation applies, Instance.LOCATION must not exist.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.LOCATION.5

Instance.LOCATION must not exist where Provider.SUBPURPOSE = 2
Business RuleErrorAdded
Plain English
If the purpose of the return is UNISTATS only then the location identfier is not permitted.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.RSNEND.1

Instance.RSNEND must exist where Instance.ENDDATE is not null.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.RSNEND.2

Instance.RSNEND should exist where QualificationsAwarded.QUAL exists, unless the qualification awarded is an interim award.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.RSNEND.3

Where Instance.RSNEND is coded 04 the associated course must be designated and Provider.SUBPURPOSE must equal 1 or 3.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.SPLENGTH.1

Where exists Instance.SPLENGTH cannot be greater than 09 where Instance.UNITLGTH =1.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.SPLENGTH.2

Where exists Instance.SPLENGTH should not be greater than 72 where any associated InstancePeriod.MODE = 01, 02, 23, 24 or 25 and Instance.UNITLGTH = 2.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.SPLENGTH.3

Where the Instance is for a designated course then (Instance.UNITLGTH = 2 and Instance.SPLENGTH < 9) or (Instance.UNITLGTH = 3 and Instance.SPLENGTH < 24).
Business RuleErrorAdded
Plain English
Where the Instance is for a designated course the expected length of study must equate to at least one year
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.UNITLGTH.1

Instance.UNITLGTH must not be coded 4 (Days) or 5 (hours)
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.UNITLGTH.2

Where Instance.UNITLGTH is coded 9 Instance.SPLENGTH must be null
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.UNITLGTH.3

Instance.UNITLGTH must be coded 9 where Instance.SPLENGTH is null
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.DISALL.1

InstancePeriod.DISALL must not exist where (the associated course is not designated or Provider.SUBPURPOSE = 2).
Business RuleErrorAdded
Plain English
Disabled student allowance data is only permitted where the associated course and submission purpose include designation.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.DISALL.2

InstancePeriod.DISALL must exist where the associated StudentEquality.DISABLE = 08, 51 – 96.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.DISALL.3

InstancePeriod.DISALL should not exist where the associated StudentEquality.DISABLE = 00.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.DISALL.4

InstancePeriod.DISALL cannot be coded 4 where (the associated EntryProfile.DOMICILE exists and is not coded GG, JE, XL, XK, IM, XF, XI, XH, XG).
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.EXCHIND.1

InstancePeriod.EXCHIND should be coded 3 where InstancePeriod.LOCSDY = 6 or 9
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.EXCHIND.2

InstancePeriod.EXCHIND must be coded 1 where Course.COURSEAIM code ends with 91.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.EXCHIND.3

InstancePeriod.EXCHIND must be coded 3 where InstancePeriod.LOCSDY = S
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.GROSSFEE.1

InstancePeriod.GROSSFEE must be greater than or equal to InstancePeriod.NETFEE
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.GROSSFEE.2

InstancePeriod.GROSSFEE must exist where InstancePeriod.NETFEE exists.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.GROSSFEE.3

InstancePeriod.GROSSFEE must exist where the course is designated and Provider.SUBPURPOSE = 1 or 3 and (InstancePeriod.EXCHIND = 2 or 3) and (the sum of InstancePeriod.STULOAD associated with the instance > 0).
Business RuleErrorAdded
Plain English
The gross fee must be returned for students who are on designated courses. It is not required for incoming exchange students or those who are dormant.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.GROSSFEE.4

InstancePeriod.GROSSFEE should be less than or equal to 40000 where any associated CourseSubject.SBJCA = A100, A200, A300, A400, D100, D190, D200, D210, D220 or D290.
Business RuleWarningAdded
Plain English
The gross fee should be less than 40,000 where any subject associated with the course relates to clinical/pre-clinical medicine, dentistry or veterinary medicine.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.GROSSFEE.5

InstancePeriod.GROSSFEE should be less than or equal to 30000 where (no associated CourseSubject.SBJCA = A100, A200, A300, A400, D100, D190, D200, D210, D220 or D290) and (Course.COURSEAIM is not equal to H88 or M28).
Business RuleWarningAdded
Plain English
The gross fee should be less than 30,000 where the course is not related to clinical/pre-clinical medicine, dentistry or veterinary medicine or Architecture Part II .
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.GROSSFEE.6

InstancePeriod.GROSSFEE should be less than or equal to 20000 where InstancePeriod.MODE = 31.
Business RuleWarningAdded
Plain English
The gross fee should be less than 20,000 where the course is part time.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.GROSSFEE.7

InstancePeriod.GROSSFEE should be less than or equal to 40000 where Course.COURSEAIM = H88 or M28.
Business RuleWarningAdded
Plain English
The gross fee should be less than 40,000 where the course is related to Architecture Part II.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.GROSSFEE.8

InstancePeriod.GROSSFEE > 0 where InstancePeriod.PERIODSTART < Y1-08-01 and InstancePeriod.PERIODEND > Y1-07-31. Please check these fees are correct as it is expected that the full-fee for the instance period will be returned in the reporting year within which the instance period commenced.
Business RuleWarningAdded
Plain English
Where an InstancePeriod is non-contained the full fee (if known) would usually be returned when the InstancePeriod commenced.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.LOCSDY.1

InstancePeriod.LOCSDY must not be coded D or E where InstancePeriod.MODE is coded 01.
Business RuleErrorAdded
Plain English
A full time student must not be on an industrial placement. Consider re-coding as sandwich mode.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.LOCSDY.3

InstancePeriod.LOCSDY should be coded D, E, T, U or Z where InstancePeriod.MODE = 23, 24 or 25.
Business RuleWarningAdded
Plain English
Sandwich students should be on industrial placement, abroad or at the provider/partner.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.LOCSDY.4

InstancePeriod.LOCSDY should be coded D, E or Z where InstancePeriod.EXCHIND = 1.
Business RuleWarningAdded
Plain English
Incoming exchange students should be on industrial placement or at the provider/partner.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.LOCSDY.5

InstancePeriod.LOCSDY should be coded U or T where InstancePeriod.EXCHIND = 2.
Business RuleWarningAdded
Plain English
Outgoing exchange students should be coded as abroad.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
Business RuleWarningAdded
Plain English
Where the country of domicile on entry for a student is the UK the location of study returned is 'studying abroad and included in the Student record as student has spent or will spend more than 8 weeks in the UK'. Please consider whether the codings for abroad for whole/proportion of the year may be more correct.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.LOCSDY.7

Where the Instance is for a designated course Instanceperiod.LOCSDY should not be coded 9 or S.
Business RuleWarningAdded
Plain English
It is expected that designated courses would be delivered ‘substantially’ in the UK.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.LOCSDY.8

Where the Instance is for a designated course Instanceperiod.LOCSDY should not be coded D or T.
Business RuleWarningAdded
Plain English
It is unusual for designated courses to involve a year abroad or a sandwich year out.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MODE.1

InstancePeriod.MODE cannot be coded 01 where Instance.UNITLGTH = 3 and Instance.SPLENGTH = 01 to 23.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MODE.2

InstancePeriod.MODE cannot be coded 01 where Instance.UNITLGTH = 2 and Instance.SPLENGTH = 01 to 05.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MODE.3

InstancePeriod.MODE should not be coded 23, 24 or 25 where Course.COURSEAIM is H16, H62, I16, or M26 and the first character of any associated CourseSubject.SBJCA is 'A'.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MODE.5

InstancePeriod.MODE should be coded 31 where Course.TTCID = 5.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MSTUFEE.1

InstancePeriod.MSTUFEE must exist where the associated course is designated and Provider.SUBPURPOSE = 1 or 3.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MSTUFEE.2

Where the associated course is designated InstancePeriod.MSTUFEE should not be coded 99.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MSTUFEE.3

InstancePeriod.MSTUFEE should not be coded 07 where InstancePeriod.MODE = 01, 23 or 24.
Business RuleWarningAdded
Plain English
Where the student is full time or sandwich they should not be on the unemployed student scheme.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MSTUFEE.4

InstancePeriod.MSTUFEE should not be coded 07 where InstancePeriod.MODE = 02 or 25, Instance.UNITLGTH = 3 and Instance.SPLENGTH > 23.
Business RuleWarningAdded
Plain English
Where the student is full time or sandwich (duration more than 24 weeks) they should not be on the unemployed student scheme.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MSTUFEE.5

InstancePeriod.MSTUFEE should not be coded 07 where InstancePeriod.MODE = 02 or 25, Instance.UNITLGTH = 2 and Instance.SPLENGTH > 05.
Business RuleWarningAdded
Plain English
Where the student is full time or sandwich (duration more than 5 months) they should not be on the unemployed student scheme.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MSTUFEE.6

InstancePeriod.MSTUFEE must not be 71 where InstancePeriod.STULOAD greater than 0
Business RuleErrorAdded
Plain English
Where some activity has taken place the student must not be ‘absent for year’.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MSTUFEE.7

InstancePeriod.MSTUFEE should not be coded 02, 03, 52 or 53 where (the associated EntryProfile.DOMICILE exists and is coded XG).
Business RuleWarningAdded
Plain English
Major source of tuition fee should not be related to England, Scotland or Wales where the student is domiciled in Northern Ireland on entry.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MSTUFEE.8

InstancePeriod.MSTUFEE should not be coded 02, 04, 52 or 54 where (the associated EntryProfile.DOMICILE exists and is coded XH).
Business RuleWarningAdded
Plain English
Major source of tuition fee should not be related to England, Northern Ireland or Wales where the student is domiciled in Scotland on entry.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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).
Business RuleWarningAdded
Plain English
Major source of tuition fee should not be related to Northern Ireland or Scotland where the student is domiciled in England or Wales on entry.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.NETFEE.1

InstancePeriod.NETFEE must exist where InstancePeriod.GROSSFEE exists.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.NETFEE.2

InstancePeriod.NETFEE = 0 where (InstancePeriod.MSTUFEE = 01-04, 06-26, 32-61, 97 or 99) and InstancePeriod.STULOAD > 0 and InstancePeriod.PERIODSTART is later than Y1-07-31. Please check it is correct that the net fee is zero for these InstancePeriods.
Business RuleWarningAdded
Plain English
A net fee should be returned for an Instance Period starting in the current reporting year where there are fees expected (not NHS funded, employer to pay, no fees charged).
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
Business RuleWarningAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule updated to include criteria on end date.
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.PERIODEND.1

InstancePeriod.PERIODEND must not be after Instance.ENDDATE (where Instance.ENDDATE is not null).
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.PERIODEND.2

Where InstancePeriod.PERIODEND does not equal Instance.ENDDATE or Instance.ENDDATE is null, the InstancePeriod should last longer than one month.
Business RuleWarningAdded
Plain English
The InstancePeriod should last longer than one month unless it has ended on the same date as the Instance.
Further Guidance
N/A
Reason for Change
Rule updated to take into account early completion/withdrawal date.
Previous Name of Rule
N/A

QR.C14054.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).
Business RuleErrorAdded
Plain English
The InstancePeriod end date can be before the start of the current reporting period only if the InstancePeriod is returned as dormant or the Instance has ended prior to the current reporting period.
Further Guidance
N/A
Reason for Change
Rule amended to enable data on ended Instances to be returned.
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.PERIODSTART.1

InstancePeriod.PERIODSTART must not be before Instance.COMDATE
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.PERIODSTART.2

Where Instance.COMDATE is after Y1-07-31, the earliest InstancePeriod.PERIODSTART returned must equal Instance.COMDATE.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.PERIODSTART.3

Within an entity InstancePeriod.PERIODSTART must be before InstancePeriod.PERIODEND
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.PERIODSTART.5

InstancePeriod.PERIODSTART must be before Y2-08-01.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.PRIPROV.1

InstancePeriod.PRIPROV should not be coded 4003 or 4004. The preferred coding of InstancePeriod.PRIPROV is a valid UKPRN.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.PRIPROV.2

InstancePeriod.PRIPROV must not equal Provider.UKPRN
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.PRIPROV.3

Where the Instance is for a designated course InstancePeriod.PRIPROV must not exist.
Business RuleErrorAdded
Plain English
Providers cannot franchise out designated courses.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.PRIPROV.4

Where InstancePeriod.PRIPROV exists and does not equal 4002, 4003 or 4004 it must contain a valid UKPRN.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
Business RuleErrorAdded
Plain English
Where an Instance has been completed successfully the details of the qualification awarded must be returned.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.SSELIG.1

InstancePeriod.SSELIG should be coded 2 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)
Business RuleWarningAdded
Plain English
Students should not be eligible to receive student support where their domicile on entry is non-EU.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.SSELIG.5

InstancePeriod.SSELIG should be coded 2 where the associated Course.TTCID = 5.
Business RuleWarningAdded
Plain English
Students should not be eligible to receive student support where they are studying an in-set course.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.SSELIG.6

InstancePeriod.SSELIG must be coded 2 for non-designated courses.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.SSELIG.7

InstancePeriod.SSELIG must be coded 1 where InstancePeriod.MSTUFEE equals 02, 03, 04, 52, 53 or 54.
Business RuleErrorAdded
Plain English
Where the major source fees includes SLC then students must be eligible to receive student support.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.SSELIG.8

InstancePeriod.SSELIG must be coded 2 where (associated EntryProfile.DOMICILE exists and is coded IM, XL, GG or JE).
Business RuleErrorAdded
Plain English
Where the country of domicile on entry for a student is Channel Islands or Isle of Man the student is not eligible to receive student support.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.STULOAD.1

The sum of InstancePeriod.STULOAD for the reporting period must be less than or equal to 300.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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).
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.STULOAD.3

InstancePeriod.STULOAD must be greater than 0 unless (InstancePeriod.LOCSDY = S or InstancePeriod.EXCHIND = 1 or InstancePeriod.NOTACT exists).
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.STULOAD.4

InstancePeriod.STULOAD should be less than 100 where InstancePeriod.PERIODEND > Y2-07-31 and InstancePeriod.PERIODSTART > Y2-01-31
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.STULOAD.5

InstancePeriod.STULOAD should be less than 100 where InstancePeriod.PERIODSTART < Y1-08-01 and InstancePeriod.PERIODEND < Y2-02-01
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.YEARPRG.1

InstancePeriod.YEARPRG code 0 should have Course.COURSEAIM beginning with H or I.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.YEARPRG.2

InstancePeriod.YEARPRG should be less than or equal to Instance.SPLENGTH where Instance.UNITLGTH = 1 and InstancePeriod.YEARPRG is not coded 99.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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).
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.YEARPRG.4

Where InstancePeriod.YEARPRG is not equal to 99 and Instance.UNITLGTH = 2, InstancePeriod.YEARPRG should be less than or equal to Instance.SPLENGTH divided by 12.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.YEARPRG.5

InstancePeriod.YEARPRG should not equal 99 where Instance.UNITLGTH = 1, 2, 3, 4 or 5.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Provider.SUBPURPOSE.1

Provider.SUBPURPOSE = 1 or 3 and no designated courses have been submitted.
Business RuleErrorAdded
Plain English
If the purpose of the return includes course designation then designated courses must be included.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Provider.SUBPURPOSE.3

Provider.SUBPURPOSE = 2 and the provider has provider designation status.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsAwarded.CLASS.1

QualificationsAwarded.CLASS must not equal 04.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsAwarded.CLASS.2

QualificationsAwarded.CLASS must exist where QualificationsAwarded.QUAL = M22, M26, M28, H00, H11, H16, H18, H22, H23, H50, I00, I11, I16.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsAwarded.CLASS.3

QualificationsAwarded.CLASS must be coded 01 - 11 where QualificationsAwarded.QUAL = H00, H11, H16, H18, H22, H23, H50.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsAwarded.CLASS.4

QualificationsAwarded.CLASS must be coded 07 - 11 where QualificationsAwarded.QUAL = I00, I11 or I16.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsAwarded.QUAL.1

QualificationsAwarded.QUAL must be coded M22, M26, M28, H00, H11, H16, H18, H22, H23, H50, I00, I11 or I16 where QualificationsAwarded.CLASS is coded 01 - 11.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsAwarded.QUAL.2

QualificationsAwarded.QUAL should not be coded M71 where Course.COURSEAIM begins H, I, J or C.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsAwarded.QUAL.3

QualificationsAwarded.QUAL should not begin H or I where Course.COURSEAIM begins J or C.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsAwarded.QUAL.4

QualificationsAwarded.QUAL must not be coded H71 or M71 where Course.TTCID = 0.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsAwarded.QUAL.5

Multiple identical occurrences of QualificationsAwarded.QUAL appear for a single Student.HUSID where QualificationsAwarded.QUAL = M22, M26, M28 or M71.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALSBJ.1

QualificationsOnEntry.QUALSBJ code 'U01' (unknown subject) used more than once so may not be counted in the tariff score.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALSBJ.2

QualificationsOnEntry.QUALSBJ must be coded 'WBA' where QualificationsOnEntry.QUALTYPE = 'WB'.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALSBJ.3

QualificationsOnEntry.QUALSBJ must be coded 'T33' where QualificationsOnEntry.QUALTYPE = IE
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALSBJ.4

QualificationsOnEntry.QUALSBJ must be coded 'B29' where QualificationsOnEntry.QUALTYPE = ID
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALTYPE.1

QualificationsOnEntry.QUALTYPE = IE must only occur once within an EntryProfile entity.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALTYPE.2

QualificationsOnEntry.QUALTYPE = WB must only occur once within an EntryProfile entity.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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 or 9U.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.1

QualificationsOnEntry.QUALYEAR should be 1951 or later where QualificationsOnEntry.QUALTYPE is A.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.10

QualificationsOnEntry.QUALYEAR should be 2005 or later where QualificationsOnEntry.QUALTYPE is WB.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.11

QualificationsOnEntry.QUALYEAR should be 2006 or later where QualificationsOnEntry.QUALTYPE is AD.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.12

QualificationsOnEntry.QUALYEAR should be 2007 or later where QualificationsOnEntry.QUALTYPE is DA.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.13

QualificationsOnEntry.QUALYEAR should be less than or equal to Instance.COMDATE year.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.2

QualificationsOnEntry.QUALYEAR should be 1986 or later where QualificationsOnEntry.QUALTYPE is SS.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.3

QualificationsOnEntry.QUALYEAR should be 1987 or later where QualificationsOnEntry.QUALTYPE is A1 or AS.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.4

QualificationsOnEntry.QUALYEAR should be 2000 or later where QualificationsOnEntry.QUALTYPE is H, HK, IK, I2, K2, K3 or K4.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.5

QualificationsOnEntry.QUALYEAR should be 2001 or later where QualificationsOnEntry.QUALTYPE is CA, or AC, FA, V1 or AH.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.6

QualificationsOnEntry.QUALYEAR should be 2002 or later where QualificationsOnEntry.QUALTYPE is AE, FM, FS or V.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.7

QualificationsOnEntry.QUALYEAR should be 2003 or later where QualificationsOnEntry.QUALTYPE is B, BE or OE (for extended diploma).
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.8

QualificationsOnEntry.QUALYEAR should be 2008 or later where QualificationsOnEntry.QUALTYPE is OC (for Certificate) or OD (for Diploma).
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALYEAR.9

QualificationsOnEntry.QUALYEAR should be 2004 or later where QualificationsOnEntry.QUALTYPE is CO.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.BIRTHDTE.1

Student.BIRTHDTE cannot be before (Y1-99)-08-01.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.BIRTHDTE.2

Student.BIRTHDTE is null. If known, please complete this data.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.BIRTHDTE.3

Student.BIRTHDTE should be less than (Y1-20)-08-01 where Course.COURSEAIM = M71 or H71.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.BIRTHDTE.4

Student.BIRTHDTE should be less than (Y1-17)-08-01 where Course.COURSEAIM = H11 or I11.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.BIRTHDTE.5

Student.BIRTHDTE should be after (Y1-70)-07-31.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.BIRTHDTE.6

Student.BIRTHDTE must be before (Y1-14)-08-01.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.BIRTHDTE.7

Student.BIRTHDTE must be before Y1-08-01
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.EntryProfile.1

EntryProfile entity must exist where the corresponding Instance.COMDATE is in the current reporting year.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.HUSID.1

Student.HUSID must not contain all zeros.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.HUSID.2

If characters 1-4 are not 0000 then chars 3-6 of Student.HUSID must be a valid INSTID plus 1000.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.HUSID.3

Student.HUSID must pass the checksum test given in the coding manual.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.SSN.1

Student.SSN must pass the checksum test given in the coding manual.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.SSN.2

Student.SSN should exist where InstancePeriod.SSELIG = '1'. Please check that Student.SSN has not been omitted in error.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.SSN.3

Student.SSN must exist where InstancePeriod.SSELIG = '1' and any associated InstancePeriod.MSTUFEE = 02, 03, 04, 52, 53 or 54.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.StudentEquality.1

The StudentEquality entity must exist where any course associated with the student is designated and Provider.SUBPURPOSE = 1 or 3.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.SURNAME.1

Student.SURNAME should begin with A to Z (case insensitive)
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.SURNAME.2

Student.SURNAME must not be a single space
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.ULN.1

Student.ULN must pass the checksum test.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.ULN.2

Student.ULN (where exists) must be unique within submitted file.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.DISABLE.1

StudentEquality.DISABLE must not exist where (no courses associated with the student are designated or Provider.SUBPURPOSE = 2)
Business RuleErrorAdded
Plain English
Disability data is only permitted where associated courses, and submission purpose, include designation.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.DISABLE.2

StudentEquality.DISABLE must exist where any course associated with the student is designated and Provider.SUBPURPOSE = 1 or 3.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.DISABLE.3

StudentEquality.DISABLE should be coded 08, 51-96 where any associated InstancePeriod.DISALL exists.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.ETHNIC.1

StudentEquality.ETHNIC must not exist where (no courses associated with the student are designated or Provider.SUBPURPOSE = 2)
Business RuleErrorAdded
Plain English
Ethnicity data is only permitted where associated courses, and submission purpose, include designation.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.ETHNIC.2

StudentEquality.ETHNIC must exist where EntryProfile.DOMICILE exists and is coded XF, XG, XH, XI, XK, XL, GG, JE, IM and any course associated with the student is designated and Provider.SUBPURPOSE = 1 or 3.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.GENDERID.1

StudentEquality.GENDERID must not exist where (no courses associated with the student are designated or Provider.SUBPURPOSE = 2)
Business RuleErrorAdded
Plain English
Gender identity data is only permitted where associated courses, and submission purpose, include designation.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.GENDERID.2

Where StudentEquality.GENDERID has been returned, all occurrences are coded 98. Please check that code 98 is not being used as an unknown value where the question has not been asked, rather than indicating that the student preferred not to answer the question
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.NATION.1

StudentEquality.NATION must exist where any course associated with the student is designated and Provider.SUBPURPOSE = 1 or 3.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.NATION.2

StudentEquality.NATION must not be coded XC or XL.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.RELBLF.1

StudentEquality.RELBLF must not exist where (no courses associated with the student are designated or Provider.SUBPURPOSE = 2)
Business RuleErrorAdded
Plain English
Religion or belief data is only permitted where associated courses, and submission purpose, include designation.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.RELBLF.2

Where StudentEquality.RELBLF has been returned, all occurrences are coded 98. Please check that code 98 is not being used as an unknown value where the question has not been asked, rather than indicating that the student preferred not to answer the question.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.SEXID.1

StudentEquality.SEXID must exist where any course associated with the student is designated and Provider.SUBPURPOSE = 1 or 3.
Business RuleErrorAdded
Plain English
Sex identifier data is required where any associated courses are designated.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.SEXORT.1

StudentEquality.SEXORT must not exist where (no courses associated with the student are designated or Provider.SUBPURPOSE = 2)
Business RuleErrorAdded
Plain English
Sexual orientation data is only permitted where associated courses, and submission purpose, include designation.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.SEXORT.2

Where StudentEquality.SEXORT has been returned, all occurrences are coded 98. Please check that code 98 is not being used as an unknown value where the question has not been asked, rather than indicating that the student preferred not to answer the question.
Business RuleWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.COURSEAIM.1

Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where Course.COURSEAIM does not end with (90 or 99) and latest InstancePeriod.MODE = 01, 23 or 24 and Instance.ENDDATE is null and the sum of all corresponding InstancePeriod.STULOAD for the Student.HUSID is greater than 125.
ExceptionWarningAdded
Plain English
There are multiple active Full time/Sandwich instances on a single student with course aim not (Credits or unspecified qualification) where total STULOAD for the student is greater than 125.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.COURSEAIM.10

Where the Instance has course designation and Course.COURSEAIM begins with C then the course(s) in the designation list provided by HEFCE should have a course aim code 28 or 900.
ExceptionWarningAdded
Plain English
For course designated students studying for course aims starting with C the aim in the designated course list should be 28 or 900.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.COURSEAIM.11

Where the Instance has course designation and any of the course(s) in the designation list provided by HEFCE have a course aim code 80 then Course.COURSEAIM must be coded I79.
ExceptionErrorAdded
Plain English
Where the aim in the designated course list is 80, the course aim submitted must be Level 5 Diploma in Teaching (I79).
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.COURSEAIM.2

Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where Course.COURSEAIM ends with (90 or 99) and latest InstancePeriod.MODE in (01, 23 or 24) and Instance.ENDDATE is blank and the sum of all corresponding InstancePeriod.STULOAD for the Student.HUSID is greater than 125.
ExceptionWarningAdded
Plain English
There are multiple active Full time/Sandwich instances on a single student with course aim of (Credits or unspecified qualification) where total STULOAD for the student is greater than 125.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.COURSEAIM.3

Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where Course.COURSEAIM does not end with (90 or 99) and latest InstancePeriod.MODE is (02, 25 or 31) and latest InstancePeriod.NOTACT does not exist and Instance.ENDDATE is blank.
ExceptionWarningAdded
Plain English
There are multiple active, Part time/Other full time/Other sandwich, instances on a single student with course aim other than (Credits or unspecified qualification).
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.COURSEAIM.5

Where the Instance has course designation and Course.COURSEAIM = H71 or M71 then the course(s) in the designation list provided by HEFCE must be at level P.
ExceptionErrorAdded
Plain English
For course designated PGCE/PGDE students the level in the designated course list must be postgraduate.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.COURSEAIM.6

Where the Instance has course designation and Course.COURSEAIM begins with M or H (excluding M71 and H71) then the course(s) in the designation list provided by HEFCE must be at level F.
ExceptionErrorAdded
Plain English
For course designated students studying for course aims starting with M or H (excluding PGCE/PGDE) the level in the designated course list must be first degree.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.COURSEAIM.7

Where the Instance has course designation and Course.COURSEAIM does not begin with M or H then the course(s) in the designation list provided by HEFCE must be at level U.
ExceptionErrorAdded
Plain English
For course designated students studying for course aims not starting with M or H the level in the designated course list must be other undergraduate.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.COURSEAIM.8

Where the Instance has course designation and Course.COURSEAIM begins with H then the course(s) in the designation list provided by HEFCE should have a course aim code between 0 and 27 (inclusive), 39, 81, 82 or 914.
ExceptionWarningAdded
Plain English
For course designated students studying for course aims starting with H the aim in the designated course list should be between 0 and 27 (inclusive), 39, 81, 82 or 914.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Course.COURSEAIM.9

Where the Instance has course designation and Course.COURSEAIM begins with J then the course(s) in the designation list provided by HEFCE should have a course aim code between 29 and 38 (inclusive).
ExceptionWarningAdded
Plain English
For course designated students studying for course aims starting with J the aim in the designated course list should be between 29 and 38 (inclusive).
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.CourseSubject.SBJCA.6

Where the course is not designated there are more than 10% of instances (and more than 10 instances) with any CourseSubject.SBJCA = Y000.
ExceptionWarningAdded
Plain English
More than 10% of instances (and more than 10) have a subject of 'Combined/ general subject unspecified' on a non-designated course.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.CourseSubject.SBJCA.8

One or more Course.SBJCA codes for a course with non-teach out designation do not exist in the Designated Course list provided by HEFCE. Please check the Course.SBJCA coding is correct.
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.CourseSubject.SBJCA.9

One or more JACS codes from the Designated Course list provided by HEFCE do not exist in Course.SBJCA codes submitted for a designated course. Please check the Course.SBJCA coding is correct.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.DOMICILE.2

More than 2% of entry profiles (and more than 5 entry profiles) have EntryProfile.DOMICILE = ZZ (Not known).
ExceptionErrorAdded
Plain English
A domicile on entry of 'not known' has been submitted for more than 2% (and more than 5) entry profiles.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.DOMICILE.6

More than 5% of entry profiles (and more than 5 entry profiles) have EntryProfile.DOMICILE = XK.
ExceptionErrorAdded
Plain English
A domicile on entry of 'United Kingdom, not otherwise specified' has been submitted for more than 5% (and more than 5) entry profiles. A more accurate country coding for the UK is required where possible.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.DOMICILE.7

More than 2% of entry profiles (and more than 5 entry profiles) have EntryProfile.DOMICILE = XK.
ExceptionWarningAdded
Plain English
A domicile on entry of 'United Kingdom, not otherwise specified' has been submitted for more than 2% (and more than 5) entry profiles. A more accurate country coding for the UK is required where possible.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.POSTCODE.4

Where EntryProfile.POSTCODE is not null it must contain a valid full postcode or a valid outward part of a postcode.
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.POSTCODE.5

More than 10 full-time, undergraduate students returned with identical non-null EntryProfile.POSTCODE.
ExceptionWarningAdded
Plain English
More than 10 Full time, undergraduate students have identical Post code on entry returned.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.POSTCODE.6

Where exists EntryProfile.POSTCODE should be located in the country of EntryProfile.DOMICILE
ExceptionWarningAdded
Plain English
Post code on entry should be located within the country returned as the student's permanent address on entry.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.PREVINST.4

There are more than 2% (and more than 5) EntryProfile.PREVINST coded as 9999 (not known).
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionErrorAdded
Plain English
Where the total tariff score is greater than 0 then the highest qualification on entry must be coded at, or above, a level which would attract a tariff.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionErrorAdded
Plain English
Where all the qualifications on entry returned do not attract a tariff score the highest qualification on entry must not be coded 'Level 3 qualifications of which some are subject to UCAS Tariff'.
Further Guidance
Please see the appendix in the specification for XTARIFF for details of the qualifications included in the tariff definitions.
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionErrorAdded
Plain English
Where any of the qualifications on entry returned attracts a tariff score, the highest qualification on entry must not be coded 'Level 3 qualifications of which none are subject to UCAS Tariff'.
Further Guidance
Please see the appendix in the specification for XTARIFF for details of the qualifications included in the tariff definitions.
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
Where any of the qualifications on entry returned is a non-tariff bearing level 3 qualification, the highest qualification on entry should not be coded 'Level 3 qualifications of which all are subject to UCAS Tariff'.
Further Guidance
Please check that all the non-tariff bearing qualifications are level 2. If any of them are level 3, please review the coding of EntryProfile.QUALENT3.
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QUALENT3.8

More than 3% of active first year Instances (and more than 5 Instances) have EntryProfile.QUALENT3 = X06.
ExceptionWarningAdded
Plain English
A highest qualification on entry of 'not known' has been returned for more than 3% (and more than 5) first year students.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QUALENT3.9

More than 10% of active non-first year Instances (and more than 10 Instances) have EntryProfile.QUALENT3 = X06.
ExceptionWarningAdded
Plain English
A highest qualification on entry of 'not known' has been returned for more than 10% (and more than 10) continuing students.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QualificationsOnEntry.10

There are more than 15% of instances (and more than 15 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) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92) with no QualificationsOnEntry entity.
ExceptionErrorAdded
Plain English
More than 15% (and more than 15) full time/sandwich instances for continuing students, aged 21 or over from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QualificationsOnEntry.11

There are more than 5% of instances (and more than 5 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) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92) with no QualificationsOnEntry entity.
ExceptionWarningAdded
Plain English
More than 5% (and more than 5) full time/sandwich instances for continuing students, aged 21 or over from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QualificationsOnEntry.3

Where EntryProfile.QualificationsOnEntry exist the total tariff score for an instance is greater than 1000 points.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QualificationsOnEntry.4

More than 5% 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) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92) with no QualificationsOnEntry entity.
ExceptionErrorAdded
Plain English
More than 5% (and more than 5) full time/sandwich instances for first year students, aged under 21 from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QualificationsOnEntry.5

More than 2% 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) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92) with no QualificationsOnEntry entity.
ExceptionWarningAdded
Plain English
More than 2% (and more than 5) full time/sandwich instances for first year students, aged under 21 from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QualificationsOnEntry.6

There are more than 10% of instances (and more than 10 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) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92) with no QualificationsOnEntry entity.
ExceptionErrorAdded
Plain English
More than 10% (and more than 10) full time/sandwich instances for first year students, aged 21 or over from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QualificationsOnEntry.7

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) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92) with no QualificationsOnEntry entity.
ExceptionWarningAdded
Plain English
More than 5% (and more than 5) full time/sandwich instances for first year students, aged 21 or over from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QualificationsOnEntry.8

More than 10% of instances (and more than 10 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) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92) with no QualificationsOnEntry entity.
ExceptionErrorAdded
Plain English
More than 10% (and more than 10) full time/sandwich instances for continuing students, aged under 21 from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.EntryProfile.QualificationsOnEntry.9

More than 5% of instances (and more than 5 instances) where Instance.COMDATE ExceptionWarningAdded
Plain English
More than 5% (and more than 5) full time/sandwich instances for continuing students, aged under 21 from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.COMDATE.6

Where the Instance is for a teach out designated course the Instance.COMDATE must be before Y1-08-01.
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.ENDDATE.4

Where a student has not been active on an instance in the current reporting period then Instance.ENDDATE must be after (Y2-6)-07-31 or must be null.
ExceptionErrorAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule moved from Business rule to Exception stage.
Previous Name of Rule
N/A

QR.C14054.Instance.HEAPESPOP.1

The course has non-teach out designation and no associated Instance (with any InstancePeriod.MODE = 01, 02, 23 or 24) has Instance.HEAPESPOP = 1.
ExceptionWarningAdded
Plain English
None of the full time instances associated with a non-teach out designated course are within the HEAPES population.
Further Guidance
N/A
Reason for Change
Rule updated to include sandwich modes and exclude legacy designated instances. Rule moved to exception stage.
Previous Name of Rule
N/A

QR.C14054.Instance.HEAPESPOP.10

More than 5% of Instances (and more than 5 Instances) where Instance.HEAPESPOP = 1 have Instance.COMDATE < Y1-08-01
ExceptionErrorAdded
Plain English
More than 5% (and more than 5) Instances starting before this reporting period are coded as being within the HEAPES population.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.HEAPESPOP.11

Where the course is designated as part time in the designated course look up file, Instance.HEAPESPOP must not be coded 1
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.HEAPESPOP.12

Where the Instance is for a teach out designated course the Instance.HEAPESPOP must be coded 2.
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.InstancePeriod.1

Where more than one InstancePeriod exists for an Instance the InstancePeriod.PERIODSTART and InstancePeriod.PERIODEND dates should define distinct time periods and not overlap.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.InstancePeriod.4

For an InstancePeriod, the InstancePeriod.PERIODSTART and InstancePeriod.PERIODEND dates must not be wholly contained within the dates of another InstancePeriod returned for the same Instance.
ExceptionErrorAdded
Plain English
The dates for an InstancePeriod must not be wholly contained within the dates of another InstancePeriod for the same Instance.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.LOCATION.2

Where Provider.SUBPURPOSE = 1 or 3 and the combination of (Provider.UKPRN and Instance.COURSEID) appear in the designated course list no Instance.LOCATION code has been returned.
ExceptionErrorAdded
Plain English
Course identifiers used for designation must not be used for non-designated courses.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Instance.RSNEND.4

QualificationsAwarded.QUAL exists on more than 20% of instances (and more than 20 instances) where Instance.RSNEND does not exist.
ExceptionErrorAdded
Plain English
More than 20% of instances (and more than 20 instances) have a qualification awarded but no reason for ending (that is, they are interim awards)
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionErrorAdded
Plain English
Where a student is in receipt of Disabled Students' Allowance the country of domicile on entry must be UK, Channel Islands or Isle of Man. Where the Entry Profile information has been submitted previously this will be included in the check.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
More than 5% (and more than 5) Instances for students with a known disability have at least one InstancePeriod with 'Information about Disabled Students' Allowance is not known/not sought'.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAmended
Plain English
A student should not be identified as on industrial placement or abroad if they are dormant for the reporting year.
Further Guidance
N/A
Reason for Change
Rule moved from Business rules to Exception stage.
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.LOCSDY.9

Where the Instance is designated and latest InstancePeriod.LOCSDY = 6 then the course(s) in the course designation file provided by HEFCE must be distance learning.
ExceptionErrorAdded
Plain English
Where a student has distance learning as the location of study on a designated course, it must be listed as a distance learning course in the designation file.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
Where the student has studied for less than 24 weeks within the year of instance and successfully completed the course, they should be coded as part-time or reduced full-time/sandwich.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MODE.7

Where the course is designated and the latest InstancePeriod.MODE = 31 then the course(s) in the designation list provided by HEFCE must be identified as part time.
ExceptionErrorAdded
Plain English
Where a student is studying part time on a designated course, it must be listed as a part time course in the designation file.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MODE.8

Where the course is designated and the latest InstancePeriod.MODE = 01, 02, 23, 24 or 25 then the course(s) in the designation list provided by HEFCE must be identified as full time.
ExceptionErrorAdded
Plain English
Where a student is studying full time or sandwich on a designated course, it must be listed as a full time course in the designation file.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
Major source of tuition fee should not be related to England, Northern Ireland or Wales where the student is domiciled in Scotland on entry.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
Major source of tuition fee should not be related to England, Scotland or Wales where the student is domiciled in Northern Ireland on entry.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
Major source of tuition fee should not be related to Northern Ireland or Scotland where the student is domiciled in England or Wales on entry.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.MSTUFEE.13

More than 2% of active Instances (and more than 5 Instances) have at least one related InstancePeriod.MSTUFEE = 99.
ExceptionWarningAdded
Plain English
More than 2% (and more than 5) Instances have at least one InstancePeriod with the major source of tuition fees not known.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.PRIPROV.5

For Information only: Counts of InstancePeriod.PRIPROV submitted
ExceptionWarningAdded
Plain English
This rule is in place to provide information on any primary provider of teaching data submitted.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.SSELIG.10

InstancePeriod.SSELIG must be coded 2 where EntryProfile.QUALENT3 (including those previously sent for the Instance) begins with C and Course.COURSEAIM begins with C. Exclude where Course.TTCID = 2.
ExceptionErrorAdded
Plain English
Students studying at level C who already have a qualification at level C are not eligible to receive student support unless the course is ITT.
Further Guidance
N/A
Reason for Change
Rule added to validate student support eligibility with ELQ.
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.SSELIG.11

InstancePeriod.SSELIG must be coded 2 where EntryProfile.QUALENT3 (including those previously sent for the Instance) begins with J (excluding JUK) and Course.COURSEAIM begins with J or C. Exclude where Course.TTCID = 2.
ExceptionErrorAdded
Plain English
Students studying at level J or C who already have a qualification at level J (apart from UK ordinary first degree) are not eligible to receive student support unless the course is ITT.
Further Guidance
N/A
Reason for Change
Rule added to validate student support eligibility with ELQ.
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.SSELIG.12

InstancePeriod.SSELIG must be coded 2 where EntryProfile.QUALENT3 (including those previously sent for the Instance) = JUK and Course.COURSEAIM begins with I, J or C. Exclude where Course.TTCID = 2.
ExceptionErrorAdded
Plain English
Students studying at level I, J or C who already have a UK ordinary first degree are not eligible to receive student support unless the course is ITT.
Further Guidance
N/A
Reason for Change
Rule added to validate student support eligibility with ELQ.
Previous Name of Rule
N/A

QR.C14054.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)
ExceptionErrorAdded
Plain English
More than 2% (and more than 5) InstancePeriods are associated with students from outside the EU coded as eligible to receive student support.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.SSELIG.3

InstancePeriod.SSELIG must be coded 2 where EntryProfile.QUALENT3 (including those previously sent for the Instance) begins with H and Course.COURSEAIM begins with I, J or C. Exclude where Course.TTCID = 2.
ExceptionErrorAdded
Plain English
Students studying at level I, J or C who already have a qualification at level H are not eligible to receive student support unless the course is ITT.
Further Guidance
N/A
Reason for Change
Rule added to validate student support eligibility with ELQ.
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.SSELIG.4

InstancePeriod.SSELIG must be coded 2 where EntryProfile.QUALENT3 (including those previously sent for the Instance) begins with H, M or D. Exclude where Course.TTCID = 2 or (Course.REGBODY = 01, 09, 10, 11, 14, 30 or 54 and Course.COURSEAIM not equal to H76, I76 or J76) or Course.COURSEAIM = M28, H78, H88, H18.
ExceptionErrorAdded
Plain English
Students who already have a qualification at level H, M or D are not eligible to receive student support unless the course being studied is ITT or leads to qualification as a social worker, medical doctor, dentist, veterinary surgeon or architect.
Further Guidance
N/A
Reason for Change
Rule added to validate student support eligibility with ELQ.
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.SSELIG.9

InstancePeriod.SSELIG should be coded 2 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = IM, XL, GG or JE.
ExceptionWarningAdded
Plain English
Where the country of domicile on entry for a student is Channel Islands or Isle of Man the student is not eligible to receive student support.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.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.
ExceptionWarningAdded
Plain English
Where the end date is in this reporting period and provision is non-contained, the student FTE is greater than or equal to 100 for over 5% (and more than 5) instances.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.STULOAD.11

For an instance the sum of all InstancePeriod.STULOAD < 100 where Course.COURSEAIM is not M71 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.
ExceptionWarningAdded
Plain English
For non-PGT full time active instances starting between 31/08/Y1 and 31/10/Y1 the student FTE reported is less than 100.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.STULOAD.12

For an instance the sum of all InstancePeriod.STULOAD < 50 where Course.COURSEAIM is not M71 and 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.
ExceptionWarningAdded
Plain English
For non-PGT full time active instances starting between 01/11/Y1 and 01/02/Y2 the student FTE reported is less than 50.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
For part time instances the student FTE reported is more than 80.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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).
ExceptionErrorAdded
Plain English
For a contained InstancePeriod, the student FTE must not exceed 5 x (no. weeks between start date and end date)
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.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).
ExceptionErrorAdded
Plain English
For first years who have not left, the student FTE must not exceed 5 x (no. weeks between start date and end of reporting year)
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.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).
ExceptionErrorAdded
Plain English
For continuers who have left in this reporting year, the student FTE must not exceed 5 x (no. weeks between start of reporting year and end date)
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.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).
ExceptionErrorAdded
Plain English
For starters who have left in this reporting year, the student FTE must not exceed 5 x (no. weeks between start date and end date)
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.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.
ExceptionWarningAdded
Plain English
Where the start date is in this reporting period and provision is non-contained, the student FTE is greater than or equal to 100 for over 5% (and more than 5) instances.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.YEARPRG.6

More than 9% of active Instances (and more than 9 Instances) have at least one related InstancePeriod.YEARPRG = 99.
ExceptionWarningAdded
Plain English
More than 9% (and more than 9) Instances have at least one InstancePeriod with the year of course undefined.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
The year of student should not be 1 if they commenced before this reporting period, have not suspended studies and the end of the InstancePeriod is after the anniversary of the commencement date plus 14 days.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
More than 5% (and more than 5) InstancePeriods contained within the reporting period, have a year of the student less than the calculated year (indicated by the difference between start date and end of the reporting period).
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.YEARSTU.4

InstancePeriod.YEARSTU is greater than 10 where the programme of study is full-time (InstancePeriod.MODE = 01 or 02).
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.InstancePeriod.YEARSTU.5

InstancePeriod.YEARSTU minus InstancePeriod.YEARPRG is greater than 2 where InstancePeriod.YEARSTU > InstancePeriod.YEARPRG.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Provider.SUBPURPOSE.4

The Provider.SUBPURPOSE returned differs from that indicated on the contract.
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Provider.UKPRN.2

UKPRN, COURSEID and LOCATION combinations exist in the designated course look up file but have no corresponding combination of Provider.UKPRN, Instance.COURSEID and Instance.LOCATION in the submitted file.
ExceptionWarningAdded
Plain English
Courses in the designated course list have not been returned in the submitted file.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsAwarded.QUAL.6

Multiple identical occurrences of QualificationsAwarded.QUAL appear for a single Student.HUSID where (first character of QualificationsAwarded.QUAL = H, I, J or C and second and third characters of QualificationsAwarded.QUAL are not 90).
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALGRADE.1

QualificationsOnEntry.QUALGRADE is invalid for the HESA tariff bearing qualification in QualificationsOnEntry.QUALTYPE.
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALGRADE.2

QualificationsOnEntry.QUALGRADE is invalid for the HESA non-tariff bearing qualification in QualificationsOnEntry.QUALTYPE.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALGRADE.3

Where Course.COURSEAIM is not M71 and Instance.COMDATE > 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.
ExceptionErrorAdded
Plain English
For full time/sandwich first degree and OUG courses started this year by students from the UK with highest qualification at level 3, more than 2% (and more than 5) of the level 3 tariff bearing qualifications on entry have no grade.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.QualificationsOnEntry.QUALGRADE.4

Where Course.COURSEAIM is not M71 and Instance.COMDATE > 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.
ExceptionWarningAdded
Plain English
For full time/sandwich first degree and OUG courses started this year by students from the UK with highest qualification at level 3, more than 1% (and more than 5) of the level 3 tariff bearing qualifications on entry have no grade.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.BIRTHDTE.10

More than 1% of active students (and more than 5 students) have a null Student.BIRTHDTE.
ExceptionWarningAdded
Plain English
More than 1% of active students (and more than 5) have no date of birth returned.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.HUSID.4

Multiple occurrences of Student.BIRTHDTE, StudentEquality.SEXID, soundex (Student.SURNAME) and soundex (Student.FNAMES), with different Student.HUSIDs.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.SSN.4

Student.SSN (where exists) must be unique within the submitted file.
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.SSN.5

No Student.SSN has been returned for more than 20% of instances (and more than 20 instances) where the course is designated and Course.COURSEAIM not (equal to M71, H60, H61, H62, I60, I61 or ends with 90 or 99) and (InstancePeriod.MODE = 01, 02, 23, 24 or 25) and InstancePeriod.SSELIG = 1.
ExceptionErrorAdded
Plain English
More than 20% (and more than 20) instances where the student is eligible to receive support, the mode is full time/sandwich and the designated course aim is not (PGT, Graduate diploma, credits or unspecified) have no associated SSN supplied.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.SSN.6

No Student.SSN has been returned for more than 80% of instances (and more than 80 instances) where the course is designated and Course.COURSEAIM not (equal to M71, H60, H61, H62, I60, I61 or ends with 90 or 99) and InstancePeriod.MODE = 31 and InstancePeriod.SSELIG = 1.
ExceptionErrorAdded
Plain English
More than 80% (and more than 80) instances where the student is eligible to receive support, the mode is part time and the designated course aim is not (PGT, Graduate diploma, credits or unspecified) have no associated SSN supplied.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.Student.SSN.7

Where the course is designated and, for a student, all InstancePeriod.SSELIG = 2 more than 10% of students (and more than 10 students) have Student.SSN returned.
ExceptionErrorAdded
Plain English
More than 10% (and more than 10) students on designated courses and not eligible to receive student support have a Student Support Number returned.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.DISABLE.4

More than 10% of students (and more than 10 students) have StudentEquality.DISABLE = 00 where InstancePeriod.DISALL exists.
ExceptionErrorAdded
Plain English
More than 10% (and more than 10) students with (DSA) Disabled Students' Allowance data have no known disability.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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, IM and the associated instance is designated and Provider.SUBPURPOSE = 1 or 3.
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.ETHNIC.6

More than 2% of active students (and more than 5 students) who were home domiciled on entry have StudentEquality.ETHNIC = 98.
ExceptionWarningAdded
Plain English
More than 2% (and more than 5) students returned with UK domicile on entry, have an ethnicity of 'information refused'.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.StudentEquality.ETHNIC.7

More than 2% of active students (and more than 5 students) who were home domiciled on entry have StudentEquality.ETHNIC = 90.
ExceptionWarningAdded
Plain English
More than 2% (and more than 5) students returned with UK domicile on entry, have an ethnicity of 'not known'.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
More than 5% (and more than 5) students are coded as female and gay man. Please check that there are no systemic errors causing this field to be returned incorrectly.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C14054.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.
ExceptionWarningAdded
Plain English
More than 5% (and more than 5) students are coded as male and gay woman/lesbian. Please check that there are no systemic errors causing this field to be returned incorrectly.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A