Skip to main content

HESA Student record 2010/11

Back to C10051

HESA Student record 2010/11

HIN validation


return to index

Version 1.0 Produced 2011-07-29

This document lists the 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 (using XLEV301) has changed.
Course.COURSEID 1 Warning Where a Year on Year link has been made to the HIN register, more than 10% of instances where Course.COURSEID differs (exclude not exists to exists).
Course.FEQAIMC 1 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 or most recent EntryProfile.QUALENT3 is coded X00 or X01) and (exists to not exists where most recent EntryProfile.QUALENT2 exists and is not coded 44 or 45 or most recent EntryProfile.QUALENT3 exists and is not coded X00 or X01)].
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, M26, H00, H11, H16, H18, H22, H23, H24, I00, I11, I16))]. Exclude records identified in EntryProfile.ARTICLN.HIN.1
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, using XDOM01.
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, using XDOM01.
EntryProfile.DOMICILE 3 Warning Where a Year on Year link has been made to the HIN Register, when EntryProfile.DOMICILE differs based on XDOM01 [exclude records identified in EntryProfile.DOMICILE.HIN.1 and EntryProfile.DOMICILE.HIN.2 and changes from XC to XA or XB, and 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)].
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)).
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, M26, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20, C30) or ( Instance.REDUCEDI on input = 06 or 07))]. Exclude records identified in EntryProfile.PARED.HIN.1.
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 EntryProfile.PGCECLSS.HIN.1
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.HIN.1.
EntryProfile.POSTCODE 1 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 2 Warning Where a Year on Year link has been made to the HIN Register, EntryProfile.POSTCODE differs [exclude unknown (POSTCODE ReasonForNull="1") to known value, outward postcode to full valid postcode, exists to not exists where most recent EntryProfile.DOMICILE not in (XF, XG, XH, XI, XK, XL, GG, JE or IM) and records identified in EntryProfile.POSTCODE.HIN.1]
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, M26, H00, H11, H16, H18, H22, H23, I00, I11, I16, J10, J16, J20, J26, J30, C20, C30) or ( Instance.REDUCEDI on input = 06 or 07))]. Exclude records identified in EntryProfile.PREVINST.HIN.2.
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.QUALENT2 1 Error Where a Year on Year link has been made to the HIN Register, when EntryProfile.QUALENT2 (using XQUALENT01) where it 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 (using XQUALENT01) where it exists, differs [exclude records identified in EntryProfile.QUALENT2.HIN.1 and unknown (99) to known value].
EntryProfile.QUALENT3 1 Error Where a Year on Year link has been made to the HIN Register, when EntryProfile.QUALENT3 (using XQUALENT01) where it exists, has changed from known to unknown value.
EntryProfile.QUALENT3 2 Warning Where a Year on Year link has been made to the HIN Register, when EntryProfile.QUALENT3 (using XQUALENT01) where it exists, differs [exclude records identified in EntryProfile.QUALENT3.HIN.1 and unknown to known value].
EntryProfile.QualificationsOnEntry 1 Warning Where a Year on Year link has been made to the HIN Register, QualificationsOnEntry total tariff score is lower [exclude unknown to known].
EntryProfile.QualificationsOnEntry 2 Warning Where a Year on Year link has been made to the HIN Register, QualificationsOnEntry total tariff score is higher [exclude unknown to known].
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.HIN.1
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, M26) or ( Instance.REDUCEDI on input = 06 or 07 ))]. Exclude records identified in EntryProfile.SEC.HIN.1.
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), information refused (0001) 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), information refused (0001) 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 in M22 or M26) or ( Instance.REDUCEDI on input = 06 or 07 )))]. Exclude records identified in EntryProfile.SOC2000.HIN.1.
EntryProfile.UCASAPPID 1 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) and (exists to not exists where Instance.REDUCEDI on input = 06 or 07)].
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.DOMICILE not XI) or (most recent Course.COURSEAIM does not begin H, I, J, C) or ( Instance.REDUCEDI on input = 06 or 07 ))].
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.HIN.1.
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.
Instance.EntryProfile 1 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.EXCHANGE 1 Warning Where a year on year link has been made to the HIN Register and Instance.LOCSDY has changed from studying abroad (S) to at institution (X), where Instance.EXCHANGE is not coded as mainly overseas (Z).
Instance.FUNDCODE 1 Warning Where a year on year link has been made to the HIN Register and Instance.LOCSDY has changed from studying abroad (S) to distance Learning (6), where Instance.FUNDCODE has changed from no funds (2, 3 or 4) to fundable by funding council (1).
Instance.NUMHUS 1 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 2 Error Year on year link exists but the incoming instance is not for a SAS course ( Course.TTCID not equal to E ) and links to an instance on the HIN Register that is a SAS course (TTCID = E)
Instance.NUMHUS 3 Warning Year on year link exists but incoming instance links to a previously wholly overseas instance (LOCSDY = 7) on the HIN register and the student is not currently studying abroad ( Instance.LOCSDY not equal to S ).
Instance.NUMHUS 4 Error Year on year link exists but the incoming SAS instance ( Course.TTCID = E ) links to an instance on the HIN Register that is not for a SAS course (TTCID not equal to E)
Instance.NUMHUS 5 Error Year on year link exists but the incoming SKE instance ( Course.TTCID = F ) links to an instance on the HIN Register that is not for a SKE course (TTCID not equal to A, B, C or F)
Instance.NUMHUS 6 Error Year on year link exists but the incoming instance is not for an SKE course ( Course.TTCID not equal to F ) and links to an instance on the HIN Register that is an SKE course (TTCID = A, B, C or F)
Instance.NUMHUS 7 Error Year on year link exists but the incoming SAS instance ( Course.TTCID = E ) links to an instance on the HIN Register that is for a SAS course ( TTCID= E ) that is more than 2 years old
Instance.NUMHUS 8 Error Year on year link exists but the incoming SKE instance ( Course.TTCID = F ) links to an instance on the HIN Register that is for a SKE course ( TTCID = A, B, C or F ) that is more than 2 years old
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].
Instance.RCSTDNT 1 Error Where a Year on Year link has been made to the HIN Register, when Instance.RCSTDNT has changed from a specific 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.HIN.1.
Student.ETHNIC 1 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 2 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.HIN.1 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). Exclude exists to not exists where Instance.REDUCEDI on input = 06 or 07.

Contact Liaison by email or on +44 (0)1242 388 531.