Skip to main content

Quality Rules Directory for C23053

Download all the C23053 rules

Filter

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

QR.C23053.CourseSubject.SBJCA.1

CourseSubject.SBJCA must be coded 100346, 101017, 100417, 100425, 100403, 100366, 100372, 100450, 100610, 100473, 100476, 100409, 100444, 100320, 100333, 100321, 100323, 100326, 100332, 101142, 100329, 100302, 100339, 100048, 100050, 100642, 100071, 100069, 100068, 101361, 100511, 100510, 100390, 100433, 100097, 101165, 101117, 100513 or 101169 where Student.TTCID = 01 and any Student.ITTPHSC = 13909 - 13915 and Student.ITTSTARTDATE is after 2023-07-31.
Business RuleErrorAmended
Plain English
Students on an ITT course at Primary level (that started after 31 July 2023) must be studying one of the specified subjects.
Further Guidance
N/A
Reason for Change
Subject code 101085 removed and 100513 and 101169 added to the rule. Student.COMDATE replaced with Student.ITTSTARTDATE.
Previous Name of Rule
QR.C21053.CourseSubject.SBJCA.1

QR.C23053.CourseSubject.SBJCA.10

CourseSubject.SBJCA must be coded 100346, 100433, 101017, 100417, 100425, 100403, 100366, 100372, 100450, 100610, 100473, 100476, 100409, 100444, 100320, 100333, 100321, 100323, 100326, 100332, 101142, 100329, 100302, 100339, 100048, 100050, 100642, 100071, 100069, 100068, 101361, 100511, 100510, 100097, 100390, 100513 or 101169 where Student.TTCID = 01 and any Student.ITTPHSC = 13909 - 13915 and Student.ITTSTARTDATE is before 2023-08-01.
Business RuleErrorAmended
Plain English
Students on an ITT course at Primary level (that started before 01 August 2023) must be studying one of the specified subjects.
Further Guidance
N/A
Reason for Change
​Subject code 101085 removed and 100513 and 101169 added to the rule. Student.COMDATE replaced with Student.ITTSTARTDATE.
Previous Name of Rule
N/A

QR.C23053.CourseSubject.SBJCA.11

Where Student.TTCID = 01, Student.ITTPHSC =13909 - 13915 and Student.ITTSTARTDATE is after 2023-07-31, then CourseSubject.SBJCA equal to 100511 with attribute Main = 1 in the surrounding tag must exist if more than one CourseSubject.SBJCA is returned.
Business RuleErrorAdded
Plain English
All primary level courses that started after 2023-07-31 must be returned with ‘primary teaching’ as the main subject.
Further Guidance
N/A
Reason for Change
Rule added to align with C23053 CourseSubject.SBJCA guidance for students who study a primary specialism.
Previous Name of Rule
N/A

QR.C23053.CourseSubject.SBJCA.12

Where Student.TTCID = 01 and Student.ITTPHSC is between 13909 to 13915 (inclusive) and Student.ITTSTARTDATE is after 2023-07-31 then CourseSubject.SBJCA = 100511 must exist.
Business RuleErrorAdded
Plain English
Students on primary level courses that started after 2023-07-31 must be studying primary teaching.
Further Guidance
N/A
Reason for Change
Rule added to align with C23053 CourseSubject.SBJCA guidance for students who choose not to study a primary specialism.
Previous Name of Rule
N/A

QR.C23053.CourseSubject.SBJCA.2

CourseSubject.SBJCA must be coded 100150, 100202, 100214, 100225, 100358, 100366, 100372, 101165, 100346, 100343, 100433, 100497, 100390, 101017, 100417, 101038, 100425, 101060, 100403, 100381, 100209, 100050, 100202, 100366, 100372, 100358, 100214, 100225, 100150, 100450, 100610, 100473, 100476, 100409, 100471, 100485, 100079, 100101, 100891, 100893, 100097, 100092, 100078, 100444, 100320, 101410, 100333, 101420, 101126, 100300, 100321, 100323, 100326, 100332, 101142, 100330, 100329, 100302, 100339, 100048, 100061, 100642, 100071, 100069, 100068, 101361, 100184, 100091, 101373, 100337, 101192, 100406, 101117, 100456, 100513 or 101169 where Student.TTCID = 01 and any Student.ITTPHSC = 13916 - 13919.
Business RuleErrorAmended
Plain English
Students on an ITT course at Secondary level must be studying one of the specified subjects.
Further Guidance
N/A
Reason for Change
100513 - Teaching English as a foreign language and 101169 - Japanese languages have been added to the coverage.
Previous Name of Rule
QR.C21053.CourseSubject.SBJCA.2

QR.C23053.CourseSubject.SBJCA.4

When more than one CourseSubject.SBJCA is returned, the attribute Main= 1 must be included in at least one tag surrounding the main CourseSubject.SBJCA code
Business RuleErrorCarried Forward
Plain English
The main subject must be identified, please see the coding manual for guidance on this.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.CourseSubject.SBJCA.4

QR.C23053.CourseSubject.SBJCA.5

When more than one CourseSubject.SBJCA code is returned, the attribute Main= 1 should only be included in the tag of one CourseSubject.SBJCA code
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.CourseSubject.SBJCA.5

QR.C23053.CourseSubject.SBJCA.8

CourseSubject.SBJCA codes 100346 (Biology), 100417 (Chemistry) and 100425 (Physics) can only be used together when Student.TTCID = 01 and Student.ITTPHSC = 13909 - 13915.
Business RuleErrorCarried Forward
Plain English
Only one of the 3 Science subjects (100346, 100417 and 100425) can be returned when the student is not on an ITT course at Primary level.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.CourseSubject.SBJCA.8

QR.C23053.CourseSubject.SBJCA.9

