Skip to main content

Quality Rules Directory for C17053

Download all the C17053 rules

Filter

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

QR.C17053.CourseSubject.SBJCA.1

CourseSubject.SBJCA must be coded C100, C600, C690, D600, F100, F300, G100, I100, I200, L100, L230, L390, L510, L700, P300, P390, Q300, Q560, R100, R200, R300, R400, R500, R900, V100, V600, W200, W300, W310, W400, W500, W900, X900, X120, X121 or X160 where Student.TTCID = 1 and any Student.ITTPHSC = 71 - 77
Business RuleErrorCarried Forward
Show more
Plain English
Students on an ITT course at Primary level must be studying one of the specified subjects.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
CourseSubject.SBJCA.BusinessRule.1

QR.C17053.CourseSubject.SBJCA.2

CourseSubject.SBJCA must be coded C900, C100, C110, C600, C800, D600, F900, F100, F110, F300, F310, F390, F750, G100, H790, I100, I200, I900, H700, H900, J420, J500, K290, L100, L230, L390, L510, L700, L900, L990, M990, N100, N190, N800, N862, N870, N890, N900, N990, P300, P390, Q300, Q490, Q560, Q610, Q710, Q800, R100, R200, R300, R400, R500, R700, R900, V100, V600, W200, W210, W300, W310, W400, W500, W900 or W990 where Student.TTCID = 1 and any Student.ITTPHSC = 54 - 57, or 78 - 81
Business RuleErrorCarried Forward
Show more
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
N/A
Previous Name of Rule
CourseSubject.SBJCA.BusinessRule.3

QR.C17053.CourseSubject.SBJCA.3

One, and only one CourseSubject.SBJCA must be coded F900 where any CourseSubject.SBJCA = C900 and Student.TTCID = 1 and Student.ITTPHSC = 54 - 57, or 78 - 81
Business RuleErrorCarried Forward
Show more
Plain English
Students on an ITT course at Secondary level studying Biological sciences (Combined/General Sciences) must also be studying Physical sciences (Combined/General Sciences).
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
CourseSubject.SBJCA.Business Rule.4

QR.C17053.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
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
CourseSubject.SBJCA.Business Rule.5

QR.C17053.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
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
CourseSubject.SBJCA.Business Rule.6

QR.C17053.CourseSubject.SBJCA.6

One, and only one CourseSubject.SBJCA must be coded C900 where any CourseSubject.SBJCA = F900 and Student.TTCID = 1 and Student.ITTPHSC = 54 - 57, or 78 - 81
Business RuleErrorCarried Forward
Show more
Plain English
Students on an ITT course at Secondary level studying Physical sciences (Combined/General Sciences) must also be studying Biological sciences (Combined/General Sciences).
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
CourseSubject.SBJCA.Business Rule.7

QR.C17053.CourseSubject.SBJCA.7

For providers in England where Student.TTCID = 1 and Student.ITTPHSC = 54 - 57, or 78 - 81, CourseSubject.SBJCA codes C110, F110 and F310 must always be used together as a triplet.
Business RuleErrorCarried Forward
Show more
Plain English
Students on an ITT course at Secondary level when studying Applied sciences must be returned with all three Applied science codes.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
CourseSubject.SBJCA.BusinessRule.8

QR.C17053.CourseSubject.SBJCA.8

CourseSubject.SBJCA codes C100, F100 and F300 can only be used together when Student.TTCID = 1 and Student.ITTPHSC = 51 - 53, or 71 - 77.
Business RuleErrorCarried Forward
Show more
Plain English
Only one of the 3 Science subjects (C100, F100 and F300) 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
CourseSubject.SBJCA.Business Rule.9

QR.C17053.CourseSubject.SBJCA.9

Student.FUNDCODE should = 2 where CourseSubject.SBJCA = W990, N190, W900, N100, N990, L230, P390, P900, W500, W400, L100, H990, B990, L510, M990, P300, W310, L390, C600, L430, C800, N870, N900, L900, L990, N890, X110, N800 and Student.ENTRYRTE = 03 and Student.COMDATE should be after Y1-07-31
Business RuleWarningCarried Forward
Show more
Plain English
Students on a School Direct (salaried) entry route studying a subject under the areas of Art, Business, Citizenship/PHSE/Public Services, Media, Dance & Drama, Economics, Engineering, Beauty, Health & Social Care, Law, PE/Sports Studies, Psychology, Retail, Social Sciences, Training Teachers (nursery) or Travel & Tourism, will not be eligible to receive funding from the NCTL 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 NCTL if they have begun their studies in the current reporting period.
Reason for Change
N/A
Previous Name of Rule
CourseSubject.SBJCA.BusinessRule.11

QR.C17053.PreviousQualification.BURSFLAG.1

PreviousQualification.BURSFLAG can only occur up to once where more than one occurrence of a PreviousQualification entity exists
Business RuleErrorCarried Forward
Show more
Plain English
Only one of the previous qualifications returned can be related to the bursary awarded to the student.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.PreviousQualification.DEGCLSS.1

PreviousQualification.DEGCLSS must exist where Student.COMDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021 or 031)
Business RuleErrorAdded
Show more
Plain English
Previous degree class must exist where the student commenced studying for a postgraduate qualification in current reporting period.
Further Guidance
N/A
Reason for Change
Rule added to replace QR.Cyy053.PreviousQualification.PGCECLSS.1 for new field PreviousQualification.DEGCLSS.
Previous Name of Rule
QR.C16053.PreviousQualification.PGCECLSS.1

