Skip to main content

HESA ITT In-year collection 2013/14

Back to C13053

Initial Teacher Training In-Year Collection 2013/14

Summary of business rules


return to index

Version 1.3 Produced 2013-10-21

The business rules below have been updated for 2013/14. 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, L230, L390, L700, P390, Q300, Q560, R100, R200, R300, R400, R500, V100, V600, W200, W300, W400, W500, W900, X900, X120 or X121 where Student.TTCID = 1, 8, G, H, L, M, N or P 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, 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, G, H, L, M, N or P 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,G, H, L, M, N or P 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, G, H, L, M , N or P and Student.ITTPHSC = 54 - 57, or 78 - 81 7
CourseSubject SBJCA Error For institutions in England where Student.TTCID = 1, 8, G, H, L, M, N or P 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, G, H, L, M, N or P and Student.ITTPHSC = 51 - 53, or 71 - 77. 9
CourseSubject SBJCA Error CourseSubject.SBJCA cannot be coded L100 when any Student.COMDATE is after 2006-07-31 10
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 = 5 must only exist where Student.ITTPHSC = 51- 53 or 71-77 1
Student BURSLEV Error Student.BURSLEV = 1, 2, 3 or 5 are only applicable when CourseSubject.SBJCA = C100, C600, F100, F300, F390, G100, I100, L700, Q300, Q800, R100, R200, R300, R400, R500, R700, R900, V100, W300, X120, X121 or X900 2
Student BURSLEV Error Where Student.TTCID does not = 1, 8, G or H then Student.BURSLEV must equal 6 3
Student BURSLEV Error Student.BURSLEV = 1 can only exist where Student.PGCECLSS = 03 or 04 and Student.DEGTYPE = 001-098, 400 or 402 4
Student BURSLEV Error Where Student.BURSLEV = 1 then Student.PGCECLSS must not = 01, 02 or 05-99 and Student.DEGTYPE must not = 200-306, 401 or 999 5
Student BURSLEV Warning Student.BURSLEV = 2 can only exist where (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) 6
Student BURSLEV Warning Where Student.BURSLEV = 2 then Student.PGCECLSS must not = 01, 03, 05-11, 98 or 99 and Student.DEGTYPE must not = 300-306 or 999 7
Student BURSLEV Error Student.BURSLEV = 3 can only exist where (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) 8
Student BURSLEV Error Where Student.BURSLEV = 3 then Student.PGCECLSS must not = 02-11 or 13-99 and Student.DEGTYPE must not = 200-213 or 999 9
Student BURSLEV Warning Student.BURSLEV = 6 can only exist where Student.PGCECLSS = 05-11, 98 or 99 OR Student.PGCECLSS does not exist 10
Student BURSLEV Warning Where Student.BURSLEV = 6 then Student.PGCECLSS must not = 01-04 or 12-14 11
Student BURSLEV Error Student.BURSLEV must = 6 where Student.FUNDCODE = 2 12
Student BURSLEV Error Student.BURSLEV must = 6 where Student.COMDATE is on or before 2013-07-31 13
Student BURSLEV Error Student.BURSLEV = 4 can only exist where CourseSubject.SBJCA = F100, F300, G100 or I100 and Student.PGCECLSS = 01 or 02 and Student.DEGTYPE = 001-098, 400 or 402 14
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 Warning Student.DEGSTDT, where exists, should not be earlier than (Y1-08-01 minus 7 years) 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 = 1 is only applicable when CourseSubject.SBJCA = C100, C600, F100, F300, F390, G100, I100, L700, Q300, Q800, R100, R200, R300, R400, R500, R700, R900, V100, W300, X120, X121 or X900 1
Student DISCFUND Error Student.DISCFUND = 1 is only applicable where Student.BURSLEV = 1 or 2 2
Student DISCFUND Error Where Student.TTCID does not = 1, 8, G or H then Student.DISCFUND must = 2 3
Student DISCFUND Error Student.DISCFUND must = 2 where Student.COMDATE is on or before 2013-07-31 4
Student DISCFUND Error Student.DISCFUND must not = 1 where Student.PGCECLSS = 01, 05-11, 98 or 99 5
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 H 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, G, H, L, M, N or P and CourseSubject.SBJCA = G100 and Student.ITTPHSC = 71 - 77 and Institution.UKPRN = 10007811, 10007823, 10007766, 10007138, 10007139, 10006840, 10007146, 10007802, 10007776 or 10007164 2
Student ITTAIM Error Student.ITTAIM = 027 can only exist where Student.TTCID = G, H, L, M, N or P 1
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, G or H and Student.COMDATE is after 2007-07-31) OR where Student.TTCID = L, M, N or P 2
Student ITTPHSC Error Student.ITTPHSC codes 31 or 49 are only available where Student.TTCID = 2, G, H, L, M, N or P 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 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 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 Where Student.TTCID = L, M, N or P, Student.COMDATE must be after 2013-07-31 1
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 01242 211144.