Skip to main content

Destinations of Leavers from Higher Education record 2011/12

Back to C11018

Destinations of Leavers from Higher Education record 2011/12

Summary of business rules


return to index

Version 1.3 Produced 2013-03-25

The business rules below are a first release for the 2011/12 DLHE record, accounting for the change in structure to an XML-based collection.

Entity Field Name Status Rule Number
Employment EMPBASIS ERROR Employment.EMPBASIS must not be coded 99 when Student.STATUS = 01, 02 or 04. 1
Employment EMPCOUNTRY ERROR Employment.EMPCOUNTRY must exist where Employment.EMPPCODE does not exist. 1
Employment EMPIMP WARNING Employment.EMPIMP must not exist where Employment.QUALREQ does not exist or where it is coded 13 or 14. 1
Employment EMPIMP WARNING Employment.EMPIMP should exist where Employment.QUALREQ = 11 or 12 and Student.STATUS = 01, 02 or 04. 2
Employment EMPPCODE ERROR Employment.EMPPCODE must exist where Employment.EMPCOUNTRY does not exist. 1
Employment EMPPCODE ERROR Employment.EMPPCODE must contain a valid full postcode structure or a valid outward postcode structure. 2
Employment EMPPCODE ERROR Employment.EMPPCODE must not exist where Employment.EMPCOUNTRY is not in (XF, XG, XH, XI, XK, XL, GG, JE or IM). 3
Employment EMPUNPAID ERROR Employment.EMPUNPAID must not exist where Employment.SALARY exists. 1
Employment EMPUNPAID WARNING Employment.EMPUNPAID should not exist where Employment.EMPBASIS is coded 01, 02, 03, 04 or 05 and Student.STATUS = 01, 02 or 04. 2
Employment ESTEARN WARNING Employment.ESTEARN should not exist if Employment.JOBSNO does not exist. 1
Employment ESTEARN WARNING Employment.ESTEARN should exist if Employment.JOBSNO exists and Student.STATUS = 01, 02 or 04. 2
Employment ESTEARN ERROR Employment.ESTEARN must be greater than or equal to Employment.SALARY. 3
Employment JOBDUTIES ERROR Employment.JOBDUTIES must exist where Employment.JOBTITLE does not exist. 1
Employment JOBFOUND WARNING Employment.JOBFOUND should exist where Student.STATUS = 01, 02 or 04. 1
Employment JOBRSNALL ERROR Where there is more than one occurrence of Employment.JOBRSNALL, each value must be unique. 1
Employment JOBRSNALL WARNING Employment.JOBRSNALL should exist where Student.STATUS = 01,02 or 04. 2
Employment JOBRSNMAIN ERROR The code in Employment.JOBRSNMAIN must be equal to that in one of the occurrences of Employment.JOBRSNALL. 1
Employment JOBTITLE ERROR Employment.JOBTITLE must exist where Employment.JOBDUTIES does not exist. 1
Employment PREVEMP WARNING Employment.PREVEMP should exist where Student.STATUS = 01, 02 or 04. 1
Employment PREVWORK ERROR Where there is more than one occurrence of Employment.PREVWORK, each value must be unique. 1
Employment PREVWORK ERROR Employment.PREVWORK must not exist where Employment.PREVEMP does not exist or is coded 4. 2
Employment PREVWORK WARNING Employment.PREVWORK should exist where Employment.PREVEMP = 1, 2 or 3 and Student.STATUS = 01, 02 or 04. 3
Employment PTHOURS ERROR Employment.PTHOURS must not exist where no occurrence of Student.ALLACT = 2. 1
Employment PTHOURS ERROR Employment.PTHOURS must not be greater than 40 as this is higher than the number of hours normally classed as full-time. 2
Employment PTHOURS WARNING Employment.PTHOURS should exist if any occurrence of Student.ALLACT = 2 and Student.STATUS = 01, 02 or 04 and Student.MIMPACT not equal to 1. 3
Employment QUALREQ WARNING Employment.QUALREQ should exist where Student.STATUS = 01, 02 or 04. 1
Employment SALARY ERROR Employment.SALARY must not exist where Employment.EMPUNPAID exists. 1
Employment SALARY WARNING Employment.SALARY is greater than zero where Employment.EMPBASIS = 06 (voluntary work). 2
Institution UKPRN ERROR Institution.UKPRN must be the same as that for the submitting institution. 1
Student ALLACT ERROR Student.ALLACT must be coded X where Student.STATUS is coded 07 or 08. 1
Student ALLACT ERROR Student.ALLACT must not be coded X where Student.STATUS is coded 01 to 06. 2
Student ALLACT ERROR Where Student.ALLACT = X there must be only one occurrence of Student.ALLACT. 3
Student ALLACT ERROR Where there is more than one occurrence of Student.ALLACT, each value must be unique. 4
Student Employment ERROR Employment entity must exist if any occurrence of Student.ALLACT is coded 1 or 2. 1
Student Employment ERROR Employment must not exist if none of the occurrences of Student.ALLACT are coded 1 or 2. 2
Student HEBUSNEXP ERROR Student.HEBUSNEXP must be coded 6 where Student.STATUS = 03, 05, 06, 07 and 08. 1
Student HESTUDYEXP ERROR Student.HESTUDYEXP must be coded 6 where Student.STATUS = 03, 05, 06, 07 and 08. 1
Student HEWORKEXP ERROR Student.HEWORKEXP must be coded 6 where Student.STATUS = 03, 05, 06, 07 and 08. 1
Student HUSID ERROR Student.HUSID must not contain all zeroes. 1
Student HUSID ERROR Student.HUSID must pass checksum test given in the Student coding manual. 2
Student MIMPACT ERROR Student.MIMPACT must be coded X where Student.STATUS is coded 07 or 08. 1
Student MIMPACT ERROR Student.MIMPACT must not be coded X where Student.STATUS is coded 01 to 06. 2
Student MIMPACT ERROR The code in Student.MIMPACT must be equal to that in one of the occurrences of Student.ALLACT. 3
Student Study ERROR Study entity must exist if any occurrence of Student.ALLACT is coded 5 or 6. 1
Student Study ERROR Study entity must not exist if no occurrence of Student.ALLACT is coded 5 or 6. 2
Student Teaching ERROR Teaching entity must not exist where Student.STATUS is coded 07 or 08. 1
Study COURSENAME ERROR Study.COURSENAME must exist where Study.SUBJECT does not exist. 1
Study STUDYFUND WARNING Study.STUDYFUND should exist where Student.STATUS = 01, 02 or 04. 1
Study SUBJECT ERROR Study.SUBJECT must exist where Study.COURSENAME does not exist. 1
Study TYPEQUAL WARNING Study.TYPEQUAL should exist where Student.STATUS = 01, 02 or 04. 1
Study UCNAME WARNING Study.UCNAME should exist where Study.UCPROV = 1, 2, 3, 4 or 5 and Student.STATUS = 01, 02 or 04. 1
Study UCPROV WARNING Study.UCPROV should exist where Student.STATUS = 01, 02 or 04 and Study.UCNAME exists. 1
Teaching GTCSTIS WARNING Teaching.GTCSTIS should exist for institutions in Scotland where Teaching.EMPLDTEACH = 1 and Student.STATUS = 01, 02 or 04. 1
Teaching GTCSTIS ERROR Teaching.GTCSTIS must not exist for institutions in England, Northern Ireland and Wales. 2
Teaching SEEKTEACH ERROR Teaching.SEEKTEACH must exist where Teaching.EMPLDTEACH = 2 and Student.STATUS = 01, 02 or 04. 1
Teaching TEACHFUND ERROR Teaching.TEACHFUND must not exist where Teaching.EMPLDTEACH = 2. 1
Teaching TEACHFUND WARNING Teaching.TEACHFUND should exist where Teaching.EMPLDTEACH = 1 and Student.STATUS = 01, 02 or 04. 2
Teaching TEACHPHS ERROR Teaching.TEACHPHS must not exist where Teaching.EMPLDTEACH = 2. 1
Teaching TEACHPHS WARNING Teaching.TEACHPHS should exist where Teaching.EMPLDTEACH = 1 and Student.STATUS = 01, 02 or 04. 2

Contact Liaison by email or on 01242 211144.