QR.C17053.PreviousQualification.DEGCTRY.1

PreviousQualification.DEGCTRY must exist where Student.COMDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021 or 031) and PreviousQualification.DEGEST does not exist
Business RuleErrorCarried Forward
Show more
Plain English
Previous degree country must exist where the previous degree establishment does not exist and the student commenced studying for a postgraduate qualification in current reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C15053.Student.DEGCTRY.1

QR.C17053.PreviousQualification.DEGCTRY.2

PreviousQualification.DEGCTRY must not exist where PreviousQualification.DEGEST exists
Business RuleErrorCarried Forward
Show more
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.C15053.Student.DEGCTRY.2

QR.C17053.PreviousQualification.DEGENDDT.1

PreviousQualification.DEGENDDT must exist where Student.COMDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021 or 031)
Business RuleErrorCarried Forward
Show more
Plain English
Previous degree end date must exist where the student commenced studying for a postgraduate qualification in current reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C15053.Student.DEGENDDT.1

QR.C17053.PreviousQualification.DEGENDDT.2

PreviousQualification.DEGENDDT must not be later than Student.COMDATE
Business RuleErrorCarried Forward
Show more
Plain English
Previous degree end date must not be later than the student's start date of instance.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C15053.Student.DEGENDDT.2

QR.C17053.PreviousQualification.DEGENDDT.3

PreviousQualification.DEGENDDT where exists must be later than PreviousQualification.DEGSTDT
Business RuleErrorCarried Forward
Show more
Plain English
Where previous degree end date exists, it must be later than the previous degree start date.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C15053.Student.DEGENDDT.3

QR.C17053.PreviousQualification.DEGEST.1

PreviousQualification.DEGEST must exist where Student.COMDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021 or 031) unless PreviousQualification.DEGCTRY exists
Business RuleErrorCarried Forward
Show more
Plain English
Either the previous degree establishment or the previous degree country must exist where the student commenced studying for a postgraduate qualification in the current reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C15053.Student.DEGEST.1

QR.C17053.PreviousQualification.DEGLENGTH.1

PreviousQualification.DEGLENGTH must exist where Student.COMDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021 or 031)
Business RuleErrorCarried Forward
Show more
Plain English
Previous degree length must exist where the student commenced studying for a postgraduate qualification in current reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C15053.Student.DEGLENGTH.1

QR.C17053.PreviousQualification.DEGSBJ.1

PreviousQualification.DEGSBJ must exist where Student.COMDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021 or 031)
Business RuleErrorAdded
Show more
Plain English
Previous subject must exist where the student commenced studying for a postgraduate qualification in current reporting period.
Further Guidance
N/A
Reason for Change
Rule added to replace QR.Cyy053.PreviousQualification.PGCESBJ.1 for new field PreviousQualification.DEGSBJ.
Previous Name of Rule
QR.C16053.PreviousQualification.PGCESBJ.1

QR.C17053.PreviousQualification.DEGSTDT.1

PreviousQualification.DEGSTDT must exist where Student.COMDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021 or 031)
Business RuleErrorCarried Forward
Show more
Plain English
Previous degree start date must exist where the student commenced studying for a postgraduate qualification in current reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C15053.Student.DEGSTDT.1

QR.C17053.PreviousQualification.DEGTYPE.1

PreviousQualification.DEGTYPE must exist where Student.COMDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021 or 031)
Business RuleErrorCarried Forward
Show more
Plain English
Previous degree type must exist where the student commenced studying for a postgraduate qualification in current reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C15053.Student.DEGTYPE.1

QR.C17053.PreviousQualification.DEGTYPE.2

Where PreviousQualification.DEGTYPE = 200-206 or 208-215, PreviousQualification.DEGCLSS should not = 01-04, except for students with a previous Integrated Masters qualification
Business RuleWarningAmended
Show more
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
Rule updated to rename PreviousQualification.PGCECLSS to PreviousQualification.DEGCLSS.
Previous Name of Rule
N/A

QR.C17053.PreviousQualification.FIRSTDEG.1

Where more than one occurrence of a PreviousQualification entity exists, only one occurrence of PreviousQualification.FIRSTDEG must be coded 01
Business RuleErrorCarried Forward
Show more
Plain English
Only one previous qualification can be flagged as the student's first degree obtained.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.BIRTHDTE.1

Student.BIRTHDTE cannot be before 1906-11-01
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.BIRTHDTE.Business Rule.1

QR.C17053.Student.BIRTHDTE.2

Student.BIRTHDTE cannot be after Y1-07-31
Business RuleErrorCarried Forward
Show more
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
Student.BIRTHDTE.Business Rule.2

QR.C17053.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
Show more
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
Student.BIRTHDTE.BusinessRule.3

QR.C17053.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
Show more
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
Student.BIRTHDTE.Business Rule.4

QR.C17053.Student.BIRTHDTE.5

Student.BIRTHDTE should be after (Y1-70)-07-31
Business RuleWarningCarried Forward
Show more
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
Student.BIRTHDTE.Business Rule.5

QR.C17053.Student.BIRTHDTE.6

