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

There are more than 30 occurrences of QualificationsOnEntry for an Entry Profile.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.1

QR.C15054.QualificationsOnEntry.QUALSBJ.1

QualificationsOnEntry.QUALSBJ code 'U01' (unknown subject) used more than once so may not be counted in the tariff score.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALSBJ.1

QR.C15054.QualificationsOnEntry.QUALSBJ.2

QualificationsOnEntry.QUALSBJ must be coded 'WBA' where QualificationsOnEntry.QUALTYPE = 'WB'.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALSBJ.2

QR.C15054.QualificationsOnEntry.QUALSBJ.3

QualificationsOnEntry.QUALSBJ must be coded 'T33' where QualificationsOnEntry.QUALTYPE = IE
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALSBJ.3

QR.C15054.QualificationsOnEntry.QUALSBJ.4

QualificationsOnEntry.QUALSBJ must be coded 'B29' where QualificationsOnEntry.QUALTYPE = ID
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALSBJ.4

QR.C15054.QualificationsOnEntry.QUALTYPE.1

QualificationsOnEntry.QUALTYPE = IE must only occur once within an EntryProfile entity.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALTYPE.1

QR.C15054.QualificationsOnEntry.QUALTYPE.2

QualificationsOnEntry.QUALTYPE = WB must only occur once within an EntryProfile entity.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALTYPE.2

QR.C15054.QualificationsOnEntry.QUALTYPE.3

Where Instance.COMDATE > Y1-07-31 and EntryProfile.QUALENT3 = P50, there should be at least one occurrence of QualificationsOnEntry.QUALTYPE = A, AD, AN, AS, A1, DA, V, V1, V2 or 9U.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALTYPE.3

QR.C15054.QualificationsOnEntry.QUALYEAR.1

QualificationsOnEntry.QUALYEAR should be 1951 or later where QualificationsOnEntry.QUALTYPE is A.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.1

QR.C15054.QualificationsOnEntry.QUALYEAR.10

QualificationsOnEntry.QUALYEAR should be 2005 or later where QualificationsOnEntry.QUALTYPE is WB.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.10

QR.C15054.QualificationsOnEntry.QUALYEAR.11

QualificationsOnEntry.QUALYEAR should be 2006 or later where QualificationsOnEntry.QUALTYPE is AD.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.11

QR.C15054.QualificationsOnEntry.QUALYEAR.12

QualificationsOnEntry.QUALYEAR should be 2007 or later where QualificationsOnEntry.QUALTYPE is DA.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.12

QR.C15054.QualificationsOnEntry.QUALYEAR.13

QualificationsOnEntry.QUALYEAR should be less than or equal to Instance.COMDATE year.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.13

QR.C15054.QualificationsOnEntry.QUALYEAR.14

Where Student.BIRTHDTE is not null and QualificationsOnEntry.QUALTYPE not coded M6, M7, M8, 6M, 7M or 8M, QualificationsOnEntry.QUALYEAR must 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.C14054.QualificationsOnEntry.QUALYEAR.14

QR.C15054.QualificationsOnEntry.QUALYEAR.15

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.C14054.QualificationsOnEntry.QUALYEAR.15

QR.C15054.QualificationsOnEntry.QUALYEAR.16

Where Student.BIRTHDTE is not null more than 10 students ( Student.HUSID ) have at least one QualificationsOnEntry.QUALYEAR (for QualificationsOnEntry.QUALTYPE other than M6, M7, M8, 6M, 7M, 8M or SS) less than (Student.BIRTHDTE + 16) year.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.16

QR.C15054.QualificationsOnEntry.QUALYEAR.2

QualificationsOnEntry.QUALYEAR should be 1986 or later where QualificationsOnEntry.QUALTYPE is SS.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.2

QR.C15054.QualificationsOnEntry.QUALYEAR.3

QualificationsOnEntry.QUALYEAR should be 1987 or later where QualificationsOnEntry.QUALTYPE is A1 or AS.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.3

QR.C15054.QualificationsOnEntry.QUALYEAR.4

QualificationsOnEntry.QUALYEAR should be 2000 or later where QualificationsOnEntry.QUALTYPE is H, HK, IK, I2, K2, K3 or K4.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.4

QR.C15054.QualificationsOnEntry.QUALYEAR.5

QualificationsOnEntry.QUALYEAR should be 2001 or later where QualificationsOnEntry.QUALTYPE is CA, or AC, FA, V1 or AH.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.5

QR.C15054.QualificationsOnEntry.QUALYEAR.6

QualificationsOnEntry.QUALYEAR should be 2002 or later where QualificationsOnEntry.QUALTYPE is AE, FM, FS or V.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.6

QR.C15054.QualificationsOnEntry.QUALYEAR.7

QualificationsOnEntry.QUALYEAR should be 2003 or later where QualificationsOnEntry.QUALTYPE is B, BE or OE (for extended diploma).
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.7

QR.C15054.QualificationsOnEntry.QUALYEAR.8

