Quality Rules Directory for C15053
Filter
QR.C15053.CourseSubject.SBJCA.1
CourseSubject.SBJCA must be coded C100, C600, C690, F100, F300, G100, I200, L100, L230, L390, L700, P390, Q300, Q560, R100, R200, R300, R400, R500, V100, V600, W200, W300, W400, W500, W900, X900, X120, X121 or X160 where Student.TTCID = 1, 8 or G and any Student.ITTPHSC = 71 - 77Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended at request of the NCTL to include CourseSubject.SBJCA code C690 which is used to identify 'Primary Sports Specialist'.
- Previous Name of Rule
- CourseSubject.SBJCA.BusinessRule.1
QR.C15053.CourseSubject.SBJCA.2
CourseSubject.SBJCA must be coded C900, C100, C110, C600, C800, D600, F900, F100, F110, F300, F310, F390, G100, I100, I200, I900, H700, H900, J420, L100, L230, L390, L510, L700, L900, N100, N190, N870, P300, P390, Q300, Q490, Q560, Q610, Q710, Q800, R100, R200, R300, R400, R500, R700, R900, V100, V600, W200, W210, W300, W400, W500, W900 or W990 where Student.TTCID = 1, 8 or G and any Student.ITTPHSC = 54 - 57, or 78 - 81Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended at request of the NCTL to include CourseSubject.SBJCA codes Q490, Q610 and Q710 which represent classical 'languages' and attract separate bursaries, therefore are recognised ITT subjects.
- Previous Name of Rule
- CourseSubject.SBJCA.BusinessRule.3
QR.C15053.CourseSubject.SBJCA.3
One, and only one CourseSubject.SBJCA must be coded F900 where any CourseSubject.SBJCA = C900 and Student.TTCID = 1, 8 or G and Student.ITTPHSC = 54 - 57, or 78 - 81Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- CourseSubject.SBJCA.Business Rule.4
QR.C15053.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 codeShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- CourseSubject.SBJCA.Business Rule.5
QR.C15053.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 codeShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- CourseSubject.SBJCA.Business Rule.6
QR.C15053.CourseSubject.SBJCA.6
One, and only one CourseSubject.SBJCA must be coded C900 where any CourseSubject.SBJCA = F900 and Student.TTCID = 1, 8 or G and Student.ITTPHSC = 54 - 57, or 78 - 81Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- CourseSubject.SBJCA.Business Rule.7
QR.C15053.CourseSubject.SBJCA.7
For providers in England where Student.TTCID = 1, 8 or G and Student.ITTPHSC = 54 - 57, or 78 - 81, CourseSubject.SBJCA codes C110, F110 and F310 must always be used together as a triplet.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to amend reference of 'institutions' to become 'providers'.
- Previous Name of Rule
- CourseSubject.SBJCA.BusinessRule.8
QR.C15053.CourseSubject.SBJCA.8
CourseSubject.SBJCA codes C100, F100 and F300 can only be used together when Student.TTCID = 1, 8 or G and Student.ITTPHSC = 51 - 53, or 71 - 77.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- CourseSubject.SBJCA.Business Rule.9
QR.C15053.CourseSubject.SBJCA.9
Where CourseSubject.SBJCA = I900, N990, K290, P390, P900, H990, F750, B990, N862, I200, M990, H790, J500, W310, L390, L430, N900, L990, N890, N800, Q800 then Student.FUNDCODE must = 2 and Student.COMDATE is after 2014-07-31Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended at request of the NCTL to include CourseSubject.SBJCA code Q800. This denotes 'Classical History' which does not attract a bursary and is therefore not fundable.
- Previous Name of Rule
- CourseSubject.SBJCA.BusinessRule.11
QR.C15053.Student.BIRTHDTE.1
Student.BIRTHDTE cannot be before 1906-11-01Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.BIRTHDTE.Business Rule.1
QR.C15053.Student.BIRTHDTE.2
Student.BIRTHDTE cannot be after Y1-07-31Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.BIRTHDTE.Business Rule.2
QR.C15053.Student.BIRTHDTE.3
Student.BIRTHDTE should be before (Y1-20)-08-01 where Student.ITTAIM is a postgraduate qualification (110, 113, 020, 031 or (032 and Student.INITIATIVES is F, G or J))Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to enforce the coverage of postgraduate qualifications.
- Previous Name of Rule
- Student.BIRTHDTE.BusinessRule.3
QR.C15053.Student.BIRTHDTE.4
Student.BIRTHDTE should be before (Y1-17)-08-01 where Student.ITTAIM = 007, 008, 014, 012, 001, 002, 003, 004 or 013Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.BIRTHDTE.Business Rule.4
QR.C15053.Student.BIRTHDTE.5
Student.BIRTHDTE should be after (Y1-70)-07-31Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.BIRTHDTE.Business Rule.5
QR.C15053.Student.BIRTHDTE.6
Student.BIRTHDTE should be before (Y1-14)-07-31Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.BIRTHDTE.Business Rule.6
QR.C15053.Student.BURSLEV.1
Student.BURSLEV = 7, 8 or 9 are only applicable when CourseSubject.SBJCA = C100, C690, F100, F300, F390, G100, H700, H900, I100, L700, Q300, Q490, Q560, Q610, Q710, R100, R200, R300, R400, R500, R700, R900, V100, V600, W200, W300, X120, X121, X160 or X900Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended following guidance from the NCTL to remove CourseSubject.SBJCA codes D600, J420 and Q800, and add code V600 to reflect changes in subjects attracting bursaries in 2015/16.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.2
QR.C15053.Student.BURSLEV.10
Student.BURSLEV does not = 4, 7 or 8 where (Student.DISCFUND exists and is coded 4 and ((Student.PGCECLSS = 12-14 and Student.DEGTYPE = 200-215 or 401) or (Student.PGCECLSS = 02 or 04 and Student.DEGTYPE = 001-098, 400 or 402))) or (Student.PGCECLSS = 03 or 04 and Student.DEGTYPE = 001-098, 400 or 402).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended to remove reference to Student.DISCFUND code 3 and to ensure that it is coded 4 where the field exists and other criteria are met. Also extended the Student.DEGTYPE range from '200-213' to '200-215' to accommodate new valid entries 214 and 215.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.17
QR.C15053.Student.BURSLEV.11
Student.BURSLEV does not = 4 or 7 where (Student.DISCFUND exists and is coded 4 and ((Student.DEGTYPE = 300-306) or (Student.PGCECLSS = 01 and Student.DEGTYPE = 001-098, 400 or 402) or (Student.PGCECLSS = 12 and Student.DEGTYPE = 064, 077, 090, 094, 095, 096 or 401))) or ((Student.PGCECLSS = 12-14 and Student.DEGTYPE = 200-215 or 401) or (Student.PGCECLSS = 02 or 04 and Student.DEGTYPE = 001-098, 400 or 402)).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended to remove reference to Student.DISCFUND code 3 and to ensure that it is coded 4 where the field exists and other criteria are met. Also extended the Student.DEGTYPE range from '200-213' to '200-215' to accommodate new valid entries 214 and 215.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.18
QR.C15053.Student.BURSLEV.12
Student.BURSLEV does not = 4 where Student.PGCECLSS = 01-04 and CourseSubject.SBJCA = F100, F300, F390, G100 or I100.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended at request of NCTL to include CourseSubject.SBJCA code F390 which is also a Scholarship qualifying subject.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.19
QR.C15053.Student.BURSLEV.13
Student.BURSLEV = A can only exist where ((CourseSubject.SBJCA = G100, F300, F390 or X160) and (Student.PGCECLSS = 05-11, 98 or 99)).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended at request of NCTL to include CourseSubject.SBJCA code X160 to identify Primary Maths specialists, and to remove references to Student.DISCFUND as discretionary funding will not be awarded in 2015/16.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.20
QR.C15053.Student.BURSLEV.14
Student.BURSLEV does not = 4, 7, 8, 9 or A where ((CourseSubject.SBJCA = G100, F100, F300, F390, I100 or X160) and (Student.PGCECLSS = 05-11, 98 or 99)).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended at request of NCTL to include CourseSubject.SBJCA codes F100, I100 and X160 which can attract a number of bursaries, and to remove references to Student.DISCFUND as discretionary funding will not be awarded in 2015/16.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.21
QR.C15053.Student.BURSLEV.15
Student.BURSLEV must = 6 where CourseSubject.SBJCA is not any of C100, C690, F100, F300, F390, G100, H700, H900, I100, L700, Q300, Q490, Q560, Q610, Q710, R100, R200, R300, R400, R500, R700, R900, V100, V600 W200, W300, X120, X121, X160 or X900.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended at request of NCTL to remove CourseSubject.SBJCA codes D600, J420 and Q800, and add code V600 to reflect changes in subjects attracting bursaries in 2015/16.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.22
QR.C15053.Student.BURSLEV.16
Student.BURSLEV must = 6 where Student.TTCID = G and Student.MSTUFEE = 81.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule added at request of NCTL to stop inaccurate entries assigning a bursary level to trainees who are not eligible/qualified to receive one.
- Previous Name of Rule
- N/A
QR.C15053.Student.BURSLEV.17
Student.BURSLEV can only = B where (Student.ITTAIM = 001-004, 007-008, 012-014 or 028) and (CourseSubject.SBJCA = G100, F300 or F390).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule added at request of NCTL to identify undergraduate students studying Mathematics, Physics or Physics with Mathematics who are eligible for an Undergraduate bursary, which will only be payable at the end of their course.
- Previous Name of Rule
- N/A
QR.C15053.Student.BURSLEV.2
Student.BURSLEV = 9 can only exist where (Student.DISCFUND exists and is coded 4 and (Student.PGCECLSS = 03 or 04 and Student.DEGTYPE = 001-098, 400 or 402)) or (CourseSubject.SBJCA = G100, F300 or F390 and Student.PGCECLSS = 05-11, 98 or 99)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended to remove reference to Student.DISCFUND code 3 and to ensure that it is coded 4 where the field exists and other criteria are met.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.4
QR.C15053.Student.BURSLEV.3
Student.BURSLEV = 8 can only exist where (Student.DISCFUND exists and is coded 4 and ((Student.PGCECLSS = 02 or 04 and Student.DEGTYPE = 001-098, 400 or 402) or where (Student.PGCECLSS = 12-14 and Student.DEGTYPE = 200-215 or 401))) or (Student.PGCECLSS = 03 or 04 and Student.DEGTYPE = 001-098, 400 or 402)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended to remove reference to Student.DISCFUND code 3 and to ensure that it is coded 4 where the field exists and other criteria are met. Also extended the Student.DEGTYPE range from '200-213' to '200-215' to accommodate new valid entries 214 and 215.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.6
QR.C15053.Student.BURSLEV.4
Student.BURSLEV = 7 can only exist where (Student.DISCFUND exists and is coded 4 and ((Student.PGCECLSS = 01 and Student.DEGTYPE = 001-098, 400 or 402) or where (Student.PGCECLSS = 12 and Student.DEGTYPE = 064, 077, 090, 094-096 or 401) or where (Student.DEGTYPE = 300-306))) or ((Student.PGCECLSS = 12-14 and Student.DEGTYPE = 200-215 or 401) or (Student.PGCECLSS = 02 or 04 and Student.DEGTYPE = 001-098, 400 or 402))Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended to remove reference to Student.DISCFUND code 3 and to ensure that it is coded 4 where the field exists and other criteria are met. Also extended the Student.DEGTYPE range from '200-213' to '200-215' to accommodate new valid entries 214 and 215.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.8
QR.C15053.Student.BURSLEV.5
Student.BURSLEV must = 6 where Student.FUNDCODE = 2Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.BURSLEV.Business Rule.12
QR.C15053.Student.BURSLEV.6
Student.BURSLEV must = 6 where (Student.ITTCOMDATE exists and is on or before 2015-07-31) or (Student.ITTCOMDATE does not exist and Student.COMDATE is on or before 2015-07-31)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to amend the date references in order to reflect the 2015/16 collection year.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.13
QR.C15053.Student.BURSLEV.7
Student.BURSLEV = 4 can only exist where CourseSubject.SBJCA = F100, F300, F390, G100 or I100 and Student.PGCECLSS = 01-04Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended at request of NCTL to include CourseSubject.SBJCA code F390 which is a Scholarship qualifying subject and should be treated in the same manner as F300.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.14
QR.C15053.Student.BURSLEV.8
Where Student.TTCID = 0 or 2, Student.BURSLEV must = 6.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.BURSLEV.Business Rule.15
QR.C15053.Student.BURSLEV.9
Student.BURSLEV does not = 4, 7, 8 or 9 where (Student.DISCFUND exists and is coded 4 and (Student.PGCECLSS = 03 or 04 and Student.DEGTYPE = 001-098, 400 or 402)) or (CourseSubject.SBJCA = G100, F300 or F390 and Student.PGCECLSS = 05-11, 98 or 99).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended to remove reference to Student.DISCFUND code 3 and to ensure that it is coded 4 where the field exists and other criteria are met.
- Previous Name of Rule
- Student.BURSLEV.BusinessRule.16
QR.C15053.Student.COMDATE.1
Student.COMDATE must not be before 1991-01-31Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.COMDATE.Business Rule.1
QR.C15053.Student.COMDATE.2
Student.COMDATE must be before Y2-08-01Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.COMDATE.Business Rule.2
QR.C15053.Student.DEGCTRY.1
Student.DEGCTRY must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 027, 031 or (032 and Student.INITIATIVES is F, G or J)) and Student.DEGEST does not existShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to enforce the coverage of Student.DEGCTRY field.
- Previous Name of Rule
- Student.DEGCTRY.BusinessRule.1
QR.C15053.Student.DEGCTRY.2
Student.DEGCTRY must not exist where Student.DEGEST existsShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.DEGCTRY.Business Rule.2
QR.C15053.Student.DEGENDDT.1
Student.DEGENDDT must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 031 or (032 and Student.INITIATIVES is F, G or J))Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to enforce the coverage of Student.DEGENDDT field.
- Previous Name of Rule
- Student.DEGENDDT.BusinessRule.1
QR.C15053.Student.DEGENDDT.2
Student.DEGENDDT must not be later than Student.COMDATEShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.DEGENDDT.Business Rule.2
QR.C15053.Student.DEGENDDT.3
Student.DEGENDDT where exists must be later than Student.DEGSTDTShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.DEGENDDT.Business Rule.3
QR.C15053.Student.DEGENDDT.4
Student.DEGENDDT where exists should not be earlier than (Y1-08-01 minus 7 years)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.DEGENDDT.Business Rule.4
QR.C15053.Student.DEGEST.1
Student.DEGEST must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 027, 031 or (032 and Student.INITIATIVES is F, G or J)) unless Student.DEGCTRY existsShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to enforce the coverage of Student.DEGEST field.
- Previous Name of Rule
- Student.DEGEST.BusinessRule.1
QR.C15053.Student.DEGLENGTH.1
Student.DEGLENGTH must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 031 or (032 and Student.INITIATIVES is F, G or J))Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to enforce the coverage of Student.DEGLENGTH field.
- Previous Name of Rule
- Student.DEGLENGTH.BusinessRule.1
QR.C15053.Student.DEGSTDT.1
Student.DEGSTDT must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 031 or (032 and Student.INITIATIVES is F, G or J))Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to enforce the coverage of Student.DEGSTDT field.
- Previous Name of Rule
- Student.DEGSTDT.BusinessRule.1
QR.C15053.Student.DEGSTDT.2
Student.DEGSTDT, where exists, must not be earlier than (Y1-40)-08-01Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.DEGSTDT.Business Rule.2
QR.C15053.Student.DEGTYPE.1
Student.DEGTYPE must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 027, 031 or (032 and Student.INITIATIVES is F, G or J))Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to enforce the coverage of Student.DEGTYPE field.
- Previous Name of Rule
- Student.DEGTYPE.BusinessRule.1
QR.C15053.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-01Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Internal change only.
- Previous Name of Rule
- Student.DISABLE.Business Rule.1
QR.C15053.Student.DISALL.1
Student.DISALL should exist where Student.DISABLE = 02 - 96Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.DISALL.Business Rule.1
QR.C15053.Student.DISALL.2
Student.DISALL should not exist where Student.DISABLE = 00, 97, 98 or 99Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.DISALL.Business Rule.2
QR.C15053.Student.DISCFUND.3
Where exists, Student.DISCFUND must = 4 where (Student.ITTCOMDATE exists and is on or before 2013-07-31) or (Student.ITTCOMDATE does not exist and Student.COMDATE is on or before 2013-07-31)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule wording amended so that the rule will only trigger where the Student.DISCFUND field exists and does not equal 4 when the other criteria are met.
- Previous Name of Rule
- Student.DISCFUND.BusinessRule.4
QR.C15053.Student.DISCFUND.4
Where Student.TTCID = 0 or 2, then Student.DISCFUND must = 4, where it exists.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule wording amended so that the rule will only trigger where the Student.DISCFUND field exists and does not equal 4 when the other criteria are met.
- Previous Name of Rule
- Student.DISCFUND.BusinessRule.6
QR.C15053.Student.DISCFUND.5
Where exists, Student.DISCFUND must = 4 where Student.PGCECLSS = 98 or 99.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule wording amended so that the rule will only trigger where the Student.DISCFUND field exists and does not equal 4 when the other criteria are met.
- Previous Name of Rule
- Student.DISCFUND.BusinessRule.7
QR.C15053.Student.DISCFUND.6
Where exists, Student.DISCFUND must = 4 where (Student.ITTCOMDATE exists and is on or after 2015-08-01) or (Student.ITTCOMDATE does not exist and Student.COMDATE is on or after 2015-08-01).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule added at request of NCTL to prevent discretionary funding from being awarded in 2015/16.
- Previous Name of Rule
- N/A
QR.C15053.Student.ENDDATE.3
Student.ENDDATE must not be null where Student.RSNEND existsShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ENDDATE.Business Rule.3
QR.C15053.Student.ENDDATE.4
Student.ENDDATE must be before Y2-08-01Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ENDDATE.Business Rule.4
QR.C15053.Student.ENDDATE.5
If Student.Mode is not equal to 63 or 64, then Student.ENDDATE must be after Y1-07-31Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ENDDATE.Business Rule.5
QR.C15053.Student.ENDDATE.6
Student.ENDDATE must be after (Y2-6)-07-31 when Student.MODE = 63 or 64Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ENDDATE.Business Rule.6
QR.C15053.Student.ENDDATE.7
Student.ENDDATE must be after or the same as Student.COMDATE unless (Student.MODE = 63 or 64 and Student.ENDDATE = Y0-08-01)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ENDDATE.Business Rule.7
QR.C15053.Student.FUNDCODE.1
Student.FUNDCODE code 7 is only available where Student.TTCID = 1, 8, G or QShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.FUNDCODE.Business Rule.1
QR.C15053.Student.FUNDCODE.2
Student.FUNDCODE code 7 is only available where Student.ITTPHSC is not 31 or 49Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.FUNDCODE.Business Rule.2
QR.C15053.Student.HUSID.1
Student.HUSID must not contain all zerosShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.HUSID.Business Rule.1
QR.C15053.Student.HUSID.2
If characters1-4 of Student.HUSID are not 0000 then characters 3-6 must be a valid HESA INSTID plus 1000Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.HUSID.Business Rule.2
QR.C15053.Student.HUSID.3
Student.HUSID must pass the checksum test given in the coding manualShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.HUSID.Business Rule.3
QR.C15053.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).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.C15053.Student.INITIATIVES.1
Where there are two occurrences of Student.INITIATIVES they must not be identicalShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.INITIATIVES.Business Rule.1
QR.C15053.Student.INITIATIVES.2
Student.INITIATIVES = D can only exist where Student.TTCID = 1, 8 or G and CourseSubject.SBJCA = G100 and Student.ITTPHSC = 71 - 77 and Provider.UKPRN = 10007811, 10007823, 10007766, 10007139, 10006840, 10007146, 10007802, 10007776, 10007140, 10007832, 10004797, 10000886, 10007792, 10007801, 10007806, 10007163 or 10007166Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to amend reference of 'Institution' entity to become 'Provider'.
- Previous Name of Rule
- Student.INITIATIVES.BusinessRule.2
QR.C15053.Student.INITIATIVES.3
Where there is more than one occurrence of Student.INITIATIVES and one of those occurrences = F, the other occurrence of Student.INITIATIVES must not be coded G, H, I or J.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.INITIATIVES.BusinessRule.3
QR.C15053.Student.INITIATIVES.4
Where there is more than one occurrence of Student.INITIATIVES and one of those occurrences = G, the other occurrence of Student.INITIATIVES must not be coded H, I or J.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.INITIATIVES.BusinessRule.4
QR.C15053.Student.INITIATIVES.5
Where there is more than one occurrence of Student.INITIATIVES and one of those occurrences = H, the other occurrence of Student.INITIATIVES must not be coded I or J.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.INITIATIVES.BusinessRule.5
QR.C15053.Student.INITIATIVES.6
Where there is more than one occurrence of Student.INITIATIVES and one of those occurrences = I, the other occurrence of Student.INITIATIVES must not be coded J.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.INITIATIVES.BusinessRule.6
QR.C15053.Student.INITIATIVES.7
(Student.TTCID must be coded 1, 8 or G and CourseSubject.SBJCA must be coded X120 and Student.ITTPHSC must be coded 71-77) where Student.INITIATIVES = L.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule added to ensure that ITT students on a Primary General (with Maths) initiative are returned correctly.
- Previous Name of Rule
- N/A
QR.C15053.Student.INITIATIVES.8
Student.TTCID must be coded G and Student.MSTUFEE must be coded 81 where Student.INITIATIVES = M.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule added to ensure that ITT students on a Maths and Physics Chairs Programme initiative are returned correctly.
- Previous Name of Rule
- N/A
QR.C15053.Student.ITTAIM.1
Student.ITTAIM = 027 can only exist where Student.TTCID = GShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ITTAIM.Business Rule.1
QR.C15053.Student.ITTAIM.2
Where Student.ITTAIM = 032 and Student.MSTUFEE = 30 and (Student.INITIATIVES = F or J) and Student.FUNDCODE = 7, then Provider.UKPRN must be in 10000291, 10000571, 10001143, 10001282, 10003614, 10003678, 10003861, 10004048, 10004180, 10007137, 10007138, 10007139, 10007146, 10007148, 10007159, 10007163, 10007164, 10007802, 10007811, 10007823 or 10007851Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to amend reference of 'Institution' entity to become 'Provider'.
- Previous Name of Rule
- Student.ITTAIM.BusinessRule.2
QR.C15053.Student.ITTAIM.3
Where Student.ITTAIM = 032 and Student.MSTUFEE = 30 and Student.INITIATIVES = G and Student.FUNDCODE = 7, then Provider.UKPRN must be in 10000291, 10000571, 10000886, 10001143, 10001282, 10003614, 10003678, 10003863, 10004048, 10004180, 10004351, 10004930, 10005790, 10006299, 10007137, 10007138, 10007139, 10007144, 10007145, 10007146, 10007148, 10007149, 10007152, 10007155, 10007159, 10007163, 10007164, 10007166, 10007802, 10007811, 10007823 or 10007851Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to amend reference of 'Institution' entity to become 'Provider'.
- Previous Name of Rule
- Student.ITTAIM.BusinessRule.3
QR.C15053.Student.ITTAIM.4
Where Student.ITTAIM = 032 or 033 and Student.INITIATIVES = H and Student.FUNDCODE = 2, then Provider.UKPRN must be in 10000291, 10000571, 10000886, 10001143, 10001282, 10003861, 10004048, 10004180, 10004351, 10005790, 10006299, 10007138, 10007139, 10007145, 10007146, 10007148, 10007149, 10007152, 10007155, 10007163, 10007164, 10007166, 10007776, 10007811 or 10007823Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to amend reference of 'Institution' entity to become 'Provider'.
- Previous Name of Rule
- Student.ITTAIM.BusinessRule.4
QR.C15053.Student.ITTAIM.5
Where Student.ITTAIM = 034 and Student.INITIATIVES = I and Student.FUNDCODE = 2, then Provider.UKPRN must be in 10000291, 10001282, 10003614, 10003863, 10004351, 10004930, 10007137, 10007139, 10007144, 10007145, 10007152, 10007159, 10007163, 10007811, 10007823 or 10007851Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to amend reference of 'Institution' entity to become 'Provider'.
- Previous Name of Rule
- Student.ITTAIM.BusinessRule.5
QR.C15053.Student.ITTAIM.6
Where Student.ITTAIM = 032, 033 or 034, then Student.TTCID must = QShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ITTAIM.Business Rule.6
QR.C15053.Student.ITTCOMDATE.1
Where exists Student.ITTCOMDATE must not be earlier than Student.COMDATEShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ITTCOMDATE.Business Rule.1
QR.C15053.Student.ITTPHSC.1
Student.ITTPHSC codes 71 - 81 are only available where Student.TTCID = 1, 8 or G and Student.COMDATE is after 2007-07-31Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ITTPHSC.Business Rule.2
QR.C15053.Student.ITTPHSC.2
Student.ITTPHSC codes 31 or 49 are only available where Student.TTCID = 2 or GShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ITTPHSC.Business Rule.3
QR.C15053.Student.ITTPHSC.3
Student.ITTPHSC codes 51 - 57 are only available where Student.COMDATE is after 2002-07-31 and before 2007-08-01Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ITTPHSC.Business Rule.4
QR.C15053.Student.ITTPHSC.4
Where Student.ITTPHSC is coded 72 Student.COMDATE must be after 2007-07-31 and before 2010-08-01Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ITTPHSC.Business Rule.6
QR.C15053.Student.ITTPHSC.5
Where Student.ITTPHSC = 84, then Student.TTCID must = QShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ITTPHSC.Business Rule.7
QR.C15053.Student.ITTSCHMS.1
Student.ITTSCHMS can only be coded 6 where Student.ITTPHSC is between 72 to 77 and CourseSubject.SBJCA is French (R100), German (R200), Italian (R300) or Spanish (R400)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ITTSCHMS.Business Rule.2
QR.C15053.Student.MODE.1
Student.MODE cannot be coded 01 where Student.UNITLGTH = 2 and Student.SPLENGTH = 01 to 05Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.MODE.Business Rule.1
QR.C15053.Student.MODE.2
Student.MODE cannot be coded 01 where Student.UNITLGTH = 3 and Student.SPLENGTH = 01 to 23Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.MODE.Business Rule.2
QR.C15053.Student.MODE.3
Student.MODE cannot be coded 63 or 64 where Student.COMDATE is in the current reporting period (i.e. on/after 01-Aug-Y1)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.MODE.Business Rule.3
QR.C15053.Student.MSTUFEE.1
Student.MSTUFEE must exist where (Student.TTCID = G or Q) and (Student.MODE = 01 or 31)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to enforce the coverage of Student.MSTUFEE field.
- Previous Name of Rule
- Student.MSTUFEE.BusinessRule.1
QR.C15053.Student.MSTUFEE.2
Where Student.TTCID = G, Student.MSTUFEE must = 01, 02, 03, 04, 06, 52, 53, 54, 81 or 97Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Student.MSTUFEE codes 06 and 97 added to the rule in line with guidance for returning NCTL programmes.
- Previous Name of Rule
- Student.MSTUFEE.Business Rule.2
QR.C15053.Student.MSTUFEE.3
Where Student.MSTUFEE = 06, then Student.FUNDCODE should = 7.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule required to permit Channel Islands and Isle of Man students to be returned as ‘fundable by the NCTL’.
- Previous Name of Rule
- N/A
QR.C15053.Student.PGCECLSS.1
Student.PGCECLSS must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 027, 031 or (032 and Student.INITIATIVES is F, G or J))Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to enforce the coverage of Student.PGCECLSS field.
- Previous Name of Rule
- Student.PGCECLSS.BusinessRule.1
QR.C15053.Student.PGCESBJ.1
Student.PGCESBJ must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 027, 031 or (032 and Student.INITIATIVES is F, G or J))Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule updated to enforce the coverage of Student.PGCESBJ field.
- Previous Name of Rule
- Student.PGCESBJ.BusinessRule.1
QR.C15053.Student.RSNEND.1
Student.RSNEND must exist where Student.ENDDATE is not nullShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.RSNEND.Business Rule.1
QR.C15053.Student.SEXID.1
Where Student.SEXID is coded 3 for 5 or more studentsShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.SEXID.Business Rule.1
QR.C15053.Student.SPLENGTH.1
Student.SPLENGTH cannot be greater than 09 where Student.MODE = 01 and Student.UNITLGTH = 1Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.SPLENGTH.Business Rule.1
QR.C15053.Student.SPLENGTH.2
Student.SPLENGTH cannot be greater than 72 where Student.MODE = 01 and Student.UNITLGTH = 2Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.SPLENGTH.Business Rule.2
QR.C15053.Student.TTCID.1
Student.TTCID = 8 can only exist where (Student.ITTCOMDATE exists and is on or before 2014-07-31) or (Student.ITTCOMDATE does not exist and Student.COMDATE is on or before 2014-07-31)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.TTCID.Business Rule.3
QR.C15053.Student.TTCID.2
When Student.TTCID = Q and Student.ITTPHSC = 84 and (Student.INITIATIVES = F or J) then (Student.ITTAIM must = 032 and Student.MSTUFEE must = 30 and Student.FUNDCODE must = 7)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.TTCID.Business Rule.4
QR.C15053.Student.TTCID.3
When Student.TTCID = Q and Student.ITTPHSC = 84 and Student.INITIATIVES = G then (Student.ITTAIM must = 032 and Student.MSTUFEE must = 30 and Student.FUNDCODE must = 7)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.TTCID.Business Rule.5
QR.C15053.Student.TTCID.4
When Student.TTCID = Q and Student.ITTPHSC = 84 and Student.INITIATIVES = H then ((Student.ITTAIM must = 032 or 033) and (Student.MSTUFEE must = 01, 02, 03, 04, 52, 53, 54) and Student.FUNDCODE must = 2)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.TTCID.Business Rule.6
QR.C15053.Student.TTCID.5
When Student.TTCID = Q and Student.ITTPHSC = 84 and Student.INITIATIVES = I then (Student.ITTAIM must = 034 and Student.MSTUFEE must = 01 and Student.FUNDCODE must = 2)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.TTCID.Business Rule.7
QR.C15053.Student.TTCID.6
Where Student.TTCID = Q, then Student.ITTPHSC must = 84Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.TTCID.Business Rule.8
QR.C15053.Student.ULN.1
Student.ULN must pass the checksum test given in the coding manualShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.ULN.Business Rule.1
QR.C15053.Student.YEARPRG.1
Student.YEARPRG code 0 is only available where Student.ITTAIM = 001, 002, 003, 004, 007, 008, 012, 013 or 014.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.YEARPRG.Business Rule.1
QR.C15053.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 99Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.YEARPRG.Business Rule.2
QR.C15053.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.COMDATEShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Student.YEARSTU.Business Rule.2
QR.C15053.Student.DISCFUND.1
Student.DISCFUND = 3 is only applicable when CourseSubject.SBJCA = C100, C690, D600, F100, F300, F390, G100, H700, H900, I100, J420, L700, Q300, Q490, Q560, Q610, Q710, Q800, R100, R200, R300, R400, R500, R700, R900, V100, W200, W210 W300, X120, X121 X160 or X900Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule deleted because discretionary funding will not be awarded in 2015/16 and therefore Student.DISCFUND code 3 is not expected to be returned.
- Previous Name of Rule
- Student.DISCFUND.BusinessRule.1
QR.C15053.Student.DISCFUND.2
Student.DISCFUND = 3 is only applicable where Student.BURSLEV = 7, 8 or 9Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule deleted because discretionary funding will not be awarded in 2015/16 and therefore Student.DISCFUND code 3 is not expected to be returned.
- Previous Name of Rule
- Student.DISCFUND.BusinessRule.2
QR.C15053.Student.ENDDATE.1
Student.ENDDATE must not be null except when ReasonForNull = 9Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule deleted as ReasonForNull attributes have been removed.
- Previous Name of Rule
- Student.ENDDATE.BusinessRule.1
QR.C15053.Student.ENDDATE.2
Student.ENDDATE must be null when ReasonForNull = 9Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule deleted as ReasonForNull attributes have been removed.
- Previous Name of Rule
- Student.ENDDATE.BusinessRule.2
QR.C15053.Student.FNAMES.1
Student.FNAMES must not be null except when ReasonForNull = 9Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule deleted as ReasonForNull attributes have been removed.
- Previous Name of Rule
- Student.FNAMES.BusinessRule.1
QR.C15053.Student.FNAMES.2
Student.FNAMES must be null when ReasonForNull = 9Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule deleted as ReasonForNull attributes have been removed.
- Previous Name of Rule
- Student.FNAMES.BusinessRule.2
QR.C15053.Student.INDSLFCRT.1
Student.INDSLFCRT must = 'Y'Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule no longer required as the field has been deleted for C15053.
- Previous Name of Rule
- Student.INDSLFCRT.BusinessRule.1