Student.BIRTHDTE should be before (Y1-14)-07-31
Business RuleWarningCarried Forward
Show more
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
Student.BIRTHDTE.Business Rule.6

QR.C17053.Student.BURSLEV.20

Student.BURSLEV = 4 can only exist where CourseSubject.SBJCA = F100, F110, F300, F310, F390, F900, G100, I100, I200, I900, L700, R100, R200 or R400 and (PreviousQualification.BURSFLAG = 01 and PreviousQualification.DEGCLSS = 01-04)
Business RuleErrorAmended
Show more
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, ICT, Geography, French, German or Spanish) and their previous qualification which makes them eligible to receive a bursary is a First or Second class degree with honours.
Further Guidance
N/A
Reason for Change
Replaced R900 (Other Foreign Languages) with codes for specific Languages of R100 (French), R200 (German) and R400 (Spanish).
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.21

Student.BURSLEV does not = 4 where PreviousQualification.DEGCLSS = 01-04 and CourseSubject.SBJCA = F100, F110, F300, F310, F390, F900, G100, I100, I200, I900, L700, R100, R200 or R400 and Student.ENTRYRTE does not = 03.
Business RuleWarningAmended
Show more
Plain English
Although a student's subject of study is in a stem subject (i.e. Chemistry, Maths, Physics, ICT, Geography, French, German or Spanish) 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
Replaced R900 (Other Foreign Languages) with codes for specific Languages of R100 (French), R200 (German) and R400 (Spanish).
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.22

Student.BURSLEV = 7 or 8 are only applicable when CourseSubject.SBJCA = C100, C110, C690, C900, D600, F100, F110, F300, F310, F390, F750, F900, G100, H700, H790, H900, I100, I200, I900, J420, J500, K290, L700, N862, Q300, Q490, Q560, Q610, Q710, Q800, R100, R200, R300, R400, R500, R700, R900, V100, V600, W200, W210, W300, X120, X121, X160 or X900
Business RuleErrorCarried Forward
Show more
Plain English
A 'Tier 1' or 'Tier 2' bursary can only be awarded when the course subject is one of the specified subjects.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.23

Student.BURSLEV = 7 can only exist where PreviousQualification.BURSFLAG = 01 and ((PreviousQualification.DEGCLSS = 01 and PreviousQualification.DEGTYPE = 001-098, 200-206, 208-215, 400 or 402) or where (PreviousQualification.DEGCLSS = 12 and PreviousQualification.DEGTYPE = 064, 077, 090, 094-096 or 401) or where (PreviousQualification.DEGTYPE = 300-306))
Business RuleErrorAmended
Show more
Plain English
A 'Tier 1' bursary level can only be awarded where a student's previous qualification which makes them eligible to receive a bursary is either a First Class in an undergraduate or Integrated Masters degree, a Distinction in a Medical Masters or a PhD.
Further Guidance
N/A
Reason for Change
Rule updated to rename PreviousQualification.PGCECLSS to PreviousQualification.DEGCLSS.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.24

Student.BURSLEV does not = 4 or 7 and CourseSubject.SBJCA = C100, C110, C690, C900, D600, F100, F110, F300, F310, F390, F750, F900, G100, H700, H790, H900, I100, I200, I900, J420, J500, K290, L700, N862, Q300, Q490, Q560, Q610, Q710, Q800, R100, R200, R300, R400, R500, R700, R900, V100, V600, W200, W210, W300, X120, X121, X160 or X900 where ((PreviousQualifications.DEGTYPE = 300-306) or (PreviousQualification.DEGCLSS = 01 and PreviousQualification.DEGTYPE = 001-098, 200-206, 208-215, 400 or 402) or (PreviousQualification.DEGCLSS = 12 and PreviousQualification.DEGTYPE = 064, 077, 090, 094, 095, 096 or 401)) and Student.ENTRYRTE does not = 03.
Business RuleWarningAmended
Show more
Plain English
Although a student's previous qualification class is either a First Class in an undergraduate or Integrated Masters degree, a Distinction in a Medical Masters or a PhD, a 'Scholarship' or 'Tier 1' bursary for which they may be eligible has not been awarded.
Further Guidance
N/A
Reason for Change
Rule updated to rename PreviousQualification.PGCECLSS to PreviousQualification.DEGCLSS. Also updated to exclude Student.ENTRYRTE code 03.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.25

Student.BURSLEV = 8 can only exist where PreviousQualification.BURSFLAG = 01 and ((PreviousQualification.DEGCLSS = 02 or 04 and PreviousQualification.DEGTYPE = 001-098, 200-206, 208-215, 400 or 402) or (PreviousQualification.DEGCLSS = 12-14 and PreviousQualification.DEGTYPE = 200-215 or 401))
Business RuleErrorAmended
Show more
Plain English
A 'Tier 2' bursary level can only be awarded where a student's previous qualification which makes them eligible to receive a bursary is either a '2:1' or 'Undivided second class' in an undergraduate or Integrated Masters degree or a Distinction, Merit or Pass or in a Masters degree.
Further Guidance
N/A
Reason for Change
Rule updated to rename PreviousQualification.PGCECLSS to PreviousQualification.DEGCLSS.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.26

