Quality Rules

Back to Homepage
QR.STUDENT.AwardingBodyRole.AWARDINGBODYID.001.V01
Where the qualification is Degree or higher and the awarding body identifier is a UKPRN it must be for a provider with Degree awarding powers.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Length(AwardingBodyRole.AWARDINGBODYID) = 8 and Qualification.QUALCAT.GRP_LevelofStudyGrouping4 in (01, 02, 03, 04).
TechnicalValidity:
AwardingBodyRole.AWARDINGBODYID <> DAP.UKPRN
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.AWARDBOD.5; QR.C19054.Course.AWARDBOD.7;
QR.STUDENT.AwardingBodyRole.AWARDINGBODYID.001.V02
Where the qualification awarded is a degree and the awarding body identifier is a UKPRN, it must be for a provider with degree awarding powers.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Qualification.QUALCAT.GRP_LevelofStudyGrouping4 = 04 and Length(AwardingBodyRole.AWARDINGBODYID) = 8
TechnicalValidity:
AwardingBodyRole.AWARDINGBODYID <> ProvAffiliation.AffiliationCode = 100
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.AWARDBOD.5, QR.C19054.Course.AWARDBOD.7
QR.STUDENT.AwardingBodyRole.AWARDINGBODYID.002.V01
Where the provider has degree awarding powers (and is not a college or institute of the University of London), the number of Engagements associated with courses awarded by other bodies is higher than expected.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records AND 20%
Department for the Economy, Northern Ireland0 Records AND 20%
Scottish Funding Council0 Records AND 20%
TechnicalPopulation:
All Engagements for providers where Provider.UKPRN in (ProvAffiliation.AffiliationCode = 100) and Provider.UKPRN not in (ProvAffiliation.AffiliationCode = 108)
TechnicalValidity:
Engagement associated with a course with no occurrence of AwardingBodyRole.AWARDINGBODYID = Provider.UKPRN
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.AWARDBOD.6
QR.STUDENT.AwardingBodyRole.AWARDINGBODYID.004.V01
Where the provider has degree awarding powers, the number of Engagements associated with courses not awarded by the provider or the University of Wales is higher than expected.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0 Records AND 20%
TechnicalPopulation:
All Engagements for providers where ProvAffiliation.AffiliationCode = 100
TechnicalValidity:
Engagement associated with a course with no occurrence of (AwardingBodyRole.AWARDINGBODYID = Provider.UKPRN or AwardingBodyRole.AWARDINGBODYID = 10008574)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.AWARDBOD.8
QR.STUDENT.AwardingBodyRole.AWARDINGBODYID.005.V01
Where the awarding body is Pearson Edexcel, the qualification must be HND or HNC.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
AwardingBodyRole.AWARDINGBODYID = 5010
TechnicalValidity:
Associated Qualification.QUALCAT not in (J0003, C0001)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.AWARDBOD.3
QR.STUDENT.AwardingBodyRole.AWARDINGBODYID.006.V01
Where the awarding body is SQA, the qualification must be HND, HNC or an SVQ qualification.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
AwardingBodyRole.AWARDINGBODYID = 5027
TechnicalValidity:
Associated Qualification.QUALCAT not in (J0003, C0001, M0013, J0007).
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.AWARDBOD.4
QR.STUDENT.AwardingBodyRole.AWARDINGBODYID.009.V01
The Awarding body identifier has changed for an active Qualification where the awarding body does not have a UKPRN. Please consider whether a new Qualification needs to be created.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All qualifications in use and returned previously.
TechnicalValidity:
AwardingBodyRole.AWARDINGBODYID <> _LatestSignedOff.AwardingBodyRole.AWARDINGBODYID
Validity:
Invalid
Category:
Updateability
QR.STUDENT.AwardingBodyRole.AWARDINGBODYID.012.V01
Where the only awarding body is 'Other UK based awarding body' or 'Non-UK based awarding body', the qualification category must not be a first degree, master or doctorate degree.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
AwardingBodyRole.AWARDINGBODYID in (5032), (5035) and no other AwardingBodyRole.AWARDINGBODYID exists
TechnicalValidity:
Qualification.QUALCAT.GRP_LevelofStudyGrouping1 in (01), (02)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C21051.Course.AWARDBOD.10 / QR.C21054.Course.AWARDBOD.8
QR.STUDENT.AwardingBodyRole.AWARDINGBODYID.013.V01
Awarding body has been returned with a generic code. Could a UKPRN be used instead?
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
AwardingBodyRole.AWARDINGBODYID in (5032), (5035)
TechnicalValidity:
No AwardingBodyRole.AWARDINGBODYID <> (5032), (5035)
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C21051.Course.AWARDBOD.11 / QR.C21054.Course.AWARDBOD.9
QR.STUDENT.CollaborativeProvision.COLPROVTYPEID.001.V01
Where a Study Location is primarily not in the UK, the Engagement must be identified as part of a collaborative programme with an overseas partner.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagements where at least one StudyLocation.PRINONUK exists
TechnicalValidity:
CollaborativeProvision.COLPROVTYPEID does not exist or <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.LOCSDY.16
QR.STUDENT.CollaborativeProvision.PARTNERSID.001.V01
Where a student has transferred in to the provider as part of a doctoral research sequential collaboration arrangement, the associated qualification must be a research-based higher degree.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All StudentCourseSessions where Engagement CollaborativeProvision.PARTNERSID exists
TechnicalValidity:
StudentCourseSession.COURSEID where Course Qualification.QUALCAT not in (D0003, L0000, L0001)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.COLFROMDATE.1, QR.C18051.Instance.COLTODATE.1, QR.C18051.Instance.NUMHUSPREV.1
QR.STUDENT.CollaborativeProvision.PARTNERSID.002.V01
Where a student has transferred in to the provider as part of a doctoral research sequential collaboration arrangement the student identifier from the previous provider must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.CollaborativeProvision exists and CollaborativeProvision.COLPROVTYPEID does not exist
TechnicalValidity:
CollaborativeProvision.PARTNERSID does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.NUMHUSPREV.2
QR.STUDENT.CollaborativeProvision.PARTNERUKPRN.001.V01
Where a UKPRN is returned as part of a doctoral research sequential collaboration arrangement, it must be the UKPRN of another HE provider in the HESA constituency.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where CollaborativeProvision.PARTNERUKPRN exists
TechnicalValidity:
CollaborativeProvision.PARTNERUKPRN not in(where Provider.INSTID = Constituency.INSTID and Constituency.CollectionReference = Current collection reference) 
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.COLFROMPROV.3
QR.STUDENT.Course.BITTM.001.V01
For ITT courses (excluding early years) the bilingual ITT marker must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Course.TTCID.GRP_TTCIDITT in (01, 02)
TechnicalValidity:
Course.BITTM exists
Validity:
Valid
Category:
Coverage
LegacyRuleId:
QR.C18051.Course.BITTM.1
QR.STUDENT.Course.BITTM.002.V01
Bilingual ITT marker must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
All courses
TechnicalValidity:
Course.BITTM exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Course.BITTM.3
QR.STUDENT.Course.BITTM.003.V01
ITT courses leading to Qualified Teacher Status with an associated subject of 'Welsh language' must include the ability to teach bilingually or gain a certificate of bilingual education.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Course.TTCID = 01 and at least one associated course QualificationSubject.QUALSUBJECT = 100333
TechnicalValidity:
Course.BITTM = 00 or Course.BITTM does not exist
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.BITTM.4
QR.STUDENT.Course.BITTM.004.V01
There are no ITT (excluding Early Years ITT) courses which include the ability to teach bilingually or gain a certificate of bilingual education.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
ProviderUKPRN in (10007858, 10007854, 10007856,10007857) and Course.TTCID.GRP_TTCIDITT in (01, 02)
TechnicalValidity:
All courses have (Course.BITTM = 00 or Course.BITTM does not exist )
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.BITTM.6
QR.STUDENT.Course.BITTM.005.V01
ITT courses not leading to Qualified Teacher Status with an associated subject of 'Welsh language' must include the ability to teach bilingually or gain a certificate of bilingual education.
Version:
0.1
Status:
Amended
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Welsh Government0%
TechnicalPopulation:
Course.TTCID = 02 and at least one associated QualificationSubject.QUALSUBJECT = 100333
TechnicalValidity:
Course.BITTM = 00
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.BITTM.7
QR.STUDENT.Course.BITTM.006.V01
Where a course leads to a certificate of bilingual education or enables students to teach bilingually, at least one associated Module Instance is expected to have a proportion taught in a Celtic language.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0 Records
Department for the Economy, Northern Ireland0 Records
Scottish Funding Council0 Records
TechnicalPopulation:
Courses where Course.BITTM in (01,02) and Course.COURSEID is returned in any (StudentCourseSession.COURSEID where StudentCourseSession.ModuleInstance exists)
TechnicalValidity:
For any Course, all StudentCourseSession.ModuleInstances have (no ModuleInstance.LANGPCNT submitted or ModuleInstance.LANGPCNT = 0)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.BITTM.5
QR.STUDENT.Course.BITTM.007.V01
For non-ITT courses, the bilingual ITT marker must not be returned.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Course.TTCID.GRP_TTCIDITT not in (01, 02)
TechnicalValidity:
Course.BITTM exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Course.BITTM.2
QR.STUDENT.Course.BITTM.008.V01
The bilingual ITT marker of an active Course has been changed. Please consider whether a new Course needs to be created.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0 Records AND 0%
Department for the Economy, Northern Ireland0 Records AND 0%
Scottish Funding Council0 Records AND 0%
TechnicalPopulation:
All Courses in use previously returned where Course.BITTM exists and _LatestSignedOff.Course.BITTM exists
TechnicalValidity:
Course.BITTM differs from _LatestSignedOff.Course.BITTM
Validity:
Invalid
Category:
Updateability
QR.STUDENT.Course.CLSDCRS.001.V01
Closed course information must be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
TechnicalPopulation:
All courses
TechnicalValidity:
Course.CLSDCRS does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Course.CLSDCRS.1
QR.STUDENT.Course.CLSDCRS.002.V01
Closed course information must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses
TechnicalValidity:
Course.CLSDCRS exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Course.CLSDCRS.2
QR.STUDENT.Course.CLSDCRS.003.V01
The closed course code of an active Course has been changed. Please consider whether a new Course needs to be created.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records AND 0%
Higher Education Funding Council for Wales0 Records AND 0%
TechnicalPopulation:
All Courses in use and previously returned.
TechnicalValidity:
Course.CLSDCRS differs from _LatestSignedOff.Course.CLSDCRS
Validity:
Invalid
Category:
Updateability
QR.STUDENT.Course.COURSEID.001.V01
It is not expected that a submitted course would have no students associated with it in this submission, and no associated dormant or intercalating students from a previous submission.
Version:
0.1
Status:
Amended
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses
TechnicalValidity:
Where there are no associated StudentCourseSession.COURSEID included in the file and no dormant or intercalating students with the StudentCourseSession.COURSEID=Course.COURSEID
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C19054.Course.COURSEID.4
QR.STUDENT.Course.COURSEID.002.V01
More than 10% of students on a course and session year combination are identified as late starters (started more than 14 days after the start of the Session year).
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All StudentCourseSession.COURSEID and StudentCourseSession.SESSIONYEARID combinations
TechnicalValidity:
For any combination, more than 10% of StudentCourseSessions have StudentCourseSession.SCSTARTDATE - SessionYear.SYSTARTDATE > 14
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Course.CourseInitiative.001.V01
Where the same initiative code is returned on a course more than once, only one must be currently active.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Courses where the same CourseInitiative.INITIATIVEID occurs more than once
TechnicalValidity:
For the same CourseInitiative.INITIATIVEID more than one CourseInitiative entity with overlapping dates (using CourseInitiative.VALIDFROM and CourseInitiative.VALIDTO)
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.INITIATIVES.10, QR.C19054.InstancePeriod.INITIATIVES.2
QR.STUDENT.Course.CourseInitiative.001.V01
Where the same initiative code is returned on a course more than once, only one must be currently active.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Courses where the same CourseInitiative.COURSEINITID occurs more than once
TechnicalValidity:
For the same CourseInitiative.COURSEINITID more than one CourseInitiative entity with overlapping dates (using CourseInitiative.COURSEINITVALIDFROM and CourseInitiative.COURSEINITVALIDTO)
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.INITIATIVES.10, QR.C19054.InstancePeriod.INITIATIVES.2
QR.STUDENT.Course.CourseInitiative.002.V01
Where the same initiative code is returned on a course more than once, the 'valid from' and 'valid to' dates must not overlap.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Courses where the same CourseInitiative.INITIATIVEID occurs more than once
TechnicalValidity:
For the same CourseInitiative.INITIATIVEID the CourseInitiative entities have overlapping dates
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.INITIATIVES.10, QR.C19054.InstancePeriod.INITIATIVES.2
QR.STUDENT.Course.CourseRole.001.V01
The course must have at least one course role identified as a delivery organisation.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses
TechnicalValidity:
At least one CourseRole.ROLETYPE = 202
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.COLLORG.1
QR.STUDENT.Course.CurriculumAccreditation.001.V01
Curriculum Accreditation must exist for ITT courses excluding Early Years ITT.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Course.TTCID in (01, 02)
TechnicalValidity:
Course.CurriculumAccreditation entity does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Course.TQSSEC.1, QR.C19054.Course.COURSEAIM.12
QR.STUDENT.Course.CurriculumAccreditation.002.V01
Where a provider currently has a medical school and subjects of study for the course include clinical medicine there is no associated current course accreditation by the General Medical Council.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
ProviderUKPRN.MedSchool is applicable to the current Reference Period and the course has at least one associated QualificationSubject.QUALSUBJECT = 100267.
TechnicalValidity:
No associated CurriculumAccreditation exists or all associated CurriculumAccreditation.ACCREDITATIONID.GRP_AccreditationBody <> 03 or (where any associated CurriculumAccreditation.ACCREDITATIONID.ACCREDITATIONID.GRP_AccreditationBody = 03 and (CurriculumAccreditation.VALIDFROM > ReferencePeriod.EndDate or CurriculumAccreditation.VALIDTO where it exists < ReferencePeriod.StartDate)).
Validity:
Invalid
Category:
Valid values
QR.STUDENT.Course.CurriculumAccreditation.003.V01
Where a provider currently has a dental school and subjects of study for the course include clinical dentistry there is no associated current course accreditation by the General Dental Council.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
UKPRN.DentalSchool = Y and the course has at least one associated QualificationSubject.QUALSUBJECT is 100266.
TechnicalValidity:
No associated CurriculumAccreditation exists Or No associated CurriculumAccreditation.ACCREDITATIONID.GRP_AccreditationBody = 02
Validity:
Invalid
Category:
Valid values
QR.STUDENT.Course.CurriculumAccreditation.004.V01
Where a provider currently has a veterinary school and subjects of study for the course include veterinary medicine or veterinary dentistry there is no associated current course accreditation by the Royal College of Veterinary Surgeons.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
UKPRN.VetSchool= Y and the course has at least one associated QualificationSubject.QUALSUBJECT in 100531 or 101347.
TechnicalValidity:
No associated CurriculumAccreditation exists or all associated CurriculumAccreditation.ACCREDITATIONID not equal to 12001
Validity:
Invalid
Category:
Valid values
QR.STUDENT.Course.CurriculumAccreditation.005.V01
Where the ITT course leads to QTS, the sector in which the student is pursuing their teaching qualification must be either Primary or Secondary education.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Course.TTCID = 01
TechnicalValidity:
At least one CurriculumAccreditation.ACCREDITATIONID has(CurriculumAccreditation.ACCREDITATIONID.MRK_PrimaryTeaching=N and CurriculumAccreditation.ACCREDITATIONID.MRK_Secondary=N)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.TQSSEC.2
QR.STUDENT.Course.CurriculumAccreditation.006.V01
Where the same accreditation code is returned on a course more than once, only one must be currently active.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Courses where the same CurriculumAccreditation.ACCREDITATIONID occurs more than once
TechnicalValidity:
For the same Accreditation more than one CurriculumAccreditation.ACCREDITATIONID, CurriculumAccreditation.VALIDTO does not exist
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Course.CurriculumAccreditation.007.V01
Where the same accreditation code is returned on a course more than once, the 'valid from' and 'valid to' dates must not overlap.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Courses where the same CurriculumAccreditation.ACCREDITATIONID occurs more than once
TechnicalValidity:
For the same CurriculumAccreditation.ACCREDITATIONID the CurriculumAccreditation entities have overlapping dates
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Course.FULLYFLEX.001.V01
The fully flexible indicator of an active Course has been changed. Please consider whether a new Course needs to be created.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records AND 0%
Higher Education Funding Council for Wales0 Records AND 0%
Department for the Economy, Northern Ireland0 Records AND 0%
Scottish Funding Council0 Records AND 0%
TechnicalPopulation:
All Courses in use and previously returned.
TechnicalValidity:
Course.FULLYFLEX differs from _LatestSignedOff.Course.FULLYFLEX (includes exists to not exists and not exists to exists)
Validity:
Invalid
Category:
Updateability
QR.STUDENT.Course.FULLYFLEX.002.V01
PhD courses are not considered to be fully flexible.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Qualification.QUALCAT = D0003
TechnicalValidity:
Course.FULLYFLEX exists
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Course.FUNDLEVEL.001.V01
The course funding level must be 'Postgraduate research course' where the associated qualification is PGR.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All courses where Course.FUNDLEVEL exists and Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 01 (PGR)
TechnicalValidity:
Course.FUNDLEVEL <> 03
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.FUNDLEV.10, QR.C18051.Instance.FUNDLEV.9, QR.C18051.Instance.FUNDLEV.5
QR.STUDENT.Course.FUNDLEVEL.002.V01
The course funding level must be 'Taught course for which qualifications below level 6 are normally required' where the associated qualification is foundation degree or other undergraduate.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All courses where Course.FUNDLEVEL exists and (Qualification.QUALCAT.GRP_LevelofStudyGrouping4 in (06, 07))
TechnicalValidity:
Course.FUNDLEVEL <> 01
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.FUNDLEV.11
QR.STUDENT.Course.FUNDLEVEL.003.V01
The Course level must be 'Taught course for which a qualification at level 6 or above is normally required' where the associated qualification is relevant and any students are fundable by a funding council.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All courses where Course.FUNDLEVEL exists and Qualification.QUALCAT in (H0010, H0016, I0002, I0010) and any associated StudentCourseSessions have FundingBody.FUNDINGBODY.GRP_FundableBy = 01
TechnicalValidity:
Course.FUNDLEVEL <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.12
QR.STUDENT.Course.FUNDLEVEL.004.V01
The Course level must be 'Taught course for which a qualification at level 6 or above is normally required' where the associated qualification is postgraduate taught.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All courses where Course.FUNDLEVEL exists and (Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 02)
TechnicalValidity:
Course.FUNDLEVEL <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.2, QR.C19051.Instance.FUNDLEV.6
QR.STUDENT.Course.FUNDLEVEL.005.V01
The course level must be 'Taught course for which a qualification at level 6 or above is normally required' where the associated qualification is at level H or I and postgraduate.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All courses where Course.FUNDLEVEL exists and Qualification.QUALCAT in (H0009, H0010, H0013, I0002)
TechnicalValidity:
Course.FUNDLEVEL <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.6
QR.STUDENT.Course.FUNDLEVEL.006.V01
The course level must be 'Taught course for which qualifications below level 6 are normally required' where the associated qualification is undergraduate.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All courses where Course.FUNDLEVEL exists and (Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02 or Qualification.QUALCAT = M0003), excluding Qualification.QUALCAT in (H0009, H0010, H0013, I0002, I0005)
TechnicalValidity:
Course.FUNDLEVEL <> 01
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.7
QR.STUDENT.Course.FUNDLEVEL.007.V01
Where the student has not started or stopped intercalating, the funding level associated with the programme of study differs from that previously returned. Please consider whether a new Engagement is required.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All StudentCourseSessions where a previous StudentCourseSession exists and _Previous.StudentCourseSession.INTERCALATE = StudentCourseSession.INTERCALATE
TechnicalValidity:
_Previous.StudentCourseSession.Course.FUNDLEVEL <> StudentCourseSession.Course.FUNDLEVEL
Validity:
Invalid
Category:
Continuity
LegacyRuleId:
QR.C18051.Instance.FUNDLEV.16
QR.STUDENT.Course.FUNDLEVEL.008.V01
The funding level of an active Course has been changed. Please consider whether a new Course needs to be created.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records AND 0%
Higher Education Funding Council for Wales0 Records AND 0%
Department for the Economy, Northern Ireland0 Records AND 0%
Scottish Funding Council0 Records AND 0%
TechnicalPopulation:
All Courses in use and previously returned.
TechnicalValidity:
Course.FUNDLEVEL differs from _LatestSignedOff.Course.FUNDLEVEL
Validity:
Invalid
Category:
Updateability
QR.STUDENT.Course.PREREQUISITE.001.V01
The course funding level must be 'Postgraduate research course' where the associated qualification is postgraduate research.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 01 (PGR)
TechnicalValidity:
Course.PREREQUISITE <> 03
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.FUNDLEV.10, QR.C18051.Instance.FUNDLEV.9, QR.C18051.Instance.FUNDLEV.5
QR.STUDENT.Course.PREREQUISITE.001.V02
The course funding level must be 'Postgraduate research course' where the associated qualification is postgraduate research.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 01 (PGR)
TechnicalValidity:
Course.PREREQUISITE <> 03
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.FUNDLEV.10, QR.C18051.Instance.FUNDLEV.9, QR.C18051.Instance.FUNDLEV.5; QR.C21054.Instance.FUNDLEV.5; QR.C21054.Instance.FUNDLEV.9; QR.C21054.Instance.FUNDLEV.10
QR.STUDENT.Course.PREREQUISITE.002.V01
The course funding level must be 'Taught course for which qualifications below level 6 are normally required' where the associated qualification is foundation degree or other undergraduate.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and (Qualification.QUALCAT.GRP_LevelofStudyGrouping4 in (06, 07))
TechnicalValidity:
Course.PREREQUISITE <> 01
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.FUNDLEV.11
QR.STUDENT.Course.PREREQUISITE.002.V02
The course funding level must be 'Taught course for which qualifications below level 6 are normally required' where the associated qualification is foundation degree or other undergraduate.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and Qualification.QUALCAT begins with J or C
TechnicalValidity:
Course.PREREQUISITE <> 01
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.FUNDLEV.11; QR.C21054.Instance.FUNDLEV.11
QR.STUDENT.Course.PREREQUISITE.003.V01
The Course level must be 'Taught course for which a qualification at level 6 or above is normally required' where the associated qualification is relevant and any students are fundable by a funding council.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and Qualification.QUALCAT in (H0010, H0016, I0002, I0010) and any associated StudentCourseSessions have FundingBody.FUNDINGBODY.GRP_FundableBy = 01
TechnicalValidity:
Course.PREREQUISITE <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.12
QR.STUDENT.Course.PREREQUISITE.003.V02
The Course level must be 'Taught course for which a qualification at level 6 or above is normally required' where the associated qualification is relevant and any students are fundable by a funding council.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and Qualification.QUALCAT in (H0010, H0016, I0002, I0010) and any associated StudentCourseSessions have FundingBody.FUNDINGBODY.GRP_FundableBy = 01
TechnicalValidity:
Course.PREREQUISITE <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.12; QR.C21054.Instance.FUNDLEV.12
QR.STUDENT.Course.PREREQUISITE.004.V01
The Course level must be 'Taught course for which a qualification at level 6 or above is normally required' where the associated qualification is postgraduate taught.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and (Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 02)
TechnicalValidity:
Course.PREREQUISITE <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.2, QR.C19051.Instance.FUNDLEV.6
QR.STUDENT.Course.PREREQUISITE.004.V02
The Course level must be 'Taught course for which a qualification at level 6 or above is normally required' where the associated qualification is postgraduate taught.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and (Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 02)
TechnicalValidity:
Course.PREREQUISITE <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.2, QR.C19051.Instance.FUNDLEV.6; QR.C21054.Instance.FUNDLEV.4; QR.C21054.Instance.FUNDLEV.6
QR.STUDENT.Course.PREREQUISITE.005.V01
The course level must be 'Taught course for which a qualification at level 6 or above is normally required' where the associated qualification is at level H or I and postgraduate.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and Qualification.QUALCAT in (H0009, H0010, H0013, I0002)
TechnicalValidity:
Course.PREREQUISITE <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.6
QR.STUDENT.Course.PREREQUISITE.005.V02
The course level must be 'Taught course for which a qualification at level 6 or above is normally required' where the associated qualification is at level H or I and postgraduate.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and Qualification.QUALCAT in (H0009, H0010, H0013, I0002)
TechnicalValidity:
Course.PREREQUISITE <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.6; QR.C21054.Instance.FUNDLEV.6
QR.STUDENT.Course.PREREQUISITE.006.V01
The course level must be 'Taught course for which qualifications below level 6 are normally required' where the associated qualification is undergraduate.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and (Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02, excluding Qualification.QUALCAT in (H0009, H0010, H0013, I0002, I0005))
TechnicalValidity:
Course.PREREQUISITE <> 01
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.7
QR.STUDENT.Course.PREREQUISITE.006.V02
The course level must be 'Taught course for which qualifications below level 6 are normally required' where the associated qualification is undergraduate.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All courses where Course.PREREQUISITE exists and (Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02, excluding Qualification.QUALCAT in (H0009, H0010, H0013, I0002, I0005))
TechnicalValidity:
Course.PREREQUISITE <> 01
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.Instance.FUNDLEV.7; QR.C21054.Instance.FUNDLEV.7
QR.STUDENT.Course.PREREQUISITE.009.V01
Where the course has medical accreditation and subjects and the all associated students have a postgraduate or first degree highest qualification on entry, then the course level must not be 'Taught course for which qualifications below level 6 are normally required'
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
TechnicalPopulation:
Courses where any current CurriculumAccreditation.CURACCID.GRP_AccreditationBody in (02, 03, 16) and any associated Qualification.QUALSUBJECT in (100266, 100267, 100494, 100531, 101347) and all associated engagements where _LatestSignedOff EntryProfile.HIGHESTQOE begins (D, M, H)
TechnicalValidity:
Course.PREREQUISITE = 01
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Course.QUALID.001.V01
An ITT course with students that have been awarded secondary teaching accreditation must not have early years or primary teaching subjects.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Course.TTCID = 01 and associated students with QualificationAwardAccreditation.ACCREDITATIONID.MRK_SecondaryTeaching = Y
TechnicalValidity:
Any associated Course QualificationSubject.QUALSUBJECT in (100510, 100511)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.2
QR.STUDENT.Course.QUALID.002.V01
When students are studying a full-time first degree in clinical medicine, it is expected that there will also be courses including pre-clinical medicine.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0 Records
Department for the Economy, Northern Ireland0 Records
TechnicalPopulation:
All Courses where any associated CurriculumAccreditation.ACCREDITATIONID.GRP_AccreditationBody = 03 and associated Qualification.QUALCAT.GRP_LevelOfStudyGrouping2 = 03 and (any associated QualificationSubject.QUALSUBJECT = 100267) and COUNT(Associated StudentCourseSession.SCSMODE=01) >0
TechnicalValidity:
COUNT(Courses where any associated CurriculumAccreditation.ACCREDITATIONID.GRP_AccreditationBody = 03 and associated Qualification.QUALCAT.GRP_LevelOfStudyGrouping2 = 03 and (any associated QualificationSubject.QUALSUBJECT = 100276) and COUNT(associated StudentCourseSession.SCSMODE=01) >0) >0
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.22
QR.STUDENT.Course.QUALID.003.V01
An ITT course with secondary teaching accreditation must have secondary teaching subjects.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Course.TTCID = 01 and any current CurriculumAccreditation.ACCREDITATIONID.MRK_SecondaryTeaching=Y
TechnicalValidity:
All Course QualificationSubject.QUALSUBJECT.MRK_SecondaryITT=Y
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.15
QR.STUDENT.Course.QUALID.004.V01
An ITT course with subjects not allocated by the Department for Education (DfE) must not have students coded as eligible for DfE funding.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Course.TTCID = 01 and all Course QualificationSubject.QUALSUBJECT.MRK_DfEITTFunded = Y
TechnicalValidity:
Any associated StudentCourseSessions with FundingBody.FUNDINGBODY = 5020
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.24
QR.STUDENT.Course.QUALID.005.V01
For an ITT course with students awarded primary QTS, non-primary teaching subjects must not be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Course.TTCID = 01 and associated Engagements with QualificationAwardAccreditation.ACCREDITATIONID.MRK_PrimaryTeaching = Y
TechnicalValidity:
Any Course QualificationSubject.QUALSUBJECT.MRK_PrimaryITT = Y
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.3
QR.STUDENT.Course.QUALID.006.V01
Subjects in biology, chemistry and physics must only be used together for non-ITT courses or primary ITT courses.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
All Courses where QualificationSubject.QUALSUBJECT = 100346 and an occurrence of QualificationSubject.QUALSUBJECT = 100417 and an occurrence of QualificationSubject.QUALSUBJECT = 100425.
TechnicalValidity:
Course.TTCID = 00 or (Course.TTCID = 01 and associated CurriculumAccreditation.ACCREDITATIONID.MRK_PrimaryTeaching = Y).
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.7
QR.STUDENT.Course.QUALID.007.V01
For a secondary ITT applied science course leading to QTS, the subjects must include applied biology, applied chemistry and applied physics as a triplet.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Course.TTCID = 01 and associated CurriculumAccreditation.ACCREDITATIONID.MRK_SecondaryTeaching=Y and at least one occurrence of Course QualificationSubject.QUALSUBJECT in (100343, 101038, 101060)
TechnicalValidity:
An occurrence Course QualificationSubject.QUALSUBJECT = 100343 and an occurrence Course QualificationSubject.QUALSUBJECT = 101038 and an occurrence Course QualificationSubject.QUALSUBJECT = 101060
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.6
QR.STUDENT.Course.QUALID.008.V01
When students are studying a full-time first degree in clinical dentistry, it is expected that there will also be courses including pre-clinical dentistry.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0 Records
Department for the Economy, Northern Ireland0 Records
TechnicalPopulation:
All Courses where any associated CurriculumAccreditation.ACCREDITATIONID in (05802,05803) and associated Qualification.QUALCAT.GRP_LevelOfStudyGrouping2 = 03 and (Any associated QualificationSubject.QUALSUBJECT = 100266) and Count(Associated StudentCourseSession.SCSMODE=01) > 0
TechnicalValidity:
COUNT(Courses where any associated CurriculumAccreditation.ACCREDITATIONID in (05802,05803) and associated Qualification.QUALCAT.GRP_LevelOfStudyGrouping2 = 03 and (Any associated QualificationSubject.QUALSUBJECT = 100275) and Count(Associated StudentCourseSession.SCSMODE=01) >0) >0
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.23
QR.STUDENT.Course.QUALID.009.V01
The qualification identifier of an active Course has been changed. Please consider whether a new Course needs to be created.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records AND 0%
Higher Education Funding Council for Wales0 Records AND 0%
Department for the Economy, Northern Ireland0 Records AND 0%
Scottish Funding Council0 Records AND 0%
TechnicalPopulation:
All Courses in use and previously returned.
TechnicalValidity:
Course.QUALID differs from _LatestSignedOff.Course.QUALID
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.29, QR.C19054.CourseSubject.SBJCA.10
QR.STUDENT.Course.Qualification.001.V01
The qualification associated with a course must be higher than level 3.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Qualifications associated with a Course.
TechnicalValidity:
Qualification.QUALCAT = P0002
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C20051.QualificationsAwarded.QUAL.21
QR.STUDENT.Course.Qualification.002.V01
Courses leading to QTS must not be Postgraduate Diploma in Education or Level 5 Diploma in Education and Training.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
Course.TTCID = 01
TechnicalValidity:
Associated Course.QUALID Qualification.QUALCAT in (M0018, I0008)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.COURSEAIM.19
QR.STUDENT.Course.Qualification.003.V01
A masters or undergraduate degree that is accredited by the Royal College of Veterinary Surgeons (RCVS) must have a veterinary science subject.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
Courses where associated (Qualification.QUALCAT in (M0021, M0003) or Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 02) and Any Current CurriculumAccreditation.ACCREDITATIONID in (12001,12002)
TechnicalValidity:
No associated QualificationSubject.QUALSUBJECT.GRP_SubjectGrouping1 = 05
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.19, QR.C19054.CourseSubject.SBJCA.3
QR.STUDENT.Course.Qualification.003.V01
A masters or undergraduate degree that is accredited by the Royal College of Veterinary Surgeons (RCVS) must have a veterinary science subject.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
Courses where associated (Qualification.QUALCAT in (M0021, M0003) or Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 02) and Any Current CurriculumAccreditation.CURACCID in (12001,12002)
TechnicalValidity:
No associated QualificationSubject.QUALSUBJECT.GRP_SubjectGrouping1 = 05
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.19, QR.C19054.CourseSubject.SBJCA.3
QR.STUDENT.Course.SANDWICH.001.V01
Courses in medicine and dentistry, accredited by the GDC (Dentists) or GMC must not be sandwich courses.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Courses where Qualification.QUALSUBJECT.GRP_SubjectGrouping1 = 01 and any current CurriculumAccreditation.ACCREDITATIONID = 05803 or 05901
TechnicalValidity:
Course.SANDWICH exists
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.MODE.10
QR.STUDENT.Course.SANDWICH.001.V01
Courses in medicine and dentistry, accredited by the GDC (Dentists) or GMC must not be sandwich courses.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Courses where Qualification.QUALSUBJECT.GRP_SubjectGrouping1 = 01 and any current CurriculumAccreditation.CURACCID = 05803 or 05901
TechnicalValidity:
Course.SANDWICH exists
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.MODE.10
QR.STUDENT.Course.SANDWICH.002.V01
INSET/ In-service courses must not have a sandwich placement.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Course.TTCID = 03
TechnicalValidity:
Course.SANDWICH exists
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.MODE.16
QR.STUDENT.Course.SANDWICH.003.V01
Postgraduate courses must not be sandwich courses.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Associated Course Qualification.QUALCAT.GRP_LevelofStudyGrouping2 in (01, 02)
TechnicalValidity:
Course.SANDWICH exists
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19054.InstancePeriod.MODE.11
QR.STUDENT.Course.SANDWICH.003.V02
Postgraduate research courses must not be sandwich courses.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Associated Course Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 01
TechnicalValidity:
Course.SANDWICH exists
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19054.InstancePeriod.MODE.11
QR.STUDENT.Course.SANDWICH.005.V01
HNC and undergraduate level access course or pathway programme courses must not be sandwich courses.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Associated Course Qualification.QUALCAT in (H0019, J0012, C0001, C0009)
TechnicalValidity:
Course.SANDWICH exists
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C20051.Instance.MODE.37
QR.STUDENT.Course.TTCID.001.V01
Where a course is associated with the qualification 'Qualified Teacher Status (QTS)/registration with a General Teaching Council (GTC) only' it must be coded as ITT leading to QTS or registration with a GTC.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Courses with associated Qualification.QUALCAT = I0005
TechnicalValidity:
Course.TTCID <> 01
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.TTCID.10
QR.STUDENT.Course.TTCID.002.V01
Where a course leads to QTS the provider must be currently identified by the Department for Education.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Course.TTCID = 01
TechnicalValidity:
ProviderRegulator.RegulatorCode = 5020
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.TTCID.11
QR.STUDENT.Course.TTCID.003.V01
Where the course is associated with a PGCE or PGDE qualification it must be coded as a teacher training course.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Associated Qualification.QUALCAT.MRK_PGCE_PGDE = Y
TechnicalValidity:
Course.TTCID.MRK_TeacherTraining = N
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.TTCID.13, QR.C19054.Course.TTCID.1
QR.STUDENT.Course.TTCID.004.V01
Where the course is associated with a qualification to teach in the Lifelong Learning Sector (LLS) it must be coded as Other ITT not leading to QTS.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Associated Qualification.QUALCAT in (M0020, H0015, I0009, C0005, C0006)
TechnicalValidity:
Course.TTCID <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.TTCID.15, QR.C19054.Course.TTCID.2
QR.STUDENT.Course.TTCID.005.V01
Where the course is associated with an Early Years Teacher Status (EYTS) qualification it must be coded as Early years ITT.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Associated Qualification.QUALCAT = I0007
TechnicalValidity:
Course.TTCID.GRP_TTCIDITT <> 03
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.TTCID.17, QR.C19054.Course.TTCID.5
QR.STUDENT.Course.TTCID.006.V01
Where the course is accredited for Early Years Teacher Status (EYTS) it must be coded as Early years ITT.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
StudentAccreditationAim.ACCREDITATIONID = 13920
TechnicalValidity:
Course.TTCID <> 06
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.TTCID.18
QR.STUDENT.Course.TTCID.007.V01
Where the course leads to Qualified Teacher Status (QTS) or registration with a General Teaching Council (GTC) only it must be coded as teacher training.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
Associated Qualification.QUALCAT = I0005
TechnicalValidity:
Course.TTCID = 00
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.TTCID.6
QR.STUDENT.Course.TTCID.008.V01
Teacher training course identifier must be applicable to the country of the provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses
TechnicalValidity:
(For England Course.TTCID.MRK_CourseTTCIDEngland = N) or (for Scotland Course.TTCID.MRK_CourseTTCIDScotland = N) or (for Northern Ireland Course.TTCID.MRK_CourseTTCIDNorthernIreland = N) or (for Wales and Course.TTCID.MRK_CourseTTCIDWales = N)
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C18051.Course.TTCID.8
QR.STUDENT.Course.TTCID.009.V01
Where a course is Early Years ITT, then it must be associated with the qualification 'Early Years Teacher Status (EYTS) only'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Course.TTCID = 06
TechnicalValidity:
Associated Qualification.QUALCAT = I0007
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.COURSEAIM.15, QR.C19054.Course.COURSEAIM.13
QR.STUDENT.Course.TTCID.010.V01
The teacher training course identifier of an active Course has been changed. Please consider whether a new Course needs to be created.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records AND 0%
Higher Education Funding Council for Wales0 Records AND 0%
Department for the Economy, Northern Ireland0 Records AND 0%
Scottish Funding Council0 Records AND 0%
TechnicalPopulation:
All Courses in use and previously returned.
TechnicalValidity:
Course.TTCID differs from _LatestSignedOff.Course.TTCID
Validity:
Invalid
Category:
Updateability
QR.STUDENT.CourseInitiative.COURSEINITID.002.V01
A course initiative of Engineering conversion course pilot scheme must only be returned by providers included in that scheme.
Version:
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
CourseInitiative.COURSEINITID = 003
TechnicalValidity:
ProviderUKPRN not in RefDataEngineeringConversionPilot.UKPRN list.
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.INITIATIVES.36
QR.STUDENT.CourseInitiative.COURSEINITVALIDFROM.001.V01
The Course initiative 'valid from' date must not be after the end of the reference period.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CourseInitiative.COURSEINITVALIDFROM exists
TechnicalValidity:
CourseInitiative.COURSEINITVALIDFROM > RefrencePeriod.EndDate
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CourseInitiative.COURSEINITVALIDTO.001.V01
Where the Course initiative has a 'valid to' date it must be after the 'valid from' date.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CourseInitiative.COURSEINITVALIDTO exists
TechnicalValidity:
CourseInitiative.COURSEINITVALIDTO < CourseInitiative.COURSEINITVALIDFROM
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CourseInitiative.INITIATIVEID.001.V01
The course initiative code used must be applicable to the country of the provider.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All CourseInitiatives
TechnicalValidity:
(For England CourseInitiative.INITIATIVEID.MRK_CourseInitiativeINITIATIVEIDEngland = N) or (For Scotland CourseInitiative.INITIATIVEID.MRK_CourseInitiativeINITIATIVEIDScotland = N) or (For Wales CourseInitiative.INITIATIVEID.MRK_CourseInitiativeWales = N) or (For Northern Ireland CourseInitiative.INITIATIVEID.MRK_CourseInitiativeINITIATIVEIDNorthernIreland = N)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.INITIATIVES.11, QR.C18051.Instance.INITIATIVES.30, QR.C18051.Instance.INITIATIVES.31, QR.C18051.Instance.INITIATIVES.43, QR.C19054.InstancePeriod.INITIATIVES.3
QR.STUDENT.CourseInitiative.INITIATIVEID.002.V01
A course initiative of Engineering conversion course pilot scheme must only be returned by providers included in that scheme.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
CourseInitiative.INITIATIVEID = 003
TechnicalValidity:
ProviderUKPRN not in RefDataEngineeringConversionPilot.UKPRN list.
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.INITIATIVES.36
QR.STUDENT.CourseInitiative.INITIATIVEID.003.V01
The 'Abridged ITT Course' initiative can only be used where the course leads to QTS and all students have an ITT entry route of 'School Direct salaried'.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
CourseInitiative.INITIATIVEID = 001
TechnicalValidity:
Associated Course.TTCID <> 01 and any associated Engagement.ENTRYRTE <> 03
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.INITIATIVES.35
QR.STUDENT.CourseInitiative.INITIATIVEID.004.V01
Micro-credential courses must only be associated with students studying part-time.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
Latest StudentCourseSession where any current CourseInitiative.INITIATIVEID = 028
TechnicalValidity:
Latest StudentCourseSession.SCSMODE.GRP_FullPartTimeGrouping1 <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C21051.Instance.INITIATIVES.57
QR.STUDENT.CourseInitiative.INITIATIVEID.005.V01
The word 'apprenticeship' has been included in the course title for a course, but the associated initiative identifier does not match this. Please check that the associated initiative identifier has been coded correctly.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Scottish Funding Council0%
TechnicalPopulation:
Courses where Course.COURSETITLE contains the word 'apprenticeship' and CourseInitiative.INITIATIVEID exists
TechnicalValidity:
All CourseInitiative.INITIATIVEID not in (004, 020)
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CourseInitiative.INITIATIVEID.006.V01
Course title contains the word 'apprenticeship' but no students associated with the course have a StudentInitiative applicable to apprenticeship. Please check that the associated initiative identifier has been coded correctly.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Course where Course.COURSETITLE contains the word 'apprenticeship' and no occurrence of CourseInitiative.INITIATIVEID in (004,020)
TechnicalValidity:
No associated Student has StudentInitiative.INITIATIVEID in (004,020)
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CourseInitiative.INITIATIVEID.007.V01
The postgraduate loan eligibility course initiative identifier can only be returned where the course is a masters or doctorate one, or where it is a taught course for which a qualification at level 6 or above is normally required and it is prescribed by the Architects Registration Board (ARB) at Part 2 level for the purpose of registration in the UK.
Version:
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
CourseInitiative.INITIATIVEID = 005
TechnicalValidity:
Associated Qualification.QUALCAT.GRP_PostGraduateLoan in (01, 02) or (Course.PREREQUISITE = 02 and CurriculumAccreditation.ACCREDITATIONID = 00103 and accreditation is applicable at the end of the current reference period (using CurriculumAccreditation.VALIDFROM and CurriculumAccreditation.VALIDTO dates))
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.INITIATIVES.37, QR.C19054.InstancePeriod.INITIATIVES.1
QR.STUDENT.CourseInitiative.INITIATIVEID.008.V01
Where a course has at least one associated student with the postgraduate loan eligibility student initiative identifier returned, it is expected that all the associated students will have the postgraduate loan eligibility student initiative identifier returned, even if they are not in receipt or personally eligible for the loan.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Courses with at least one associated Engagement where StudentInitiative.INITIATIVEID = 005
TechnicalValidity:
All associated Engagements do not have StudentInitiative.INITIATIVEID = 005
Validity:
Invalid
Category:
Guidance
QR.STUDENT.CourseInitiative.VALIDFROM.001.V01
The Course initiative 'valid from' date must not be after the end of the reference period.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CourseInitiative.VALIDFROM exists
TechnicalValidity:
CourseInitiative.VALIDFROM > RefrencePeriod.EndDate
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CourseInitiative.VALIDTO.001.V01
Where the Course initiative has a 'valid to' date it must be after the 'valid from' date.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CourseInitiative.VALIDTO exists
TechnicalValidity:
CourseInitiative.VALIDTO < CourseInitiative.VALIDFROM
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CourseReference.COURSEREFRNCID.001.V01
Where the Course reference ID type is 'UCAS programme ID' the Course reference ID must be in the correct format.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CourseReference.COURSEREFRNCIDTYPE = 02
TechnicalValidity:
CourseReference.COURSEREFRNCID must be in the format CNN-CNN (where 'C' is an alpha-code character and 'N' is a numeric value)
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CourseReference.COURSEREFRNCID.002.V01
Where the Course reference ID type is 'UCAS Course code' the Course reference ID must be in the correct format.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CourseReference.COURSEREFRNCIDTYPE = 03
TechnicalValidity:
CourseReference.COURSEREFRNCID must be in the format NNNN (where 'N' is numeric)
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CourseRole.COURSEROLEHESAID.002.V01
Where the Course role type is 'delivery organisation' and the HESA identifier is not a UKPRN, it must have an appropriate identifier code.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses where CourseRole.COURSEROLEHESAID is shorter than 8 characters and CourseRole.ROLETYPE = 202
TechnicalValidity:
CourseRole.COURSEROLEHESAID.MRK_CourseRoleDelivery = N
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Course.MSFUND.5, QR.C18051.Course.MSFUND.6, QR.C18051.Course.MSFUND.4, QR.C18051.Course.MSFUND.3
QR.STUDENT.CourseRole.CRPROPORTION.001.V01
The sum of all course role proportions for a course role type must be 100.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Courses
TechnicalValidity:
Sum(CourseRole.CRPROPORTION) for a distinct CourseRole.ROLETYPE <> 100
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CourseRole.CRPROPORTION.002.V01
Course role proportion must be a positive whole number.
Version:
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CourseRole.CRPROPORTION exists
TechnicalValidity:
CourseRole.CRPROPORTION < 1 or CourseRole.CRPROPORTION is not a whole number.
Validity:
Invalid
Category:
Valid values
QR.STUDENT.CourseRole.CRPROPORTION.003.V01
Course role proportion must be greater than or equal to 1 and returned as a whole number.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CourseRole.CRPROPORTION exists
TechnicalValidity:
CourseRole.CRPROPORTION <1 or CourseRole.CRPROPORTION contains decimal places
Validity:
Invalid
Category:
Valid values
QR.STUDENT.CourseRole.HESAID.001.V01
Where the HESA identifier is a UKPRN it must be a current UKPRN.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
LENGTH(CourseRole.HESAID) = 8
TechnicalValidity:
CourseRole.HESAID not in UKRLP lookup or CourseRole.HESAID in UKRLP lookup but not an active UKPRN
Validity:
Invalid
Category:
Valid values
QR.STUDENT.CourseRole.HESAID.002.V01
Where the Course role type is 'delivery organisation' and the HESA identifier is not a UKPRN, it must have an appropriate identifier code.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses where CourseRole.HESAID is shorter than 8 characters and CourseRole.ROLETYPE = 202
TechnicalValidity:
CourseRole.HESAID.MRK_CourseRoleDelivery = Y
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Course.MSFUND.5, QR.C18051.Course.MSFUND.6, QR.C18051.Course.MSFUND.4, QR.C18051.Course.MSFUND.3
QR.STUDENT.CourseRole.HESAID.003.V01
Where a course is funded by research councils the qualification must be a research-based higher degree.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
CourseRole.HESAID = 5056 and CourseRole.ROLETYPE = 401
TechnicalValidity:
Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 01 and Qualification.QUALCAT.MRK_QUALCATCredits = N
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.MSFUND.14
QR.STUDENT.CourseRole.HESAID.004.V01
Where the Course role type is 'funder' it must have an appropriate 4-character identifier code.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses where CourseRole.ROLETYPE = 401
TechnicalValidity:
Length(CourseRole.HESAID) <> 4
Validity:
Invalid
Category:
Guidance
QR.STUDENT.CourseRole.HESAID.005.V01
A new Course role delivery organisation has been added to an active Course. Please consider whether a new Course needs to be created.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records AND 0%
Higher Education Funding Council for Wales0 Records AND 0%
Department for the Economy, Northern Ireland0 Records AND 0%
Scottish Funding Council0 Records AND 0%
TechnicalPopulation:
All Courses in use and returned previously
TechnicalValidity:
CourseRole.ROLETYPE = 202 and CourseRole.HESAID not previously included in any (_LatestSignedOff.CourseRole.HESAID where _LatestSignedOff.CourseRole.ROLETYPE = 202)
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C20051.DeliveryOrganisationAndLocation.DELORG.6
QR.STUDENT.CourseRole.HESAID.007.V01
A generic delivery organisation has been returned. Please check whether this can be coded more accurately.
Version:
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5 Records AND 5%
Higher Education Funding Council for Wales5 Records AND 5%
Department for the Economy, Northern Ireland5 Records AND 5%
Scottish Funding Council5 Records AND 5%
TechnicalPopulation:
CourseRole.ROLETYPE = 202
TechnicalValidity:
CourseRole.HESAID in (5043, 5044, 5057)
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CourseRole.ROLETYPE.001.V01
Course role type must be 'Delivery organisation' for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
All CourseRoles
TechnicalValidity:
CourseRole.ROLETYPE <> 202
Validity:
Invalid
Category:
Guidance
QR.STUDENT.CourseRole.ROLETYPE.002.V01
Course role type must be 'Funder'.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All CourseRoles
TechnicalValidity:
CourseRole.ROLETYPE <> 401
Validity:
Invalid
Category:
Guidance
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.001.V01
Where the course has current accreditation by the General Medical Council then the provider must have a medical school and the course subjects must include clinical medicine.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Courses where at least one CurriculumAccreditation.ACCREDITATIONID.GRP_AccreditationBody = 03 and overlaps the current reference period start date (using CurriculumAccreditation.VALIDFROM and CurriculumAccreditation.VALIDTO)
TechnicalValidity:
The course has no associated QualificationSubject.QUALSUBJECT = 100267 or Provider.MEDSCHOOL = No
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C18051.Course.COURSEAIM.3
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.002.V01
Where the course has current accreditation by the General Dental Council (GDC) then the provider must have a dental school and the course subjects must include dentistry.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Courses where any CurriculumAccreditation.ACCREDITATIONID.GRP_AccreditationBody = 02 and overlaps the end of the current reference period (using CurriculumAccreditation.VALIDFROM and CurriculumAccreditation.VALIDTO)
TechnicalValidity:
The course has (no associated QualificationSubject.QUALSUBJECT = 100266, 100268, 100275 or 100283) or Provider.DENSCHOOL = No
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C18051.Course.COURSEAIM.3, QR.C18051.CourseSubject.SBJCA.20, QR.C19054.CourseSubject.SBJCA.4
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.003.V01
Where the course has current accreditation for veterinary surgeons by the Royal College of Veterinary Surgeons then the provider must have a veterinary school.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CurriculumAccreditation.ACCREDITATIONID = (12001 or 12002) and overlaps the current reference period (using CurriculumAccreditation.VALIDFROM and CurriculumAccreditation.VALIDTO)
TechnicalValidity:
Provider.VetSchool = N
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C19051.Course.COURSEAIM.1, QR.C19051.Course.COURSEAIM.3
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.004.V01
For ITT courses leading to QTS, the accreditation must be for QTS or registration with the General Teaching council or Education Workforce Council.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All Courses Course.TTCID = 01
TechnicalValidity:
All Courses where any (For England CurriculumAccreditation.ACCREDITATIONID.MRK_CurriculumAccreditationACCREDITATIONIDEngland=N) or (for Scotland CurriculumAccreditation.ACCREDITATIONID.MRK_CurriculumAccreditationACCREDITATIONIDScotland=N) or (for Northern Ireland CurriculumAccreditation.ACCREDITATIONID.MRK_CurriculumAccreditationACCREDITATIONIDNorthernIreland=N) or (for Wales and CurriculumAccreditation.ACCREDITATIONID.MRK_CurriculumAccreditationACCREDITATIONIDWales=N)
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C19054.Course.COURSEAIM.12
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.005.V01
For ITT courses not leading to QTS or registration with the General Teaching council, the curriculum accreditation must be for Further education/Higher education or Nursing and Midwifery.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses where Course.TTCID = 02 and at least one CurriculumAccreditation.ACCREDITATIONID exists
TechnicalValidity:
Any CurriculumAccreditation.ACCREDITATIONID.GRP_AccreditationBody not in (99801, 99802)
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C20051.Course.TQSSEC.3
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.006.V01
Where the accreditation submitted is for teaching, it must be associated with a teacher training course.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All Courses with CurriculumAccreditation.ACCREDITATIONID.GRP_TeachingAccreditation in (01, 02, 03, 04)
TechnicalValidity:
Course.TTCID.MRK_TeacherTraining = N
Validity:
Invalid
Category:
Valid values
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.007.V01
Where a valid to date exists, it must not be earlier than the valid from date.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CurriculumAccreditation.VALIDTO exists
TechnicalValidity:
CurriculumAccreditation.VALIDFROM > CurriculumAccreditation.VALIDTO
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.008.V01
The generic accreditation codes for the General Dental Council (GDC), the Health and Care Professions Council (HCPC) and the Nursing and Midwifery Council (NMC) must not be used.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Scottish Funding Council10%
TechnicalPopulation:
All courses with Course.CurriculumAccreditation
TechnicalValidity:
CurriculumAccreditation.ACCREDITATIONID in (05802, 06920, 11108)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.REGBODY.3
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.009.V01
The generic accreditation code for Nursing and Midwifery Council (NMC) must not be returned by your provider.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Course.CurriculumAccreditations
TechnicalValidity:
CurriculumAccreditation.ACCREDITATIONID = 11108
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.REGBODY.4, QR.C19054.Course.REGBODY.2, QR.C19054.InstancePeriod.COURSEID.1
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.010.V01
Where the course is Early years ITT any associated curriculum accreditation must be for Early Years Teacher Status (EYTS).
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Course.TTCID = 06 and Course.CurriculumAccreditation exists
TechnicalValidity:
CurriculumAccreditation.ACCREDITATIONID <> 13920
Validity:
Invalid
Category:
Guidance
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.011.V01
Accreditation codes used must be applicable to the country of the provider.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Where Course.CurriculumAccreditation exists
TechnicalValidity:
(For England MRK_CurriculumAccreditationACCREDITATIONIDEngland = N) or (for Scotland MRK_CurriculumAccreditationACCREDITATIONIDScotland = N) or (for Northern Ireland MRK_CurriculumAccreditationACCREDITATIONIDNorthernIreland = N) or (for Wales and MRK_CurriculumAccreditationACCREDITATIONIDWales = N)
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C18051.Course.REGBODY.4, QR.C19054.Course.REGBODY.2
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.012.V01
Where a course aims for a qualification in a health and social care subject, it should have a relevant accreditation associated with it.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
TBC
TechnicalValidity:
TBC
Validity:
Invalid
Category:
Guidance
QR.STUDENT.CurriculumAccreditation.ACCREDITATIONID.013.V01
Where a course has health and social care accreditation, it should have a relevant subjects associated with it.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
TBC
TechnicalValidity:
TBC
Validity:
Invalid
Category:
Guidance
QR.STUDENT.CurriculumAccreditation.CURACCID.004.V02
For ITT courses leading to QTS, the curriculum accreditation must be for registration with the General Teaching council.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Courses where Course.TTCID = 01 and at least one CurriculumAccreditation.CURACCID exists
TechnicalValidity:
Any current CurriculumAccreditation.CURACCID.GRP_AccreditationBody not in (04, 05)
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C19054.Course.COURSEAIM.12, QR.C20051.Course.TQSSEC.7, QR.C20051.Course.TQSSEC.2
QR.STUDENT.CurriculumAccreditation.CURACCID.006.V02
Where the accreditation submitted is for teaching, it must be associated with a teacher training course.
Version:
0.1
Status:
Amended
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Courses with CurriculumAccreditation.CURACCID.GRP_TeachingAccreditation = 04
TechnicalValidity:
Course.TTCID.MRK_TeacherTraining = N
Validity:
Invalid
Category:
Valid values
QR.STUDENT.CurriculumAccreditation.CURACCID.008.V01
The generic accreditation codes for the General Dental Council (GDC), the Health and Care Professions Council (HCPC) and the Nursing and Midwifery Council (NMC) must not be used.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Scottish Funding Council10%
TechnicalPopulation:
All courses with Course.CurriculumAccreditation
TechnicalValidity:
CurriculumAccreditation.CURACCID in (05802, 06920, 11108)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Course.REGBODY.3
QR.STUDENT.CurriculumAccreditation.CURACCID.012.V01
Where a course aims for a qualification in a health and social care subject, it should have at least one of the relevant accreditations associated with it.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All courses where any QualificationSubject.QUALSUBJECT.GRP_SubjectGrouping2 = 15-04
TechnicalValidity:
CurriculumAccreditation.CURACCID not in (06921, 06922, 11001, 11110, 13001, 99901, 99902)
Validity:
Invalid
Category:
Guidance
QR.STUDENT.CurriculumAccreditation.CURACCID.013.V01
Where a course aims for a qualification in social work, it should have the relevant accreditation associated with it.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
All courses where any QualificationSubject.QUALSUBJECT = 100503
TechnicalValidity:
CurriculumAccreditation.CURACCID <> 02202
Validity:
Invalid
Category:
Guidance
QR.STUDENT.CurriculumAccreditation.VALIDFROM.001.V01
The Curriculum accreditation 'valid from' date must not be after the end of the reference period.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CurriculumAccreditation.VALIDFROM exists
TechnicalValidity:
CurriculumAccreditation.VALIDFROM > RefrencePeriod.EndDate
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.CurriculumAccreditation.VALIDTO.001.V01
Where Curriculum accreditation has a 'valid to' date it must be after the 'valid from' date.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CurriculumAccreditation.VALIDTO exists
TechnicalValidity:
CurriculumAccreditation.VALIDTO < CurriculumAccreditation.VALIDFROM
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Disability.DISABILITY.001.V01
Where the student is in receipt of the disabled students' allowance (DSA), then they must be reported as having a disability.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students10 Records
Higher Education Funding Council for Wales10 Records
Department for the Economy, Northern Ireland10 Records
Scottish Funding Council10 Records
TechnicalPopulation:
Any StudentFinancialSupport.FINSUPTYPE = 100
TechnicalValidity:
No occurrence of Disability.DISABILITY.MRK_DisabilityKnown=Y (includes where disability entity does not exist)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Student.DISABLE.2, QR.C19054.StudentEquality.DISABLE.3, QR.C19054.StudentEquality.DISABLE.4
QR.STUDENT.Disability.DISABILITY.003.V01
A higher than expected number of students have a disability coded as not available.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5 Records AND 5%
Higher Education Funding Council for Wales5 Records AND 5%
Department for the Economy, Northern Ireland5 Records AND 5%
Scottish Funding Council5 Records AND 5%
TechnicalPopulation:
Students where Disability.DISABILITY exists
TechnicalValidity:
Any Disability.DISABILITY = 99
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Disability.DISABILITY.004.V01
A higher than expected number of students have a disability coded as prefer not to say.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5 Records AND 5%
Higher Education Funding Council for Wales5 Records AND 5%
Department for the Economy, Northern Ireland5 Records AND 5%
Scottish Funding Council5 Records AND 5%
TechnicalPopulation:
Students where Disability.DISABILITY exists
TechnicalValidity:
Any Disability.DISABILITY = 98
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Disability.DISABILITY.005.V01
All students have been returned with the same disability code. Please check that there has not been a miscoding.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All students where Disability.DISABILITY exists
TechnicalValidity:
Disability.DISABILITY codes are the same.
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Engagement.CollaborativeProvision.001.V01
Where any of the Collaborative Partner fields exists (PARTNERNUMHUS, PARTNERSID or PARTNERUKPRN) then all three fields must exist.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
CollaborativeProvision.PARTNERNUMHUS exists or CollaborativeProvision.PARTNERSID exists or CollaborativeProvision.PARTNERUKPRN exists
TechnicalValidity:
CollaborativeProvision.PARTNERNUMHUS does not exist or CollaborativeProvision.PARTNERSID does not exist or CollaborativeProvision.PARTNERUKPRN does not exist
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.COLFROMDATE.2, QR.C18051.Instance.COLFROMPROV.2, QR.C18051.Instance.COLFROMPROV.1, QR.C18051.Instance.NUMHUSPREV.2
QR.STUDENT.Engagement.EMPLOYINGSCHOOL.001.V01
Where the entry route is School Direct salaried or Postgraduate teaching apprenticeship then employing school must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Engagement.ENTRYRTE in (03, 10)
TechnicalValidity:
Engagement.EMPLOYINGSCHOOL does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.SDEMPLOY.1
QR.STUDENT.Engagement.EMPLOYINGSCHOOL.002.V01
Where the entry route is not School Direct salaried or Postgraduate teaching apprenticeship then employing school must not be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Engagement.ENTRYRTE not in (03, 10)
TechnicalValidity:
Engagement.EMPLOYINGSCHOOL exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.SDEMPLOY.2
QR.STUDENT.Engagement.EMPLOYINGSCHOOL.003.V01
The employing school must not be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.EMPLOYINGSCHOOL exists
Validity:
Invalid
Category:
Coverage
QR.STUDENT.Engagement.EMPLOYINGSCHOOL.004.V01
Where employing school code is not a generic code, then it must exist in the Unique Reference Number (URN) list.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Engagement.EMPLOYINGSCHOOL exists and Engagement.EMPLOYINGSCHOOL not in (900000, 900010)
TechnicalValidity:
Engagement.EMPLOYINGSCHOOL not in URN.URN
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C18051.Instance.SDEMPLOY.3
QR.STUDENT.Engagement.EMPLOYINGSCHOOL.005.V01
A higher than expected number of Engagements have an employing school of 'Not applicable/not available' or 'Establishment outside England and Wales'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records AND 10%
TechnicalPopulation:
All engagements where Engagement.EMPLOYINGSCHOOL exists
TechnicalValidity:
Engagement.EMPLOYINGSCHOOL= 900000 or 900010
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.SDEMPLOY.4
QR.STUDENT.Engagement.ENGEXPECTEDENDDATE.001.V01
Where the student is not incoming exchange and the course is not fully flexible, the expected end date of the engagement must be returned.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.INCOMINGEXCHANGE does not exist and latest StudentCoursesession Course.FULLYFLEX does not exist
TechnicalValidity:
Engagement.ENGEXPECTEDENDDATE does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.SPLENGTH.1
QR.STUDENT.Engagement.ENGEXPECTEDENDDATE.002.V01
The expected end date of the engagement must not be before the start date.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.ENGEXPECTEDENDDATE exists
TechnicalValidity:
Engagement.ENGSTARTDATE > Engagement.ENGEXPECTEDENDDATE
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.LEARNPLANENDDATE.4
QR.STUDENT.Engagement.ENGEXPECTEDENDDATE.003.V01
The expected end date of the engagement must not be more than 10 years after the start date.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.ENGEXPECTEDENDDATE exists
TechnicalValidity:
Engagement.ENGSTARTDATE + 10 years < Engagement.ENGEXPECTEDENDDATE
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.LEARNPLANENDDATE.5, QR.C18051.Instance.SPLENGTH.3, QR.C18051.Instance.SPLENGTH.4, QR.C19054.Instance.SPLENGTH.1, QR.C19054.Instance.SPLENGTH.2
QR.STUDENT.Engagement.ENGSTARTDATE.001.V01
The Engagement start date must not be earlier than 20 years before the latest Student Course Session start date.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements (exclude SessionStatus.STATUSCHANGEDTO = 04)
TechnicalValidity:
Engagement.ENGSTARTDATE < _Latest StudentCourseSession.SCSSTARTDATE - 20 years
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.COMDATE.1, QR.C19054.Instance.COMDATE.1
QR.STUDENT.Engagement.ENGSTARTDATE.001.V02
The Engagement start date must not be earlier than 20 years before the latest Student Course Session start date.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements (exclude SessionStatus.STATUSCHANGEDTO = 04)
TechnicalValidity:
Engagement.ENGSTARTDATE < Latest StudentCourseSession.SCSSTARTDATE - 20 years
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.COMDATE.1, QR.C19054.Instance.COMDATE.1
QR.STUDENT.Engagement.ENGSTARTDATE.002.V01
The Engagement start date must be earlier than the reference period end date.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.ENGSTARTDATE > Collection.RefPeriodEnd
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.COMDATE.2, QR.C19054.Instance.COMDATE.2
QR.STUDENT.Engagement.ENGSTARTDATE.003.V01
A higher than expected number of 'Part time' or 'Other full time' engagements which are active, not writing up and not aiming for Credits, have the engagement start date earlier than 7 years before the latest Student course session start date.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students100 Records AND 0%
Higher Education Funding Council for Wales100 Records AND 0%
Department for the Economy, Northern Ireland100 Records AND 0%
Scottish Funding Council100 Records AND 0%
TechnicalPopulation:
Engagements where (Latest StudentCourseSession has ((SCSMODE = 02 or SCSMODE.GRP_FullPartTimeGrouping1 = 02) and Z_STATUSENDSCS = 01 and associated Qualification.QUALCAT.MRK_QUALCATCredits = N
TechnicalValidity:
Engagement.ENGSTARTDATE < Latest StudentCourseSession.SCSSTARTDATE - 7 years
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.COMDATE.5, QR.C18051.Instance.COMDATE.7, QR.C19054.Instance.COMDATE.3
QR.STUDENT.Engagement.ENGSTARTDATE.004.V01
A higher than expected number of Full time or Accelerated full time Engagements which are active, not writing up and not medicine and dentistry, have the start date earlier than 5 years before the latest Student Course Session start date.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Engagements where latest StudentCourseSession.SCSMODE in (01, 03) and (where latest StudentCourseSession.SessionStatus exists, Z_STATUSENDSCS = 01) and all associated QualificationSubject.QUALSUBJECT.GRP_SubjectGrouping1 <> 01
TechnicalValidity:
Engagement.ENGSTARTDATE < _Latest StudentCourseSession.SCSSTARTDATE - 5 years
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.COMDATE.6, QR.C18051.Instance.COMDATE.8, QR.C19054.Instance.COMDATE.4
QR.STUDENT.Engagement.ENGSTARTDATE.006.V01
A higher than expected number of Engagements have a start date which differs from that returned in the first Student Course Session by more than 14 days.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0.5%
Higher Education Funding Council for Wales0.5%
Department for the Economy, Northern Ireland0.5%
Scottish Funding Council0.5%
TechnicalPopulation:
All Engagements
TechnicalValidity:
ABS(Engagement.ENGSTARTDATE - _EarliestSignedOff.StudentCourseSession.SCSSTARTDATE) > 14
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.COMDATE.10
QR.STUDENT.Engagement.ENGSTARTDATE.009.V01
Where the first Student course session is included in the submission, it is expected that the start date aligns with the Engagement start date.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagements where no StudentCourseSessions have been returned in a previous reference period
TechnicalValidity:
Earliest StudentCourseSession.SCSSTARTDATE <> Engagement.ENGSTARTDATE
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Engagement.ENTRYRTE.001.V01
Where course leads to QTS or registration with a General Teaching Council (GTC) and the student is not incoming exchange, then ITT entry route must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Latest associated Course.TTCID = 01 and Engagement.INCOMINGEXCHANGE does not exist
TechnicalValidity:
Engagement.ENTRYRTE does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.ENTRYRTE.4
QR.STUDENT.Engagement.ENTRYRTE.002.V01
ITT entry route must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.ENTRYRTE exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.ENTRYRTE.3
QR.STUDENT.Engagement.ENTRYRTE.003.V01
Where course does not lead to QTS or registration with a General Teaching Council (GTC) or the student is incoming exchange, then ITT entry route must not be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
All associated Course.TTCID <> 01 or Engagement.INCOMINGEXCHANGE exists
TechnicalValidity:
Engagement.ENTRYRTE does exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.ENTRYRTE.2
QR.STUDENT.Engagement.ENTRYRTE.004.V01
Where the ITT entry route is Postgraduate teaching apprenticeship, the engagement start date must be after 2018-08-31.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Engagement.ENTRYRTE = 10
TechnicalValidity:
Engagement.ENGSTARTDATE <= 2018-08-31
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.ENTRYRTE.10
QR.STUDENT.Engagement.ENTRYRTE.005.V01
All ITT entry routes have been coded as provider-led.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Submitted file has at least one Engagement.ENTRYRTE
TechnicalValidity:
All submitted Engagement.ENTRYRTE codes = 01
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.ENTRYRTE.6
QR.STUDENT.Engagement.ENTRYRTE.005.V02
All ITT entry routes have been coded as provider-led.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Submitted file has at least one Engagement.ENTRYRTE
TechnicalValidity:
All submitted Engagement.ENTRYRTE codes in (11, 12)
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.ENTRYRTE.6
QR.STUDENT.Engagement.ENTRYRTE.006.V01
All ITT entry routes have been coded as School Direct.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records
TechnicalPopulation:
Submitted file has at least one Engagement.ENTRYRTE
TechnicalValidity:
All submitted Engagement.ENTRYRTE codes in (02, 03)
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.ENTRYRTE.7
QR.STUDENT.Engagement.ENTRYRTE.007.V01
Where ITT entry route is Undergraduate opt-in, the student must be aiming for an Undergraduate qualification.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All Engagements where any associated Course.TTCID=01 and (Engagement.INCOMINGEXCHANGE does not exist.)Engagement.ENTRYRTE = 09
TechnicalValidity:
All Engagement.StudentCourseSessions returned must be associated with courses with Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.ENTRYRTE.8
QR.STUDENT.Engagement.ENTRYRTE.008.V01
Where ITT entry route is coded as School Direct or Postgraduate teaching apprenticeship, the student must be aiming for a Postgraduate qualification.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Engagement.ENTRYRTE in (02, 03, 10)
TechnicalValidity:
Latest StudentCourseSession associated Course Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 01
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.ENTRYRTE.9
QR.STUDENT.Engagement.EXPECTEDENDDATE.001.V01
Where the student is not incoming exchange and the course is not fully flexible, the expected end date of the engagement must be returned.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.INCOMINGEXCHANGE does not exist and latest StudentCoursesession Course.FULLYFLEX does not exist
TechnicalValidity:
Engagement.EXPECTEDENDDATE does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.SPLENGTH.1
QR.STUDENT.Engagement.EXPECTEDENDDATE.002.V01
The expected end date of the engagement must not be before the start date.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.EXPECTEDENDDATE exists
TechnicalValidity:
Engagement.ENGSTARTDATE > Engagement.EXPECTEDENDDATE
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.LEARNPLANENDDATE.4
QR.STUDENT.Engagement.EXPECTEDENDDATE.003.V01
The expected end date of the engagement must not be more than 10 years after the start date.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.EXPECTEDENDDATE exists
TechnicalValidity:
Engagement.ENGSTARTDATE + 10 years < Engagement.EXPECTEDENDDATE
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.LEARNPLANENDDATE.5, QR.C18051.Instance.SPLENGTH.3, QR.C18051.Instance.SPLENGTH.4, QR.C19054.Instance.SPLENGTH.1, QR.C19054.Instance.SPLENGTH.2
QR.STUDENT.Engagement.FEEELIG.001.V01
Fee eligibility must be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.FEEELIG does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.FEEELIG.1
QR.STUDENT.Engagement.FEEELIG.001.V02
Fee eligibility must be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All Engagements except where Engagement.INCOMINGEXCHANGE exists or (SessionStatus.STATUSCHANGEDTO = 02 for the entire reference period) or (Leaver.ENGENDDATE - Engagement.ENGSTARTDATE <= 14 days)
TechnicalValidity:
Engagement.FEEELIG does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.FEEELIG.1
QR.STUDENT.Engagement.FEEELIG.002.V01
Fee eligibility must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.FEEELIG exists
Validity:
Invalid
Category:
Coverage
QR.STUDENT.Engagement.FEEELIG.003.V01
Where the permanent address on entry is in the Channel Islands or Isle of Man, then fee eligibility must be coded as 'Not eligible to pay home fees'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All Engagements where EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping1=10
TechnicalValidity:
Engagement.FEEELIG <> 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.FEEELIG.5, QR.C18051.Instance.FEEELIG.6
QR.STUDENT.Engagement.FEEELIG.003.V02
Where the permanent address on entry for a student is in the Channel Islands or Isle of Man, fee eligibility must be coded as 'Eligible to pay home fees'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All Engagements where Engagement.FEEELIG exists and EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping1 = 10
TechnicalValidity:
Engagement.FEEELIG <> 01
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.FEEELIG.5, QR.C18051.Instance.FEEELIG.6
QR.STUDENT.Engagement.FEEELIG.004.V01
Where a student is fundable by the funding council they must be eligible to pay home fees.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
Engagements where any associated StudentCourseSession FundingBody.FUNDINGBODY in (5008, 5016)
TechnicalValidity:
Engagement.FEEELIG <> 01
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.FEEELIG.2, QR.C18051.Instance.FEEELIG.4
QR.STUDENT.Engagement.FEEELIG.005.V01
Where a student is fundable by the funding council they must be not be ineligible to pay home fees.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
Any StudentCourseSession with FundingBody.FUNDINGBODY in (5008, 5016)
TechnicalValidity:
Engagement.FEEELIG = 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.FEEELIG.3
QR.STUDENT.Engagement.FEESTATUS.001.V01
Fee status must be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.FEESTATUS does not exist
Validity:
Invalid
Category:
Coverage
QR.STUDENT.Engagement.FEESTATUS.002.V01
Fee status must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.FEESTATUS exists
Validity:
Invalid
Category:
Coverage
QR.STUDENT.Engagement.INCOMINGEXCHANGE.001.V01
Where a student has a study location primarily outside the UK, they cannot be coded as incoming exchange.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where any associated StudentCourseSession.StudyLocation.PRINONUK=01
TechnicalValidity:
Engagement.INCOMINGEXCHANGE exists
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.EXCHANGE.3, QR.C19054.InstancePeriod.EXCHIND.3
QR.STUDENT.Engagement.INCOMINGEXCHANGE.003.V01
Taith must not be used by your provider.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.INCOMINGEXCHANGE exists
TechnicalValidity:
Engagement.INCOMINGEXCHANGE = 04
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Engagement.INCOMINGEXCHANGE.004.V01
Taith cannot be used if the Engagement start date is before 2022-08-01.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
Engagement.INCOMINGEXCHANGE = 04
TechnicalValidity:
Engagement.ENGSTARTDATE <= 2022-07-31
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Engagement.LEADSCHOOL.001.V01
Where the ITT entry route is school direct or postgraduate teaching apprenticeship, then a lead school must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
All Engagements where Engagement.ENTRYRTE in (02, 03, 10)
TechnicalValidity:
Engagement.LEADSCHOOL does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.SDLEAD.1
QR.STUDENT.Engagement.LEADSCHOOL.002.V01
Where the ITT entry route is not school direct or postgraduate teaching apprenticeship, then a lead school must not be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
All Engagements where Engagement.ENTRYRTE does not exist or Engagement.ENTRYRTE not in (02, 03, 10)
TechnicalValidity:
Engagement.LEADSCHOOL exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.SDLEAD.2
QR.STUDENT.Engagement.LEADSCHOOL.003.V01
The lead school must be a valid URN (Unique Reference Number).
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Department for Education Early Years and Schools Group0%
TechnicalPopulation:
Engagement.LEADSCHOOL exists and Engagement.LEADSCHOOL not in (900000, 900010)
TechnicalValidity:
Engagement.LEADSCHOOL not in URN.URN
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C18051.Instance.SDLEAD.3
QR.STUDENT.Engagement.LEADSCHOOL.004.V01
A higher than expected number of students have been returned with a generic code.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students10%
TechnicalPopulation:
Engagement.LEADSCHOOL exists
TechnicalValidity:
Engagement.LEADSCHOOL in (900000, 900010)
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.Instance.SDLEAD.4
QR.STUDENT.Engagement.LEADSCHOOL.005.V01
Lead school must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.LEADSCHOOL exists
Validity:
Invalid
Category:
Coverage
QR.STUDENT.Engagement.Leaver.001.V01
Where a student has withdrawn, a leaver entity must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where latest StudentCourseSession.RSNSCSEND = 01
TechnicalValidity:
Associated Engagement.Leaver entity does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.ENDDATE.1, QR.C18051.Instance.RSNEND.1
QR.STUDENT.Engagement.Leaver.002.V01
A leaver entity must not be returned where the Student course session does not have an end date.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement where Latest.StudentCourseSession exists and Latest.StudentCourseSession.SCSENDDATE does not exist
TechnicalValidity:
Engagement.Leaver entity exists
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.ENDDATE.10, QR.C18051.Instance.RSNEND.2
QR.STUDENT.Engagement.Leaver.003.V01
The student has been awarded a qualification but has not been returned as a Leaver. Please check that the leaver data has not been omitted in error.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where any QualificationAwarded Qualification.QUALCAT in (D0003, E0000, M0002, M0003, M0004, M0006, M0007, M0016, M0018, M0021, H0003, H0004, H0005, H0009) and latest StudentCourseSession has StudentCourseSession.INTERCALATION does not exist.
TechnicalValidity:
Engagement.Leaver entity does not exist
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.ENDDATE.11, QR.C18051.Instance.RSNEND.8, QR.C18051.Instance.RSNEND.3, QR.C19054.Instance.ENDDATE.6, QR.C19054.Instance.RSNEND.2
QR.STUDENT.Engagement.Leaver.004.V01
A higher than expected number of students where a qualification has been awarded have no Leaver entity returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students20%
Higher Education Funding Council for Wales20%
Department for the Economy, Northern Ireland20%
Scottish Funding Council20%
TechnicalPopulation:
All Engagements where any QualificationAwarded entity exists
TechnicalValidity:
Engagement.Leaver entity does not exist.
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.ENDDATE.11, QR.C18051.Instance.RSNEND.8, QR.C18051.Instance.RSNEND.3, QR.C19054.Instance.ENDDATE.6, QR.C19054.Instance.RSNEND.4
QR.STUDENT.Engagement.Leaver.005.V01
No students have left their programme of study this Reference Period.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records
Higher Education Funding Council for Wales0 Records
Department for the Economy, Northern Ireland0 Records
Scottish Funding Council0 Records
TechnicalPopulation:
Submitted file has at least one Student.Engagement entity
TechnicalValidity:
No Engagement.Leaver entities exist across submitted file
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C19054.Instance.RSNEND.6
QR.STUDENT.Engagement.NHSEMP.001.V01
Where the Engagement is associated with a course with post-registration health and social care accreditation, the NHS employer must be returned.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Engagements with any associated StudentCourseSession Course CurriculumAccreditation.ACCREDITATIONID.MRK_PostRegistrationHealth = Y
TechnicalValidity:
Engagement.NHSEMP does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.NHSEMP.1
QR.STUDENT.Engagement.NHSEMP.001.V02
Where the Engagement is associated with a course with post-registration health and social care accreditation, the NHS employer must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Engagements with any associated StudentCourseSession Course CurriculumAccreditation.CURACCID.MRK_PostRegistrationHealth = Y
TechnicalValidity:
Engagement.NHSEMP does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.NHSEMP.1
QR.STUDENT.Engagement.NHSEMP.002.V01
NHS employer must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.NHSEMP exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.NHSEMP.2
QR.STUDENT.Engagement.NHSEMP.003.V01
Where the Engagement is not associated with any courses with post-registration health and social care accreditation, the NHS employer must not be returned.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Engagements with no associated StudentCourseSession Course CurriculumAccreditation.ACCREDITATIONID.MRK_PostRegistrationHealth = Y
TechnicalValidity:
Engagement.NHSEMP exists
Validity:
Invalid
Category:
Coverage
QR.STUDENT.Engagement.NUMHUS.003.V01
An Engagement which was previously returned as 'Left and awarded credit or a qualification' has been returned again.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagements where _LatestSignedOff.Leaver.RSNENGEND = 01
TechnicalValidity:
Student.SID and Engagement.NUMHUS included in this submission.
Validity:
Invalid
Category:
Continuity
LegacyRuleId:
QR.C18051.Instance.RSNEND.12, QR.C19054.Instance.RSNEND.8
QR.STUDENT.Engagement.NUMHUS.008.V01
A student has been dormant for between 5 and 10 years and has not been included in the submission. Please check the student has not returned to study or left the Engagement.
Version:
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where _LatestSignedOff.StudentCourseSession.Z_STATUSSTARTSCS = 02 and _LatestSignedOff.StudentCourseSession.SCSENDDATE exists and _LatestSignedOff.StudentCourseSession.SCSENDDATE < (RPStartdate - 5 years) and _LatestSignedOff.StudentCourseSession.SCSENDDATE >= (RPStartdate - 10 years)
TechnicalValidity:
Student.SID and Engagement.NUMHUS do not exist
Validity:
Invalid
Category:
Continuity
LegacyRuleId:
QR.C18051.Instance.ENDDATE.15, QR.C18051.Instance.ENDDATE.16, QR.C19054.Instance.ENDDATE.8
QR.STUDENT.Engagement.NUMHUS.009.V01
A student has been dormant for over 10 years and has not been included in the submission. Please check the student has not returned to study or left the Engagement.
Version:
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where _LatestSignedOff.StudentCourseSession.Z_STATUSSTARTSCS = 02 and _LatestSignedOff.StudentCourseSession.SCSENDDATE exists and _LatestSignedOff.StudentCourseSession.SCSENDDATE < (RPStartdate - 10 years)
TechnicalValidity:
Student.SID and Engagement.NUMHUS do not exist
Validity:
Invalid
Category:
Continuity
LegacyRuleId:
QR.C18051.Instance.ENDDATE.15, QR.C18051.Instance.ENDDATE.16, QR.C19054.Instance.ENDDATE.8
QR.STUDENT.Engagement.QTS.001.V01
Where a student is on a teacher training INSET course and not incoming exchange, then QTS status of the student must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
Engagement.INCOMINGEXCHANGE does not exist and any (StudentCourseSessions have Course.TTCID = 03)
TechnicalValidity:
Engagement.QTS does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.QTS.1
QR.STUDENT.Engagement.QTS.002.V01
Where a student is not on a teacher training INSET course or is an incoming exchange student, the QTS status of the student must not be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
NOT(Engagement.INCOMINGEXCHANGE does not exist and Latest StudentCourseSession Course.TTCID = 03)
TechnicalValidity:
Engagement.QTS exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.QTS.5
QR.STUDENT.Engagement.QTS.003.V01
The QTS status of the student must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.QTS exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.QTS.4
QR.STUDENT.Engagement.QTS.004.V01
Where QTS field is returned and the highest qualification on entry leads to QTS, PCGE or PGDE, then student must hold Qualified Teacher Status.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.HIGHESTQOE in (H0002, M0016, H0013) and Engagement.QTS exists
TechnicalValidity:
Engagement.QTS = 02
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.QTS.2, QR.C18051.Instance.QTS.6, QR.C18051.Instance.QTS.7, QR.C18051.Instance.QTS.9
QR.STUDENT.Engagement.QTS.005.V01
The student must not hold Qualified Teacher Status, where it is returned, if the highest qualification on entry is at level C or below.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
(SUBSTR(EntryProfile.HIGHESTQOE,1,1) in (P, Q, R, X) and EntryProfile.HIGHESTQOE <> X0003) and Engagement.QTS exists
TechnicalValidity:
Engagement.QTS = 01
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.QTS.3, QR.C18051.Instance.QTS.8
QR.STUDENT.Engagement.QualificationAwarded.001.V01
Where the student has left with a 'credit or qualification', then a qualification awarded entity must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.Leaver entity exists and Leaver.RSNENGEND = 01
TechnicalValidity:
Engagement.QualificationAwarded entity does not exist
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.QualificationsAwarded.1, QR.C19054.InstancePeriod.QualificationsAwarded.2
QR.STUDENT.Engagement.QualificationAwarded.002.V01
Where a student does not progress beyond two weeks, then a qualification must not be awarded.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where (Leaver.ENGENDDATE - Engagement.ENGSTARTDATE) <= 14 days and where Engagement.EXPECTEDENDDATE exists ((Engagement.EXPECTEDENDDATE - Engagement.ENGSTARTDATE) > 14 days)
TechnicalValidity:
Engagement.QualificationAwarded entity exists
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.QualificationsAwarded.3
QR.STUDENT.Engagement.QualificationAwarded.003.V01
The total number of qualifications awarded is lower than expected when compared to the figure for the previous year.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students-10%
Higher Education Funding Council for Wales-10%
Department for the Economy, Northern Ireland-10%
Scottish Funding Council-10%
TechnicalPopulation:
Count QualificationAwarded for previous year comparable reference period where Z_POPQUAL_RP = 1
TechnicalValidity:
Count QualificationAwarded where Z_POPQUAL_RP = 1
Validity:
Invalid
Category:
Credibility report
LegacyRuleId:
QR.C18051.QualificationsAwarded.QUAL.19
QR.STUDENT.Engagement.RCSTDID.001.V01
A higher than expected number of engagements have been returned without a Research Council identifier where the student is funded by a Research Council and is not an incoming exchange student.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students2%
Higher Education Funding Council for Wales2%
Department for the Economy, Northern Ireland2%
Scottish Funding Council2%
TechnicalPopulation:
Engagement.RCSTNDT exists and <> 9997
TechnicalValidity:
Engagement.RCSTDID does not exist
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Engagement.RCSTDID.001.V02
A higher than expected number of engagements have been returned without a Research Council identifier where the student is funded by a Research Council and is not an incoming exchange student.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students10%
Higher Education Funding Council for Wales10%
Department for the Economy, Northern Ireland10%
Scottish Funding Council10%
TechnicalPopulation:
Engagement.RCSTNDT exists and <> 9997
TechnicalValidity:
Engagement.RCSTDID does not exist
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Engagement.RCSTDNT.001.V01
Where non-incoming exchange students are on a programme of study at postgraduate level (excluding PGCE and PGDE), the Research Council student data must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.INCOMINGEXCHANGE does not exist and any StudentCourseSession has associated Course (Qualification.QUALCAT.GRP_LevelofStudyGrouping2 in (01, 02) and Qualification.QUALCAT.MRK_PGCE_PGDE = N)
TechnicalValidity:
Engagement.RCSTDNT does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.RCSTDNT.1
QR.STUDENT.Engagement.RCSTDNT.003.V01
Where a student receives Research Council funding, the associated course subject must not be a generic code.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.RCSTDNT exists and Engagement.RCSTDNT <> 9997
TechnicalValidity:
latest StudentCourseSession.SCSESSIONID associated Course Qualification where QualificationSubject.QUALSUBJECT in (100390, 101273, 101274, 101275, 101276, 101277, 101278, 101279)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19051.CourseSubject.SBJCA.1
QR.STUDENT.Engagement.RCSTDNT.007.V01
Only students studying at postgraduate level would be expected to be returned as having been funded in whole or part by a Research Council.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records AND 0%
Higher Education Funding Council for Wales0 Records AND 0%
Department for the Economy, Northern Ireland0 Records AND 0%
Scottish Funding Council0 Records AND 0%
TechnicalPopulation:
Engagement.RCSTDNT exists
TechnicalValidity:
Engagement.INCOMINGEXCHANGE exists or no occurrence of Qualification.QUALCAT starts with D, E, L or M (except M0002, M0016 and M0018).
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C20051.Instance.RCSTDNT.5
QR.STUDENT.Engagement.RCSTDNT.009.V01
A Research Council has been returned as funding, in whole or in part, an engagement but has not been recorded as a majority source of tuition for any student course session.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All engagements where Engagement.RCSTDNT exists and Engagement.RCSTDNT <> 9997
TechnicalValidity:
(StudentCourseSession.INVOICEHESAID exists and all (StudentCourseSession.INVOICEHESAID.GRP_FundableBy <> 03 or StudentCourseSession.INVOICEHESAID <> 5045)) or StudentCourseSession.INVOICEHESAID does not exist
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Engagement.SCN.001.V01
Where the student's country of permanent address on entry is in Scotland and they are studying for an undergraduate qualification, then Scottish candidate number must be returned.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
Student has any Engagement with (EntryProfile.PERMADDCOUNTRY=XH and any StudentCourseSession.Course.SUBSTR(Qualification.QUALCAT,1,1) in (H, I, J, C))
TechnicalValidity:
Engagement.SCN does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Student.SCN.3
QR.STUDENT.Engagement.SCN.002.V01
Where the student's country of permanent address on entry is in Scotland, they entered through UCAS and are studying for an undergraduate qualification, then Scottish candidate number must be returned.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
Student has any Engagement with (EntryProfile.PERMADDCOUNTRY=XH and EntryProfile.UCASSCHEMECODE exist and any StudentCourseSession.Course.SUBSTR(Qualification.QUALCAT,1,1) in (H, I, J, C))
TechnicalValidity:
Student.SCN does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Student.SCN.2
QR.STUDENT.Engagement.SCN.003.V01
Scottish candidate number must pass the Checksum test. Details of the Checksum calculation can be found in the coding manual.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.SCN exists and Engagement.SCN <> 999999999
TechnicalValidity:
_Checksum(Engagement.SCN) = FALSE
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C18051.Student.SCN.1
QR.STUDENT.Engagement.SCN.004.V01
Scottish Candidate Number (SCN) has changed from a known to an unknown value.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
TODO - continuity
TechnicalValidity:
TODO - continuity
Validity:
Invalid
Category:
Continuity
LegacyRuleId:
QR.C18051.Student.SCN.8
QR.STUDENT.Engagement.STUDYINTENTION.001.V01
Where the student is studying a research based higher degree at level L, the study intention must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
All Engagements where the latest associated StudentCourseSession has Course.Qualification.QUALCAT = L0000
TechnicalValidity:
Engagement.STUDYINTENTION does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C19054.Instance.INTENTLEV.1, QR.C18051.Instance.INTENTLEV.2
QR.STUDENT.Engagement.STUDYINTENTION.003.V01
Study intention must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.STUDYINTENTION exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C19054.Instance.INTENTLEV.4, QR.C18051.Instance.INTENTLEV.1
QR.STUDENT.Engagement.STUDYINTENTION.004.V01
A higher than expected number of students have been returned with a study intention of 'Not available'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students10 Records AND 10%
TechnicalPopulation:
Engagement.STUDYINTENTION exists
TechnicalValidity:
Engagement.STUDYINTENTION = 99999
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C19054.Instance.INTENTLEV.3, QR.C18051.Instance.INTENTLEV.4
QR.STUDENT.Engagement.StudentAccreditationAim.001.V01
Where the student is not on the first year of a course with a generic Nursing and Midwifery Council accreditation, they must have the specialism returned on Student Course Session.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where latest StudentCourseSession has (associated Course.CurriculumAccreditation.ACCREDITATIONID = 11108) and (YEARPRG > 1 or Engagement.ENGSTARTDATE < ReferencePeriodEndDate - 1)
TechnicalValidity:
Engagement.StudentAccreditationAim does not exist or all StudentAccreditationAim.ACCREDITATIONID.GRP_AccreditationBody <> 14
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.Instance.COURSEID.3, QR.C19054.Course.REGBODY.2, QR.C19054.InstancePeriod.COURSEID.2
QR.STUDENT.Engagement.StudentAccreditationAim.002.V01
Where the student is on a teacher training course, then a student accreditation must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records
Higher Education Funding Council for Wales0 Records
TechnicalPopulation:
Students where the associated Course.TTCID in (01, 02)
TechnicalValidity:
Engagement.StudentAccreditationAim entity does not exist
Validity:
Invalid
Category:
Coverage
QR.STUDENT.Engagement.StudentAccreditationAim.003.V01
Where the student is on a teacher training course, then a specific accreditation from the Department for Education (England) or the Education Workforce Council (EWC) must be returned.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All students where Engagement.StudentAccreditationAim exists and Course.TTCID = 01 or 02
TechnicalValidity:
No occurrence of StudentAccreditationAim.ACCREDITATIONID.GRP_AccreditationBody in (01, 19)
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Engagement.StudentAccreditationAim.004.V01
The number of student accreditation aims for an engagement is higher than expected.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagements where at least one Engagement.StudentAccreditationAim entity exists
TechnicalValidity:
Count(Engagement.StudentAccreditationAim)>3
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Engagement.StudentCourseSession.001.V01
Where an Engagement has not been returned previously a Student course session must be submitted.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement exists and Engagement has not been returned previously
TechnicalValidity:
Engagement.StudentCourseSession does not exist
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Engagement.StudentCourseSession.002.V01
The student course session has a higher than expected number of venues (3) associated.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
StudentCourseSessions where any StudyLocation.VENUEID exists
TechnicalValidity:
COUNT distinct (StudyLocation.VENUEID) >3
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Engagement.StudentCourseSession.003.V01
Where more than one Student course session has been returned for an Engagement, they must cover distinct time periods and not overlap.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where Count(Engagement.StudentCourseSession) > 1
TechnicalValidity:
Using StudentCourseSession.SCSSTARTDATE and NVL(StudentCourseSession.SCSENDDATE, 9999-12-31) multiple StudentCourseSessions overlap
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Engagement.StudentCourseSession.004.V01
Student course session must exist where no Leaver entity has been returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where Engagement.Leaver does not exist
TechnicalValidity:
Engagement.StudentCourseSession does not exist
Validity:
Invalid
Category:
Guidance
QR.STUDENT.Engagement.StudentCourseSession.005.V01
No more than 2 Student course sessions are expected to be returned for an Engagement in a single reference period.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where Engagement.StudentCourseSession exists
TechnicalValidity:
Count(Engagement.StudentCourseSession) > 2
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Engagement.StudentInitiative.001.V01
More than three student initiatives have been returned for this engagement. Please check that this is correct.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.StudentInitiative entity exists
TechnicalValidity:
COUNT(Engagement.StudentInitiative entities)>3
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Engagement.StudentInitiatives.001.V01
More than three student initiatives have been returned for this engagement. Please check that this is correct.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.StudentInitiatives entity exists
TechnicalValidity:
COUNT(Engagement.StudentInitiatives entities)>3
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.Engagement.TRN.001.V01
Teacher reference number must not be returned for your provider.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements
TechnicalValidity:
Engagement.TRN exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C21051.Instance.TREFNO.2
QR.STUDENT.Engagement.TRN.002.V01
Where the student is on a course leading to QTS, then teacher reference number must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
All Engagements where latest StudentCourseSession has associated Course.TTCID = 01
TechnicalValidity:
Engagement.TRN does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.TREFNO.6
QR.STUDENT.Engagement.TRN.003.V01
Where a course does not lead to QTS the Teacher reference number must not be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
TechnicalPopulation:
All Engagements where latest StudentCourseSession has associated Course.TTCID <> 01
TechnicalValidity:
Engagement.TRN exists
Validity:
Invalid
Category:
Coverage
QR.STUDENT.Engagement.TRN.004.V01
Where the student has gained QTS from a BEd award, then teacher reference number must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
All Engagements where latest StudentCourseSession has associated Course.TTCID=01 and any (QualificationAwardAccreditation.ACCREDITATIONID.GRP_TeachingAccreditation=03) and (QualificationAwarded.Qualification.QUALCAT in (H0003, I0001)) and Engagement.INCOMINGEXCHANGE does not exist
TechnicalValidity:
Engagement.TRN does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.TREFNO.1
QR.STUDENT.Engagement.TRN.005.V01
Where the student has not gained QTS, then teacher reference number must not be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
Engagement.TRN exists
TechnicalValidity:
Engagements where latest StudentCourseSession has associated Course.TTCID=01 and any (QualificationAwardAccreditation.ACCREDITATIONID.GRP_TeachingAccreditation=03 and (the awarded Qualification.QUALCAT in (M0016, M0018, H0003, H0013, I0001, I0005)) and Engagement.INCOMINGEXCHANGE does not exist.
Validity:
Valid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.TREFNO.1
QR.STUDENT.Engagement.TRN.006.V01
A higher than expected number of students on an accredited QTS course gaining PGCE, PGDE or QTS award only have no teacher reference number returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales5 Records AND 10%
TechnicalPopulation:
All Engagements with latest StudentCourseSession with associated Course.TTCID=01 and any (QualificationAwardAccreditation.ACCREDITATIONID.GRP_TeachingAccreditation=03 and QualificationAwarded Qualification.QUALCAT in (M0016, M0018, H0013, I0005)) and Engagement.INCOMINGEXCHANGE does not exist
TechnicalValidity:
Engagement.TRN does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.Instance.TREFNO.3
QR.STUDENT.Engagement.TRN.007.V01
Teacher reference number must be seven digits.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
TechnicalPopulation:
Engagement.TRN exists and Engagement.TRN not in (999999998, 999999999)
TechnicalValidity:
_REGEX{Engagement.TRN, [0-9]{7})
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C18051.Instance.TREFNO.7
QR.STUDENT.EntryProfile.ACCESSPRG.001.V01
Where a student has a highest qualification on entry of HE access course, then Access programme must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
Submitted EntryProfile.HIGHESTQOE in (X0000, X0001)
TechnicalValidity:
EntryProfile.ACCESSPRG does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.ACCESS.1
QR.STUDENT.EntryProfile.ACCESSPRG.002.V01
Access programme must not be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All submitted Entry Profiles
TechnicalValidity:
EntryProfile.ACCESSPRG exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.ACCESS.2
QR.STUDENT.EntryProfile.ACCESSPRG.003.V01
Access programme differs from that returned previously.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
All engagements where EntryProfile.ACCESSPRG exists and _LatestSignedOff.EntryProfile.ACCESSPRG exists.
TechnicalValidity:
EntryProfile.ACCESSPRG differs from _LatestSignedOff.EntryProfile.ACCESSPRG
Validity:
Invalid
Category:
Continuity
LegacyRuleId:
QR.C18051.EntryProfile.ACCESS.3
QR.STUDENT.EntryProfile.APELCRD.001.V01
APEL credits must not be returned by your provider.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile entity exists
TechnicalValidity:
EntryProfile.APELCRD exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.APELCRD.1
QR.STUDENT.EntryProfile.APELCRD.002.V01
Students entering with credit points have not been recorded as APEL (Accreditation of Prior Experiential Learning). Please check and return this field where the Credits points are as a result of APEL.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
EntryProfile.CRDPTSTU exists
TechnicalValidity:
EntryProfile.APELCRD does not exist
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C20051.EntryProfile.APELCRD.2
QR.STUDENT.EntryProfile.APELCRD.003.V01
APEL credits must be 0 or greater.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfile.APELCRD exists
TechnicalValidity:
EntryProfile.APELCRD <0
Validity:
Invalid
Category:
Valid values
QR.STUDENT.EntryProfile.APELCRD.004.V01
Where APEL credits have been returned then the credit transfer points and scheme it is assigned to must be returned too.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfile.APELCRD exists
TechnicalValidity:
EntryProfile.CRDPTSTU does not exist or EntryProfile.CRDSCM does not exist
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C20051.EntryProfile.APELCRD.4
QR.STUDENT.EntryProfile.APELCRD.005.V01
The APEL differs from that previously returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfile.APELCRD exists or _LatestSignedOff.EntryProfile.APELCRD exists
TechnicalValidity:
EntryProfile.APELCRD <> _LatestSignedOff.EntryProfile.APELCRD (include exists to not exists and vice versa)
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C20051.EntryProfile.APELCRD.3
QR.STUDENT.EntryProfile.CARELEAVER.001.V01
Where the student started their programme of study after 2014-07-31 and their permanent address on entry is in the UK or European Union, then Care leaver must be returned.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping3 in (01,02,03,05) and Engagement.ENGSTARTDATE >2014-07-31
TechnicalValidity:
EntryProfile.CARELEAVER does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.CARELEAVER.17
QR.STUDENT.EntryProfile.CARELEAVER.002.V01
Care leaver must be returned where student started after 2013-08-01 if they are a UCAS entrant studying for PGCE/PGDE or at undergraduate level.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
EntryProfile.UCASSCHEMECODE exists and _EarliestSCS.StudentCourseSession Course.(Qualification.QUALCAT.GRP_LevelofStudyGrouping1=02 or Qualification.QUALCAT.MRK_PGCE_PGDE=Y) and Engagement.ENGSTARTDATE > 2013-07-31
TechnicalValidity:
EntryProfile.CARELEAVER does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.CARELEAVER.8
QR.STUDENT.EntryProfile.CARELEAVER.003.V01
Care leaver must be returned for students who started their programme of study after 2013-07-31, are fundable by the OfS or the DfE, who are not incoming exchange students and are studying for one of the qualifications listed in the coverage statement in the data dictionary.
Version:
0.3
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Engagement.INCOMINGEXCHANGE does not exist and Engagement.ENGSTARTDATE > 2013-07-31 and _EarliestSignedOff.StudentCourseSession has (FundingBody.FUNDINGBODY in (5016, 5020) and (Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02 or Qualification.QUALCAT.MRK_PGCE_PGDE = Y) and Qualification.QUALCAT not in (H0009, H0010))
TechnicalValidity:
EntryProfile.CARELEAVER does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.CARELEAVER.1, QR.C18051.EntryProfile.CARELEAVER.3
QR.STUDENT.EntryProfile.CARELEAVER.004.V01
Care leaver must be returned for non-incoming exchange students starting between 2013-07-31 and 2014-08-01 where their permanent address on entry is in the UK.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY.MRK_AllUnitedKingdom=Y and Engagement.ENGSTARTDATE > 2013-07-31 and Engagement.ENGSTARTDATE < 2014-08-01 and Engagement.INCOMINGEXCHANGE does not exist
TechnicalValidity:
EntryProfile.CARELEAVER does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.CARELEAVER.6
QR.STUDENT.EntryProfile.CARELEAVER.005.V01
Care leaver must be returned for students with a permanent address on entry is in the UK and who are initially studying for an undergraduate, PGCE or PGDE qualification.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping3 in (01, 02) and (_EarliestSCS has Course.Qualification.QUALCAT.GRP_LevelofStudyGrouping1=02 or Qualification.QUALCAT.MRK_PGCE_PGDE=Y)
TechnicalValidity:
EntryProfile.CARELEAVER does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.CARELEAVER.9
QR.STUDENT.EntryProfile.CARELEAVER.006.V01
Care leaver must not be returned outside the stated coverage.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.CARELEAVER exists
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY.MRK_AllUnitedKingdom=Y and _EarliestSCS.StudentCourseSession has Course.(Qualification.QUALCAT.GRP_LevelofStudyGrouping1=02 or Qualification.QUALCAT.MRK_PGCE_PGDE=Y)
Validity:
Valid
Category:
Coverage
QR.STUDENT.EntryProfile.CARELEAVER.006.V02
Care leaver must not be returned outside the stated coverage.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.CARELEAVER exists
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY.MRK_AllUnitedKingdom=Y and _EarliestSCS.StudentCourseSession has Course.(Qualification.QUALCAT.GRP_LevelofStudyGrouping1=02 or Qualification.QUALCAT.MRK_PGCE_PGDE=Y)
Validity:
Valid
Category:
Coverage
QR.STUDENT.EntryProfile.CARELEAVER.007.V01
Care leaver must not be returned outside the stated coverage.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.CARELEAVER exists
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY.MRK_AllUnitedKingdom=Y and Engagement.ENGSTARTDATE > 2013-07-31 and Engagement.ENGSTARTDATE < 2014-08-01 and Engagement.INCOMINGEXCHANGE does not exist
Validity:
Valid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.CARELEAVER.7
QR.STUDENT.EntryProfile.CARELEAVER.008.V01
Care leaver must not be returned outside the stated coverage.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfile.CARELEAVER exists
TechnicalValidity:
Engagement.INCOMINGEXCHANGE does not exist and Engagement.ENGSTARTDATE > 2013-07-31 and _EarliestSCS.StudentCourseSession has (FundingBody.FUNDINGBODY in (5016, 5020) and _EarliestSCS has (Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02 or Qualification.QUALCAT.MRK_PGCE_PGDE = Y) and Qualification.QUALCAT not in (H0009, H0010))
Validity:
Valid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.CARELEAVER.5
QR.STUDENT.EntryProfile.CARELEAVER.009.V01
Care leaver must not be returned outside the stated coverage.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
EntryProfile.CARELEAVER exists
TechnicalValidity:
(EntryProfile.PERMADDCOUNTRY.GRP_GeographicGrouping3 in (01, 02, 03, 05) and Engagement.ENGSTARTDATE >2014-07-31) or (EntryProfile.UCASSCHEMECODE exists and _EarliestSCS.StudentCourseSession Course.(Qualification.QUALCAT.GRP_LevelofStudyGrouping1=02 or Qualification.QUALCAT.MRK_PGCE_PGDE=Y) and Engagement.ENGSTARTDATE >2013-07-31)
Validity:
Valid
Category:
Coverage
QR.STUDENT.EntryProfile.CARELEAVER.010.V01
Care leaver codes used must be applicable to the country of the provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.CARELEAVER exists
TechnicalValidity:
(For England EntryProfile.CARELEAVER.MRK_EntryProfileCARELEAVEREngland = N) or (for Scotland EntryProfile.CARELEAVER.MRK_EntryProfileCARELEAVERScotland = N) or (for Northern Ireland EntryProfile.CARELEAVER.MRK_EntryProfileCARELEAVERNorthernIreland = N) or (for Wales and EntryProfile.CARELEAVER.MRK_EntryProfileCARELEAVERWales = N)
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C18051.EntryProfile.CARELEAVER.10, QR.C18051.EntryProfile.CARELEAVER.11, QR.C18051.EntryProfile.CARELEAVER.2
QR.STUDENT.EntryProfile.CARELEAVER.012.V01
Care leaver has changed from a known to an unknown or information refused value.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.CARELEAVER exists and _LatestSignedOff.EntryProfile.CARELEAVER.MRK_CareleaverKnown = Y
TechnicalValidity:
Submitted EntryProfile.CARELEAVER.MRK_CareleaverKnown = N Unknown
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.CARELEAVER.15
QR.STUDENT.EntryProfile.CARELEAVER.013.V01
Care leaver differs from that returned previously.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.CARELEAVER exists and EntryProfile.CARELEAVER.MRK_CareleaverKnown =N and _LatestSignedOff.EntryProfile.CARELEAVER exists and _LatestSignedOff.EntryProfile.CARELEAVER.MRK_CareleaverKnown = N
TechnicalValidity:
Submitted EntryProfile.CARELEAVER <> _LatestSignedOff.EntryProfile.CARELEAVER
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.CARELEAVER.16
QR.STUDENT.EntryProfile.CARELEAVER.014.V01
A higher than expected number of care leavers have been returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students10 Records AND 3%
Higher Education Funding Council for Wales10 Records AND 3%
Department for the Economy, Northern Ireland10 Records AND 3%
Scottish Funding Council10 Records AND 3%
TechnicalPopulation:
Submitted EntryProfile.CARELEAVER exists
TechnicalValidity:
EntryProfile.CARELEAVER.MRK_IsCareleaver = Y
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.EntryProfile.CARELEAVER.13
QR.STUDENT.EntryProfile.CRDPTSTU.001.V01
The number of credit points counting towards the student's current study must not be returned by your organisation.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All EntryProfiles
TechnicalValidity:
EntryProfile.CRDPTSTU exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.CRDPTSTU.1
QR.STUDENT.EntryProfile.CRDPTSTU.002.V01
No students have been returned with credit points counting towards their current study.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
Submitted file contains more than 200 Engagement.EntryProfiles
TechnicalValidity:
No EntryProfile.CRDPTSTU exists
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C20051.EntryProfile.CRDPTSTU.2
QR.STUDENT.EntryProfile.CRDPTSTU.003.V01
The number of credit points differs from that previously returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfile.CRDPTSTU exists and _LatestSignedOff.EntryProfile.CRDPTSTU exists
TechnicalValidity:
EntryProfile.CRDPTSTU <> _LatestSignedOff.EntryProfile.CRDPTSTU
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C20051.EntryProfile.CRDPTSTU.7
QR.STUDENT.EntryProfile.CRDPTSTU.004.V01
It is not expected that credit points counting towards the current study will exceed 300.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfile.CRDPTSTU exists
TechnicalValidity:
EntryProfile.CRDPTSTU > 300
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C20051.EntryProfile.CRDPTSTU.6
QR.STUDENT.EntryProfile.CRDPTSTU.005.V01
Credits points counted towards study must be 0 or greater
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfile.CRDPTSTU exists
TechnicalValidity:
EntryProfile.CRDPTSTU <0
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C20051.EntryProfile.CRDPTSTU.5
QR.STUDENT.EntryProfile.CRDPTSTU.005.V01
Credits points counted towards study must be 0 or greater
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfile.CRDPTSTU exists
TechnicalValidity:
EntryProfile.CRDPTSTU <0
Validity:
Invalid
Category:
Valid values
LegacyRuleId:
QR.C20051.EntryProfile.CRDPTSTU.5
QR.STUDENT.EntryProfile.CRDSCM.001.V01
The credit points transfer scheme must not be returned by your organisation.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All EntryProfiles
TechnicalValidity:
EntryProfile.CRDSCM exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.CRDSCM.1
QR.STUDENT.EntryProfile.CRDSCM.002.V01
Where either the number of credit points or the credit points transfer scheme have been returned, both fields must be submitted.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfiles where EntryProfile.CRDSCM exists or EntryProfile.CRDPTSTU exists
TechnicalValidity:
EntryProfile.CRDSCM does not exist or EntryProfile.CRDPTSTU does not exist
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C20051.EntryProfile.CRDPTSTU.3, QR.C20051.EntryProfile.CRDSCM.2
QR.STUDENT.EntryProfile.DEPENDANT.001.V01
Where the student's permanent address on entry is Northern Ireland and they are not incoming exchange, then Dependant must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY = XG and Engagement.INCOMINGEXCHANGE does not exist
TechnicalValidity:
EntryProfile.DEPENDANT does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.NIDEPEND.1
QR.STUDENT.EntryProfile.DEPENDANT.002.V01
Dependant must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Scottish Funding Council0%
TechnicalPopulation:
All EntryProfiles
TechnicalValidity:
EntryProfile.DEPENDANT exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.NIDEPEND.2
QR.STUDENT.EntryProfile.DEPENDANT.003.V01
Dependant coding differs from that returned previously.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.DEPENDANT exists and <> 99 and _LatestSignedOff.EntryProfile.DEPENDANT exists
TechnicalValidity:
EntryProfile.DEPENDANT <> _LatestSignedOff.DEPENDANT
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.NIDEPEND.3
QR.STUDENT.EntryProfile.DEPENDANT.004.V01
Dependant has changed from a known to an unknown value.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.DEPENDANT exists and _LatestSignedOff.EntryProfile.DEPENDANT exists.
TechnicalValidity:
EntryProfile.DEPENDANT = 99 and _LatestSignedOff.EntryProfile.DEPENDANT <> 99
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.NIDEPEND.4
QR.STUDENT.EntryProfile.DEPENDANT.005.V01
Where the student's permanent address on entry is not Northern Ireland or they are incoming exchange, then Dependant is not expected to be returned.
Version:
0.1
Status:
Deleted
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY <> XG or Engagement.INCOMINGEXCHANGE exists
TechnicalValidity:
EntryProfile.DEPENDANT exists
Validity:
Invalid
Category:
Coverage
QR.STUDENT.EntryProfile.ENTPRODEP.001.V02
Where the student's permanent address on entry is Northern Ireland and they are not incoming exchange, then Dependant must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY = XG and Engagement.INCOMINGEXCHANGE does not exist and NOT(Leaver.ENGENDDATE - Engagement.ENGSTARTDATE) <= 14 days
TechnicalValidity:
EntryProfile.ENTPRODEP does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.NIDEPEND.1
QR.STUDENT.EntryProfile.ENTPRODEP.002.V01
Dependant must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Scottish Funding Council0%
TechnicalPopulation:
All EntryProfiles
TechnicalValidity:
EntryProfile.ENTPRODEP exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.NIDEPEND.2
QR.STUDENT.EntryProfile.ENTPRODEP.003.V01
Dependant coding differs from that returned previously.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.ENTPRODEP exists and <> 99 and _LatestSignedOff.EntryProfile.ENTPRODEP exists
TechnicalValidity:
EntryProfile.ENTPRODEP <> _LatestSignedOff.ENTPRODEP
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.NIDEPEND.3
QR.STUDENT.EntryProfile.ENTPRODEP.004.V01
Dependant has changed from a known to an unknown value.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.ENTPRODEP exists and _LatestSignedOff.EntryProfile.ENTPRODEP exists.
TechnicalValidity:
EntryProfile.ENTPRODEP = 99 and _LatestSignedOff.EntryProfile.ENTPRODEP <> 99
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.NIDEPEND.4
QR.STUDENT.EntryProfile.ENTPRODEP.005.V02
Where the student's permanent address on entry is not Northern Ireland or they are incoming exchange, then Dependant is not expected to be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.ENTPRODEP exists
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY = XG and Engagement.INCOMINGEXCHANGE does not exist and NOT(Leaver.ENGENDDATE - Engagement.ENGSTARTDATE) <= 14 days
Validity:
Valid
Category:
Coverage
QR.STUDENT.EntryProfile.ESTRANGED.001.V01
Estranged student must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All EntryProfiles
TechnicalValidity:
EntryProfile.ESTRANGED exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.ESTRANGED.1
QR.STUDENT.EntryProfile.ESTRANGED.002.V01
Where the permanent address of entry for an undergraduate student is UK (including Channel Islands and Isle of Man), the Estranged student information must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
All EntryProfiles where EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and any associated StudentCourseSession Course Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02
TechnicalValidity:
EntryProfile.ESTRANGED does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.ESTRANGED.2
QR.STUDENT.EntryProfile.ESTRANGED.002.V02
Where the permanent address of entry for an undergraduate student is UK (including Channel Islands and Isle of Man), the Estranged student information must be returned.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
All EntryProfiles where EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and any associated StudentCourseSession Course Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02 and Engagement.ENGSTARTDATE > 2020-07-31 and NOT((Leaver.ENGENDDATE - Engagement.ENGSTARTDATE) <= 14 days and Leaver.RSNENGEND = 03, 05, 11, 12) and NOT(any CourseInitiative.COURSEINITID = 027 or any StudentInitiative.STUINITID = 027 or 030)
TechnicalValidity:
EntryProfile.ESTRANGED does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.ESTRANGED.2
QR.STUDENT.EntryProfile.ESTRANGED.003.V01
Estranged student information must not be returned outside of coverage.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
All EntryProfiles where (EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 <> 01 or all associated StudentCourseSession Course Qualification.QUALCAT.GRP_LevelofStudyGrouping1 <> 02
TechnicalValidity:
EntryProfile.ESTRANGED exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.ESTRANGED.7
QR.STUDENT.EntryProfile.ESTRANGED.003.V02
Estranged student information must not be returned outside of coverage.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.ESTRANGED exists
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and any associated StudentCourseSession Course Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02 and Engagement.ENGSTARTDATE > 2020-07-31 and NOT((Leaver.ENGENDDATE - Engagement.ENGSTARTDATE) <= 14 days and Leaver.RSNENGEND = 03, 05, 11, 12) and NOT(any CourseInitiative.COURSEINITID = 027 or any StudentInitiative.STUINITID = 027 or 030)
Validity:
Valid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.ESTRANGED.7
QR.STUDENT.EntryProfile.ESTRANGED.004.V01
Estranged student information has changed from a known to an unknown value.
Version:
0.2
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.ESTRANGED exists and _LatestSignedOff.EntryProfile.ESTRANGED in (01, 02, 98)
TechnicalValidity:
(Submitted) EntryProfile.ESTRANGED in (99)
Validity:
Invalid
Category:
Continuity
QR.STUDENT.EntryProfile.ESTRANGED.005.V01
The Estranged student information differs from that returned previously.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
All engagements where EntryProfile.ESTRANGED exists and _LatestSignedOff.EntryProfile.ESTRANGED exists
TechnicalValidity:
EntryProfile.ESTRANGED differs from _LatestSignedOff.EntryProfile.ESTRANGED
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C21051.EntryProfile.ESTRANGED.5
QR.STUDENT.EntryProfile.ESTRANGED.006.V01
Information as to whether a student is estranged is not available for a higher than expected number of undergraduate engagements whose permanent address is in the UK, Channel Islands or Isle of Man.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council10%
TechnicalPopulation:
EntryProfile.ESTRANGED exists and EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and latest associated StudentCourseSession Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02
TechnicalValidity:
EntryProfile.ESTRANGED = 99 (not available)
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C20051.EntryProfile.ESTRANGED.3
QR.STUDENT.EntryProfile.EntryQualificationAward.001.V01
Duplicate entry qualification awards have been returned for an engagement.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All EntryQualificationAward entities for an Engagement.
TechnicalValidity:
COUNT(CONCATENATE(EntryQualificationAward.QUALTYPEID, EntryQualificationAward.QUALRESULT, EntryQualificationAward.QUALYEAR, all EntryQualificationSubject.SUBJECTID))>1
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.EntryProfile.QualificationsOnEntry.4, QR.C18051.EntryProfile.QualificationsOnEntry.12, QR.C18051.QualificationsOnEntry.QUALSBJ.1, QR.C19054.EntryProfile.QualificationsOnEntry.2
QR.STUDENT.EntryProfile.EntryQualificationAward.002.V01
A higher than expected number of students aged 21 or over, whose permanent address on entry is in the UK have been reported as having a level 3 qualification as their highest qualification on entry but no detail of the qualifications has been returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5 Records AND 5%
Higher Education Funding Council for Wales5 Records AND 10%
Department for the Economy, Northern Ireland5 Records AND 5%
Scottish Funding Council5 Records AND 10%
TechnicalPopulation:
(EntryProfile.HIGHESTQOE in (X0000, X0001) or (LEFT(EntryProfile.HIGHESTQOE) = P and EntryProfile.HIGHESTQOE <> P0013) ) and EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and Engagement.Z_AGESTARTGRP1 in (02, Z9)
TechnicalValidity:
EntryProfile.EntryQualificationAward does not exist
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C19051.EntryProfile.QualificationsOnEntry.2, QR.C19051.EntryProfile.QualificationsOnEntry.9, QR.C19051.EntryProfile.QualificationsOnEntry.7, QR.C19054.EntryProfile.QualificationsOnEntry.6, QR.C19054.EntryProfile.QualificationsOnEntry.10
QR.STUDENT.EntryProfile.EntryQualificationAward.003.V01
A higher than expected number of young entrants, whose permanent address on entry is in the UK have been reported as having a level 3 qualification as their highest qualification on entry but no detail of the qualifications has been returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5 Records AND 2%
Higher Education Funding Council for Wales5 Records AND 2%
Department for the Economy, Northern Ireland5 Records AND 2%
Scottish Funding Council5 Records AND 2%
TechnicalPopulation:
(EntryProfile.HIGHESTQOE in (X0000, X0001) or (LEFT(EntryProfile.HIGHESTQOE) = P and EntryProfile.HIGHESTQOE <> P0013)) and EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and Engagement.Z_AGESTARTGRP1 = 01 and Engagement.Z_ENTRANT_CYC = 1
TechnicalValidity:
EntryProfile.EntryQualificationAward does not exist
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C19051.EntryProfile.QualificationsOnEntry.6, QR.C19051.EntryProfile.QualificationsOnEntry.8, QR.C19054.EntryProfile.QualificationsOnEntry.4
QR.STUDENT.EntryProfile.EntryQualificationAward.004.V01
A higher than expected number of entry qualification award entities have been returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
All Engagements where Engagement.EntryProfile exists
TechnicalValidity:
Count of EntryProfile.EntryQualificationAward>30
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.EntryProfile.QualificationsOnEntry.1, QR.C19054.EntryProfile.QualificationsOnEntry.1
QR.STUDENT.EntryProfile.EntryQualificationAward.005.V01
A higher than expected number of full time first degree UK students with a level 3 highest qualification on entry, have a zero or unknown tariff score or no tariff points.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students10 Records AND 5%
Higher Education Funding Council for Wales10 Records AND 5%
Department for the Economy, Northern Ireland10 Records AND 5%
Scottish Funding Council10 Records AND 5%
TechnicalPopulation:
All EntryProfiles where latest StudentCourseSession.Course.Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 03 and latest StudentCourseSession.SCSMODE.GRP_FullPartTimeGrouping1 = 01 and Z_PERMADDGRP4 in (01, 02, 03, 04, 05) and Z_TARIFFGRP2 <> Z5
TechnicalValidity:
Z_TARIFFGRP2 = Z4
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QualificationsOnEntry.14
QR.STUDENT.EntryProfile.EntryQualificationAward.006.V01
Where the student is studying for a PGCE or PGDE and are not incoming or visiting exchange, then an Entry qualification award entity must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All EntryProfiles where Engagement.INCOMINGEXCHANGE does not exist and _Earliest.StudentCourseSession Course Qualification.QUALCAT.MRK_PGCE_PGDE = Y
TechnicalValidity:
EntryProfile.EntryQualificationAward does not exist
Validity:
Invalid
Category:
Coverage
QR.STUDENT.EntryProfile.EntryQualificationAward.007.V01
The total tariff score for this engagement is greater than 400 points.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All Engagements where EntryProfile.EntryQualificationAward exists
TechnicalValidity:
Z_TARIFF > 400
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QualificationsOnEntry.5, QR.C19054.EntryProfile.QualificationsOnEntry.3
QR.STUDENT.EntryProfile.EntryQualificationAward.008.V01
Multiple qualifications on entry of the same type have a subject code of 'Unknown'. This may affect tariff calculations.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfiles where multiple EntryProfile.EntryQualificationAwards have the same EntryQualificationAward.QUALTYPEID
TechnicalValidity:
For each EntryQualificationAward.QUALTYPEID, EntryQualificationSubject.SUBJECTID = ZZZZZZ is returned more than once
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.QualificationsOnEntry.QUALSBJ.1, QR.C19054.QualificationsOnEntry.QUALSBJ.1
QR.STUDENT.EntryProfile.EntryQualificationAward.009.V01
The total tariff points from the Entry Qualification Awards submitted is higher than the previous total tariff points.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryQualificationSubject.Z_POINTS exists and _LatestSignedOff.EntryQualificationSubject.Z_POINTS exists
TechnicalValidity:
total EntryQualificationSubject.Z_POINTS > total _LatestSignedOff.EntryQualificationSubject.Z_POINTS
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.QualificationsOnEntry.11, QR.C19054.EntryProfile.QualificationsOnEntry.13
QR.STUDENT.EntryProfile.EntryQualificationAward.012.V01
A higher than expected number of young continuing students whose permanent address on entry is in the UK have been reported as having a level 3 qualification as their highest qualification on entry but no detail of the qualifications has been returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5 Records AND 2%
Higher Education Funding Council for Wales5 Records AND 2%
Department for the Economy, Northern Ireland5 Records AND 2%
Scottish Funding Council5 Records AND 2%
TechnicalPopulation:
(EntryProfile.HIGHESTQOE in (X0000, X0001) or (LEFT(EntryProfile.HIGHESTQOE) = P and EntryProfile.HIGHESTQOE <> P0013) ) and EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and Engagement.Z_AGESTARTGRP1 = 01 and Engagement.Z_ENTRANT_CYC = 0
TechnicalValidity:
EntryProfile.EntryQualificationAward does not exist
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C19054.EntryProfile.QualificationsOnEntry.8
QR.STUDENT.EntryProfile.EntryQualificationAward.013.V01
No Entry qualifications have been returned but they were included in an earlier submission. Please check they have not been omitted in error.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile exists and _LatestSignedOff.EntryProfile exists
TechnicalValidity:
(Count EntryQualification Award) = 0 and (count _LatestSignedOff.EntryQualificationAward) > 0
Validity:
Invalid
Category:
Updateability
QR.STUDENT.EntryProfile.EntryQualificationAward.014.V01
Where a student commenced their studies prior to the current reference period, Entry qualifications are expected to be submitted. Please check they have not been omitted in error.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfiles where Engagement.ENGSTARTDATE < current ReferencePeriod.StartDate and _LatestSignedOff.EntryProfile.EntryQualificationAward does not exist
TechnicalValidity:
EntryProfile.EntryQualificationAward does not exist
Validity:
Invalid
Category:
Data integrity
QR.STUDENT.EntryProfile.HIGHESTQOE.001.V01
Where the student is not incoming or visiting exchange, then Highest qualification on entry must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Engagement.INCOMINGEXCHANGE does not exist
TechnicalValidity:
EntryProfile.HIGHESTQOE does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.1
QR.STUDENT.EntryProfile.HIGHESTQOE.003.V01
Highest qualification on entry differs from that returned previously.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All engagements where EntryProfile.HIGHESTQOE exists and _LatestSignedOff.EntryProfile.HIGHESTQOE exists
TechnicalValidity:
EntryProfile.HIGHESTQOE differs from _LatestSignedOff.EntryProfile.HIGHESTQOE
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.19, QR.C19054.EntryProfile.QUALENT3.7
QR.STUDENT.EntryProfile.HIGHESTQOE.004.V01
Highest qualification on entry has changed from a known to an unknown value.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile exists and _LatestSignedOff.EntryProfile.HIGHESTQOE exists and <> 99999
TechnicalValidity:
EntryProfile.HIGHESTQOE = 99999 or EntryProfile.HIGHESTQOE does not exist
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.18, QR.C19054.EntryProfile.QUALENT3.6
QR.STUDENT.EntryProfile.HIGHESTQOE.005.V01
Where the student has entered HE through the Scottish Wider Access Programme (SWAP) their highest qualification on entry must be a HE access course.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.ACCESSPRG exists
TechnicalValidity:
EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE in (X0000, X0001)
Validity:
Valid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.5
QR.STUDENT.EntryProfile.HIGHESTQOE.006.V01
Where qualifications on entry have been returned, then the highest qualification on entry must not be 'not available'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.QualificationsOnEntry entity exists
TechnicalValidity:
EntryProfile.HIGHESTQOE = 99999
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.3, QR.C19054.EntryProfile.QUALENT3.1
QR.STUDENT.EntryProfile.HIGHESTQOE.006.V02
Where qualifications on entry have been returned, then the highest qualification on entry must not be 'not available'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryQualificationAward entity exists
TechnicalValidity:
EntryProfile.HIGHESTQOE = 99999
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.3, QR.C19054.EntryProfile.QUALENT3.1
QR.STUDENT.EntryProfile.HIGHESTQOE.007.V01
Where a student has been returned with tariff bearing qualifications on entry, their highest qualification on entry must be subject to tariff.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
Z_TARIFF > 0
TechnicalValidity:
EntryProfile.HIGHESTQOE in (99999, P0014) or begins with Q, R or X (excluding X0000 and X0001)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C20051.EntryProfile.QUALENT3.13
QR.STUDENT.EntryProfile.HIGHESTQOE.009.V01
Where any associated qualification on entry is tariff bearing, then highest qualification on entry must not be 'UK Level 3 qualifications of which none are subject to UCAS Tariff'
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile where any associated EntryQualificationAward.QUALTYPEID have (TariffLookup.HESATariffStatus = 1 or TariffLookup.UCASTariffStatus = 1)
TechnicalValidity:
EntryProfile.HIGHESTQOE = P0014
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.16, QR.C19054.EntryProfile.QUALENT3.5
QR.STUDENT.EntryProfile.HIGHESTQOE.010.V01
A higher than expected number of full time first year students, studying at postgraduate research level, do not have first degree or higher as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students9 Records AND 20%
Higher Education Funding Council for Wales9 Records AND 20%
Department for the Economy, Northern Ireland9 Records AND 20%
Scottish Funding Council9 Records AND 20%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 1 and SCSMODE.GRP_FullPartTimeGrouping1 = 01 and Course Qualification.QUALCAT.GRP_LevelofStudyGrouping5 = 01) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 99999
TechnicalValidity:
Z_HQUALENTGRP1 = 04, 05, 06, 07 or 08
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.22, QR.C19054.EntryProfile.QUALENT3.20
QR.STUDENT.EntryProfile.HIGHESTQOE.011.V01
A higher than expected number of part time first year students, studying at postgraduate research level, do not have first degree or higher as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students9 Records AND 20%
Higher Education Funding Council for Wales9 Records AND 20%
Department for the Economy, Northern Ireland9 Records AND 20%
Scottish Funding Council9 Records AND 20%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 1 and SCSMODE.GRP_FullPartTimeGrouping1 = 02 and course Qualification.QUALCAT.GRP_LevelofStudyGrouping5= 01) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 9999
TechnicalValidity:
Z_HQUALENTGRP1 in (04, 05, 06, 07 or 08)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.23, QR.C19054.EntryProfile.QUALENT3.21
QR.STUDENT.EntryProfile.HIGHESTQOE.012.V01
A higher than expected number of full time first year students, studying at first degree level, do not have a level 3 qualification or other undergraduate qualification (other than a first degree) as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students10 Records AND 10%
Higher Education Funding Council for Wales10 Records AND 10%
Department for the Economy, Northern Ireland10 Records AND 10%
Scottish Funding Council10 Records AND 10%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 1 and StudentCourseSession.SCSMODE.GRP_FullPartTimeGrouping1 = 01 and course Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 03) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 99999
TechnicalValidity:
Z_HQUALENTGRP1 in (01, 02, 03, 05, 07, 08)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C20051.EntryProfile.QUALENT3.24, QR.C19054.EntryProfile.QUALENT3.13
QR.STUDENT.EntryProfile.HIGHESTQOE.013.V01
A higher than expected number of part time first year students, studying at first degree level, do not have a level 3 qualification or other undergraduate qualification (other than a first degree) as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students10 Records AND 10%
Higher Education Funding Council for Wales10 Records AND 10%
Department for the Economy, Northern Ireland10 Records AND 10%
Scottish Funding Council10 Records AND 10%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 1 and StudentCourseSession.SCSMODE.GRP_FullPartTimeGrouping1 = 02 and course Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 03) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 99999
TechnicalValidity:
Z_HQUALENTGRP1 in (01, 02, 03, 05, 07, 08)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C20051.EntryProfile.QUALENT3.25, QR.C19054.EntryProfile.QUALENT3.14
QR.STUDENT.EntryProfile.HIGHESTQOE.014.V01
A higher than expected number of full time first year students, studying at postgraduate taught level, do not have a first degree or higher as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students9 Records AND 20%
Higher Education Funding Council for Wales9 Records AND 20%
Department for the Economy, Northern Ireland9 Records AND 20%
Scottish Funding Council9 Records AND 20%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 1 and SCSMODE.GRP_FullPartTimeGrouping1 = 01 and course Qualification.QUALCAT.GRP_LevelofStudyGrouping5 = 02) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 99999
TechnicalValidity:
Z_HQUALENTGRP1 = 04, 05, 06, 07, 08
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.26, QR.C19054.EntryProfile.QUALENT3.18
QR.STUDENT.EntryProfile.HIGHESTQOE.015.V01
A higher than expected number of part time first year students, studying at postgraduate taught level, do not have a first degree or higher as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students9 Records AND 20%
Higher Education Funding Council for Wales9 Records AND 20%
Department for the Economy, Northern Ireland9 Records AND 20%
Scottish Funding Council9 Records AND 20%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 1 and SCSMODE.GRP_FullPartTimeGrouping1 = 02 and course Qualification.QUALCAT.GRP_LevelofStudyGrouping5 = 02) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 99999
TechnicalValidity:
Z_HQUALENTGRP1 in (04, 05, 06, 07, 08)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.27, QR.C19054.EntryProfile.QUALENT3.19
QR.STUDENT.EntryProfile.HIGHESTQOE.016.V01
A higher than expected number of part time students that are fundable by the funding council have been returned with an unknown highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students20%
Higher Education Funding Council for Wales20%
Department for the Economy, Northern Ireland20%
Scottish Funding Council20%
TechnicalPopulation:
EntryProfile exists and associated latest StudentCourseSession.SCSMODE.GRP_FullPartTimeGrouping1 = 02 and any (FundingBody.FUNDINGBODY.GRP_FundableBy = 01)
TechnicalValidity:
EntryProfile.HIGHESTQOE.GRP_HighestEntryQualificationGrouping1 = Z9
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.10, QR.C18051.EntryProfile.QUALENT3.12
QR.STUDENT.EntryProfile.HIGHESTQOE.017.V01
A higher than expected number of full time students that are fundable by the funding council have been returned with an unknown highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5%
Higher Education Funding Council for Wales5%
Department for the Economy, Northern Ireland5%
Scottish Funding Council5%
TechnicalPopulation:
EntryProfile exists and associated latest StudentCourseSession.SCSMODE.GRP_FullPartTimeGrouping1 = 01 and any (FundingBody.FUNDINGBODY.GRP_FundableBy = 01)
TechnicalValidity:
EntryProfile.HIGHESTQOE.GRP_HighestEntryQualificationGrouping1 = Z9
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.11, QR.C18051.EntryProfile.QUALENT3.7
QR.STUDENT.EntryProfile.HIGHESTQOE.018.V01
A higher than expected number of undergraduate students entering via UCAS have an unknown highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students1%
Higher Education Funding Council for Wales1%
Department for the Economy, Northern Ireland1%
Scottish Funding Council1%
TechnicalPopulation:
EntryProfile exists and associated latest StudentCourseSession (Course.Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 03) and EntryProfile.UCASSCHEMECODE exists
TechnicalValidity:
EntryProfile.HIGHESTQOE.GRP_HighestEntryQualificationGrouping1 = Z9
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.20
QR.STUDENT.EntryProfile.HIGHESTQOE.019.V01
A higher than expected number of postgraduate students entering via UCAS have an unknown Highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students3%
Higher Education Funding Council for Wales3%
Department for the Economy, Northern Ireland3%
Scottish Funding Council3%
TechnicalPopulation:
EntryProfile.UCASSCHEMECODE exists and associated Qualification.QUALCAT.GRP_LevelofStudyGrouping2 in (01,02)
TechnicalValidity:
EntryProfile.HIGHESTQOE = 99999
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.21
QR.STUDENT.EntryProfile.HIGHESTQOE.020.V01
Where the student has a UK qualification on entry, then the Highest qualification on entry must not be 'Other qualification at level 3'.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryQualificationAward.QUALTYPEID exists and EntryQualificationAward.QUALTYPEID not in (H1, H2, H3, HD, IB, IC, ID, IE, IF, IH, IJ, IL, IO, IS, IU, IV, IX 6J, 6K, 6L, 6N, 6P, 6Q, 6R, 6S, 6T)
TechnicalValidity:
EntryProfile.HIGHESTQOE = P0013
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.28, QR.C19054.EntryProfile.QUALENT3.17
QR.STUDENT.EntryProfile.HIGHESTQOE.021.V01
A higher than expected number of full-time undergraduate students whose address on entry is in the UK have been returned with no detailed qualifications and a highest qualification on entry of 'Other qualification at level 3'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5%
Higher Education Funding Council for Wales5%
Department for the Economy, Northern Ireland5%
Scottish Funding Council5%
TechnicalPopulation:
EntryProfiles where for latest StudentCourseSession (Course Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02 and StudentCourseSession.SCSMODE.GRP_FullPartTimeGrouping1 = 01) and EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping3 in (01, 05)
TechnicalValidity:
EntryProfile.HIGHESTQOE = P0013 and EntryQualificationAward entity does not exist
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.EntryProfile.QUALENT3.8, QR.C18051.EntryProfile.QUALENT3.9
QR.STUDENT.EntryProfile.HIGHESTQOE.023.V01
A higher than expected number of young students with a UK nationality have highest qualification on entry coded 'Other qualification at level 3'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5 Records AND 5%
Higher Education Funding Council for Wales5 Records AND 5%
Department for the Economy, Northern Ireland5 Records AND 5%
Scottish Funding Council5 Records AND 5%
TechnicalPopulation:
Associated Student.NATION = GB and Z_AGESTART <= 21 and Student.BIRTHDTE exists
TechnicalValidity:
EntryProfile.HIGHESTQOE = P0013
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.QualificationsOnEntry.13, QR.C19054.EntryProfile.QualificationsOnEntry.14
QR.STUDENT.EntryProfile.HIGHESTQOE.024.V01
A higher than expected number of students have a highest qualification on entry of 'Other qualification level not known'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5 Records AND 20%
TechnicalPopulation:
EntryProfile.HIGHESTQOE exists
TechnicalValidity:
EntryProfile.HIGHESTQOE = X0003
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C19054.EntryProfile.QUALENT3.11
QR.STUDENT.EntryProfile.HIGHESTQOE.025.V01
A higher than expected number of students have a highest qualification on entry of 'Mature student admitted on basis of previous experience and/or admissions test'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5 Records AND 5%
TechnicalPopulation:
EntryProfile.HIGHESTQOE exists
TechnicalValidity:
EntryProfile.HIGHESTQOE = X0002
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C19054.EntryProfile.QUALENT3.10
QR.STUDENT.EntryProfile.HIGHESTQOE.026.V01
A higher than expected number of students have 'no formal qualification' on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5 Records AND 5%
TechnicalPopulation:
EntryProfile.HIGHESTQOE exists
TechnicalValidity:
EntryProfile.HIGHESTQOE = X0004
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C19054.EntryProfile.QUALENT3.12
QR.STUDENT.EntryProfile.HIGHESTQOE.027.V01
A higher than expected number of full time non-first year students, studying at first degree level, do not have a level 3 qualification or other undergraduate qualification (other than a first degree) as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students9 Records AND 5%
Higher Education Funding Council for Wales9 Records AND 5%
Department for the Economy, Northern Ireland9 Records AND 5%
Scottish Funding Council9 Records AND 5%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 0 and MODE.ECF_IsFulltime = 1 and course Qualification.QUALCAT.ECF_LevelOfStudy5 = 03) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 99999
TechnicalValidity:
Z_HQUALENTGRP1 in (01, 02, 03, 05, 07, 08)
Validity:
Invalid
Category:
Credibility report
LegacyRuleId:
QR.C19054.EntryProfile.QUALENT3.16
QR.STUDENT.EntryProfile.HIGHESTQOE.028.V01
A higher than expected number of part time non-first year students, studying at first degree level, do not have a level 3 qualification or other undergraduate qualification (other than a first degree) as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students5 Records AND 20%
Higher Education Funding Council for Wales5 Records AND 20%
Department for the Economy, Northern Ireland5 Records AND 20%
Scottish Funding Council5 Records AND 20%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 0 and StudentCourseSession.SCSMODE.GRP_FullPartTimeGrouping1 = 02 and course Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 03) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 99999
TechnicalValidity:
Z_HQUALENTGRP1 in (01, 02, 03, 05, 07, 08)
Validity:
Invalid
Category:
Credibility report
LegacyRuleId:
QR.C19054.EntryProfile.QUALENT3.15, QR.C19054.EntryProfile.QUALENT3.16
QR.STUDENT.EntryProfile.HIGHESTQOE.029.V01
A higher than expected number of full time non-first year students, studying at postgraduate taught level, do not have a first degree or higher as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students9 Records AND 20%
Higher Education Funding Council for Wales9 Records AND 20%
Department for the Economy, Northern Ireland9 Records AND 20%
Scottish Funding Council9 Records AND 20%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 0 and SCSMODE.GRP_FullPartTimeGrouping1 = 01 and course Qualification.QUALCAT.GRP_LevelofStudyGrouping5 = 02) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 99999
TechnicalValidity:
Z_HQUALENTGRP1 in (04, 05, 06, 07, 08)
Validity:
Invalid
Category:
Credibility report
LegacyRuleId:
QR.C19054.EntryProfile.QUALENT3.22
QR.STUDENT.EntryProfile.HIGHESTQOE.030.V01
A higher than expected number of part time non-first year students, studying at postgraduate taught level, do not have a first degree or higher as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students9 Records AND 20%
Higher Education Funding Council for Wales9 Records AND 20%
Department for the Economy, Northern Ireland9 Records AND 20%
Scottish Funding Council9 Records AND 20%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 0 and StudentCourseSession.SCSMODE.GRP_FullPartTimeGrouping1 = 02 and course Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 02) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 99999
TechnicalValidity:
Z_HQUALENTGRP1 in (04, 05, 06, 07, 08)
Validity:
Invalid
Category:
Credibility report
LegacyRuleId:
QR.C19054.EntryProfile.QUALENT3.23
QR.STUDENT.EntryProfile.HIGHESTQOE.031.V01
A higher than expected number of full time non-first year students, studying at postgraduate research level, do not have first degree or higher as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students9 Records AND 20%
Higher Education Funding Council for Wales9 Records AND 20%
Department for the Economy, Northern Ireland9 Records AND 20%
Scottish Funding Council9 Records AND 20%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 0 and SCSMODE.GRP_FullPartTimeGrouping1 = 01 and Course Qualification.QUALCAT.GRP_LevelofStudyGrouping5 = 01) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 99999
TechnicalValidity:
Z_HQUALENTGRP1 in (04, 05, 06, 07 or 08)
Validity:
Invalid
Category:
Credibility report
LegacyRuleId:
QR.C19054.EntryProfile.QUALENT3.24
QR.STUDENT.EntryProfile.HIGHESTQOE.032.V01
A higher than expected number of part time non-first year students, studying at postgraduate research level, do not have first degree or higher as their highest qualification on entry.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students9 Records AND 20%
Higher Education Funding Council for Wales9 Records AND 20%
Department for the Economy, Northern Ireland9 Records AND 20%
Scottish Funding Council9 Records AND 20%
TechnicalPopulation:
EntryProfile where, for latest StudentCourseSession (Z_ENTRANT_CYC = 0 and StudentCourseSession.SCSMODE.GRP_FullPartTimeGrouping1 = 02 and course Qualification.QUALCAT.GRP_LevelofStudyGrouping2 = 01) and EntryProfile.HIGHESTQOE exists and EntryProfile.HIGHESTQOE <> 99999
TechnicalValidity:
Z_HQUALENTGRP1 in (04, 05, 06, 07 or 08)
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19054.EntryProfile.QUALENT3.25
QR.STUDENT.EntryProfile.HIGHESTQOE.033.V01
A higher than expected number of students, aged 22 and over, from the UK have a highest qualification on entry coded 'Other qualification at level 3'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students15 Records AND 15%
Higher Education Funding Council for Wales15 Records AND 15%
Department for the Economy, Northern Ireland15 Records AND 15%
Scottish Funding Council15 Records AND 15%
TechnicalPopulation:
Associated Student.NATION = GB and Z_AGESTARTGRP1 = 02
TechnicalValidity:
EntryProfile.HIGHESTQOE = P0013
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C19054.EntryProfile.QualificationsOnEntry.15
QR.STUDENT.EntryProfile.MARSTAT.001.V01
Where the student's permanent address on entry is in Northern Ireland and they are not incoming exchange, then Marital status must be returned.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY = XG and Engagement.INCOMINGEXCHANGE does not exist.
TechnicalValidity:
EntryProfile.MARSTAT does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.MARSTAT.1
QR.STUDENT.EntryProfile.MARSTAT.002.V01
Marital status must not be returned for your provider.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Scottish Funding Council0%
TechnicalPopulation:
All EntryProfiles
TechnicalValidity:
EntryProfile.MARSTAT exists
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.MARSTAT.2
QR.STUDENT.EntryProfile.MARSTAT.003.V01
Where Marital status is returned then the student's permanent address on entry must be in Northern Ireland and they must not be an incoming exchange student.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.MARSTAT exists
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY = XG and Engagement.INCOMINGEXCHANGE does not exist.
Validity:
Valid
Category:
Coverage
QR.STUDENT.EntryProfile.MARSTAT.004.V01
Marital status differs from that returned previously.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
All engagements where EntryProfile.MARSTAT and _LatestSignedOff.EntryProfile.MARSTAT exists
TechnicalValidity:
EntryProfile.MARSTAT differs from _LatestSignedOff.EntryProfile.MARSTAT
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.MARSTAT.3
QR.STUDENT.EntryProfile.MARSTAT.006.V01
Marital status has changed to 'Not available'.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.MARSTAT exists and _LatestSignedOff.EntryProfile.MARSTAT exists and <> 99
TechnicalValidity:
EntryProfile.MARSTAT = 99
Validity:
Invalid
Category:
Updateability
QR.STUDENT.EntryProfile.PARED.001.V01
Parental education must be returned where the student's permanent address on entry is in the UK and they are studying for an undergraduate qualification.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and latest StudentCourseSession Course Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02)
TechnicalValidity:
EntryProfile.PARED does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.PARED.1, QR.C18051.EntryProfile.PARED.2
QR.STUDENT.EntryProfile.PARED.001.V02
Parental education must be returned where the student's permanent address on entry is in the UK and they are studying for an undergraduate qualification.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Higher Education Funding Council for Wales0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and latest StudentCourseSession Course Qualification.QUALCAT.GRP_LevelofStudyGrouping1 = 02 and Engagement.ENGSTARTDATE > 2008-07-31 and Engagement.INCOMINGEXCHANGE does not exist and Z_ACT_RP = 1 and NOT(Leaver.ENGENDDATE - Engagement.ENGSTARTDATE <= 14 days)
TechnicalValidity:
EntryProfile.PARED does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.PARED.1, QR.C18051.EntryProfile.PARED.2
QR.STUDENT.EntryProfile.PARED.002.V01
Parental education must be returned where the students started the Engagement after 2007-07-31, are not incoming or exchange, are fundable by the OfS or DfE and are studying for one of the qualifications listed in the coverage statement in the data dictionary.
Version:
0.3
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfile where _EarliestSCS.StudentCourseSession Course.((Qualification.QUALCAT.GRP_LevelofStudyGrouping1=02 or Qualification.QUALCAT.MRK_PGCE_PGDE=Y) and Qualification.QUALCAT not in (H0009, H0010)) and Engagement.INCOMINGEXCHANGE does not exist and Engagement.ENGSTARTDATE > 2007-07-31 and for the latest StudentCourseSession any associated FundingBody.FUNDINGBODY in (5016, 5020)
TechnicalValidity:
EntryProfile.PARED does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.PARED.1, QR.C20051.EntryProfile.PARED.6
QR.STUDENT.EntryProfile.PARED.002.V02
At Approved (fee cap) providers in England where the provider previously submitted to the Student record, Parental education must be returned for active students who started the Engagement after 2007-07-31, are not incoming exchange, and are studying for one of the qualifications listed in the coverage statement in the data dictionary.
Version:
0.3
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfile where latest StudentCourseSession Course.((Qualification.QUALCAT.GRP_LevelofStudyGrouping1=02 or Qualification.QUALCAT.MRK_PGCE_PGDE=Y) and Qualification.QUALCAT not in (H0009, H0010)) and Engagement.INCOMINGEXCHANGE does not exist and Engagement.ENGSTARTDATE > 2007-07-31 and EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and Z_ACT_RP = 1 and NOT(Leaver.ENGENDDATE - Engagement.ENGSTARTDATE <= 14 days) and Provider.CategoryCode = 01 and Collection.Stream = 051
TechnicalValidity:
EntryProfile.PARED does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.PARED.1, QR.C20051.EntryProfile.PARED.6
QR.STUDENT.EntryProfile.PARED.003.V01
Parental education has changed from a known to an unknown value.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All engagements where EntryProfile.PARED exists and _LatestSignedOff.EntryProfile.PARED exists and _LatestSignedOff.EntryProfile.PARED in (01, 02, 98)
TechnicalValidity:
EntryProfile.PARED in (03, 97, 99)
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.PARED.3
QR.STUDENT.EntryProfile.PARED.004.V01
Parental education differs from that returned previously.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All engagements where EntryProfile.PARED and _LatestSignedOff.EntryProfile.PARED exists
TechnicalValidity:
EntryProfile.PARED differs from _LatestSignedOff.EntryProfile.PARED exists
Validity:
Invalid
Category:
Updateability
LegacyRuleId:
QR.C18051.EntryProfile.PARED.4
QR.STUDENT.EntryProfile.PARED.005.V01
A higher than expected number of students have returned an unknown parental education.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
----
TechnicalPopulation:
Submitted EntryProfile.PARED exists
TechnicalValidity:
EntryProfile.PARED in (03,97,98,99)
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.EntryProfile.PARED.5
QR.STUDENT.EntryProfile.PARED.005.V02
A higher than expected number of students have returned an unknown parental education.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students10%
Higher Education Funding Council for Wales10%
Department for the Economy, Northern Ireland10%
Scottish Funding Council10%
TechnicalPopulation:
EntryProfile.PARED exists
TechnicalValidity:
EntryProfile.PARED in (03, 97, 99)
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.EntryProfile.PARED.5; QR.C21051.EntryProfile.PARED.16; QR.C21051.EntryProfile.PARED.17; QR.C21051.EntryProfile.PARED.18; QR.C21054.EntryProfile.PARED.2
QR.STUDENT.EntryProfile.PARED.006.V01
Parental education must be returned where the student's permanent address on entry is in the UK (including Channel Islands and Isle of Man).
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01
TechnicalValidity:
EntryProfile.PARED does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.PARED.1, QR.C18051.EntryProfile.PARED.2
QR.STUDENT.EntryProfile.PARED.006.V02
Parental education must be returned where the student's permanent address on entry is in the UK (including Channel Islands and Isle of Man) and the engagement started after 2008-07-31.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and Engagement.ENGSTARTDATE > 2008-07-31.
TechnicalValidity:
EntryProfile.PARED does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C18051.EntryProfile.PARED.1, QR.C18051.EntryProfile.PARED.2
QR.STUDENT.EntryProfile.PARED.007.V01
Parental education must be returned where the student's permanent address on entry is in the UK (including Channel Islands and Isle of Man), they are not incoming exchange, not intercalating and studying for one of the qualifications listed in the coverage statement in the data dictionary.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and latest StudentCourseSession.COURSEID has Qualification.QUALCAT in (M0002, H0003, H0004, H0005, I0001, J0000, J0001, J0002, J0003, C0000, C0001) and Engagement.INCOMINGEXCHANGE does not exist and latest StudentCourseSession.INTERCALATION does not exist
TechnicalValidity:
EntryProfile.PARED does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.PARED.1
QR.STUDENT.EntryProfile.PARED.007.V02
Parental education must be returned where the student's permanent address on entry is in the UK (including Channel Islands and Isle of Man), they are not incoming exchange, not intercalating and studying for one of the qualifications listed in the coverage statement in the data dictionary.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and latest StudentCourseSession.COURSEID has Qualification.QUALCAT in (M0002, H0003, H0004, H0005, I0001, J0000, J0001, J0002, J0003, C0000, C0001) and Engagement.INCOMINGEXCHANGE does not exist and latest StudentCourseSession.INTERCALATION does not exist and Engagement.ENGSTARTDATE > 2007-07-31 and NOT(Leaver.ENGENDDATE - Engagement.ENGSTARTDATE <= 14 days)
TechnicalValidity:
EntryProfile.PARED does not exist
Validity:
Invalid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.PARED.1
QR.STUDENT.EntryProfile.PARED.010.V01
Parental education must not be returned outside of coverage.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0 Records AND 0%
TechnicalPopulation:
EntryProfile.PARED exists
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01
Validity:
Valid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.PARED.10
QR.STUDENT.EntryProfile.PARED.010.V02
Parental education must not be returned outside of coverage.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Department for the Economy, Northern Ireland0 Records AND 0%
TechnicalPopulation:
EntryProfile.PARED exists
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and Engagement.ENGSTARTDATE > 2008-07-31.
Validity:
Valid
Category:
Coverage
LegacyRuleId:
QR.C20051.EntryProfile.PARED.10
QR.STUDENT.EntryProfile.PARED.012.V01
At Approved (fee cap) providers in England where the provider previously submitted to the Student Alternative record, Parental education must be returned for active students who started the Engagement after 2020-07-31, are not incoming exchange, and are studying for one of the qualifications listed in the coverage statement in the data dictionary.
Version:
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
TechnicalPopulation:
EntryProfile where latest StudentCourseSession Course.((Qualification.QUALCAT.GRP_LevelofStudyGrouping1=02 or Qualification.QUALCAT.MRK_PGCE_PGDE=Y) and Qualification.QUALCAT not in (H0009, H0010)) and Engagement.INCOMINGEXCHANGE does not exist and Engagement.ENGSTARTDATE > 2020-07-31 and EntryProfile.PERMADDCOUNTRY.GRP_CountryGrouping2 = 01 and Z_ACT_RP = 1 and NOT(Leaver.ENGENDDATE - Engagement.ENGSTARTDATE <= 14 days) and Provider.CategoryCode = 01 and Collection.Stream = 054
TechnicalValidity:
EntryProfile.PARED does not exist
Validity:
Invalid
Category:
Coverage
QR.STUDENT.EntryProfile.PERMADDCOUNTRY.001.V01
A higher than expected number of students have returned an unknown Country of permanent address.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0 Records
Higher Education Funding Council for Wales0 Records
Department for the Economy, Northern Ireland0 Records
Scottish Funding Council0 Records
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY exists
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY = 97
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.EntryProfile.DOMICILE.12, QR.C19054.EntryProfile.DOMICILE.1, QR.C19054.EntryProfile.DOMICILE.11, QR.C19054.EntryProfile.DOMICILE.1
QR.STUDENT.EntryProfile.PERMADDCOUNTRY.003.V01
A higher than expected number of students have a Country of permanent address of United Kingdom, not otherwise specified.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students2%
Higher Education Funding Council for Wales2%
Department for the Economy, Northern Ireland2%
Scottish Funding Council2%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY exists
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY = XK
Validity:
Invalid
Category:
Data integrity
LegacyRuleId:
QR.C18051.EntryProfile.DOMICILE.7, QR.C20051.EntryProfile.DOMICILE.8, QR.C18051.EntryProfile.DOMICILE.4, QR.C19054.EntryProfile.DOMICILE.6, QR.C19054.EntryProfile.DOMICILE.7
QR.STUDENT.EntryProfile.PERMADDCOUNTRY.004.V01
For non-UCAS entrants, the country of permanent address on entry has been returned as 'Cyprus not otherwise specified'. Please recode this to one of the specific Cyprus codes where possible.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY exists and EntryProfile.UCASSCHEMECODE does not exist
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY = XC
Validity:
Invalid
Category:
Guidance
LegacyRuleId:
QR.C18051.EntryProfile.DOMICILE.1, QR.C19054.EntryProfile.DOMICILE.3
QR.STUDENT.EntryProfile.PERMADDCOUNTRY.005.V01
Country of permanent address has changed from a known to an unknown value.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
EntryProfile.PERMADDCOUNTRY exists and _LatestSignedOff.EntryProfile.PERMADDCOUNTRY <> 97
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY =97
Validity:
Invalid
Category:
Continuity
LegacyRuleId:
QR.C18051.EntryProfile.DOMICILE.9, QR.C19054.EntryProfile.DOMICILE.8
QR.STUDENT.EntryProfile.PERMADDCOUNTRY.006.V01
Country of permanent address on entry differs from that returned previously.
Version:
0.1
Status:
Added
Intolerable:
Yes
DefaultTolerance:
RegulatorTolerance
Office for Students0%
Higher Education Funding Council for Wales0%
Department for the Economy, Northern Ireland0%
Scottish Funding Council0%
TechnicalPopulation:
All engagements where EntryProfile.PERMADDCOUNTRY and _LatestSignedOff.EntryProfile.PERMADDCOUNTRY exists
TechnicalValidity:
EntryProfile.PERMADDCOUNTRY differs from _LatestSignedOff.EntryProfile.PERMADDCOUNTRY
Validity:
Invalid
Category:
Continuity
LegacyRuleId:
QR.C18051.EntryProfile.DOMICILE.11, QR.C19054.EntryProfile.DOMICILE.10
QR.STUDENT.EntryProfile.PERMADDCOUNTRY.007.V01
Country of permanent address on entry has changed from a UK code to a non-UK code or a non-UK code to a UK code.