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.Student.HUSID.1

Student.HUSID must not contain all zeros.
Business RuleErrorCarried Forward
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
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
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
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14051.Student.HUSID.4

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.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.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
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