Student.BURSLEV does not = 4, 7 or 8 and CourseSubject.SBJCA = C100, C110, C690, C900, D600, F100, F110, F300, F310, F390, F750, F900, G100, H700, H790, H900, I100, I200, I900, J420, J500, K290, L700, N862, Q300, Q490, Q560, Q610, Q710, Q800, R100, R200, R300, R400, R500, R700, R900, V100, V600, W200, W210, W300, X120, X121, X160 or X900 where ((PreviousQualification.DEGCLSS = 12-14 and PreviousQualification.DEGTYPE = 200-215 or 401) or (PreviousQualification.DEGCLSS = 02 or 04 and PreviousQualification.DEGTYPE = 001-098, 200-206, 208-215, 400 or 402)) and Student.ENTRYRTE does not = 03.
Business RuleWarningAmended
Show more
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 or in a Masters degree, a 'Scholarship', 'Tier 1' or 'Tier 2' bursary for which they may be eligible has not been awarded.
Further Guidance
N/A
Reason for Change
Rule updated to rename PreviousQualification.PGCECLSS to PreviousQualification.DEGCLSS. Also updated to exclude Student.ENTRYRTE code 03.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.27

Student.BURSLEV = 9 is only applicable when CourseSubject.SBJCA = C100, C110, C900, F100, F110, F300, F310, F390, F750, F900, G100, I100, I200, I900, L700, Q490, Q560, Q610, Q710, R100, R200, R300, R400, R500, R700, R900, X120 or X160
Business RuleErrorCarried Forward
Show more
Plain English
A 'Tier 3' bursary can only be awarded when the course subject is one of the specified subjects.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.28

Student.BURSLEV = 9 can only exist where PreviousQualification.BURSFLAG = 01 and (PreviousQualification.DEGCLSS = 03 or 04 and PreviousQualification.DEGTYPE = 001-098, 200-206, 208-215, 400 or 402)
Business RuleErrorAmended
Show more
Plain English
A 'Tier 3' bursary level can only be awarded where a student's previous qualification which makes them eligible to receive a bursary is either a '2:2' or 'Undivided second class' in an undergraduate or Integrated Masters degree.
Further Guidance
N/A
Reason for Change
Rule updated to rename PreviousQualification.PGCECLSS to PreviousQualification.DEGCLSS.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.29

Student.BURSLEV does not = 4, 7, 8 or 9 and CourseSubject.SBJCA = C100, C110, C900, F100, F110, F300, F310, F390, F750, F900, G100, I100, I200, I900, L700, Q490, Q560, Q610, Q710, R100, R200, R300, R400, R500, R700, R900, X120 or X160 where (PreviousQualification.DEGCLSS = 03 or 04 and PreviousQualification.DEGTYPE = 001-098, 200-206, 208-215, 400 or 402) or (CourseSubject.SBJCA = G100, F300, F310, F390, F900) or (CourseSubject.SBJCA = X120 and Student.INITIATIVES = L) or (CourseSubject.SBJCA = X160 and Student.INITIATIVES = D) and Student.ENTRYRTE does not = 03.
Business RuleWarningAmended
Show more
Plain English
A student has not been awarded a bursary of 'Scholarship', 'Tier 1', 'Tier 2' or 'Tier 3' although they meet the eligibility criteria.
Further Guidance
N/A
Reason for Change
Rule updated to rename PreviousQualification.PGCECLSS to PreviousQualification.DEGCLSS. Also updated to exclude Student.ENTRYRTE code 03.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.30

Student.BURSLEV = A can only exist where (CourseSubject.SBJCA = G100, F300, F310, F390, F900, X120 or X160) and (PreviousQualification.BURSFLAG = 01 and PreviousQualification.DEGCLSS = 05-11, 98 or 99) and Student.COMDATE (or Student.ITTCOMDATE if it exists) is before 01/08/2017.
Business RuleErrorAmended
Show more
Plain English
A 'Tier 4' bursary level can only be awarded where a student's subject of study is in a stem subject (i.e. Maths, Physics etc.) and the previous qualification which makes the student eligible to receive a bursary is lower than a 'Second class' or is either 'Not applicable' or 'Not known' and Studies begin before 01/08/2017.
Further Guidance
N/A
Reason for Change
Limited availability of Tier 4 bursaries to studies starting before 01/08/2017.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.31

Student.BURSLEV does not = 4, 7, 8, 9 or A where ((CourseSubject.SBJCA = G100, F300, F310, F390, F900, X120 or X160) and (PreviousQualification.DEGCLSS = 05-11, 98 or 99)) and Student.ENTRYRTE does not = 03.
Business RuleWarningAmended
Show more
Plain English
A student has not been awarded a bursary of 'Scholarship', 'Tier 1', 'Tier 2', 'Tier 3' or 'Tier 4' although they meet the eligibility criteria.
Further Guidance
N/A
Reason for Change
Rule updated to rename PreviousQualification.PGCECLSS to PreviousQualification.DEGCLSS. Also updated to exclude Student.ENTRYRTE code 03.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.32

Student.BURSLEV can only = B where (Student.QLAIM = 001, 002, 003, 004, 007, 008 or 028) and ((CourseSubject.SBJCA = G100, F300, F310, F390 or F900) or (CourseSubject.SBJCA = I100, I200, I900, R100, R200, R400 and Student.ENTRYRTE = 09)).
Business RuleErrorAmended
Show more
Plain English
An 'Undergraduate bursary' can only be awarded where a student is studying for an undergraduate degree in Maths or Physics, or it is in a Computing or Modern Foreign Languages subject and the the student is on an Undergraduate Opt-in programme.
Further Guidance
N/A
Reason for Change
Rule amended to add in the Modern Foreign Language subjects for students on an Undergraduate Opt-in programme, PBI 49980.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.33