QualificationsOnEntry.QUALYEAR should be 2008 or later where QualificationsOnEntry.QUALTYPE is OC (for Certificate) or OD (for Diploma).
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.8

QR.C15054.QualificationsOnEntry.QUALYEAR.9

QualificationsOnEntry.QUALYEAR should be 2004 or later where QualificationsOnEntry.QUALTYPE is CO.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALYEAR.9

QR.C15054.QualificationsOnEntry.QUALGRADE.2

QualificationsOnEntry.QUALGRADE is invalid for the HESA non-tariff bearing qualification in QualificationsOnEntry.QUALTYPE.
Business RuleWarningAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule display updated to show latest InstancePeriod.COURSEID.
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALGRADE.2

QR.C15054.QualificationsOnEntry.QUALGRADE.3

Where Course.COURSEAIM is not M71 and Instance.COMDATE > Y1-07-31 and latest InstancePeriod.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 begins with P or is equal to X00 or X01), then, across the submission, more than 2% of QualificationsOnEntry records (and more than 5 records) for level 3 tariff bearing qualifications have no QualificationsOnEntry.QUALGRADE.
Business RuleErrorAmended
Plain English
For full time/sandwich first degree and OUG courses started this year by students from the UK with highest qualification at level 3, more than 2% (and more than 5) of the level 3 tariff bearing qualifications on entry have no grade.
Further Guidance
N/A
Reason for Change
Rule display updated to show latest InstancePeriod.COURSEID.
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALGRADE.3

QR.C15054.QualificationsOnEntry.QUALGRADE.4

Where Course.COURSEAIM is not M71 and Instance.COMDATE > Y1-07-31 and any InstancePeriod.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and (EntryProfile.QUALENT3 begins with P or is equal to X00 or X01), then, across the submission, more than 1% of QualificationsOnEntry records (and more than 5 records) for level 3 tariff bearing qualifications have no QualificationsOnEntry.QUALGRADE.
ExceptionWarningAmended
Plain English
For full time/sandwich first degree and OUG courses started this year by students from the UK with highest qualification at level 3, more than 1% (and more than 5) of the level 3 tariff bearing qualifications on entry have no grade.
Further Guidance
In this context, tariff bearing is a qualification (QUALTYPE) that exists in the look-up table for calculating XTARIFF with tariff status = 1. Base population is all QualificationsOnEntry records for tariff bearing qualifications where the associated instance has (Course.COURSEAIM not equal to M71) and any (InstancePeriod.MODE = 01, 23 or 24) and (Instance.COMDATE>Y1-07-31) and in the associated entry profile record (EntryProfile = XK, XF, XI, XH or XG) and (EntryProfile.QUALENT3 begins with P or equal to X00 or X01).Trigger rule if QUALGRADE does not exist on more than 1% of these (and more than 5). The calculation is based on the number of QualificationsOnEntry entities across all instances/entry profiles in the base population and not the count of instances/entry profiles.The course must be that associated with the Qualifications on Entry entity - the link from EntryProfile/QualificationsOnEntry to Instance/InstancePeriod is via HUSID and NUMHUS.Do not trigger if QualificationsOnEntry.QUALGRADE.3 has triggered.
Reason for Change
Rule display updated to show latest InstancePeriod.COURSEID.
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALGRADE.4

QR.C15054.QualificationsOnEntry.QUALGRADE.1

QualificationsOnEntry.QUALGRADE is invalid for the HESA tariff bearing qualification in QualificationsOnEntry.QUALTYPE.
ExceptionErrorAmended
Plain English
N/A
Further Guidance
Use the look-up table created from Appendix 1 of the XTARIFF derived field specification.Do not trigger where QUALGRADE does not exist. The course shown must be that associated with the Qualifications on Entry entity - the link from EntryProfile/QualificationsOnEntry to Instance/InstancePeriod is via HUSID and NUMHUS.
Reason for Change
Rule display updated to show latest InstancePeriod.COURSEID.
Previous Name of Rule
QR.C14054.QualificationsOnEntry.QUALGRADE.1

QR.C15054.EntryProfile.QualificationsOnEntry.10

There are more than 10% of instances (and more than 10 instances) where Instance.COMDATE < Y1-08-01 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and latest InstancePeriod.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92 and P80) with no QualificationsOnEntry entity.
Business RuleErrorAmended
Plain English
More than 10% (and more than 10) full time/sandwich instances for continuing students, aged 21 or over from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
Rule updated to amend tolerance and the number of instances, and to exclude P80 from the population
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.10

QR.C15054.EntryProfile.QualificationsOnEntry.14

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.
Business RuleErrorAdded
Plain English
More than 5% (and more than 5) instances where students are under 21 years old with a UK nationality have a highest qualification on entry returned as 'Other qualification at level 3'.
Further Guidance
N/A
Reason for Change
Rule added for when students are under 21 and have their highest qualification on entry returned as 'Other qualification at level 3'
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.14

QR.C15054.EntryProfile.QualificationsOnEntry.15