Student.FUNDCODE should = 2 where CourseSubject.SBJCA = 100048, 100061, 100068, 100069, 100071, 100078, 100079, 100091, 100092, 100097, 100101, 100202, 100209, 100214, 100225, 100302, 100320, 100337, 100339, 100409, 100433, 100444, 100450, 100456, 100471, 100473, 100476, 100485, 100497, 100510, 100511, 100610, 100642, 100891, 100893, 101017, 101361, 101373, 100302, 100300, 100339 or 100511 and Student.ENTRYRTE = 03 or 10 and Student.ITTSTARTDATE is after Y1-07-31.
Business RuleWarningAmended
Plain English
Students on a School Direct (salaried) or Postgraduate teaching apprenticeship entry route studying a subject under the areas of Art, Business, UK government/parliamentary studies/health studies/Public Services, Media and Communication, Dance & Drama, Economics, Beauty, Health & Social Care, Law, History, Classical Studies, Religious Studies, Sport and Exercise Sciences/Sports Studies, Psychology, Retail, Social Sciences, Early Years Teaching, Primary Teaching, or Travel and Tourism, will not be eligible to receive funding from the DfE if they have begun their studies in the current reporting period.
Further Guidance
Students studying one of the specified subjects will not normally be eligible for receiving funding from the DfE if they have begun their studies in the current reporting period.
Reason for Change
​Subject code 101085 removed and 100302, 100300, 100339 and 100511 added to the rule. Student.COMDATE replaced with Student.ITTSTARTDATE.
Previous Name of Rule
QR.C21053.CourseSubject.SBJCA.9

QR.C23053.Placement.PLMNTSCH.1

Where there is more than one occurrence of the Placement entity for a student, Placement.PLMNTSCH must be unique.
Business RuleErrorCarried Forward
Plain English
The placement school identified in a URN (Unique Reference Number) has been returned for more than one placement.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Placement.PLMNTSCH.2

Placement.PLMNTSCH is not a generic code and does not exist in the lookup file provided by Edubase.
Business RuleErrorAmended
Plain English
The school code returned is not a generic code or a valid URN (Unique Reference Number).
Further Guidance
N/A
Reason for Change
Generic codes updated to match Coding manual schema changes
Previous Name of Rule
N/A

QR.C23053.PreviousQualification.DEGCLSS.1

PreviousQualification.DEGCLSS must exist where Student.ITTSTARTDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021, 031 or 032)
Business RuleErrorAmended
Plain English
Previous degree class must exist where the student studying for a postgraduate qualification in the current reporting period.
Further Guidance
N/A
Reason for Change
Student.ITTSTARTDATE added to ensure rule triggers only for new entrants.
Previous Name of Rule
QR.C21053.PreviousQualification.DEGCLSS.1

QR.C23053.PreviousQualification.DEGCTRY.1

PreviousQualification.DEGCTRY must exist where Student.ITTSTARTDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021, 031 or 032) and PreviousQualification.DEGEST does not exist.
Business RuleErrorAmended
Plain English
Previous degree country must exist where the previous degree establishment does not exist and the student is studying for a postgraduate qualification in the current reporting period.
Further Guidance
N/A
Reason for Change
Student.ITTSTARTDATE added to ensure rule triggers only for new entrants.
Previous Name of Rule
QR.C21053.PreviousQualification.DEGCTRY.1

QR.C23053.PreviousQualification.DEGCTRY.2

PreviousQualification.DEGCTRY must not exist where PreviousQualification.DEGEST exists
Business RuleErrorCarried Forward
Plain English
Previous degree country must not exist where previous degree establishment exists.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.PreviousQualification.DEGCTRY.2

QR.C23053.PreviousQualification.DEGENDDT.1

PreviousQualification.DEGENDDT must exist where Student.ITTSTARTDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021, 031 or 032).
Business RuleErrorAmended
Plain English
Previous degree end date must exist where the student is studying for a postgraduate qualification in the current reporting period.
Further Guidance
N/A
Reason for Change
Student.ITTSTARTDATE added to ensure rule triggers only for new entrants.
Previous Name of Rule
QR.C21053.PreviousQualification.DEGENDDT.1

QR.C23053.PreviousQualification.DEGENDDT.2

Where exists PreviousQualification.DEGENDDT must not be later than Student.ITTSTARTDATE
Business RuleErrorAmended
Plain English
Previous degree end date must not be later than start date of ITT course.
Further Guidance
N/A
Reason for Change
Rule amended because Student.COMDATE has been replaced with Student.ITTSTARTDATE.
Previous Name of Rule
QR.C21053.PreviousQualification.DEGENDDT.2

QR.C23053.PreviousQualification.DEGEST.1

PreviousQualification.DEGEST must exist where Student.ITTSTARTDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021, 031 or 032) unless PreviousQualification.DEGCTRY exists.
Business RuleErrorAmended
Plain English
Either the previous degree establishment or the previous degree country must exist where the student is studying a postgraduate qualification in the current reporting period.
Further Guidance
N/A
Reason for Change
Student.ITTSTARTDATE added to ensure rule triggers only for new entrants.
Previous Name of Rule
QR.C21053.PreviousQualification.DEGEST.1

QR.C23053.PreviousQualification.DEGSBJ.1

PreviousQualification.DEGSBJ must exist where Student.ITTSTARTDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021, 031 or 032).
Business RuleErrorAmended
Plain English
Previous subject must exist where the student is studying for a postgraduate qualification in the current reporting period.
Further Guidance
N/A
Reason for Change
Student.ITTSTARTDATE added to ensure rule triggers only for new entrants.
Previous Name of Rule
QR.C21053.PreviousQualification.DEGSBJ.1

QR.C23053.PreviousQualification.DEGTYPE.1

PreviousQualification.DEGTYPE must exist where Student.ITTSTARTDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021, 031 or 032).
Business RuleErrorAmended
Plain English
Previous degree type must exist where the student is studying for a postgraduate qualification in the current reporting period.
Further Guidance
N/A
Reason for Change
Student.ITTSTARTDATE added to ensure rule triggers only for new entrants.
Previous Name of Rule
QR.C21053.PreviousQualification.DEGTYPE.1

QR.C23053.PreviousQualification.DEGTYPE.2

Where the Previous Qualification entity exists then PreviousQualification.DEGTYPE = 200-206 or 208-218, PreviousQualification.DEGCLSS should not = 01-04, except for students with a previous Integrated Masters Qualification
Business RuleWarningAmended
Plain English
It is not normally expected that a previous qualification degree type at Masters level would be returned with an undergraduate degree award class. An exception to this may be in cases of Integrated Masters qualifications.
Further Guidance
N/A
Reason for Change
Updated PreviousQualification.DEGTYPE with new valid entries for Integrated Masters.
Previous Name of Rule
N/A

