# HESA Student Record 2007/08

## Initial Teacher Training In-Year Collection 2008/09## Summary of validation rules |
return to index |

Version 1.2 Produced 2008-10-08

Entity | Field Name | Status | Rule | Number |
---|---|---|---|---|

CourseSubject | SBJCA | Error | CourseSubject.SBJCA must be coded C100, C600, F100, F300, G100, G500, L230, L390, L700, P390, Q300, Q560, R100, R200, R300, R400, R500, V100, V600, W200, W300, W400, W500, W900, X900, X120 or Y000 where Student.TTCID = 1 or 8 and any Student.ITTPHSC = 71 - 77 | 1 |

CourseSubject | SBJCA | Error | CourseSubject.SBJCA cannot be coded X120 where Student.TTCID = 1 or 8 and any (Student.ITTPHSC = 15 - 19, 51-53, 71 - 77 and Student.COMDATE before 2002-09-01) | 2 |

CourseSubject | SBJCA | Error | CourseSubject.SBJCA must be coded C000, C100, C110, C600, C800, D600, F000, F100, F110, F300, F310, G100, G500, G510, 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 or 8 and any Student.ITTPHSC = 24 - 26, 54 - 57, or 78 - 82 | 3 |

CourseSubject | SBJCA | Error | One, and only one, CourseSubject.SBJCA must be coded F000 where any CourseSubject.SBJCA = C000 and Student.TTCID = 1 or 8 and any Student.ITTPHSC = 24 -26, 54 - 57, or 78 - 82 | 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 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 C000 where any CourseSubject.SBJCA = F000 and Student.TTCID = 1 or 8 and Student.ITTPHSC = 24 - 26, 54 - 57, or 78 - 82 | 7 |

CourseSubject | SBJCA | Error | CourseSubject.SBJCA codes C110, F110 and F310 can only be used together when Course.TTCID = 1 or 8 and Instance.ITTPHSC = 24 - 26, 54 - 57, or 78 - 82 | 8 |

CourseSubject | SBJCA | Error | CourseSubject.SBJCA codes C100, F100 and F300 can only be used together when Course.TTCID = 1 or 8 and Instance.ITTPHSC = 15 - 19, 51 - 53, or 71 - 77 | 9 |

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 | 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 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 | 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 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 | 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 or 031) | 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 | ENDDATE | Error | Student.ENDDATE must not be null except where ReasonForNull = 9 | 1 |

Student | ENDDATE | Error | Student.ENDDATE must be null where 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 or 8 | 1 |

Student | FUNDCODE | Error | Student.FUNDCODE code 7 is only available where Student.ITTPHSC is not 31 or 49 | 2 |

Student | FUNDCODE | Error | Student.FUNDCODE code 4 is only available where Student.TTCID = 2 | 3 |

Student | HUSID | Error | Student.HUSID must not contain all zeros | 1 |

Student | HUSID | Error | If characters 1-4 are not 0000 then characters 3-6 of Student.HUSID must be a valid 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 exist where Student.COMDATE is in the current reporting period | 1 |

Student | ITTPHSC | Error | Student.ITTPHSC codes 15 - 26 are only available where Student.TTCID = 1 or 8 and Student.COMDATE is before 2002-08-01 | 1 |

Student | ITTPHSC | Error | Student.ITTPHSC codes 71 - 82 are only available where Student.TTCID = 1 or 8 and Student.COMDATE is after 2007-07-31 | 2 |

Student | ITTPHSC | Error | Student.ITTPHSC codes 31 or 49 are only available where Student.TTCID is coded 2 | 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 | 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 | ITTSCHMS | Error | Student.ITTSCHMS can only be coded 7 where Student.ITTPHSC is between 77 to 82 (i.e. secondary or KS2/3) and CourseSubject.SBJCA is Chemistry (F100), German (R200), ICT (G500), Mathematics (G100), French (R100) or Physics (F300) | 3 |

Student | ITTSCHMS | Warning | Student.ITTSCHMS should only be coded 3 where Student.ITTAIM = 007 to 013, Student.ITTPHSC = 78, 79, 80, 81 or 82 and CourseSubject.SBJCA is Mathematics (G100), Physics (F300) or Chemistry (F100) | 4 |

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 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 or 031) | 1 |

Student | RSNEND | Error | Student.RSNEND must exist where Student.ENDDATE is not null | 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 | 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.