Skip to main content

Quality Rules Directory for C15051

Download all the C15051 rules

Filter

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

QR.C15051.QualificationsOnEntry.QUALYEAR.19

Where Student.BIRTHDTE is not null and QualificationsOnEntry.QUALTYPE not coded M6, M7, M8, 6M, 7M or 8M, QualificationsOnEntry.QUALYEAR should be greater than (Student.BIRTHDTE + 13) years.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.QualificationsOnEntry.QUALYEAR.19

QR.C15051.QualificationsOnEntry.QUALYEAR.20

For institutions in England, Northern Ireland and Wales, 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 RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.QualificationsOnEntry.QUALYEAR.20

QR.C15051.Student.BIRTHDTE.1

Where exists Student.BIRTHDTE cannot be before (Y1-99)-08-01.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.BIRTHDTE.1

QR.C15051.Student.BIRTHDTE.2

Where exists Student.BIRTHDTE must be < Y1-08-01
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.BIRTHDTE.2

QR.C15051.Student.BIRTHDTE.3

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

QR.C15051.Student.BIRTHDTE.4

Where exists Student.BIRTHDTE should be earlier than (Y1-17)-08-01 where Course.COURSEAIM = H11, H12, I11 or I12.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.BIRTHDTE.4

QR.C15051.Student.BIRTHDTE.6

Where exists Student.BIRTHDTE must be less than (Y1-14)-08-01.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.BIRTHDTE.6

QR.C15051.EntryProfile.QualificationsOnEntry.13

More than 5% of instances (and more than 5 instances) where Student.BIRTHDTE later than (Y1-21)-08-31 and StudentEquality.NATION = GB have EntryProfile.QUALENT3 = P80.
ExceptionErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule added to prevent young UK students being coded with 'other level 3' highest qualification on entry.
Previous Name of Rule
N/A

QR.C15051.EntryProfile.QualificationsOnEntry.2

Where the provider is in England there are more than 5% of instances where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P41, P42, P46, P47, P50, P51, P53, P54, P62, P63, P64, P65, P68, P93 or P94) with no QualificationsOnEntry entity.
ExceptionWarningAmended
Plain English
More than 5% of full-time entrants aged 21 or over domiciled in the UK have been reported as having a level 3 qualification as their highest qualification on entry but no detail of the qualifications has been returned.
Further Guidance
N/A
Reason for Change
Rule amended to include EntryProfile.QUALENT3 code P53 and removing P80 in the restrictions
Previous Name of Rule
QR.C14051.EntryProfile.QualificationsOnEntry.2

QR.C15051.EntryProfile.QualificationsOnEntry.6

More than 5% of instances where Instance.COMDATE > Y1-07-31 and Student.BIRTHDTE later than (Y1-21)-08-31 and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P41, P42, P46, P47, P50, P51, P53, P54, P62, P63, P64, P65, P68, P93 or P94) with no QualificationsOnEntry entity.
ExceptionErrorAmended
Plain English
More than 5% of young full-time entrants domiciled in the UK have been reported as having a level 3 qualification as their highest qualification on entry but no detail of the qualifications has been returned.
Further Guidance
N/A
Reason for Change
Rule updated to remove P80 from the list of QUALENT3 codes and add P53
Previous Name of Rule
QR.C14051.EntryProfile.QualificationsOnEntry.6

QR.C15051.EntryProfile.QualificationsOnEntry.7

Where the provider is in Northern Ireland, Scotland or Wales there are more than 10% of instances where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P41, P42, P46, P47, P50, P51, P53, P54, P62, P63, P64, P65, P68, P93 or P94) with no QualificationsOnEntry entity.
ExceptionWarningAmended
Plain English
More than 10% of full-time entrants aged 21 or over domiciled in the UK have been reported as having a level 3 qualification as their highest qualification on entry but no detail of the qualifications has been returned.
Further Guidance
N/A
Reason for Change
Rule updated to remove P80 from the list of QUALENT3 codes and add P53
Previous Name of Rule
QR.C14051.EntryProfile.QualificationsOnEntry.7

QR.C15051.EntryProfile.QualificationsOnEntry.8

Where the provider is in England more than 2% of instances where Instance.COMDATE > Y1-07-31 and Student.BIRTHDTE later than (Y1-21)-08-31 and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P41, P42, P46, P47, P50, P51, P53, P54, P62, P63, P64, P65, P68, P93 or P94) with no QualificationsOnEntry entity.
ExceptionWarningAmended
Plain English
More than 2% of young full-time entrants domiciled in the UK have been reported as having a level 3 qualification as their highest qualification on entry but no detail of the qualifications has been returned.
Further Guidance
N/A
Reason for Change
Rule amended to include EntryProfile.QUALENT3 code P53 and removing P80 in the restrictions
Previous Name of Rule
QR.C14051.EntryProfile.QualificationsOnEntry.8

QR.C15051.EntryProfile.QualificationsOnEntry.9

