HESA Student Record 2008/09
HESA Student Record 2008/09Commit-stage validation |
return to index |
Version 1.6 Produced 2009-09-11
This document lists the validation checks including HIN validation checks that will be applied during the COMMIT transaction of the data collection system. An explanation of the different stages of validation is shown in the validation overview document.
HIN Validation Checks at COMMIT
| Course.COURSEAIM | 1 | Error | Where a Year on Year link has been made to the HIN Register, where level (PG/UG/FE based on QUALAIM/Course.COURSEAIM has changed |
| Course.COURSEID | 2 | Warning | Where a Year on Year link has been made to the HIN register, Course.COURSEID differs (exclude not exists to exists) |
| Course.FEQAIMC | 3 | Error | Where a Year on Year link has been made to the HIN Register, where Course.FEQAIMC has changed |
| EntryProfile.ACCESS | 1 | Warning | Where a Year on Year link has been made to the HIN Register, EntryProfile.ACCESS differs [exclude (not exists to exists where most recent EntryProfile.QUALENT2 is coded 44 or 45) and (exists to not exists where most recent EntryProfile.QUALENT2 is not coded 44 or 45)]. Exclude records identified in EntryProfile.ACCESS.Exception.2. |
| EntryProfile.ACCESS | 2 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.ACCESS has changed from exists to not exists [exclude where most recent EntryProfile.QUALENT2 exists and is not coded 44 or 45]. |
| EntryProfile.ARTICLN | 1 | Error | Where a Year on Year link has been made to the HIN Register, EntryProfile.ARTICLN has changed from known to information sought but not known (8) |
| EntryProfile.ARTICLN | 2 | Warning | Where a Year on Year link has been made to the HIN Register, EntryProfile.ARTICLN differs [exclude (not exists to exists) and (not known (8) to known) and (exists to not exists where (most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM) or (most recent Course.COURSEAIM not in M22, H00, H11, H16, H18, H22, H23, H24, I00, I11, I16))]. Exclude records identified in EntryProfile.ARTICLN.Exception.1 and EntryProfile.ARTICLN.Exception.3. |
| EntryProfile.ARTICLN | 3 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.ARTICLN has changed from exists to not exists [exclude where (most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM) or (most recent Course.COURSEAIM not in M22, H00, H11, H16, H18, H22, H23, H24, I00, I11, I16)]. |
| EntryProfile.DOMICILE | 1 | Error | Where a Year on Year link has been made to the HIN Register, when EntryProfile.DOMICILE has changed from known to unknown (ZZ) value |
| EntryProfile.DOMICILE | 2 | Error | Where a Year on Year link has been made to the HIN Register, when EntryProfile.DOMICILE has changed from a UK (XF, XG, XH, XI, XK) code to non-UK OR non-UK to UK (XF, XG, XH, XI, XK) excluding unknown (ZZ) to known |
| EntryProfile.DOMICILE | 3 | Warning | Where a Year on Year link has been made to the HIN Register, when EntryProfile.DOMICILE differs [exclude records identified in Exception.1 and Exception.2 and changes from unknown (ZZ) to known value] | EntryProfile.MARSTAT | 1 | Warning | Where a Year on Year link made to the HIN Register, EntryProfile.MARSTAT differs [exclude not exists to exists and (exists to not exists where most recent EntryProfile.DOMICILE not XG)]. Exclude records identified in EntryProfile.MARSTAT.2 | EntryProfile.MARSTAT | 2 | Error | Where a Year on Year link made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.MARSTAT has changed from exists to not exists [exclude where most recent EntryProfile.DOMICILE not XG] | EntryProfile.NEWENT | 2 | Error | Where a Year on Year link has been made to the HIN Register, EntryProfile.NEWENT changed from known to unknown (C) |
| EntryProfile.NEWENT | 3 | Warning | Where a Year on Year link has been made to the HIN Register, EntryProfile.NEWENT differs [exclude (not exists to exists) and (unknown (C) to known) and (exists to not exists where most recent Course.COURSEAIM does not begin D, E, L, M H, I, J or C)]. Exclude records identified in EntryProfile.NEWENT.Exception.2 and EntryProfile.NEWENT.Exception.4 |
| EntryProfile.NEWENT | 4 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.NEWENT has changed from exists to not exists [exclude where most recent Course.COURSEAIM does not begin D, E, L, M H, I, J or C] |
| EntryProfile.NIDEPEND | 1 | Warning | Where a link has been made to the HIN Register, EntryProfile.NIDEPEND differs (exclude (not exists to exists) and (exists to not exists where most recent EntryProfile.DOMICILE is not XG)). Exclude records identified in EntryProfile.NIDEPEND.Exception.2. |
| EntryProfile.NIDEPEND | 2 | Error | Where a Year on Year link made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.NIDEPEND has changed from exists to not exists [exclude where most recent EntryProfile.DOMICILE is not XG]. |
| EntryProfile.PARED | 1 | Error | Where a Year on Year link has been made to the HIN Register, EntryProfile.PARED changed from known to unknown (8) |
| EntryProfile.PARED | 2 | Warning | Where a Year on Year link has been made to the HIN Register, EntryProfile.PARED differs [exclude (not exists to exists) and (unknown (8), Information refused (9) to known) and (exists to not exists where (most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM) or (most recent Course.COURSEAIM not in M22, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20, C30))]. Exclude records identified in EntryProfile.PARED.Exception.1 and EntryProfile.PARED.Exception.3 |
| EntryProfile.PARED | 3 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.PARED has changed from exists to not exists [exclude where (most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM) or (most recent Course.COURSEAIM not in M22, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20, C30)] |
| EntryProfile.PGCECLSS | 1 | Error | Where a Year on Year link has been made to the HIN Register, EntryProfile.PGCECLSS has changed from known to unknown (99) or not applicable (98) |
| EntryProfile.PGCECLSS | 2 | Warning | Where a Year on Year link has been made to the HIN Register, EntryProfile.PGCECLSS differs [exclude (not exists to exists) and (unknown (99) to known) and (not applicable (98) to known) and (exists to not exists where most recent Course.COURSEAIM not M71 or H71)]. Exclude records identified in EntryProfile.PGCECLSS.Exception.1 and EntryProfile.PGCECLSS.Exception.3 |
| EntryProfile.PGCECLSS | 3 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.PGCECLSS has changed from exists to not exists [exclude where most recent Course.COURSEAIM not M71 or H71] |
| EntryProfile.PGCESBJ | 1 | Error | Where a Year on Year link has been made to the HIN Register, EntryProfile.PGCESBJ has changed from known to unknown (9999) or not applicable (9998) |
| EntryProfile.PGCESBJ | 2 | Warning | Where a Year on Year link has been made to the HIN Register, EntryProfile.PGCESBJ differs [exclude (not exists to exists) and (unknown (9999) to known) and (exists to not exists where most recent Course.COURSEAIM not M71 or H71)]. Exclude records identified in EntryProfile.PGCESBJ.Exception.1 and EntryProfile.PGCESBJ.Exception.3 |
| EntryProfile.PGCESBJ | 3 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.PGCESBJ has changed from exists to not exists [exclude where most recent Course.COURSEAIM not M71 or H71] |
| EntryProfile.POSTCODE | 2 | Error | Where a Year on Year link has been made to the HIN Register, when EntryProfile.POSTCODE has changed from known full postcode to unknown (POSTCODE ReasonForNull="1") value or just an outward postcode has been returned (exclude known to not exists where most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE or IM) |
| EntryProfile.POSTCODE | 3 | Warning | Where a Year on Year link has been made to the HIN Register, when EntryProfile.POSTCODE differs [exclude records identified in Exception 2, unknown (POSTCODE ReasonForNull="1") to known value, and outward postcode to full valid postcode and (known to not exists where most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE or IM)] |
| EntryProfile.PREVINST | 1 | Warning | Where a Year on Year link has been made to the HIN Register, EntryProfile.PREVINST differs [exclude (not exists to exists) and (generic or unknown code to a learning provider code) and (exists to not exists where (most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM) or (most recent Course.COURSEAIM not in M22, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20, C30))]. Exclude records identified in EntryProfile.PREVINST.Exception.2 and EntryProfile.PREVINST.Exception.3. |
| EntryProfile.PREVINST | 2 | Error | Where a Year on Year link has been made to the HIN Register, EntryProfile.PREVINST has changed from a learning provider or a generic code to an unknown code. |
| EntryProfile.PREVINST | 3 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.PREVINST has changed from exists to not exists [exclude where (most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM) or (most recent Course.COURSEAIM not in M22, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20, C30)] |
| EntryProfile.QUALENT2 | 1 | Error | Where a Year on Year link has been made to the HIN Register, when EntryProfile.QUALENT2 , where exists, has changed from known to unknown (99) value |
| EntryProfile.QUALENT2 | 2 | Warning | Where a Year on Year link has been made to the HIN Register, when EntryProfile.QUALENT2 , where exists, differs [exclude records identified in EntryProfile.QUALENT2 .Exception.1 and EntryProfile.QUALENT2 .Exception.3 and unknown (99) to known value]. |
| EntryProfile.QUALENT2 | 3 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.QUALENT2 has changed from exists to not exists. |
| EntryProfile.RELIGION | 1 | Error | Where a Year on Year link had been made to the HIN Register, EntryProfile.RELIGION has changed from known to missing data (4) |
| EntryProfile.RELIGION | 2 | Warning | Where a Year on Year link had been made to the HIN Register, EntryProfile.RELIGION differs [exclude (not exists to exists) and (missing data (4) to known) and (exists to not exists where most recent EntryProfile.DOMICILE is not XG)]. Exclude records identified in EntryProfile.RELIGION.Exception.1 and EntryProfile.RELIGION.Exception.3 |
| EntryProfile.RELIGION | 3 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.RELIGION has changed from exists to not exists [exclude where most recent EntryProfile.DOMICILE is not XG] |
| EntryProfile.SEC | 1 | Error | Where a Year on Year link has been made to the HIN Register, EntryProfile.SEC has changed from known to not classified (9) |
| EntryProfile.SEC | 2 | Warning | Where a Year on Year link has been made to the HIN Register, EntryProfile.SEC differs [exclude (not exists to exists) and (not classified (9) to known) and (exists to not exists where (most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM) or (most recent Course.COURSEAIM does not begin H, I, J or C and is not M22))]. Exclude records identified in EntryProfile.SEC.Exception.1 and EntryProfile.SEC.Exception.3 |
| EntryProfile.SEC | 3 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.SEC has changed from exists to not exists [exclude where (most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM) or (most recent Course.COURSEAIM does not begin H, I, J or C and is not M22)] |
| EntryProfile.SOC2000 | 1 | Error | Where a Year on Year link has been made to the HIN Register, EntryProfile.SOC2000 has changed from known to not stated (0000) or not known (0009) |
| EntryProfile.SOC2000 | 2 | Warning | Where a Year on Year link has been made to the HIN Register, EntryProfile.SOC2000 differs [exclude (not exists to exists) and (not stated (0000) or not known (0009) to known) and (exists to not exists where (most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM) or (most recent Course.COURSEAIM does not begin H, I, J or C and is not M22))]. Exclude records identified in EntryProfile.SOC2000.Exception.1 and EntryProfile.SOC2000.Exception.3 |
| EntryProfile.SOC2000 | 3 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.SOC2000 has changed from exists to not exists [exclude where (most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM) or (most recent Course.COURSEAIM does not begin H, I, J or C and is not M22)] |
| EntryProfile.UCASAPPID | 2 | Warning | Where a Year on Year link has been made to the HIN Register, EntryProfile.UCASAPPID differs [exclude (not exists to exists) and (zeros to a valid code)]. Exclude records identified in EntryProfile.UCASAPPID.Exception.3 |
| EntryProfile.UCASAPPID | 3 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.UCASAPPID has changed from exists to not exists. |
| EntryProfile.WELBACC | 1 | Warning | Where a Year on Year link has been made to the HIN register, EntryProfile.WELBACC differs [exclude (not exists to exists) and (exists to not exists where most recent EntryProfile.DOMCILE not XI or most recent Course.COURSEAIM does not begin H, I, J, C)]. Exclude records identified in EntryProfile.WELBACC.Exception.2. |
| EntryProfile.WELBACC | 2 | Error | Where a Year on Year link has been made to the HIN Register and Instance.REDUCEDI on input=04, EntryProfile.WELBACC has changed from exists to not exists [exclude where most recent EntryProfile.DOMCILE not XI or most recent EntryProfile.DOMICILE does not begin H, I, J, C]. |
| EntryProfile.YRLLINST | 1 | Error | Where a Year on Year link has been made to the HIN register, EntryProfile.YRLLINST changed from known to unknown (9999) |
| EntryProfile.YRLLINST | 2 | Warning | Where a Year on Year link has been made to the HIN register, EntryProfile.YRLLINST differs [exclude (not exists to exists) and unknown(9999) to known) and (exists to not exists where most recent EntryProfile.ARTICLN not in 1, 2, 3, 4)]. Exclude records identified in EntryProfile.YRLLINST.Exception.1 and EntryProfile.YRLLINST.Exception.3. |
| EntryProfile.YRLLINST | 3 | Error | Where a Year on Year link has been made to the HIN register, and Instance.REDUCEDI on input=04, EntryProfile.YRLLINST has changed from exists to not exists [exclude where most recent EntryProfile.ARTICLN is not in 1, 2, 3, 4] |
| Instance.COMDATE | 1 | Error | Where a Year on Year link has been made to the HIN Register, when Instance.COMDATE exists and is after start of reporting year |
| EntryProfile | 3 | Error | EntryProfile entity exists however the corresponding Instance with a previous year COMDATE has not been previously reported (i.e. cannot be found on the HIN Register) |
| Instance.NUMHUS | 2 | Error | No year-on-year link in incoming data for an instance that was 'live' last year i.e appeared on the HIN Target List |
| Instance.NUMHUS | 3 | Error | Year on year link exists but incoming instance links to a SAS instance (TTCID = 'E') on the HIN Register |
| Instance.NUMHUS | 4 | Warning | Year on year link exists but incoming instance links to a previously wholly overseas instance (LOCSDY = '7') on the HIN Register |
| Instance.PHDSUB | 1 | Error | Where a Year on Year link has been made to the HIN Register, Instance.PHDSUB differs [exclude not exists to exists]. |
| QaulificationsOnEntry | 2 | Warning | Where a Year on Year link has been made to the HIN Register, QualificationsOnEntry total tariff score is lower [exclude unknown to known]. |
| QaulificationsOnEntry | 3 | Warning | Where a Year on Year link has been made to the HIN Register, QualificationsOnEntry total tariff score is higher [exclude unknown to known]. |
| Instance.RCSTDNT | 1 | Error | Where a Year on Year link has been made to the HIN Register, when Instance.RCSTDNT has changed from Research Council to not Research Council student (99) |
| Student.BIRTHDTE | 1 | Error | Where a Year on Year link has been made to the HIN Register, when Student.BIRTHDTE changed from known to unknown (ReasonForNull = 1) value |
| Student.BIRTHDTE | 2 | Warning | Where a Year on Year link has been made to the HIN Register, Student.BIRTHDTE differs (exclude unknown (9999-12-31 or null) to known value changes. Exclude records identified in Student.BIRTHDTE.Exception.1 |
| Student.ETHNIC | 2 | Error | Where a Year on Year link has been made to the HIN Register, when Student.ETHNIC exists and it has changed from known to unknown (90) value |
| Student.ETHNIC | 3 | Warning | Where a Year on Year link has been made to the HIN Register, when Student.ETHNIC exists and it differs (exclude records identified in Student.ETHNIC Exception.2 and unknown (90) to known value, and information refused (98) to known value, and codes 11, 12, 13 and 19 changing to 10, and for institutions not in NI exclude codes changing from 14 to 10) and (exists to not exists where most recent EntryProfile.DOMICILE not in XF, XG, XH, XI, XK, XL, GG, JE, IM)) |
| Student.GENDER | 1 | Warning | Where a Year on Year link has been made to the HIN Register, Student.GENDER differs |
| Student.SURNAME | 1 | Warning | Where a Year on Year link has been made to the HIN Register, when Student.GENDER = '1' and Student name differs NAMECAT (Concatenation of Student.SURNAME and Student.FNAMES) |
Validation Checks at COMMIT
| Course.COURSEAIM | 2 | Error | Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where (first character of Course.COURSEAIM = D, E, L, M, H, I, J or C and second and third characters of Course.COURSEAIM are not 90 or 99) and Instance.MODE= 01, 23, 24, 52 or 53 and Instance.ENDDATE is blank and the sum of all Instance.STULOAD for the Student.HUSID is greater than 125.0 |
| Course.COURSEAIM | 3 | Warning | Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where Course.COURSEAIM = C90, H90, I90, J90, D90, E90, L90, M90, C99, H99, I99, J99, L99 or M99 and Instance.MODE = 01, 23, 24, 52 or 53 and Instance.ENDDATE is blank and the sum of all Instance.STULOAD for the Student.HUSID is greater than 125.0 |
| Course.COURSEAIM | 4 | Warning | Multiple occurrences of Course.COURSEAIM appear for a single Student.HUSID where (first character of Course.COURSEAIM = D, E, L, M, H, I, J or C and second and third characters of Course.COURSEAIM are not 90 or 99) and Instance.MODE is not 01, 23, 24, 52, 53, 63 or 64 and Instance.ENDDATE is blank |
| Course.COURSEID | 1 | Error | Course.COURSEID must be unique within an institution's return (ie all Course and CourseSubject entity data for a given COURSEID must be consistent) |
| Course.FEQAIMC | 1 | Warning | Course.FEQAIMC not found in Learning Aims Database (LAD) Qualifications database or not '66666666' where institution in England and Instance.FESTUMK = 1, 3 or 4 |
| Course.FEQAIMC | 2 | Error | Course.FEQAIMC must not exist for institutions in England or Wales where all Instance.FESTUMK = 2 |
| Course.FEQAIMC | 4 | Warning | Course.FEQAIMC not found in the Welsh Learning Aims Database (WLAD) or not ‘66666666’ where institution in Wales and Instance.FESTUMK = 1, 3 or 4. |
| Course.MSFUND | 2 | Error | Course.MSFUND codes 47, 62 - 64, 73 - 79, 83, 85 - 89, 92 - 99, AA, AB, AC and AD must have all Instance.FESTUMK = 1 or 4 |
| Course.REDUCEDC | 1 | Warning | If Course.REDUCEDC not equal 00 then all linked instances must have the same value in Instance.REDUCEDI |
| Course.REDUCEDC | 2 | Error | Course.REDUCEDC code 01 must have all occurrences of Instance.STULOAD less than or equal to 010.0 |
| Course.REDUCEDC | 3 | Error | Course.REDUCEDC code 03 must have all occurrences of Instance.EXCHANGE coded 1, 2, 3, 4 or 6 |
| Course.REDUCEDC | 4 | Error | Course.REDUCEDC code 04 must have all occurrences of Instance.MODE coded 63 or 64. |
| Course.SBJCA | 1 | Warning | More that 10% of instances where any CourseSubject.SBJCA = Y000 |
| Course.CourseSubject | 1 | Warning | CourseSubject entity must exist for all courses at institutions in England where Course.FEQAIMC exists and is not in the Learning Aims Database (LAD) |
| Course.CourseSubject | 2 | Warning | CourseSubject entity must exist for all courses at institutions in Wales where Course.FEQAIMC exists and is not in the Welsh Learning Aims Database (WLAD) |
| EntryProfile | 2 | Error | EntryProfile entity must exist where the corresponding Instance has not been previously reported (ie cannot be found on the Entry Profile Lookup Table) |
| EntryProfile.NEWENT | 1 | Warning | More than 500 students aged 18 or under with EntryProfile.NEWENT = A and Course.COURSEAIM begins D, E, L, M, H, I, J, or C |
| EntryProfile.POSTCODE | 1 | Error | Where exists, EntryProfile.POSTCODE must contain a valid full postcode or a valid outward part of a postcode |
| EntryProfile.POSTCODE | 4 | Error | More than 10 young (between 18 and 21), full-time, undergraduate students returned with identical EntryProfile.POSTCODE, where exists |
| EntryProfile.POSTCODE | 5 | Warning | More than 10 young (between 18 and 21), full-time, undergraduate students, not in own accommodation (Student.TTACCOM=1, 4, 8 or 9), have EntryProfile.POSTCODE = Student.TTPCODE (where EntryProfile.POSTCODE and Student.TTPCODE exist) |
| EntryProfile.POSTCODE | 6 | Warning | Where exists, EntryProfile.POSTCODE should be located in the country of EntryProfile.DOMICILE |
| EntryProfile.QUALENT2 | 4 | Error | More than 5% of instances at an institution in England where Instance.FUNDCODE = 1 and Instance.MODE in (01, 23, 24) and where exists in the incoming data EntryProfile.QUALENT2 = 99 |
| EntryProfile.QUALENT2 | 5 | Error | More than 20% of instances at an institution in England where Instance.FUNDCODE = 1 and Instance.MODE in (02, 25, 31) and where exists in the incoming data EntryProfile.QUALENT2 = 99 |
| EntryProfile.QUALENT2 | 6 | Warning | More than 5% of instances at an institution in Northern Ireland, Scotland or Wales where Instance.FUNDCODE = 1 and Instance.MODE in (01, 23, 24) and where exists in the incoming data EntryProfile.QUALENT2 = 99 |
| EntryProfile.QUALENT2 | 7 | Warning | More than 20% of instances at an institution in Northern Ireland, Scotland or Wales where Instance.FUNDCODE = 1 and Instance.MODE in (02, 25, 31) and where exists in the incoming data EntryProfile.QUALENT2 = 99 |
| EntryProfile.UCASAPPID | 1 | Error | More than 20% of instances where Instance.COMDATE is in the current reporting period and Instance.MODE is in (01, 23, 24) and Course.COURSEAIM (begins H, I, J, C or is M22) and EntryProfile.DOMICILE is in (XK, XF, XI, XH, XG and EntryProfile.UCASAPPID does not exist |
| Instance.CAMPID | 1 | Error | Instance.CAMPID must contain a valid character 1 - 9, A - Z and have been submitted in the Campus Information System |
| Instance.COMDATE | 2 | Error | More than 100 instances at an Institution in England where Instance.MODE in (02, 25, 31, 74) have Instance.COMDATE earlier than (Y1-7)-07-31. |
| Instance.COMDATE | 3 | Error | More than 50 instances at an Institution in England where (Instance.MODE = 01, 23, 24) have Instance.COMDATE earlier than (Y1-5)-07-31 |
| Instance.COMDATE | 4 | Warning | More than 100 instances at an Institution in Northern Ireland, Scotland or Wales where Instance.MODE in (02, 25, 31, 74) have Instance.COMDATE earlier than (Y1-7)-07-31 |
| Instance.COMDATE | 5 | Warning | More than 50 instances at an Institution in Northern Ireland, Scotland or Wales where (Instance.MODE = 01, 23, 24) have Instance.COMDATE earlier than (Y1-7)-07-31 |
| Instance.DESTCOM | 1 | Warning | More than 10 students with an instance where Instance.DESTOCM = ZZ |
| Instance.DISALL | 1 | Error | Instance.DISALL code 4 must have an EntryProfile.DOMICILE (including those previously sent for the student) = GG, JE, XL, XK, IM, XF, XI, XH or XG |
| Instance.FEEELIG | 1 | Error | Instance.FEEELIG must be coded 2 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = IM, XL, GG or JE unless Instance.FESTUMK = 1 or 3 |
| Instance.FUNDCODE | 1 | Error | More than 500 instances where institution in England, Wales or Northern Ireland and Instance.FUNDCODE coded 1 where ( EntryProfile.DOMICILE exists and is not in (XK, XL, GG, JE, IM, XF, XI, XH, XG, AT, BE, XA, CZ, DK, FI, FR, DE, GI, GR, HU, IE, IT, LU, MT, NL, PL, PT, ES, SE, ZZ, AA, EE, LV, LT, SI, SK, RO, BG)) |
| Instance.FUNDLEV | 2 | Warning | If any Instance.FUNDLEV = 10 or 11 for a Course.COURSEID then Instance.FUNDLEV must be 10, 11 or 99 for all other instances for the same Course.COURSEID |
| Instance.FUNDLEV | 1 | Warning | If any Instance.FUNDLEV = 20 or 21 for a Course.COURSEID then Instance.FUNDLEV must be 20, 21 or 99 for all other instances for the same Course.COURSEID |
| Instance.FUNDLEV | 3 | Warning | If any Instance.FUNDLEV = 30 or 31 for a Course.COURSEID then Instance.FUNDLEV must be 30, 31 or 99 for all other instances for the same Course.COURSEID |
| Instance.INSTCAMP | 1 | Error | Instance.INSTCAMP must exist and contain a valid full postcode or a valid outward postcode for institutions in Wales where Course.COURSEAIM is coded X41 to X46 |
| Instance.MODE | 1 | Warning | More than 6 students with an instance where Instance.MODE = 51 |
| Instance.MSTUFEE | 1 | Warning | Instance.MSTUFEE should not be coded 02, 04, 52 or 54 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = XH |
| Instance.MSTUFEE | 2 | Warning | Instance.MSTUFEE should not be coded 02, 03, 52, 53 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = XG |
| Instance.MSTUFEE | 3 | Warning | Instance.MSTUFEE should not be coded 03, 04, 53 or 54 where the corresponding EntryProfile.DOMICILE (including those previously sent for the student) = XF or XI |
| Instance.NUMHUS | 1 | Error | All Instance.NUMUHS for a Student.HUSID must be unique |
| Instance.QTS | 1 | Error | Instance.QTS cannot be coded 4 where the corresponding EntryProfile.QUALENT2 (including those previously sent) = 03 or 10 |
| Instance.QTS | 2 | Error | Instance.QTS cannot be coded 3 where the corresponding EntryProfile.QUALENT2 (including those previously sent) = 04, 37 - 98 |
| Instance.RSNEND | 1 | Error | More than 20% of instances where Instance.RSNEND does not exist where QualificationsAwarded.QUAL exists. |
| Instance.StudentOnModule | 1 | Warning | More than 40 StudentOnModule entity occurrences for this instance |
| Institution.INSTAPP | 1 | Error | Institution.INSTAPP must be consistent within an institution's return |
| Module.MODID | 1 | Error | Module.MODID must be unique within an institution's return |
| Module.TINST | 1 | Error | Module.TINST must = 4001, 4002, 4003 or 4004 where all linked Instance.FROUTARR = 01 - 80 |
| Module.TINST | 2 | Warning | Where Module.TINST exists more that 10% are coded 4001 |
| ModuleSubject.MODSBJ | 1 | Error | Where (first character of Course.COURSEAIM = D, E, L, M, H, I, J or C and second and third characters of Course.COURSEAIM are not 90 or 99) and Instance.MODE = 01, 23, 24, 52 or 53 and a student instance is attached to a single module then at least one ModuleSubject.MODSBJ must contain a code in the same JACS Subject Area as at least one of the CourseSubject.SBJCA codes |
| QualificationsAwarded.QUAL | 1 | Warning | Multiple identical occurrences of QualificationsAwarded.QUAL appear for a single Student.HUSID where (first character of QualificationsAwarded.QUAL = D, E, L, M and second and third characters of QualificationsAwarded.QUAL are not 90) |
| QualificationsAwarded.QUAL | 4 | Warning | Multiple identical occurrences of QualificationsAwarded.QUAL appear for a single Student.HUSID where (first character of QualificationsAwarded.QUAL = H, I, J or C and second and third characters of QualificationsAwarded.QUAL are not 90) |
| QualificationsAwarded.TQGSUB | 1 | Error | If QualificationsAwarded.TQGSUB is coded 360 for more than 10 records then fail |
| QualificationsOnEntry | 1 | Error | More than 50% of instances where Instance.COMDATE is in the current reporting year and EntryProfile.UCASAPPID exists and EntryProfile.DOMICILE in (XK, XF, XI, XH, XG) and Instance.MODE is in (01, 23, 24) and (EntryProfile.QUALENT2 exists and is coded 39 or 40) with no QualificationsOnEntry entity |
| QualificationsOnEntry | 4 | Error | Multiple indentical qualifications on entry for this instance, ie. QualificationsOnEntry.QUALTYPE, QualificationsOnEntry.QUALSBJ, QualificationsOnEntry.QUALGRADE, QualificationsOnEntry.QUALYEAR and QualificationsOnEntry.QUALSIT all occur more than once |
| QualificationsOnEntry.QUALGRADE | 1 | Error | More than 10% QualificationsOnEntry records with no QualificationsOnEntry.QUALGRADE |
| QualificationsOnEntry.QUALYEAR | 1 | Error | Where Student.BIRTHDTE is not null and more than 10 students (Student.HUSID) where at least one QualificationsOnEntry.QUALYEAR for QualificationsOnEntry.QUALTYPE other than SS is not greater than (Student.BIRTHDTE + 15) year |
| Student.ETHNIC | 1 | Error | Student.ETHNIC must exist where any EntryProfile.DOMICILE (including those previously sent for the student) = XF, XG, XH, XI, XK, XL, GG, JE or IM and the corresponding Instance.REDUCEDI = 00 or 01 |
| Student.GENDER | 2 | Error | More than 1 student where Student.GENDER = 9 |
| Student.HUSID | 1 | Error | Student.HUSID must be unique within an institution's return (i.e. all student entity data for the given HUSID must be consistent) |
| Student.HUSID | 2 | Warning | Multiple occurrences of Student.BIRTHDTE, Student.GENDER, soundex (Student.SURNAME) and soundex (Student.FNAMES), with different Student.HUSIDs |
| Student.NATION | 1 | Error | Student.NATION code XC must have Instance.COMDATE before 2007-08-01 unless EntryProfile.UCASAPPID exists. |
| Student.NATIOND | 1 | Error | Student.NATIOND must exist where Welsh institution and any EntryProfile.DOMICILE (including those previously sent for the student) = XH and the corresponding Instance.REDUCEDI = 00 or 02 |
| Student.SCN | 1 | Error | Student.SCN must exist where any EntryProfile.DOMICILE (including those previously sent for the student) = XH and the corresponding EntryProfile.UCASAPPID exists and Course.COURSEAIM begins H, I, J, C, P, Q, R or S |
| Student.SCN | 2 | Error | Student.SCN must exist where Scottish institution and any EntryProfile.DOMICILE (including those previously sent for the student) = XH and Course.COURSEAIM begins H, I, J, C, P, Q, R or S |
| Student.TTPCODE | 1 | Warning | More than 50 young (between 18 and 21), full-time, undergraduate students, at parental home (Student.TTACCOM=2), have EntryProfile.TTPCODE (where exists) not equal to EntryProfile.POSTCODE |
| Student.TTPCODE | 2 | Warning | More than 150 students have the same Student.TTPCODE (where exists) and do not have Student.TTACCOM = 1 or 9 |
| Student.TTPCODE | 3 | Error | More than 600 students have the same Student.TTPCODE (where exists) and do not have Student.TTACCOM = 1 or 9 |
| Student.TTPCODE | 4 | Warning | Where exists, Student.TTPCODE should contain a valid full postcode or a valid outward part of a postcode |
| Student.TTPCODE | 5 | Error | Where exists Student.TTPCODE must not equal EntryProfile.POSTCODE where Student.TTACCOM = 1 or 9 |
| Student.TTPCODE | 6 | Warning | Where exists Student.TTPCODE should not equal EntryProfile.POSTCODE where Student.TTACCOM = 8 |
| Student.TTPCODE | 7 | Error | Student.TTPCODE must not be in Northern Ireland, Channel Islands or Isle of Man where institution is in England, Scotland or Wales and Instance.MODE is in (01, 12, 23, 24, 73) |
| Student.UCASPERID | 2 | Error | Student.UCASPERID must exist where any EntryProfile.UCASAPPID (including those previously sent for the student) exists and is a 4 character code. |
| Student.WELSSP | 1 | Error | Student.WELSSP must exist for institutions in Wales and any EntryProfile.DOMICILE (including those previously sent for the student) = XI and the corresponding Instance.REDUCEDI = 00 |
Contact Liaison by email or on +44 (0)1242 388 531.