Student.BURSLEV does not = B where Student.QLAIM = 001, 002, 003, 004, 007, 008 or 028 and CourseSubject.SBJCA = G100, F300, F310, F390 or F900 (or I100, I200, I900, R100, R200 or R400 and Student.ENTRYRTE = 09) and Student.ENTRYRTE does not = 03.
Business RuleWarningAmended
Show more
Plain English
Although a student is on an 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 amended to add in the Modern Foreign Language subjects for students on an Undergraduate Opt-in programme, PBI 49980.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.34

Student.BURSLEV must = 6 where CourseSubject.SBJCA is any of B990, C600, C800, H990, L100, L230, L390, L430, L510, L900, L990, M990, N100, N190, N800, N870, N890, N900, N990, P300, P390, P900, W310, W400, W500, W900 or W990
Business RuleErrorCarried Forward
Show more
Plain English
The specified subjects are not eligible to have a bursary award.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.35

Student.BURSLEV must = 6, B or A where (Student.ITTCOMDATE exists and is on or before Y1-07-31) or (Student.ITTCOMDATE does not exist and Student.COMDATE is on or before Y1-07-31)
Business RuleErrorCarried Forward
Show more
Plain English
Only a 'No bursary awarded', 'Undergraduate bursary' or 'Tier 4' can be awarded if the student began their studies prior to this reporting period.
Further Guidance
N/A
Reason for Change
Added A (Tier 4) to list of allowable codes.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.36

Student.BURSLEV must = 6 where Student.FUNDCODE = 2
Business RuleErrorCarried Forward
Show more
Plain English
A student must not receive a bursary where they are not eligible for NCTL funding.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.37

Student.BURSLEV must = 6 where Student.TTCID = 0 or 2
Business RuleErrorCarried Forward
Show more
Plain English
A student must not receive a bursary where they are not studying an ITT course.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.38

Student.BURSLEV must = 6 where Student.ENTRYRTE = 03
Business RuleErrorAmended
Show more
Plain English
A student must not receive a bursary where their entry route is School Direct salaried.
Further Guidance
N/A
Reason for Change
Rule updated to remove Student.ENTRYRTE valid entry 05 as it no longer exists.
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.39

Student.BURSLEV must = 6 or B where PreviousQualification.BURSFLAG does not exist
Business RuleErrorCarried Forward
Show more
Plain English
Student.BURSLEV must be coded either 6 'No bursary awarded' or B 'Undergraduate bursary' where it has not been indicated that a previous qualification is related to a bursary award.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.BURSLEV.40

Where Student.BURSLEV = 4, 7, 8, 9 or A then at least one PreviousQualification entity should exist
Business RuleWarningCarried Forward
Show more
Plain English
Where a Scholarship or Tier 1, 2, 3 or 4 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.C17053.Student.COMDATE.1

Student.COMDATE must not be before 1991-01-31
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.COMDATE.Business Rule.1

QR.C17053.Student.COMDATE.2

Student.COMDATE must be before Y2-08-01
Business RuleErrorCarried Forward
Show more
Plain English
Student.COMDATE must be before the end of the reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.COMDATE.Business Rule.2

QR.C17053.Student.DISALL.1

Student.DISALL should exist where Student.DISABLE = 08 - 96
Business RuleWarningAmended
Show more
Plain English
Disabled student allowance should exist when it is indicated that the student has a disability.
Further Guidance
N/A
Reason for Change
Rule updated to remove Student.DISABLE valid entries that no longer exist.
Previous Name of Rule
Student.DISALL.Business Rule.1

QR.C17053.Student.DISALL.2

Student.DISALL should not exist where Student.DISABLE = 00
Business RuleWarningAmended
Show more
Plain English
Disabled student allowance should not exist when it is indicated that the student does not have a disability.
Further Guidance
N/A
Reason for Change
Rule updated to remove Student.DISABLE valid entry codes that no longer exist.
Previous Name of Rule
Student.DISALL.Business Rule.2

QR.C17053.Student.DOMICILE.1

Student.DOMICILE codes XL and XC must have Student.COMDATE before 2007-08-01
Business RuleErrorCarried Forward
Show more
Plain English
Domiciles 'Channel Islands not otherwise specified' or 'Cyprus not otherwise specified' must only be used for students starting their course before 1 August 2007.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.ENDDATE.3

Student.ENDDATE must not be null where Student.RSNEND exists
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.ENDDATE.Business Rule.3

QR.C17053.Student.ENDDATE.4

Student.ENDDATE must be before Y2-08-01
Business RuleErrorCarried Forward
Show more
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
N/A
Previous Name of Rule
Student.ENDDATE.Business Rule.4

QR.C17053.Student.ENDDATE.5

If Student.Mode is not equal to 63 or 64, then Student.ENDDATE must be after Y1-07-31
Business RuleErrorCarried Forward
Show more
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
N/A
Previous Name of Rule
Student.ENDDATE.Business Rule.5