QR.C23053.Student.APPLYAPPLICATIONID.1

Where exists, Student.APPLYAPPLICATIONID must be a 6-digit number and not a default code (e.g. 000000, 999999 etc.)
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule to check that new field Student.APPLYAPPLICATIONID has the correct format.
Previous Name of Rule
N/A

QR.C23053.Student.APPLYAPPLICATIONID.3

Student.APPLYAPPLICATIONID must not exist where Student.ENTRYRTE equals 09 or 11 (undergraduate entry routes).
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule to check that new field Student.APPLYAPPLICATIONID is not being returned for undergraduate students.
Previous Name of Rule
N/A

QR.C23053.Student.BIRTHDTE.1

Student.BIRTHDTE cannot be before (Y1-100)-08-01
Business RuleErrorCarried Forward
Plain English
A student cannot have a date of birth 100 years prior to the start of the reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.BIRTHDTE.1

QR.C23053.Student.BIRTHDTE.2

Student.BIRTHDTE cannot be after Y1-07-31
Business RuleErrorCarried Forward
Plain English
Student.BIRTHDTE cannot be in or after the current reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.BIRTHDTE.2

QR.C23053.Student.BIRTHDTE.3

Student.BIRTHDTE should be before (Y1-20)-08-01 where Student.QLAIM is a postgraduate qualification (020, 021 or 031)
Business RuleWarningCarried Forward
Plain English
The student should be at least 20 years old where they are studying for a postgraduate qualification.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.BIRTHDTE.3

QR.C23053.Student.BIRTHDTE.4

Student.BIRTHDTE should be before (Y1-17)-08-01 where Student.QLAIM = 001, 002, 003, 004, 007, 008, or 028
Business RuleWarningCarried Forward
Plain English
The student should be at least 17 years old where they are studying for an undergraduate qualification.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.BIRTHDTE.4

QR.C23053.Student.BIRTHDTE.5

Student.BIRTHDTE should be after (Y1-70)-07-31
Business RuleWarningCarried Forward
Plain English
It is anticipated that a student's age during the reporting period will be 70 or younger.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.BIRTHDTE.5

QR.C23053.Student.BIRTHDTE.6

Student.BIRTHDTE should be before (Y1-14)-07-31
Business RuleWarningCarried Forward
Plain English
It is anticipated that a student's age during the reporting period will be 14 or older.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.BIRTHDTE.6

QR.C23053.Student.BURSLEV.20

Student.BURSLEV = 4 can only exist where CourseSubject.SBJCA = 101060, 100425, 100403, 100406, 100358, 100366, 100372, 101038, 100417, 100321, 100323 or 100332 and (PreviousQualification.DEGCLSS = 01, 02, 03 or 04 or PreviousQualification.DEGTYPE = 200-206, 208-218 or 306).
Business RuleErrorAmended
Plain English
A 'Scholarship' bursary level can only be awarded where a student's subject of study is in a STEM subject (i.e. Chemistry, Maths, Physics or ICT) or is French Language, German Language or Spanish Language and one of their previous qualifications is a First or Second class degree with honours or a Masters or PhD degree.
Further Guidance
N/A
Reason for Change
Codes for French Language, German Language and Spanish Language added to CourseSubject.SBJCA and PreviousQualification.DEGTYPE clause added to the rule.
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.21

Student.BURSLEV should equal 4 where PreviousQualification.DEGCLSS = 01-04 and CourseSubject.SBJCA = 101060, 100425, 100403, 100406, 100358, 100366, 100372, 101038, 100417, 100321, 100323 or 100332 and Student.ENTRYRTE does not = 03 or 10.
Business RuleWarningAmended
Plain English
Although a student's subject of study is in a STEM subject (i.e. Chemistry, Maths, Physics or ICT) or is French Language, German Language or Spanish Language and previous qualification class is a First or Second class degree with honours, a 'Scholarship' bursary for which they may be eligible has not been awarded.
Further Guidance
N/A
Reason for Change
Amended rule to add CourseSubject.SBJCA codes 100321, 100323 and 10332.
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.22

Student.BURSLEV = D is only applicable when Student.FUNDCODE = 7 and CourseSubject.SBJCA = (100048, 100050, 100150, 100184, 100891, 100202, 100209, 100214, 100225, 101017, 101060, 100425, 100403, 100406, 100358, 100366, 100372, 101038, 100417, 101126, 101410, 101420, 101117, 100321, 100323, 100333, 100326, 100329, 101142, 100330, 100332, 101192, 101165, 100343, 100346, 100381, 100390, 100409, 100513 or 100320).
Business RuleErrorAmended
Plain English
A 'Postgraduate bursary' can only be awarded when the course subject is one of the specified subjects and the course is eligible for funding from the DfE.
Further Guidance
N/A
Reason for Change
Codes 100513 and 100320 have been added to the rule.
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.26

Student.BURSLEV should = D where CourseSubject.SBJCA = (100048, 100050, 100150, 100184, 100891, 100202, 100209, 100214, 100225, 101017, 101060, 100425, 100403, 100406, 100358, 100366, 100372, 101038, 100417, 101126, 101410, 101420, 101117, 100321, 100323, 100333, 100326, 100329, 101142, 100330, 100332, 101192, 101165, 100343, 100346, 100381, 100390 or 100409, 100513 or 100320)) and ((PreviousQualification.DEGCLSS = 12-14 and PreviousQualification.DEGTYPE = 200-218 or 401) or (PreviousQualification.DEGCLSS = 02 or 04 and PreviousQualification.DEGTYPE = 001-098, 200-206, 208-218, , 400 or 402)).
Business RuleWarningAmended
Plain English
Although a student's previous qualification class is either a '2:1' or 'Undivided second class' in an undergraduate or Integrated Masters degree or a Distinction, Merit or Pass in a Masters degree, a "Postgraduate Bursary" for which they may be eligible has not been awarded.
Further Guidance
N/A
Reason for Change
Codes 100513 and 100320 have been added to CourseSubject.SBJCA and 216, 217 and 218 added to PreviousQualification.DEGTYPE.
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.29

