Skip to main content

Destinations of Leavers from Higher Education record 2011/12

Back to C11018

COMMIT-stage validation


Version 1.1 Produced 2013-03-25

This document lists the COMMIT 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.

Validation Checks at COMMIT

Field Name Number Severity Rule
Employment.EMPCOUNTRY 1 Warning More than 10 respondents in the DLHE population have Employment.EMPCOUNTRY coded as ZZ (Not Known). Please check whether Employment.EMPCOUNTRY can be coded with a known value.
Employment.EMPPCODE 1 Warning Employment.EMPPCODE does not exist for more than 1% of leavers in the DLHE population where Employment.EMPCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM. It is asked that postcode is provided for those in UK employment.
Employment.EMPPCODE 2 Warning Only the outward part of the postcode has been returned in Employment.EMPPCODE for leavers in the DLHE population. Please check to see if a full postcode can be returned.
Employment.EMPPCODE 3 Warning Where exists Employment.EMPPCODE should contain a valid full postcode or a valid outward part of a postcode.
Employment.ESTEARN 1 Warning Employment.ESTEARN > 75000 for leavers in the DLHE population who are working in the UK, Channel Islands or Isle of Man. Please check this is correct.
Employment.JOBFOUND 1 Warning More than 80% of leavers in the DLHE population where Employment entity exists and Student.STATUS=02 have not returned Employment.JOBFOUND. Please check that the question is being asked of the leaver over the telephone.
Employment.JOBRSNALL 1 Warning More than 80% of leavers in the DLHE population where Employment entity exists and Student.STATUS=02 have not returned Employment.JOBRSNALL. Please check that the question is being asked of the leaver over the telephone.
Employment.JOBSNO 1 Warning Employment.JOBSNO is not expected to exist if any occurrence of Student.ALLACT is coded 1 but there is no occurrence of Student.ALLACT = 2. Please check the coding of Student.ALLACT as it implies that these leavers have more than 1 full-time job.
Employment.POSTDOC 1 Error Where the leaver is in the DLHE population, Employment.POSTDOC must exist where Cyy051.QualificationsAwarded.QUAL = D00, D01 or E00 (doctorates) and any occurrence of Student.ALLACT = 1 or 2 and Student.STATUS does not equal 8.
Employment.POSTDOC 2 Warning More than 10% of leavers in the DLHE population have Employment.POSTDOC coded 3 (Unable to code) who studied for a doctorate (Cyy051.QualificationsAwarded.QUAL = D00, D01 or E00). Please check whether this can be coded more accurately?
Employment.PREVEMP 1 Warning More than 80% of leavers in the DLHE population where Employment entity exists and Student.STATUS=02 have not returned Employment.PREVEMP. Please check that the question is being asked of the leaver over the telephone.
Employment.PTHOURS 1 Warning Employment.PTHOURS should not be greater than 35 hours for leavers in the DLHE population as this is the number of hours normally classified as full-time.
Employment.QUALREQ 1 Warning More than 80% of leavers in the DLHE population where Employment entity exists and Student.STATUS=02 have not returned Employment.QUALREQ. Please check that the question is being asked of the leaver over the telephone.
Employment.SALARY 1 Warning Where the leaver in the DLHE population is working in the UK, Channel Islands or Isle of Man, Employment.SALARY > 75000. Please check this is correct.
Employment.SALARY 2 Warning Employment.SALARY is less than £10,000 for leavers working full-time (no occurrence of Employment.ALLACT=2 or PTHOURS does not exist) where Employment.EMPBASIS=03,04 or 05 and employment is in the UK, Channel Islands or Isle of Man. Please check this is correct.
Employment.SALARY 3 Warning Employment.SALARY is less than £7,000 for leavers working part-time (no occurrence of Employment.ALLACT=1 or Employment.PTHOURS exists) where Employment.EMPBASIS=03,04 or 05 and employment is in the UK, Channel Islands or Isle of Man. Please check this is correct.
Employment.SALARY 4 Warning Employment.SALARY is less than £10,000 where Employment.EMPBASIS=03,04 or 05 and employment is outside of the UK, Channel Islands or Isle of Man . Please check this is correct.
Employment.SOCDLHE2010 1 Warning More than 1% of records in the DLHE population with Employment entity where Employment.SOCDLHE2010 = 00010 and Student.STATUS is coded 01, 02 or 04. Please check whether Employment.SOCDLHE2010 can be coded more accurately.
Employment.SOCDLHE2010 2 Warning More than 5% of records in the DLHE population where Employment.SOCDLHE2010 = 00010 and Student.STATUS is coded 03, 05 or 06. Please check whether Employment.SOCDLHE2010 can be coded more accurately.
Student.ALLACT 1 Warning Where Student.ALLACT is coded 1, Student.ALLACT is also coded 5. Please check this is correct as it may affect your KIS population.
Student.ALLACT 2 Warning There are 4 or more occurrences of Student.ALLACT. Please check that this is correct.
Student.ALLACT 3 Warning Where Student.ALLACT is coded 1 or 2, Student.ALLACT is also coded 3. It is not expected that a leaver will be working and unemployed.
Student.APRJAN 1 Error Student.APRJAN should be coded 1 (April) as the instance for which the qualification was awarded ended between Y1-08-01 and Y1-12-31.
Student.APRJAN 2 Error Student.APRJAN should be coded 2 (January) as the instance for which the qualification was awarded ended between Y2-01-01 and Y2-07-31.
Student.HUSID 1 Error Student.HUSID must not occur twice in the DLHE return as this student only has one instance in the DLHE population.
Student.HUSID 2 Error Student.HUSID must not occur twice in the DLHE return as this student only has one instance in the corresponding student return and it is not in the DLHE population.
Student.HUSID 3 Error There must not be multiple occurrences of the same Student.HUSID with Student.APRJAN = 1 (April survey).
Student.HUSID 4 Error There must not be multiple occurrences of the same Student.HUSID with Student.APRJAN = 2 (January survey).
Student.STATUS 1 Warning More than 2% of records in the DLHE population have been returned with Student.STATUS = 05 or 06.
Student.Teaching 1 Error Where the instance is in the DLHE population, Student.Teaching must exist where Cyy051.Course.TTCID = 1 or 8 and Student.STATUS is not equal to 07 or 08 as the leaver's qualification gave them newly qualified teacher status.
Student.Teaching 2 Error Where the instance is in the DLHE population, Student.Teaching must not exist where Cyy051.Course.TTCID is not equal to 1 or 8 as the leaver's qualification did not give them newly qualified teacher status.
Study.COURSENO 1 Warning Study.COURSENO is not expected to exist if any occurrence of Student.ALLACT is coded 5 but there is no occurrence of Student.ALLACT = 6. Please check the coding of Student.ALLACT as it implies that these leavers are taking more than 1 full-time course.
Study.JACS 1 Warning More than 5% of records in the DLHE population where Student.STATUS = 01, 02 or 04, Study entity exists and Study.JACS = 9999. Please check whether Study.JACS can be coded more accurately.
Study.JACS 2 Warning More than 10% of records in the DLHE population where Student.STATUS = 03, 05 or 06 and, Study entity exists with Study.JACS = 9999. Please check whether Study.JACS can be coded more accurately.
Study.STUDYFUND 1 Warning More than 80% of leavers in the DLHE population where Study entity exists and Student.STATUS=02 have not returned Study.STUDYFUND. Please check that the question is being asked of the leaver over the telephone.
Study.TYPEQUAL 1 Warning More than 80% of leavers in the DLHE population where Study entity exists and Student.STATUS=02 have not returned Study.TYPEQUAL. Please check that the question is being asked of the leaver over the telephone.
Study.TYPEQUAL 2 Warning More than 20 leavers in the DLHE population where Cyy051.XQMODE01 = 1 and Cyy051.XDLEV501 = 3 but Study.TYPEQUAL = 04. It is not expected that a leaver will be studying for another first-degree having previously gained a full-time first degree.
Study.UCNAME 1 Warning More than 80% of leavers in the DLHE population where Study.UCPROV=1-5 and Student.STATUS=02 have not returned Study.UCNAME. Please check that the question is being asked of the leaver over the telephone.

Contact Liaison by email or on 01242 211144.