QR.C17053.Student.ENDDATE.6

Student.ENDDATE must be after (Y2-6)-07-31 when Student.MODE = 63 or 64
Business RuleErrorCarried Forward
Show more
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
N/A
Previous Name of Rule
Student.ENDDATE.Business Rule.6

QR.C17053.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 RuleErrorCarried Forward
Show more
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
N/A
Previous Name of Rule
Student.ENDDATE.Business Rule.7

QR.C17053.Student.ENTRYRTE.2

Where Student.ENTRYRTE = 09 then Student.BURSLEV must = B or 6
Business RuleErrorAdded
Show more
Plain English
When entry route is 'Undergraduate Opt-In' then Bursary Level must either be 'Undergraduate bursary' or 'No bursary awarded'.
Further Guidance
N/A
Reason for Change
New rule added to enforce the guidance.
Previous Name of Rule
N/A

QR.C17053.Student.FUNDCODE.1

Student.FUNDCODE code 7 is only available where Student.TTCID = 1.
Business RuleErrorAmended
Show more
Plain English
Only students on an ITT Teacher Training course are eligible for funding from the NCTL.
Further Guidance
N/A
Reason for Change
Rule updated to remove the restriction on Student.TTCID = 'Q' as the code no longer exists.
Previous Name of Rule
Student.FUNDCODE.Business Rule.1

QR.C17053.Student.FUNDCODE.2

Student.FUNDCODE code 7 is only available where Student.ITTPHSC is not 31 or 49
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.FUNDCODE.Business Rule.2

QR.C17053.Student.HUSID.1

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

QR.C17053.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
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.HUSID.Business Rule.2

QR.C17053.Student.HUSID.3

Student.HUSID must pass the checksum test given in the coding manual
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.HUSID.Business Rule.3

QR.C17053.Student.HUSID.4

If characters 1-4 of Student.HUSID are not 0000 then characters 3-6 of Student.HUSID must not be 3001 when Student.COMDATE after 2007-07-31 (INSTID 2001 is invalid).
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.HUSID.Business Rule.4

QR.C17053.Student.INITIATIVES.1

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

QR.C17053.Student.INITIATIVES.11

Where Student.INITIATIVES = C then Student.BURSLEV must = 6.
Business RuleErrorAdded
Show more
Plain English
A student on a 'Troops to Teachers' initiative is not eligible to receive a bursary.
Further Guidance
N/A
Reason for Change
New rule added to ensure that 'Troops to Teachers' have a Bursary level of 'No Bursary awarded'.
Previous Name of Rule
N/A

QR.C17053.Student.INITIATIVES.12

Where Student.INITIATIVES = C, then Student.ITTPHSC should = 78 to 81 and CourseSubject.SBJCA = G100, C100, F100, F300, I100, R100, R200, R300, R400, R500, R700 or R900.
Business RuleWarningAdded
Show more
Plain English
The 'Troops to Teachers' initiative should only be returned where the student is studying for a secondary level ITT course in Maths, Biology, Chemistry, Physics, Computing or Modern Foreign Languages.
Further Guidance
N/A
Reason for Change
New rule added as 'Troops to Teachers' is only available for ITT courses in secondary level Maths, Biology, Chemistry, Physics, Computing or Modern Foreign Languages.
Previous Name of Rule
N/A

QR.C17053.Student.INITIATIVES.2

Student.INITIATIVES = D can only exist where Student.TTCID = 1 and CourseSubject.SBJCA = X160 and Student.ITTPHSC = 71 - 77
Business RuleErrorCarried Forward
Show more
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
Student.INITIATIVES.BusinessRule.2

QR.C17053.Student.INITIATIVES.7

(Student.TTCID must be coded 1 and CourseSubject.SBJCA must be coded X120 and Student.ITTPHSC must be coded 71-77) where Student.INITIATIVES = L.
Business RuleErrorCarried Forward
Show more
Plain English
Where initiatives is 'Primary General (with Maths)' then the student must be studying a primary level ITT course with a subject 'General Primary'.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.INITIATIVES.8

Student.ENTRYRTE must be coded 03 where Student.INITIATIVES = M.
Business RuleErrorCarried Forward
Show more
Plain English
The entry route must be 'School Direct salaried' 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.C17053.Student.INITIATIVES.9

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

QR.C17053.Student.ITTCOMDATE.1

Where exists Student.ITTCOMDATE must not be earlier than Student.COMDATE
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.ITTCOMDATE.Business Rule.1

QR.C17053.Student.ITTPHSC.1

Student.ITTPHSC codes 71 - 81 are only available where Student.TTCID = 1 and Student.COMDATE is after 2007-07-31
Business RuleErrorCarried Forward
Show more
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
N/A
Previous Name of Rule
Student.ITTPHSC.Business Rule.2

QR.C17053.Student.ITTPHSC.2

Student.ITTPHSC codes 31 or 49 are only available where Student.TTCID = 2
Business RuleErrorCarried Forward
Show more
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
Student.ITTPHSC.Business Rule.3

QR.C17053.Student.ITTPHSC.3

Student.ITTPHSC codes 51 - 57 are only available where Student.COMDATE is after 2002-07-31 and before 2007-08-01
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.ITTPHSC.Business Rule.4

QR.C17053.Student.ITTPHSC.4