Student.BURSLEV does not = 4 or D where (CourseSubject.SBJCA = 100048, 100050, 100150, 100184, 100891, 100202, 100209, 100214, 100225, 101017, 101060, 100425, 100403, 100406, 100358, 100366, 100372, 101038, 100417, 101126, 101410, 101420, 101117, 100321, 100323, 100326, 100329, 101142, 100330, 100332, 100333, 101192, 101165, 100343, 100346, 100381, 100390, 100490, 100513 or 100320 and (PreviousQualification.DEGCLSS = 03 or 04 and PreviousQualification.DEGTYPE = 001-098, 200-206, 208 - 218, 400, 401 or 402)) or (CourseSubject.SBJCA = 100403, 100425, 101060 or 100390 and Student.ENTRYRTE does not = 03 or 10).
Business RuleWarningAmended
Plain English
A student has not been awarded a Scholarship or Postgraduate bursary although they meet the eligibility criteria.
Further Guidance
N/A
Reason for Change
Codes 100513 and 100320 added to CourseSubject.SBJCA and 216, 217 and 218 added to PreviousQualification.DEGTYPE.
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.32

Student.BURSLEV can only = B where Student.QLAIM = 001, 002, 003, 004, 007, 008 or 028 and (CourseSubject.SBJCA = 100403, 100425, 101060 or 100406) or (CourseSubject.SBJCA = 100366, 100372, 100358, 100321, 100323, 100332, 100326, 100329, 100330, 100333, 101142, 101192 or 101165 and Student.ENTRYRTE = 09).
Business RuleErrorAmended
Plain English
An 'Undergraduate bursary' can only be awarded where a student is studying for a secondary undergraduate degree in Maths or Physics, or it is in a Computing or Modern Foreign Languages subject and the student is on an Undergraduate Opt-in programme.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.33

Student.BURSLEV does not = B where Student.ENTRYRTE does not = 03 or 10 and Student.QLAIM = 001, 002, 003, 004, 007, 008 or 028 and (CourseSubject.SBJCA = 100403, 100425, 101060 or 100406) or (CourseSubject.SBJCA = 100366, 100372, 100358, 100321, 100323, 100332, 100326, 100329, 100330, 100333, 101142, 101192 or 101165 and Student.ENTRYRTE = 09).
Business RuleWarningAmended
Plain English
Although a student is on a secondary undergraduate degree in Maths or Physics, or in a Computing or Modern Foreign Languages subject and the the student is on an Undergraduate Opt-in programme, an 'Undergraduate bursary' for which they may be eligible has not been awarded.
Further Guidance
N/A
Reason for Change
Rule updated to include secondary for further clarification.
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.34

Student.BURSLEV must = 6 where all occurrences of CourseSubject.SBJCA are any of 100061, 100068, 100069, 100071, 100078, 100079, 100091, 100092, 100097, 100101, 100300, 100302, 100337, 100339, 100433, 100444, 100450, 100456, 100471, 100473, 100476, 100485, 100497, 100510, 100511, 100610, 100642, 100893, 101361 or 101373.
Business RuleErrorAmended
Plain English
The specified subjects are not eligible to have a bursary award, scholarship or grant awarded.
Further Guidance
N/A
Reason for Change
Specified subjects that are not eligible to have a bursary, scholarship or grant awarded have been updated. Student.BURSLEV = 6 is now No bursary, scholarship or grant awarded.
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.36

Student.BURSLEV must = 6 where Student.FUNDCODE = 2, unless Student.ITTSTARTDATE is after 31 July 2023 and CourseSubject.SBJCA is coded Languages (101192, 101165, 100321, 100323, 100326, 101169, 100329, 101142, 100330, 100332, 100333, 101117, 101126 or 101420) or Physics (101060 or 100425).
Business RuleErrorAmended
Plain English
A student must not receive a bursary, scholarship or grant where they are not eligible for DfE funding, unless their course started after 31 July 2023 and they are studying languages or physics.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.37

Student.BURSLEV must = 6 where Student.TTCID = 02 or 07
Business RuleErrorAmended
Plain English
A student must not receive a bursary, scholarship or grant where they are not studying an ITT course.
Further Guidance
N/A
Reason for Change
Rule updated as Student.BURSLEV = 6 is now No bursary, scholarship or grant awarded.
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.40

Where Student.BURSLEV = 4 or D then at least one PreviousQualification entity should exist.
Business RuleWarningCarried Forward
Plain English
Where a Scholarship or Postgraduate bursary has been awarded then it is expected that the student will have at least one previous qualification.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.41

Where Student.BURSLEV = C then Student.QLAIM must equal 001, 002, 003, 004, 007, 008 or 028 and CourseSubject.SBJCA must equal 101117, 100343, 101038, 100358, 101060, 101192, 100346, 100417, 101165, 101126, 100366, 100150, 100048, 100381, 101017, 100321, 100184, 100409, 100323, 100372, 100326, 101420, 100202, 100225, 100403, 100329, 100425, 101142, 100050, 100209, 100330, 100332, 100406, 100214, 101169, 100513, 100320 or 100333.
Business RuleErrorAmended
Plain English
An undergraduate veteran teaching bursary can only be awarded to undergraduates when the course subject is one of the specified subjects.
Further Guidance
N/A
Reason for Change
Rule amended to reflect changes to the course subjects that are available to trainees with Student.BURSLEV = C, which has been renamed as the Veteran Teaching undergraduate bursary.
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.42

Where Student.BURSLEV = E (Grant), Student.ENTRYRTE must equal 03 or 10.
Business RuleErrorAdded
Plain English
Valid entry E, 'Grant' should only be returned for employment-based entry routes.
Further Guidance
N/A
Reason for Change
New rule added to check that valid entry E, 'Grant' is only returned where the student's entry route is employment-based.
Previous Name of Rule
N/A

QR.C23053.Student.DISABLE.1

