Quality Rules Directory for C15051
Filter
QR.C15051.Student.HUSID.1
Student.HUSID must not contain all zeros.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.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.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).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.Student.HUSID.6
Multiple occurrences of Student.BIRTHDTE, Student.SEXID, soundex (Student.SURNAME) and soundex (Student.FNAMES), with different Student.HUSIDs.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.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).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.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).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