Initial Teacher Training record 2014/15
Summary of business rules
Version 1.5 Produced 2015-05-21
The business rules below have been updated for 2014/15. Individual changes are listed in the Revision history against the field or entity in which they appear.
Entity | Field Name | Status | Rule | Number |
CourseSubject | SBJCA | Error | CourseSubject.SBJCA must be coded C100, C600, 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 - 77 | 1 |
CourseSubject | SBJCA | Error | 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, Q560, 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 - 81 | 3 |
CourseSubject | SBJCA | Error | 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 - 81 | 4 |
CourseSubject | SBJCA | Error | 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 | 5 |
CourseSubject | SBJCA | Warning | 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 | 6 |
CourseSubject | SBJCA | Error | 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 - 81 | 7 |
CourseSubject | SBJCA | Error | For institutions 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. | 8 |
CourseSubject | SBJCA | Error | 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. | 9 |
CourseSubject | SBJCA | Error | Where CourseSubject.SBJCA = I900, N990, K290, P390, P900, H990, F750, B990, N862, I200, M990, H790, J500, W310, L390, L430, N900, L990, N890, N800 then Student.FUNDCODE must = 2 and Student.COMDATE is after 2014-07-31 | 11 |
Student | BIRTHDTE | Error | Student.BIRTHDTE cannot be before 1906-11-01 | 1 |
Student | BIRTHDTE | Error | Student.BIRTHDTE cannot be after Y1-07-31 | 2 |
Student | BIRTHDTE | Warning | Student.BIRTHDTE should be before (Y1-20)-08-01 where Student.ITTAIM is a postgraduate qualification (110, 113, 020 or 031) | 3 |
Student | BIRTHDTE | Warning | Student.BIRTHDTE should be before (Y1-17)-08-01 where Student.ITTAIM = 007, 008, 014, 012, 001, 002, 003, 004 or 013 | 4 |
Student | BIRTHDTE | Warning | Student.BIRTHDTE should be after (Y1-70)-07-31 | 5 |
Student | BIRTHDTE | Warning | Student.BIRTHDTE should be before (Y1-14)-07-31 | 6 |
Student | BURSLEV | Error | Student.BURSLEV = 7, 8 or 9 are 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, W300, X120, X121, X160 or X900 | 2 |
Student | BURSLEV | Error | Student.BURSLEV = 9 can only exist where (Student.DISCFUND = 4 and (Student.PGCECLSS = 03 or 04 and Student.DEGTYPE = 001-098, 400 or 402)) or (Student.DISCFUND = 3 and (Student.CourseSubject.SBJCA = G100, F300 or F390 and Student.PGCECLSS = 05-11, 98 or 99)) | 4 |
Student | BURSLEV | Error | Student.BURSLEV = 8 can only exist where (Student.DISCFUND = 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-213 or 401))) or (Student.DISCFUND = 3 and (Student.PGCECLSS = 03 or 04 and Student.DEGTYPE = 001-098, 400 or 402)) | 6 |
Student | BURSLEV | Error | Student.BURSLEV = 7 can only exist where (Student.DISCFUND = 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.DISCFUND = 3 and ((Student.PGCECLSS = 12-14 and Student.DEGTYPE = 200-213 or 401) or Student.PGCECLSS = 02 or 04 and Student.DEGTYPE = 001-098, 400 or 402))) | 8 |
Student | BURSLEV | Error | Student.BURSLEV must = 6 where Student.FUNDCODE = 2 | 12 |
Student | BURSLEV | Error | Student.BURSLEV must = 6 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) | 13 |
Student | BURSLEV | Error | Student.BURSLEV = 4 can only exist where CourseSubject.SBJCA = F100, F300, G100 or I100 and Student.PGCECLSS = 01-04 | 14 |
Student | BURSLEV | Error | Where Student.TTCID = 0 or 2, Student.BURSLEV must = 6. | 15 |
Student | BURSLEV | Warning | Student.BURSLEV does not = 4, 7, 8 or 9 where (Student.DISCFUND = 4 and (Student.PGCECLSS = 03 or 04 and Student.DEGTYPE = 001-098, 400 or 402)) or (Student.DISCFUND = 3 and (Student.CourseSubject.SBJCA = G100, F300 or F390 and Student.PGCECLSS = 05-11, 98 or 99)). | 16 |
Student | BURSLEV | Warning | Student.BURSLEV does not = 4, 7 or 8 where (Student.DISCFUND = 4 and ((Student.PGCECLSS = 12-14 and Student.DEGTYPE = 200-213 or 401) or Student.PGCECLSS = 02 or 04 and Student.DEGTYPE = 001-098, 400 or 402))) or (Student.DISCFUND = 3 and (Student.PGCECLSS = 03 or 04 and Student.DEGTYPE = 001-098, 400 or 402)). | 17 |
Student | BURSLEV | Warning | Student.BURSLEV does not = 4 or 7 where (Student.DISCFUND = 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.DISCFUND = 3 and ((Student.PGCECLSS = 12-14 and Student.DEGTYPE = 200-213 or 401) or Student.PGCECLSS = 02 or 04 and Student.DEGTYPE = 001-098, 400 or 402))). | 18 |
Student | BURSLEV | Warning | Student.BURSLEV does not = 4 where Student.PGCECLSS = 01-04 and CourseSubject.SBJCA = F100, F300, G100 or I100. | 19 |
Student | BURSLEV | Error | Student.BURSLEV = A can only exist where (Student.DISCFUND = 4 and (Student.CourseSubject.SBJCA = G100, F300 or F390 and Student.PGCECLSS = 05-11, 98 or 99)). | 20 |
Student | BURSLEV | Warning | Student.BURSLEV does not = 4, 7, 8, 9 or A where (Student.DISCFUND = 4 and (Student.CourseSubject.SBJCA = G100, F300 or F390 and Student.PGCECLSS = 05-11, 98 or 99)). | 21 |
Student | BURSLEV | Error | Student.BURSLEV must = 6 where CourseSubject.SBJCA is not any of 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, W300, X120, X121, X160 or X900. | 22 |
Student | COMDATE | Error | Student.COMDATE must not be before 1991-01-31 | 1 |
Student | COMDATE | Error | Student.COMDATE must be before Y2-08-01 | 2 |
Student | DEGCTRY | Error | Student.DEGCTRY must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 027 or 031) and Student.DEGEST does not exist | 1 |
Student | DEGCTRY | Error | Student.DEGCTRY must not exist where Student.DEGEST exists | 2 |
Student | DEGENDDT | Error | Student.DEGENDDT must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020 or 031) | 1 |
Student | DEGENDDT | Error | Student.DEGENDDT must not be later than Student.COMDATE | 2 |
Student | DEGENDDT | Error | Student.DEGENDDT where exists must be later than Student.DEGSTDT | 3 |
Student | DEGENDDT | Warning | Student.DEGENDDT where exists should not be earlier than (Y1-08-01 minus 7 years) | 4 |
Student | DEGEST | Error | Student.DEGEST must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 027 or 031) unless Student.DEGCTRY exists | 1 |
Student | DEGLENGTH | Error | Student.DEGLENGTH must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020 or 031) | 1 |
Student | DEGSTDT | Error | Student.DEGSTDT must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020 or 031) | 1 |
Student | DEGSTDT | Error | Student.DEGSTDT, where exists, must not be earlier than (Y1-40)-08-01 | 2 |
Student | DEGTYPE | Error | Student.DEGTYPE must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 027 or 031) | 1 |
Student | DISABLE | Warning | Where Student.DISABLE = 02, 03, 04, 05, 06, 07, 10, 11, 97, 98 or 99 then Student.COMDATE must be before 2010-08-01 | 1 |
Student | DISALL | Warning | Student.DISALL should exist where Student.DISABLE = 02 - 96 | 1 |
Student | DISALL | Warning | Student.DISALL should not exist where Student.DISABLE = 00, 97, 98 or 99 | 2 |
Student | DISCFUND | Error | 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 X900 | 1 |
Student | DISCFUND | Error | Student.DISCFUND = 3 is only applicable where Student.BURSLEV = 7, 8 or 9 | 2 |
Student | DISCFUND | Error | 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) | 4 |
Student | DISCFUND | Error | Where Student.TTCID = 0 or 2, then Student.DISCFUND must = 4. | 6 |
Student | DISCFUND | Error | Student.DISCFUND must = 4 where Student.PGCECLSS = 98 or 99. | 7 |
Student | ENDDATE | Error | Student.ENDDATE must not be null except when ReasonForNull = 9 | 1 |
Student | ENDDATE | Error | Student.ENDDATE must be null when ReasonForNull = 9 | 2 |
Student | ENDDATE | Error | Student.ENDDATE must not be null where Student.RSNEND exists | 3 |
Student | ENDDATE | Error | Student.ENDDATE must be before Y2-08-01 | 4 |
Student | ENDDATE | Error | If Student.Mode is not equal to 63 or 64, then Student.ENDDATE must be after Y1-07-31 | 5 |
Student | ENDDATE | Error | Student.ENDDATE must be after (Y2-6)-07-31 when Student.MODE = 63 or 64 | 6 |
Student | ENDDATE | Error | Student.ENDDATE must be after or the same as Student.COMDATE unless (Student.MODE = 63 or 64 and Student.ENDDATE = Y0-08-01) | 7 |
Student | FNAMES | Error | Student.FNAMES must not be null except when ReasonForNull = 9 | 1 |
Student | FNAMES | Error | Student.FNAMES must be null when ReasonForNull = 9 | 2 |
Student | FUNDCODE | Error | Student.FUNDCODE code 7 is only available where Student.TTCID = 1, 8, G or Q | 1 |
Student | FUNDCODE | Error | Student.FUNDCODE code 7 is only available where Student.ITTPHSC is not 31 or 49 | 2 |
Student | HUSID | Error | Student.HUSID must not contain all zeros | 1 |
Student | HUSID | Error | If characters1-4 of Student.HUSID are not 0000 then characters 3-6 must be a valid HESA INSTID plus 1000 | 2 |
Student | HUSID | Error | Student.HUSID must pass the checksum test given in the coding manual | 3 |
Student | HUSID | Error | 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). | 4 |
Student | INDSLFCRT | Error | Student.INDSLFCRT must = 'Y' | 1 |
Student | INITIATIVES | Error | Where there are two occurrences of Student.INITIATIVES they must not be identical | 1 |
Student | INITIATIVES | Error | Student.INITIATIVES = D can only exist where Student.TTCID = 1, 8 or G and CourseSubject.SBJCA = G100 and Student.ITTPHSC = 71 - 77 and Institution.UKPRN = 10007811, 10007823, 10007766, 10007139, 10006840, 10007146, 10007802, 10007776, 10007140, 10007832, 10004797, 10000886, 10007792, 10007801, 10007806, 10007163 or 10007166 | 2 | Student | INITIATIVES | Error | 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. | 3 | Student | INITIATIVES | Error | 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. | 4 | Student | INITIATIVES | Error | 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. | 5 | Student | INITIATIVES | Error | 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. | 6 |
Student | ITTAIM | Error | Student.ITTAIM = 027 can only exist where Student.TTCID = G | 1 |
Student | ITTAIM | Error | Where Student.ITTAIM = 032 and Student.MSTUFEE = 30 and (Student.INITIATIVES = F or J) and Student.FUNDCODE = 7, then Institution.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 10007851 | 2 |
Student | ITTAIM | Error | Where Student.ITTAIM = 032 and Student.MSTUFEE = 30 and Student.INITIATIVES = G and Student.FUNDCODE = 7, then Institution.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 10007851 | 3 |
Student | ITTAIM | Error | Where Student.ITTAIM = 032 or 033 and Student.INITIATIVES = H and Student.FUNDCODE = 2, then Institution.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 10007823 | 4 |
Student | ITTAIM | Error | Where Student.ITTAIM = 034 and Student.INITIATIVES = I and Student.FUNDCODE = 2, then Institution.UKPRN must be in 10000291, 10001282, 10003614, 10003863, 10004351, 10004930, 10007137, 10007139, 10007144, 10007145, 10007152, 10007159, 10007163, 10007811, 10007823 or 10007851 | 5 |
Student | ITTAIM | Error | Where Student.ITTAIM = 032, 033 or 034, then Student.TTCID must = Q | 6 |
Student | ITTCOMDATE | Error | Where exists Student.ITTCOMDATE must not be earlier than Student.COMDATE | 1 |
Student | ITTPHSC | Error | Student.ITTPHSC codes 71 - 81 are only available where Student.TTCID = 1, 8 or G and Student.COMDATE is after 2007-07-31 | 2 |
Student | ITTPHSC | Error | Student.ITTPHSC codes 31 or 49 are only available where Student.TTCID = 2 or G | 3 |
Student | ITTPHSC | Error | Student.ITTPHSC codes 51 - 57 are only available where Student.COMDATE is after 2002-07-31 and before 2007-08-01 | 4 |
Student | ITTPHSC | Error | Where Student.ITTPHSC is coded 72 Student.COMDATE must be after 2007-07-31 and before 2010-08-01 | 6 |
Student | ITTPHSC | Error | Where Student.ITTPHSC = 84, then Student.TTCID must = Q | 7 |
Student | ITTSCHMS | Error | 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) | 2 |
Student | MODE | Error | Student.MODE cannot be coded 01 where Student.UNITLGTH = 2 and Student.SPLENGTH = 01 to 05 | 1 |
Student | MODE | Error | Student.MODE cannot be coded 01 where Student.UNITLGTH = 3 and Student.SPLENGTH = 01 to 23 | 2 |
Student | MODE | Error | Student.MODE cannot be coded 63 or 64 where Student.COMDATE is in the current reporting period (i.e. on/after 01-Aug-Y1) | 3 |
Student | MSTUFEE | Error | Student.MSTUFEE must exist where Student.TTCID = G or Q | 1 |
Student | MSTUFEE | Error | Where Student.TTCID = G, Student.MSTUFEE must = 01, 02, 03, 04, 52, 53, 54 or 81 | 2 |
Student | PGCECLSS | Error | Student.PGCECLSS must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 027 or 031) | 1 |
Student | PGCESBJ | Error | Student.PGCESBJ must exist where Student.COMDATE is in the current reporting period and Student.ITTAIM is a postgraduate qualification (110, 113, 020, 027 or 031) | 1 |
Student | RSNEND | Error | Student.RSNEND must exist where Student.ENDDATE is not null | 1 |
Student | SEXID | Warning | Where Student.SEXID is coded 3 for 5 or more students | 1 |
Student | SPLENGTH | Error | Student.SPLENGTH cannot be greater than 09 where Student.MODE = 01 and Student.UNITLGTH = 1 | 1 |
Student | SPLENGTH | Error | Student.SPLENGTH cannot be greater than 72 where Student.MODE = 01 and Student.UNITLGTH = 2 | 2 |
Student | TTCID | Error | 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) | 3 |
Student | TTCID | Error | 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) | 4 |
Student | TTCID | Error | 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) | 5 |
Student | TTCID | Error | 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) | 6 |
Student | TTCID | Error | 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) | 7 |
Student | TTCID | Error | Where Student.TTCID = Q, then Student.ITTPHSC must = 84 | 8 |
Student | ULN | Error | Student.ULN must pass the checksum test given in the coding manual | 1 |
Student | YEARPRG | Error | Student.YEARPRG code 0 is only available where Student.ITTAIM = 001, 002, 003, 004, 007, 008, 012, 013 or 014. | 1 |
Student | YEARPRG | Warning | 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 | 2 |
Student | YEARSTU | Error | 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 | 2 |
Contact Liaison by email or on +44 (0)1242 388 531.