Where there is more than one occurrence of Student.DISABLE they must not be identical.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.DISABLE.2

There must be a single occurrence of ​Student.DISABLE when codes 95, 98 or 99 are returned.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.ENTRYRTE.2

Where Student.ENTRYRTE = 09 then Student.BURSLEV must = B or 6
Business RuleErrorAmended
Plain English
When entry route is 'Undergraduate Opt-In' then Bursary Level must either be 'Undergraduate bursary' or 'No bursary, scholarship or grant awarded'.
Further Guidance
N/A
Reason for Change
Rule amended as Student.BURSLEV = 6, is now No bursary, scholarship or grant awarded.
Previous Name of Rule
N/A

QR.C23053.Student.ENTRYRTE.4

Where Student.ENTRYRTE is coded 02, 03, 10 or 12 and Student.ITTAIM = 202, Student.QLAIM must be either 020, 021, or 031.
Business RuleErrorCarried Forward
Plain English
School Direct tution fee, School Direct salaried, Postgraduate teaching apprenticeship or Provider-led (postgraduate) must have a postgraduate qualification aim.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.ENTRYRTE.6

Where Student.ENTRYRTE is coded 09 or 11, Student.QLAIM (where exists) must not be coded 021 or 031.
Business RuleErrorAmended
Plain English
Where a student follows an undergraduate entry route, a postgraduate qualification aim must not be returned.
Further Guidance
N/A
Reason for Change
Student.QLAIM = 020 has been removed from the list of postgraduate qualification aims.
Previous Name of Rule
N/A

QR.C23053.Student.EXPECTEDENDDATE.1

Student.EXPECTEDENDDATE must be greater than or equal to Student.ITTSTARTDATE.
Business RuleErrorAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Student.COMDATE has been replaced with Student.ITTSTARTDATE
Previous Name of Rule
N/A

QR.C23053.Student.EXPECTEDENDDATE.2

If Student.MODE is not equal to 63 or 64, then Student.EXPECTEDENDDATE must be after Y1-07-31.
Business RuleErrorAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule amended as Student.EXPECTEDENDDATE is now a mandatory field.
Previous Name of Rule
N/A

QR.C23053.Student.EXPECTEDENDDATE.3

The expected length of study cannot be greater than 72 months (6 years) where Student.MODE = 01 or 02.
Business RuleErrorAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule amended so that Student.ITTSTARTDATE is used with Student.EXPECTEDENDDATE in the calculation of expected length of study.
Previous Name of Rule
QR.21053.Student.SPLENGTH.1, QR.21053.Student.SPLENGTH.2

QR.C23053.Student.FUNDCODE.1

Student.FUNDCODE code 7 is only available where Student.TTCID = 01.
Business RuleErrorCarried Forward
Plain English
Only students on an ITT Teacher Training course are eligible for funding from the DfE.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.FUNDCODE.1

QR.C23053.Student.FUNDCODE.2

Student.FUNDCODE code 7 is only available where Student.ITTPHSC is 13909, 13911, 13912, 13913, 13914, 13915, 13916, 13917, 13918 or 13919.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.FUNDCODE.2

QR.C23053.Student.HUSID.1

Student.HUSID must not contain all zeros
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.HUSID.1

QR.C23053.Student.HUSID.10

Where Student.ITTSTARTDATE is before 1-Aug-2022, the identifier returned in Student.HUSID must be 13-characters in length.
Business RuleErrorAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule amended because Student.COMDATE is being replaced with Student.ITTSTARTDATE.
Previous Name of Rule
N/A

QR.C23053.Student.HUSID.11

Where Student.ITTSTARTDATE is after 31-Jul-2022 and Student.HUSID starts with a 22 or higher, the identifier returned in Student.HUSID must be 17-characters in length. (Exclude where Student.HUSID starts with a 9).
Business RuleErrorAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule amended to exclude a Student.HUSID created in the 1990s
Previous Name of Rule
N/A

QR.C23053.Student.HUSID.2

If characters 1-4 of Student.HUSID are not 0000 then characters 3-6 must be a valid HESA INSTID plus 1000, where a 13-character identifier has been returned.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.HUSID.2

QR.C23053.Student.HUSID.3

Where a 13-character HUSID is returned, Student.HUSID must pass the 13-character checksum test given in the coding manual.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.HUSID.3

QR.C23053.Student.HUSID.4

Characters 3-6 of Student.HUSID must not be 3001 where characters 1-4 of Student.HUSID are not 0000, Student.ITTSTARTDATE is after 2007-07-31, and a 13-character identifier has been returned.
Business RuleErrorAmended
Plain English
INSTID 2001 is invalid.
Further Guidance
N/A
Reason for Change
Rule amended as Student.COMDATE has been replaced with Student.ITTSTARTDATE.
Previous Name of Rule
QR.C21053.Student.HUSID.4

QR.C23053.Student.HUSID.8

Where the identifier returned in Student.HUSID is 17 characters in length, characters 3-10 must be a valid UKPRN.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.HUSID.8

QR.C23053.Student.HUSID.9

Where the identifier returned in Student.HUSID is 17 characters in length, Student.HUSID must pass the checksum test given in the coding manual for 17 character identifiers.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.HUSID.9

QR.C23053.Student.INITIATIVES.1

Where there are two occurrences of Student.INITIATIVES they must not be identical
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.INITIATIVES.1

QR.C23053.Student.INITIATIVES.13

Where Student.INITIATIVES = 019, then the main CourseSubject.SBJCA must equal 100433, 100068 or 100097 and a subsequent CourseSubject.SBJCA must equal 100346, 100343, 100417, 101038, 100425, 100403, 100366, 100409, 100320, 101410, 100333, 101420, 101126, 100300, 100321, 100323, 100326, 100332, 101142, 100330, 100329, 100302, 101060, 100450 or 100390.
Business RuleErrorCarried Forward
Plain English
The 'Additional ITT place for PE with a priority subject' initiative should only be returned where the main course subject code is 'Physical Education' and a subsequent course subject is one of those specified.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.INITIATIVES.14

