Destinations of Leavers from Higher Education record 2013/14
Summary of business rules
Version 1.1 Produced 2014-10-07
The business rules below have been updated for the 2013/14 collection.
Entity Name | Field Name | Severity | Description | 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 | PREVEM | WARNING | Employment.PREVEM 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.PREVEM does not exist or is coded 4. | 2 |
Employment | PREVWORK | WARNING | Employment.PREVWORK should exist where Employment.PREVEM = 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 |
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 | 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 providers in Scotland where Teaching.EMPLDTEACH = 1 and Student.STATUS = 01, 02 or 04. | 1 |
Teaching | GTCSTIS | ERROR | Teaching.GTCSTIS must not exist for providers 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.