Skip to main content

HESA Student Record 2008/09

Back to C08051

HESA Student Record 2008/09

Commit-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 01242 211144.