Where Student.INITIATIVES = 019, then CourseSubject.SBJCA must have at least two occurrences.
Business RuleErrorCarried Forward
Plain English
'Additional ITT place for PE with a priority subject' initiative must be returned with at least two course subject codes.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.INITIATIVES.15

Where Student.INITIATIVES = 025 or 026, then Student.QLAIM where exists must be coded 020, 021, 031 or 032 and Student.ENTRYRTE must be coded 02, 03, 11 or 12.
Business RuleErrorAmended
Plain English
These initiatives codes can only be entered for postgraduate qualification aims where the entry routes are 'Provider-led (undergraduate)', 'Provider-led (postgraduate)','School Direct Salaried' or 'School Direct Tuition Fee'.
Further Guidance
N/A
Reason for Change
Rule amended so that students on School Direct Salaried routes with ITT qualification aim of Professional status only and no qualification aim can be coded to these initiatives.
Previous Name of Rule
N/A

QR.C23053.Student.INITIATIVES.16

When Student.INITIATIVES = 001, 009, 011, 019 or 025, Student.ITTSTARTDATE and where exists Student.TRAINEESTARTDATE must be before 2023-08-01.
Business RuleErrorAdded
Plain English
Student.INITIATIVES = 001, 009, 011, 019 and 025 are no longer active and can only be returned for continuing students who started before 1 August 2023.
Further Guidance
N/A
Reason for Change
New rule added as Student.INITIATIVES = 001, 009, 011, 019 and 025 are no longer active and only available to continuing students.
Previous Name of Rule
N/A

QR.C23053.Student.INITIATIVES.2

Student.INITIATIVES = 011 can only exist where Student.TTCID = 01 and CourseSubject.SBJCA = 101085 and Student.ITTPHSC = 13909 - 13915.
Business RuleErrorCarried Forward
Plain English
Initiatives can only be 'Primary mathematics specialist' where a student is studying a primary level ITT course with a subject 'Training teachers - specialist'.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.INITIATIVES.2

QR.C23053.Student.INITIATIVES.8

Student.ENTRYRTE must be coded 02 or 03 where Student.INITIATIVES = 009.
Business RuleErrorCarried Forward
Plain English
The entry route must be 'School Direct salaried' or 'School Direct tuition fee' where the initiative is 'Maths and Physics Chairs Programme'
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.INITIATIVES.9

Where Student.INITIATIVES = 001 then Student.ENTRYRTE must = 03.
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.ITTPHSC.2

Student.ITTPHSC codes 99801 or 99803 are only available where Student.TTCID = 02.
Business RuleErrorCarried Forward
Plain English
When a student's ITT phase/scope is either 'Further education' or 'Other' then they can not be studying an ITT course.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.ITTPHSC.2

QR.C23053.Student.ITTSTARTDATE.1

Student.ITTSTARTDATE must be before Y2-08-01.
Business RuleErrorAdded
Plain English
Student.ITTSTARTDATE must be before the end of the reporting period.
Further Guidance
N/A
Reason for Change
Student.COMDATE has been replaced with Student.ITTSTARTDATE. This rule ensures that Student.ITTSTARTDATE is before Y2-08-01.
Previous Name of Rule
N/A

QR.C23053.Student.ITTSTARTDATE.2

Student.ITTSTARTDATE must not be before (Y1-1)-08-01 where YEARPRG = 1.
Business RuleErrorAdded
Plain English
Student.ITTSTARTDATE cannot be more than 1 year before start of current academic year, where this is the first year of programme.
Further Guidance
N/A
Reason for Change
New rule to ensure that Student.ITTSTARTDATE cannot be more than 1 year before start of current academic year, where this is the first year of programme.
Previous Name of Rule
N/A

QR.C23053.Student.MODE.1

Student.MODE cannot be coded 01 or 02 when an instance is 5 months or less.
Business RuleErrorAmended
Plain English
When an instance is 5 months or less in length then it can not be recorded as full-time.
Further Guidance
N/A
Reason for Change
Student.ITTSTARTDATE replaces Student.COMDATE in the calculation of length of instance.
Previous Name of Rule
QR.C22053.Student.MODE.1

QR.C23053.Student.NATION.1

Student.Nation = XC (Cyprus not otherwise specified) is not a valid code for nationality in the ITT record.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
Student.NATION = XC is only valid for instances starting prior to 2007/08 or for those who enter through UCAS. It is not expected that ITT students will have entered through UCAS.
Previous Name of Rule
N/A

QR.C23053.Student.NQTEMAIL.2

Student.NQTEMAIL field must contain at least seven characters, including an '@' and '.'.
Business RuleErrorAmended
Plain English
Student.NQTEMAIL must contain a valid email format.
Further Guidance
N/A
Reason for Change
Rule has been changed from a warning to an error as returning the student's email is a requirement.
Previous Name of Rule
N/A

QR.C23053.Student.NQTEMAIL.3

The trainees current personal email address must be returned in Student.NQTEMAIL.
Business RuleErrorAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
This rule has been changed from a warning to an error as the student's personal email is a requirement.
Previous Name of Rule
N/A

QR.C23053.Student.PGAPPSTDT.1

Where Student.PGAPPSTDT exists then Student.ENTRYRTE must equal 10.
Business RuleErrorCarried Forward
Plain English
Where the start date of a postgraduate's teaching apprenticeship is returned then the student must be on a Postgraduate teaching apprenticeship.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.PGAPPSTDT.2

Where Student.ENTRYRTE equals 10, Student.PGAPPSTDT must exist.
Business RuleErrorCarried Forward
Plain English
Where the student is on a Postgraduate teaching apprenticeship, the start date of the apprenticeship must be returned.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.Placement.1

Student.Placement entity should exist for a student except where Student.MODE = 63 or 64.
Business RuleWarningCarried Forward
Plain English
Student.Placement entity should exist for a student except where the student is dormant.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.PreviousQualification.1

PreviousQualification entity must exist where Student.ITTSTARTDATE is in the current reporting period and ((Student.QLAIM = 020, 021, 031 or 032) or (Student.TTCID = 01 and Student.ITTAIM = 201)).
Business RuleErrorAmended
Plain English
A previous qualification must exist where the student commenced studying during this reporting period and is either a postgraduate or on an ITT course with an aim of 'Professional status only'.
Further Guidance
N/A
Reason for Change
Student.ITTSTARTDATE added to ensure rule triggers only for new entrants.
Previous Name of Rule
QR.C21053.PreviousQualification.1

