Destinations of Leavers from Higher Education record 2011/12
Summary of business rules
Version 1.2 Produced 2014-02-28
The business rules below are for the 2012/13 DLHE record.
| Entity | Field or Entity Name | Status | Rule | Number |
|---|---|---|---|---|
| Employment | EMPBASIS | Error | Employment.EMPBASIS must not be coded 99 when Student.STATUS = 02 or 04. | 1 |
| Employment | EMPBASIS | Warning | Employment.EMPBASIS should not be coded 99 when Student.STATUS = 01 | 2 |
| Employment | EMPCOUNTRY | Error | Employment.EMPCOUNTRY must exist where Employment.EMPPCODE does not exist. | 1 |
| Employment | EMPIMP | Warning | Employment.EMPIMP should 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 | EMPNAME | Warning | Where Employment.EMPNAME exists it should be greater than one character in length | 1 |
| 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 | JOBTITLE | Warning | Where Employment.JOBTITLE exists it should be greater than one character in length. | 2 |
| Employment | MAKEDO | Warning | Where Employment.MAKEDO exists it should be greater than one character in length. | 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 | 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 | 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 |
| 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 | 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 |
| Study | COURSENAME | Error | Study.COURSENAME must exist where Study.SUBJECT does not exist. | 1 |
| Study | JACS | Error | Where there is more than one occurrence of Study.JACS, each value must be unique | 2 |
| Study | JACS | Error | Where multiple occurrences of Study.JACS exists, and an occurrence does not equal 9999, then no other occurrence must equal 9999. | 3 |
| 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 | UCNAME | Warning | Where Study.UCNAME exists it should be greater than one character in length | 2 |
| 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 +44 (0)1242 388 531.