More than 15% of instances (and more than 15 instances) where Student.BIRTHDTE earlier than (Y1-21)-09-01 and StudentEquality.NATION = GB have EntryProfile.QUALENT3 = P80.
Business RuleErrorAdded
Plain English
More than 15% (and more than 15) instances where students are 21 years old and over with a UK nationality have a highest qualification on entry returned as 'Other qualification at level 3'.
Further Guidance
N/A
Reason for Change
Rule added for when students are 21 and over and have their highest qualification on entry returned as 'Other qualification at level 3'
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.15

QR.C15054.EntryProfile.QualificationsOnEntry.2

There are multiple identical qualifications on entry for an entry profile. That is, the combination of QualificationsOnEntry.QUALTYPE, QualificationsOnEntry.QUALSBJ, QualificationsOnEntry.QUALGRADE, QualificationsOnEntry.QUALYEAR and QualificationsOnEntry.QUALSIT all occur more than once.
Business RuleErrorAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Display updated to show latest InstancePeriod.COURSEID.
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.2

QR.C15054.EntryProfile.QualificationsOnEntry.3

Where EntryProfile.QualificationsOnEntry exist the total tariff score for an instance is greater than 1000 points.
ExceptionWarningAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Display updated to show latest InstancePeriod.COURSEID.
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.3

QR.C15054.EntryProfile.QualificationsOnEntry.4

More than 3% of instances (and more than 5 instances) where Instance.COMDATE > Y1-07-31 and Student.BIRTHDTE later than (Y1-21)-08-31 and latest InstancePeriod.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92 and P80) with no QualificationsOnEntry entity.
Business RuleErrorAmended
Plain English
More than 3% (and more than 5) full time/sandwich instances for first year students, aged under 21 from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
Rule updated to amend tolerance and to exclude P80 from the population
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.4

QR.C15054.EntryProfile.QualificationsOnEntry.6

There are more than 5% of instances (and more than 5 instances) where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and latest InstancePeriod.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92 and P80) with no QualificationsOnEntry entity.
Business RuleErrorAmended
Plain English
More than 5% (and more than 5) full time/sandwich instances for first year students, aged 21 or over from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
Rule updated to amend tolerance and number of instances, and to exclude P80 from the population
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.6

QR.C15054.EntryProfile.QualificationsOnEntry.8

More than 5% of instances (and more than 5 instances) where Instance.COMDATE < Y1-08-01 and Student.BIRTHDTE later than (Y1-21)-08-31 and latest InstancePeriod.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92 and P80) with no QualificationsOnEntry entity
Business RuleErrorAmended
Plain English
More than 5% (and more than 5) full time/sandwich instances for continuing students, aged under 21 from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
Rule updated to amend tolerance and the number of instances, and to exclude P80 from the population
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.8

QR.C15054.EntryProfile.QualificationsOnEntry.11

There are more than 5% of instances (and more than 5 instances) where Instance.COMDATE < Y1-08-01 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and latest InstancePeriod.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92) with no QualificationsOnEntry entity.
ExceptionWarningDeleted
Plain English
More than 5% (and more than 5) full time/sandwich instances for continuing students, aged 21 or over from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
Warning now redundant as covered by QR.C15054.EntryProfile.QualificationsOnEntry.10
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.11

QR.C15054.EntryProfile.QualificationsOnEntry.5

More than 2% of instances (and more than 5 instances) where Instance.COMDATE > Y1-07-31 and Student.BIRTHDTE later than (Y1-21)-08-31 and latest InstancePeriod.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92) with no QualificationsOnEntry entity.
ExceptionWarningDeleted
Plain English
More than 2% (and more than 5) full time/sandwich instances for first year students, aged under 21 from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
Warning now redundant as covered by QR.C15054.EntryProfile.QualificationsOnEntry.4
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.5

QR.C15054.EntryProfile.QualificationsOnEntry.7

There are more than 5% of instances (and more than 5 instances) where Instance.COMDATE > Y1-07-31 and (Student.BIRTHDTE is null or earlier than (Y1-21)-09-01) and latest InstancePeriod.MODE is in (01, 23, 24) and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and EntryProfile.QUALENT3 begins with P (excluding P92) with no QualificationsOnEntry entity.
ExceptionWarningDeleted
Plain English
More than 5% (and more than 5) full time/sandwich instances for first year students, aged 21 or over from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
Warning now redundant as covered by QR.C15054.EntryProfile.QualificationsOnEntry.6
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.7

QR.C15054.EntryProfile.QualificationsOnEntry.9

More than 5% of instances (and more than 5 instances) where Instance.COMDATE ExceptionWarningDeleted
Plain English
More than 5% (and more than 5) full time/sandwich instances for continuing students, aged under 21 from the UK, with highest qualification on entry at level 3 have no qualifications on entry submitted.
Further Guidance
N/A
Reason for Change
Warning now redundant as covered by QR.C15054.EntryProfile.QualificationsOnEntry.8
Previous Name of Rule
QR.C14054.EntryProfile.QualificationsOnEntry.9