QR.C23053.Student.QLAIM.1

Student.QLAIM must exist where Student.ITTAIM = 202
Business RuleErrorCarried Forward
Plain English
Qualification Aim must exist where the ITT qualification aim is 'Both professional status and academic award'.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.SDEMPLOY.1

Student.SDEMPLOY must exist where Student.ENTRYRTE = 03 or 10 and Student.MODE is not equal to 63 or 64.
Business RuleErrorCarried Forward
Plain English
Employing school must exist for School Direct salaried and Postgraduate teaching apprenticeship trainees.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.SDEMPLOY.2

Student.SDEMPLOY must not exist where Student.ENTRYRTE does not equal 03 or 10.
Business RuleErrorCarried Forward
Plain English
Employing school must not exist where their entry route is not for School Direct salaried or Postgraduate teaching apprenticeship trainees.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.SDEMPLOY.4

Student.SDEMPLOY is not a generic code and does not exist in the lookup file provided by Edubase.
Business RuleErrorAmended
Plain English
The school code returned is not a generic code or a valid URN (Unique Reference Number).
Further Guidance
N/A
Reason for Change
Rule updated to match new generic codes for the field.
Previous Name of Rule
N/A

QR.C23053.Student.SDEMPLOY.5

Student.SDEMPLOY should exist where Student.ENTRYRTE = 03 or 10, Student.FUNDCODE = 7 and Student.TTCID = 01.
Business RuleWarningCarried Forward
Plain English
Students on School Direct salaried or PGTA entry routes are not eligible for funding from the DfE unless an employing school exists.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.SDLEAD.1

Student.SDLEAD must exist where Student.ENTRYRTE = 02 or 03 or 10 and Student.MODE is not equal to 63 or 64.
Business RuleErrorCarried Forward
Plain English
Lead school must exist for School Direct and Postgraduate teaching apprenticeship trainees.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.SDLEAD.2

Student.SDLEAD must not exist where Student.ENTRYRTE does not equal 02 or 03 or 10.
Business RuleErrorCarried Forward
Plain English
Lead school must not exist where entry route is not for School Direct trainees.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.SDLEAD.4

Student.SDLEAD is not a generic code and does not exist in the lookup file.
Business RuleErrorAmended
Plain English
The school code returned is not a generic code or a valid URN (Unique Reference Number).
Further Guidance
N/A
Reason for Change
Rule updated to match new generic codes for the field.
Previous Name of Rule
N/A

QR.C23053.Student.SDLEAD.5

Student.SDLEAD should exist where Student.ENTRYRTE = 02, 03 or 10, Student.FUNDCODE= 7 and Student.TTCID = 01.
Business RuleWarningCarried Forward
Plain English
Students on School Direct salaried, School Direct tuition fee or PGTA entry routes are not eligible for funding from the DfE unless a lead school exists.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.SEXID.1

Student.SEXID is coded 12 for 5 or more students.
Business RuleWarningCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.SEXID.1

QR.C23053.Student.TRAINEESTARTDATE.1

Where exists, Student.TRAINEESTARTDATE must be before Y2-08-01.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule to replace Sudent.ITTCOMDATE with Student.TRAINEESTARTDATE. Dates returned in Student.TRAINEESTARTDATE must be before the next reporting period.
Previous Name of Rule
N/A

QR.C23053.Student.TRAINEESTARTDATE.2

Where exists, Student.TRAINEESTARTDATE must not be earlier than Student.ITTSTARTDATE.
Business RuleErrorAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule to replace Sudent.ITTCOMDATE with Student.TRAINEESTARTDATE. Dates returned in Student.TRAINEESTARTDATE must not be earlier than Student.ITTSTARTDATE.
Previous Name of Rule
N/A

QR.C23053.Student.TRN.1

Where Student.TRN exists, it must be 7 numbers and not a default code (e.g. 999999999 or 000000000).
Business RuleErrorCarried Forward
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.YEARPRG.1

Student.YEARPRG code 0 is only available where Student.QLAIM = 001, 002, 003, 004, 007, 008 or 028.
Business RuleErrorCarried Forward
Plain English
Foundation year is only available for undergraduates.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C22053.Student.YEARPRG.1

QR.C23053.Student.YEARPRG.2

Student.YEARPRG should be less than or equal to expected length of study in years where Student.MODE is less than 40 and Student.YEARPRG is not coded 99.
Business RuleWarningAmended
Plain English
A student's year of course should be less than or equal to the expected length of study for non-dormant students. Expected length of study is calculated using Student.ITTSTARTDATE and Student.EXPECTEDENDDATE.
Further Guidance
N/A
Reason for Change
Rule updated as Student.COMDATE has been replaced with Student.ITTSTARTDATE
Previous Name of Rule
QR.C22053.Student.YEARPRG.2

QR.C23053.Student.APPLYAPPLICATIONID.2

More than 10% of students where Student.ENTRYRTE equals 02, 03, 10 or 12 (postgraduate) have been returned with no Student.APPLYAPPLICATIONID.
ExceptionWarningAdded
Plain English
More than 10% of postgraduate students have been returned with no Student.APPLYAPPLICATIONID.
Further Guidance
N/A
Reason for Change
New rule to check that the new field Student.APPLYAPPLICATIONID has been completed for more than 90% of postgraduate students.
Previous Name of Rule
N/A

QR.C23053.Student.NQTEMAIL.1

More than 25.0% of students have not returned Student.NQTEMAIL.
ExceptionWarningCarried Forward
Plain English
More than 25.0% of students have not returned an email address.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.SDEMPLOY.3

More than 10.0% of students have Student.SDEMPLOY = 900000 or 900010.
ExceptionWarningCarried Forward
Plain English
More than 10.0% of students have an employing school of '900010 Not applicable/not available' or '900000 Establishment outside England and Wales'.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.SDLEAD.3