Where Student.ITTPHSC is coded 72 Student.COMDATE must be after 2007-07-31 and before 2010-08-01
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.ITTPHSC.Business Rule.6

QR.C17053.Student.ITTSCHMS.1

Student.ITTSCHMS can only be coded 6 where Student.ITTPHSC is between 71 and 77 and CourseSubject.SBJCA is French (R100), German (R200), Italian (R300), Spanish (R400) or Other Modern Language (R900)
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule amended to include ITTPHSC code 71 (Ages 3 - 7 Primary) and SBJCA code R900 (Other Modern Language).
Previous Name of Rule
Student.ITTSCHMS.Business Rule.2

QR.C17053.Student.MODE.1

Student.MODE cannot be coded 01 or 02 where Student.UNITLGTH = 2 and Student.SPLENGTH = 01 to 05
Business RuleErrorCarried Forward
Show more
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
N/A
Previous Name of Rule
Student.MODE.Business Rule.1

QR.C17053.Student.MODE.2

Student.MODE cannot be coded 01 or 02 where Student.UNITLGTH = 3 and Student.SPLENGTH = 01 to 23
Business RuleErrorCarried Forward
Show more
Plain English
When an instance is 23 weeks or less in length then it can not be recorded as full-time.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.MODE.Business Rule.2

QR.C17053.Student.NATION.1

Student.NATION codes XL and XC must have Student.COMDATE before 2007-08-01
Business RuleErrorCarried Forward
Show more
Plain English
Nations 'Channel Islands not otherwise specified' or 'Cyprus not otherwise specified' must only be used for students starting their course before 1 August 2007.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.NATIOND.1

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

QR.C17053.Student.NATIOND.2

Where Student.NATIOND is coded R or U there must be only one occurrence of Student.NATIOND
Business RuleErrorCarried Forward
Show more
Plain English
There must only be one occurrence of National Identity where it is 'Information Refused' or 'Unknown'.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.PreviousQualification.1

PreviousQualification entity must exist where Student.COMDATE is in the current reporting period and ((Student.QLAIM = 020, 021 or 031) or (Student.TTCID = 1 and Student.ITTAIM = 201))
Business RuleErrorAmended
Show more
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
Rule updated to remove Student.ENTRYRTE restriction as the valid entries no longer exist.
Previous Name of Rule
N/A

QR.C17053.Student.QLAIM.1

Student.QLAIM must exist where Student.ITTAIM = 202
Business RuleErrorCarried Forward
Show more
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.C17053.Student.RSNEND.1

Student.RSNEND must exist where Student.ENDDATE is not null
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.RSNEND.Business Rule.1

QR.C17053.Student.SDEMPLOY.1

Student.SDEMPLOY must exist where Student.ENTRYRTE = 03 and Student.MODE is not equal to 63 or 64.
Business RuleErrorAdded
Show more
Plain English
Employing school must exist for School Direct salaried trainees.
Further Guidance
N/A
Reason for Change
New rule added to enforce the coverage.
Previous Name of Rule
N/A

QR.C17053.Student.SDEMPLOY.2

Student.SDEMPLOY must not exist where Student.ENTRYRTE does not equal 03.
Business RuleErrorAdded
Show more
Plain English
Employing school must not exist where their entry route is not for School Direct salaried trainees.
Further Guidance
N/A
Reason for Change
New rule added to enforce the coverage.
Previous Name of Rule
N/A

QR.C17053.Student.SDEMPLOY.4

Student.SDEMPLOY is not a generic code and does not exist in the lookup file provided by Edubase.
Business RuleErrorAdded
Show more
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
New rule to check the school code submitted.
Previous Name of Rule
N/A

QR.C17053.Student.SDLEAD.1

Student.SDLEAD must exist where Student.ENTRYRTE = 02 or 03 and Student.MODE is not equal to 63 or 64.
Business RuleErrorAdded
Show more
Plain English
Lead school must exist for School Direct trainees.
Further Guidance
N/A
Reason for Change
New rule added to enforce the coverage.
Previous Name of Rule
N/A

QR.C17053.Student.SDLEAD.2

Student.SDLEAD must not exist where Student.ENTRYRTE does not equal 02 or 03.
Business RuleErrorAdded
Show more
Plain English
Lead school must not exist where entry route is not for School Direct trainees.
Further Guidance
N/A
Reason for Change
New rule added to enforce the coverage.
Previous Name of Rule
N/A

QR.C17053.Student.SDLEAD.4

Student.SDLEAD is not a generic code and does not exist in the lookup file provided by Edubase.
Business RuleErrorAdded
Show more
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
New rule to check the school code submitted.
Previous Name of Rule
N/A

QR.C17053.Student.SEXID.1

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

QR.C17053.Student.SPLENGTH.1

Student.SPLENGTH cannot be greater than 09 where Student.MODE = 01 or 02 and Student.UNITLGTH = 1
Business RuleErrorCarried Forward
Show more
Plain English
A full-time course must not be greater than 9 years in length.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.SPLENGTH.Business Rule.1

QR.C17053.Student.SPLENGTH.2

Student.SPLENGTH cannot be greater than 72 where Student.MODE = 01 or 02 and Student.UNITLGTH = 2
Business RuleErrorCarried Forward
Show more
Plain English
A full-time course must not be greater than 72 months in length.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.SPLENGTH.Business Rule.2

