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.EntryProfile.UCASAPPID.1

EntryProfile.UCASAPPID must pass the checksum test as applied to Student.HUSID where it is nine characters long and (digits 1-8 are not in ranges 06000999 to 06009996 inclusive or 06690999 to 06692257 inclusive).
Business RuleErrorCarried Forward
Show more
Plain English
The UCAS Application Identifier returned does not pass the checksum. The calculation for the checksum is specified in the coding manual.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.EntryProfile.UCASAPPID.1

QR.C15051.EntryProfile.UCASAPPID.2

Where EntryProfile.UCASAPPID digits 1-8 are in ranges (06000999 to 06009996 inclusive or 06690999 to 06692257 inclusive), this field must pass either the checksum test as applied to Student.HUSID or the 'incorrectly calculated checksum' test, details of which are in the student circular: http://www.hesa.ac.uk/circulars/student/2006/06_04.html.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.EntryProfile.UCASAPPID.2

QR.C15051.Student.HUSID.1

Student.HUSID must not contain all zeros.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.HUSID.1

QR.C15051.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 RuleErrorCarried Forward
Show more
Plain English
The Student.HUSID returned contains an invalid set of digits in positions 3-6. The characters in positions 3-6 must be a valid institution identifier + 1000.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.HUSID.2

QR.C15051.Student.HUSID.3

Student.HUSID must pass the checksum test given in the coding manual.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.HUSID.3

QR.C15051.Student.HUSID.4

If characters 1-4 of Student.HUSID are not 0000 then characters 3-6 of Student.HUSID must not be 3001 when Instance.COMDATE is after 2007-07-31 (INSTID 2001 is invalid).
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.HUSID.4

QR.C15051.Course.COURSEAIM.10

Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where (first character of Course.COURSEAIM = D, E, L, M, H, I, J or C and second and third characters of Course.COURSEAIM are not 90 or 99) and Instance.MODE = 01, 23 or 24 and Instance.ENDDATE is blank and the sum of all Instance.STULOAD for the Student.HUSID is greater than 125.0.
ExceptionErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Course.COURSEAIM.10

QR.C15051.Course.COURSEAIM.11

Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where Course.COURSEAIM in (C90, H90, I90, J90, D90, E90, L90, M90, C99, H99, I99, J99, L99, M99) and Instance.MODE in (01, 23 or 24) and Instance.ENDDATE is blank and the sum of all Instance.STULOAD for the Student.HUSID is greater than 125.0.
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Course.COURSEAIM.11

QR.C15051.Course.COURSEAIM.12

Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where (first character of Course.COURSEAIM = D, E, L, M, H, I, J or C and second and third characters of Course.COURSEAIM are not 90 or 99) and Instance.MODE not in (01, 23, 24, 63, 64) and Instance.ENDDATE is blank.
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Course.COURSEAIM.12

QR.C15051.Course.COURSEAIM.13

For institutions in England, there must not be more than 3 instances for a single Student.HUSID where Course.COURSEAIM begins D, E, L or M (excluding M22, M26 and M28).
ExceptionErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Course.COURSEAIM.13

QR.C15051.Instance.PLANEEPHOURS.4

When a Student.HUSID has more than one instance where Instance.PLANEEPHOURS exists, all occurrences of Instance.PLANEEPHOURS must be identical.
ExceptionErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Instance.PLANEEPHOURS.4

QR.C15051.Instance.PLANLEARNHOURS.4

When a Student.HUSID has more than one instance where Instance.PLANLEARNHOURS exists, all occurrences of Instance.PLANLEARNHOURS must be identical.
ExceptionErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Instance.PLANLEARNHOURS.4

QR.C15051.QualificationsAwarded.QUAL.12

Multiple identical occurrences of QualificationsAwarded.QUAL appear for a single Student.HUSID where (first character of QualificationsAwarded.QUAL = D, E, L, M, and second and third characters of QualificationsAwarded.QUAL are not 90).
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.QualificationsAwarded.QUAL.12

QR.C15051.QualificationsAwarded.QUAL.13

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).
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.QualificationsAwarded.QUAL.13

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
Show more
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.HUSID.6

Multiple occurrences of Student.BIRTHDTE, Student.SEXID, soundex (Student.SURNAME) and soundex (Student.FNAMES), with different Student.HUSIDs.
ExceptionWarningCarried Forward
Show more
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.SSN.3

The same Student.SSN must not be returned for more than one Student.HUSID as Student.SSN is unique to a student.
ExceptionErrorAdded
Show more
Plain English
A student support number (SSN) must not be returned for more than one student as SSN is unique.
Further Guidance
As a student must not have more than one HUSID there must not be multiple students with the same SSN.
Reason for Change
Rule added to mirror previous validation prior to the SSN field moving from Instance to the Student entity.
Previous Name of Rule
N/A

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
Show more
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.C15051.Instance.NUMHUS.1

All Instance.NUMHUS for a Student.HUSID must be unique.
Business RuleErrorDeleted
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as this validation is now a schema check.
Previous Name of Rule
QR.C14051.Instance.NUMHUS.1

QR.C15051.Instance.NUMHUS.2

All Instance.NUMHUS for a Student.HUSID must be unique.
ExceptionErrorDeleted
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as this validation is now a schema check.
Previous Name of Rule
QR.C14051.Instance.NUMHUS.2

QR.C15051.Instance.SSN.5

The same Instance.SSN must not be returned for more than one Student.HUSID as Instance.SSN is unique to a person. The same person should not have more than one HUSID
ExceptionErrorDeleted
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as SSN field has moved from the Instance to the Student entity.
Previous Name of Rule
QR.C14051.Instance.SSN.5

QR.C15051.Instance.SSN.6

For a single Student.HUSID the same Instance.SSN has been returned for more than one instance. Please check that the student support genuinely applies to all the instances.
ExceptionWarningDeleted
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as SSN field has moved from the Instance to the Student entity.
Previous Name of Rule
QR.C14051.Instance.SSN.6

QR.C15051.Instance.SSN.7

A Student.HUSID has more than one instance where Instance.SSN exists and not all of the occurrences of Instance.SSN are identical. Please check it is correct for the student to have more than one SSN.
ExceptionWarningDeleted
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as SSN field has moved from the Instance to the Student entity.
Previous Name of Rule
QR.C14051.Instance.SSN.7

QR.C15051.Student.HUSID.5

Student.HUSID must be unique within an institutions return (i.e. all student entity data for the given HUSID must be consistent).
ExceptionErrorDeleted
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as this validation is now a schema check.
Previous Name of Rule
QR.C14051.Student.HUSID.5