More than 10.0% of students have Student.SDLEAD = 900000 or 900010.
ExceptionWarningCarried Forward
Plain English
More than 10.0% of students have a lead school of '900010 Not applicable/not available' or '900000 Establishment outside England and Wales'.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C23053.Student.SEXID.2

It is not expected that there will be more than 3% of staff with Student.SEXID = 99, Not available.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule where there are a high number of unknowns (not available) being returned.
Previous Name of Rule
N/A

QR.C23053.Student.SEXID.3

It is not expected that there will be more than 3% of staff with Student.SEXID = 96, Information refused.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule where there are a high number of unknowns (information refused) being returned.
Previous Name of Rule
N/A

QR.C23053.Student.BURSLEV.38

Student.BURSLEV must = 6 where Student.ENTRYRTE = 03 or 10
Business RuleErrorDeleted
Plain English
A student must not receive a bursary where their entry route is School Direct salaried or a postgraduate teaching apprenticeship.
Further Guidance
N/A
Reason for Change
Rule deleted due to update to Student.BURSLEV = 6. Grant can be awarded for employment-based entry routes.
Previous Name of Rule
N/A

QR.C23053.Student.COMDATE.1

Student.COMDATE must not be before 1992-01-31
Business RuleErrorDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted due to Student.COMDATE removal from the record.
Previous Name of Rule
QR.C22053.Student.COMDATE.1

QR.C23053.Student.COMDATE.2

Student.COMDATE must be before Y2-08-01
Business RuleErrorDeleted
Plain English
Student.COMDATE must be before the end of the reporting period.
Further Guidance
N/A
Reason for Change
Rule deleted due to Student.COMDATE removal from the record.
Previous Name of Rule
QR.C22053.Student.COMDATE.2

QR.C23053.Student.ENDDATE.4

Student.ENDDATE must be before Y2-08-01
Business RuleErrorDeleted
Plain English
Where a specific Student.ENDDATE has been returned it must be before the end of the reporting period.
Further Guidance
N/A
Reason for Change
Rule deleted due to Student.ENDDATE being removed from the record.
Previous Name of Rule
QR.C22053.Student.ENDDATE.4

QR.C23053.Student.ENDDATE.5

If Student.Mode is not equal to 63 or 64, then Student.ENDDATE must be after Y1-07-31
Business RuleErrorDeleted
Plain English
Unless the student is dormant, then where a specific Student.ENDDATE has been returned it must be after the start of the reporting period.
Further Guidance
N/A
Reason for Change
Rule deleted due to Student.ENDDATE being removed from the record.
Previous Name of Rule
QR.C22053.Student.ENDDATE.5

QR.C23053.Student.ENDDATE.6

Student.ENDDATE must be after (Y2-6)-07-31 when Student.MODE = 63 or 64
Business RuleErrorDeleted
Plain English
When a student is dormant then Student.ENDDATE must be within the last 6 years as at the end of the reporting period.
Further Guidance
N/A
Reason for Change
Rule deleted as Student.ENDDATE has been removed from the record.
Previous Name of Rule
QR.C22053.Student.ENDDATE.6

QR.C23053.Student.ENDDATE.7

Student.ENDDATE must be after or the same as Student.COMDATE unless (Student.MODE = 63 or 64 and Student.ENDDATE = (Y1-1)-08-01)
Business RuleErrorDeleted
Plain English
Student.ENDDATE must be equal to or greater than Student.COMDATE except where the student is dormant and Student.ENDDATE equals the start of the previous reporting period.
Further Guidance
N/A
Reason for Change
The rule is being deleted as Student.ENDDATE has been removed from the record.
Previous Name of Rule
QR.C22053.Student.ENDDATE.7

QR.C23053.Student.ENTRYRTE.3

Where Student.ENTRYRTE = 10 then Student.PGAPPSTDT (where exists) must be after 2018-08-31 otherwise Student.ITTCOMDATE (where exists) must be after 2018-08-31 otherwise Student.COMDATE must be after 2018-08-31.
Business RuleErrorDeleted
Plain English
A Postgraduate teaching apprenticeship entry route is only available to trainees starting from September 2018.
Further Guidance
N/A
Reason for Change
Rule deleted because Student.PGAPPSTDT is unlikely to be before 2018-08-31 and Student.COMDATE has been removed from the record.
Previous Name of Rule
N/A

QR.C23053.Student.EXPECTEDENDDATE.4

Student.EXPECTEDENDDATE should exist where Student.YEARPRG is not 99.
Business RuleWarningDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
This rule has been deleted because Student.EXPECTEDENDDATE is mandatory from C23053.
Previous Name of Rule
N/A

QR.C23053.Student.ITTCOMDATE.1

Where exists Student.ITTCOMDATE must not be earlier than Student.COMDATE
Business RuleErrorDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule to be deleted because Student.ITTCOMDATE and Student.COMDATE have been removed from the ITT record.
Previous Name of Rule
QR.C22053.Student.ITTCOMDATE.1

QR.C23053.Student.ITTCOMDATE.2

Student.ITTCOMDATE must be before Y2-08-01.
Business RuleErrorDeleted
Plain English
N/A
Further Guidance
Dates returned in Student.ITTCOMDATE must be before the next reporting period.
Reason for Change
Rule deleted because Student.ITTCOMDATE has been removed from the ITT record.
Previous Name of Rule
N/A

QR.C23053.Student.ITTPHSC.1

Student.ITTPHSC codes 13909 - 13919 are only available where Student.TTCID = 01 and Student.COMDATE is after 2007-07-31.
Business RuleErrorDeleted
Plain English
These ITT phase/scope values can only be used for students who started studying an ITT course after 31 July 2007.
Further Guidance
N/A
Reason for Change
Rule has been deleted because it is unlikely that there will be students who studied before 2007.
Previous Name of Rule
QR.C22053.Student.ITTPHSC.1

QR.C23053.Student.RSNEND.1

Student.RSNEND must exist where Student.ENDDATE is not null
Business RuleErrorDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
This rule is being deleted because Student.ENDDATE and Student.RSNEND have been removed from the record.
Previous Name of Rule
QR.C22053.Student.RSNEND.1