Quality Rules Directory for C15054
Filter
QR.C15054.EntryProfile.QualificationsOnEntry.1
There are more than 30 occurrences of QualificationsOnEntry for an Entry Profile.Show more
- 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.Show more
- 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'.Show more
- 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 = IEShow more
- 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 = IDShow more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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) yearShow more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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).Show more
- 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).Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.Show more
- 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 entityShow more
- 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.Show more
- 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.Show more
- 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.Show more
- 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.COMDATEShow more
- 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