Skip to main content

Quality Rules Directory for C15054

Download all the C15054 rules

Filter

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

QR.C15054.Student.SSN.1

Student.SSN 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.C14054.Student.SSN.1

QR.C15054.Student.SSN.3

Student.SSN must exist where any associated InstancePeriod.MSTUFEE = 02, 03, 04, 52, 53 or 54.
Business RuleErrorAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule updated to remove InstancePeriod.SSELIG criteria.
Previous Name of Rule
QR.C14054.Student.SSN.3

QR.C15054.Student.SSN.4

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

QR.C15054.Student.SSN.5

No Student.SSN has been returned for more than 20% of instances (and more than 20 instances) where the latest Instance Period is for a designated course and Course.COURSEAIM not (equal to M71, H60, H61, H62, I60, I61 or ends with 90 or 99) and, for the latest Instance Period, ((InstancePeriod.MODE = 01, 02, 23, 24 or 25) and InstancePeriod.SSELIG = 1).
ExceptionErrorAmended
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
Rule updated to refer to designation of latest Instance Period.
Previous Name of Rule
QR.C14054.Student.SSN.5

QR.C15054.Student.SSN.6

No Student.SSN has been returned for more than 80% of instances (and more than 80 instances) where the latest Instance Period is for a designated course and Course.COURSEAIM not (equal to M71, H60, H61, H62, I60, I61 or ends with 90 or 99) and, for the latest Instance Period, (InstancePeriod.MODE = 31 and InstancePeriod.SSELIG = 1).
ExceptionErrorAmended
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
Rule updated to refer to designation of latest Instance Period.
Previous Name of Rule
QR.C14054.Student.SSN.6

QR.C15054.Student.SSN.8

Where a Year on Year link has been made to the Continuity Register, the associated Student.SSN has changed from exists to not exists [exclude where (all incoming Course.COURSEAIMs for the Instance end with 90 or 99) or (incoming XINACT01 = 1)].
ContinuityWarningAdded
Plain English
A matching record has been found on the Continuity Register and where the Student Support number has changed from exists to not exists (exclude where the course leads to credits or an unspecified aim or where the student is dormant for the year)
Further Guidance
A year on year link has been made between the record sent in the latest file and that returned in the previous reporting period (linked via Provider.UKPRN, Student.HUSID and Instance.NUMHUS). Data between this year and last is inconsistent and must be checked and corrected where applicable. Data which is correct in the current submission should be retained.
Reason for Change
Rule added to ensure consistency between reporting years
Previous Name of Rule
QR.C14054.Student.SSN.8

QR.C15054.Student.SSN.2

Student.SSN should exist where InstancePeriod.SSELIG = '1'. Please check that Student.SSN has not been omitted in error.
Business RuleWarningDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule removed as existence of SSN is not dependant on SSELIG.
Previous Name of Rule
QR.C14054.Student.SSN.2

QR.C15054.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.
ExceptionErrorDeleted
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
Rule removed as return of SSN is permitted where student is not eligible to receive student support.
Previous Name of Rule
QR.C14054.Student.SSN.7