Skip to main content

Destinations of Leavers from Higher Education record 2013/14

Back to C13018

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.