QR.C17053.Student.TREFNO.1

Where Student.TREFNO exists, it must be compiled of 7 numerical digits
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17053.Student.ULN.1

Student.ULN must pass the checksum test given in the coding manual
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.ULN.Business Rule.1

QR.C17053.Student.YEARPRG.1

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

QR.C17053.Student.YEARPRG.2

Student.YEARPRG should be less than or equal to Student.SPLENGTH where Student.UNITLGTH = 1 and Student.MODE is less than 40 and Student.YEARPRG is not coded 99
Business RuleWarningCarried Forward
Show more
Plain English
A student's year of course should be less than or equal to the expected length of study for non-dormant students.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.YEARPRG.Business Rule.2

QR.C17053.Student.YEARSTU.1

Student.YEARSTU value cannot be greater than the difference in years between 31 July of the reporting period and the 01 August before Student.COMDATE
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
Student.YEARSTU.Business Rule.2

QR.C17053.Student.NQTEMAIL.1

More than 25.0% of students have not returned Student.NQTEMAIL.
ExceptionWarningAdded
Show more
Plain English
More than 25.0% of students have not returned an email address.
Further Guidance
N/A
Reason for Change
New rule added to warn where students have not returned an email address.
Previous Name of Rule
N/A

QR.C17053.Student.SDEMPLOY.3

More than 10.0% of students have Student.SDEMPLOY = 900000 or 900010.
ExceptionWarningAdded
Show more
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
New rule added to warn the use of codes '900010 Not applicable/not available' and '900000 Establishment outside England and Wales'.
Previous Name of Rule
N/A

QR.C17053.Student.SDLEAD.3

More than 10.0% of students have Student.SDLEAD = 900000 or 900010.
ExceptionWarningAdded
Show more
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
New rule added to warn the use of codes '900010 Not applicable/not available' and '900000 Establishment outside England and Wales'.
Previous Name of Rule
N/A

QR.C17053.PreviousQualification.PGCECLSS.1

PreviousQualification.PGCECLSS must exist where Student.COMDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021 or 031)
Business RuleErrorDeleted
Show more
Plain English
Previous PGCE class of undergraduate degree must exist where the student commenced studying for a postgraduate qualification in current reporting period.
Further Guidance
N/A
Reason for Change
Rule deleted and replaced with new rule on DEGCLSS.
Previous Name of Rule
QR.C15053.Student.PGCECLSS.1

QR.C17053.PreviousQualification.PGCESBJ.1

PreviousQualification.PGCESBJ must exist where Student.COMDATE is in the current reporting period and Student.QLAIM is a postgraduate qualification (020, 021 or 031)
Business RuleErrorDeleted
Show more
Plain English
Previous PGCE subject of undergraduate degree must exist where the student commenced studying for a postgraduate qualification in current reporting period.
Further Guidance
N/A
Reason for Change
Rule deleted and replaced with new rule on DEGSBJ.
Previous Name of Rule
QR.C15053.Student.PGCESBJ.1

QR.C17053.Student.DISABLE.1

Where Student.DISABLE = 02, 03, 04, 05, 06, 07, 10, 11, 97, 98 or 99 then Student.COMDATE must be before 2010-08-01
Business RuleWarningDeleted
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as Student.DISABLE valid entries no longer exist.
Previous Name of Rule
Student.DISABLE.Business Rule.1

QR.C17053.Student.ENTRYRTE.1

Where Student.ENTRYRTE = 04, 05, 06, 07 or 08 then Student.TTCID must = Q
Business RuleErrorDeleted
Show more
Plain English
When a student's entry route is one of the Early Years Initial Teacher Training routes then they must be on an Early Years Teacher Training course.
Further Guidance
N/A
Reason for Change
Rule deleted as it no longer applies.
Previous Name of Rule
N/A

QR.C17053.Student.INITIATIVES.10

Where Student.INITIATIVES = R then Student.BURSLEV must = B or 6
Business RuleErrorDeleted
Show more
Plain English
When initiative is 'Undergraduate Opt-In' then Bursary Level must either be 'Undergraduate bursary' or 'No bursary awarded'.
Further Guidance
N/A
Reason for Change
Rule deleted as INITIATIVES valid entry 'R' has been removed.
Previous Name of Rule
N/A

QR.C17053.Student.ITTPHSC.5

Where Student.ITTPHSC = 84, then Student.TTCID must = Q
Business RuleErrorDeleted
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as Student.TTCID code 'Q' and Student.ITTPHSC code '84' no longer exists.
Previous Name of Rule
Student.ITTPHSC.Business Rule.7

QR.C17053.Student.TTCID.6

Where Student.TTCID = Q, then Student.ITTPHSC must = 84
Business RuleErrorDeleted
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule deleted as Student.TTCID code 'Q' and Student.ITTPHSC code '84' no longer exists.
Previous Name of Rule
Student.TTCID.Business Rule.8

QR.C17053.Student.TTCID.7

Where Student.TTCID = Q then Student.ENTRYRTE must = 04, 05, 06, 07 or 08
Business RuleErrorDeleted
Show more
Plain English
When a student is on an Early Years Teacher Training course, their entry route must be one of the Early Years Initial Teacher Training routes.
Further Guidance
N/A
Reason for Change
Rule deleted as it no longer applies.
Previous Name of Rule
N/A