Where the provider is in England there are more than 10% of instances where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and Instance.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 is coded P41, P42, P46, P47, P50, P51, P53, P54, P62, P63, P64, P65, P68, P93 or P94) with no QualificationsOnEntry entity.
ExceptionErrorAmended
Plain English
More than 10% of full-time entrants aged 21 or over (or who have an unknown date of birth) domiciled in the UK have been reported as having a level 3 qualification as their highest qualification on entry but no detail of the qualifications has been returned.
Further Guidance
N/A
Reason for Change
Rule updated to align with the coverage by including EntryProfile.QUALENT3 code 'P53' and removing 'P80' in the restriction.
Previous Name of Rule
QR.C14051.EntryProfile.QualificationsOnEntry.9

QR.C15051.QualificationsOnEntry.QUALYEAR.28

For providers in England, Northern Ireland and Wales, where Student.BIRTHDTE is not null and more than 10 students ( Student.HUSID ) where at least one QualificationsOnEntry.QUALYEAR for QualificationsOnEntry.QUALTYPE other than F1, F2, K1, K2, M6, M7, M8, 6M, 7M, 8M or SS is not greater than (Student.BIRTHDTE + 15) year.
ExceptionErrorAmended
Plain English
More than 10 students have been reported as having gained a qualification at the age of 15 or below. It is not expected that these qualifications would be awarded to students of this age.
Further Guidance
N/A
Reason for Change
Rule updated to include QUALTYPE codes F1, F2, K1 and K2 to the list of excluded codes from the age check
Previous Name of Rule
QR.C14051.QualificationsOnEntry.QUALYEAR.28

QR.C15051.Student.BIRTHDTE.12

Student.BIRTHDTE is not known (null value) for more than 1% of instances in the HE standard registration population.
ExceptionWarningAdded
Plain English
Date of birth is not known for a higher than expected number of students.
Further Guidance
N/A
Reason for Change
Rule added to replace the monitoring of unknown values in checkdoc.
Previous Name of Rule
N/A

QR.C15051.Student.BIRTHDTE.9

Student.BIRTHDTE is unknown (null), but has a known value in the UCAS (*J) data. It is expected that a known value in the UCAS data will be passed through to the HESA return.
ExceptionWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.BIRTHDTE.9

QR.C15051.Student.HUSID.6

Multiple occurrences of Student.BIRTHDTE, Student.SEXID, soundex (Student.SURNAME) and soundex (Student.FNAMES), with different Student.HUSIDs.
ExceptionWarningCarried Forward
Plain English
There are multiple records returned with matching personal information but different Student.HUSIDs. An individual student should not have multiple HESA Unique Student Identifiers.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.HUSID.6

QR.C15051.Student.BIRTHDTE.10

Where a year-on-year link has been made to the Continuity Register, when Student.BIRTHDTE changed from known to unknown value.
ContinuityErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.BIRTHDTE.10

QR.C15051.Student.BIRTHDTE.11

Where a year-on-year link has been made to the Continuity Register, Student.BIRTHDTE differs (exclude unknown (9999-12-31 or null) to known value changes. Exclude records identified in QR.Cyy051.Student.BIRTHDTE.10
ContinuityWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.BIRTHDTE.11

QR.C15051.Student.HUSID.7

Where a year-on-year link has been made to the Continuity Register and (Student name differs from NAMECAT (Concatenation of Student.SURNAME and Student.FNAMES)) and (where BIRTHDTE exists it differs from Student.BIRTHDTE) and (where GENDER = 1 or 2 and Student.SEXID = 1 or 2, GENDER differs from Student.SEXID) and (where SEXID exists it differs from Student.SEXID).
ContinuityWarningCarried Forward
Plain English
The personal information submitted for a student does not match the previously sent information for this Student.HUSID. HESA Unique Student Identifiers must be unique to the student and not reused.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.HUSID.7

QR.C14051.Instance.SSN.10

Where Instance.SSN links to the data supplied by the SLC, Student.BIRTHDTE is not equal to the date of birth held by the SLC. Please check that the date of birth in the HESA return is correct.
ExceptionWarningDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted because a link to the SLC data will not be performed for C14051.
Previous Name of Rule
C14051.Instance.SSN.Exception.6

QR.C14051.Student.BIRTHDTE.7

Student.BIRTHDTE must not be null except when ReasonForNull = 1.
Business RuleErrorDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as the ReasonForNull attribute for this field has been removed from the coding frame.
Previous Name of Rule
C14051.Student.BIRTHDTE.Business Rule.8

QR.C14051.Student.BIRTHDTE.8

Student.BIRTHDTE must be null when ReasonForNull = 1.
Business RuleErrorDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as the ReasonForNull attribute for this field has been removed from the coding frame.
Previous Name of Rule
C14051.Student.BIRTHDTE.Business Rule.9

QR.C15051.Student.BIRTHDTE.5

Where exists Student.BIRTHDTE should be greater than (Y1-70)-07-31.
Business RuleWarningDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as this check will be covered by a new credibility report showing a breakdown of the student population by age ranges.
Previous Name of Rule
QR.C14051.Student.BIRTHDTE.5