Skip to main content

Destinations of Leavers from Higher Education record 2013/14

Back to C13018

COMMIT-stage rules


Version 1.0 Produced 2015-02-27

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

Entity Name Field Name Severity Description Number
Employment EMPCOUNTRY 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. 1
Employment EMPPCODE 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 thatpostcode is provided for those in UK employment. 1
Employment EMPPCODE 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. 2
Employment EMPPCODE WARNING Where exists Employment.EMPPCODE should contain a valid full postcode or a valid outward part of a postcode. 3
Employment ESTEARN 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. 1
Employment JOBFOUND 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. 1
Employment JOBRSNALL 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. 1
Employment JOBSNO 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. 1
Employment PREVEM WARNING More than 80% of leavers in the DLHE population where Employment entity exists and Student.STATUS=02 have not returned Employment.PREVEM. Please check that the question is being asked of the leaver over the telephone. 1
Employment POSTDOC 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. 1
Employment POSTDOC 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? 2
Employment PTHOURS 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. 1
Employment QUALREQ 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. 1
Employment SALARY 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. 1
Employment SALARY WARNING Employment.SALARY is less than £11,000 for leavers in employment where no occurrence of Employment.ALLACT=2 or PTHOURS does not exist and Employment.EMPBASIS=03,04 or 05 and employment is in the UK, Channel Islands or Isle of Man. Please check this is correct. 2
Employment SALARY WARNING Employment.SALARY is less than £7,000 for leavers in employment where (no occurrence of Employment.ALLACT=1 or Employment.PTHOURS exists) and where Employment.EMPBASIS=03,04 or 05 and employment is in the UK, Channel Islands or Isle of Man. Please check this is correct. 3
Employment SALARY 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. 4
Employment SALARY ERROR For all instances where any occurrence of Student.ALLACT = 1 or 2 there are no Employment.SALARY. 5
Employment SALARY ERROR If any occurrence of Student.ALLACT = 1 then at least half of the leavers must have an Employment.SALARY (exclude where Employment.EMPBASIS = 01, 02, 06 or 08). 6
Employment SALARY WARNING Where Student.ALLACT = 1 or 2 and Employment.SALARY is between £1 and £999 (inclusive). Salaries should be rounded to the nearest thousand (£). Please check this is correct. 8
Employment SOCDLHE2010 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. 1
Employment SOCDLHE2010 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. 2
Student ALLACT 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. 1
Student ALLACT WARNING There are 4 or more occurrences of Student.ALLACT. Please check that this is correct. 2
Student ALLACT WARNING Where Student.ALLACT is coded 1 or 2, Student.ALLACT is also coded 9. It is not expected that a leaver will be working and unemployed. 3
Student ALLACT WARNING Where Student.ALLACT is coded 1 or 2, Student.ALLACT is also coded 7. It is not expected that a leaver will be working and taking time out in order to travel. 4
Student APRJAN 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. 1
Student APRJAN 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. 2
Student HUSID ERROR Student.HUSID must not occur twice in the DLHE return as this student only has one instance in the DLHE population. 1
Student HUSID 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. 2
Student HUSID ERROR There must not be multiple occurrences of the same Student.HUSID with Student.APRJAN = 1 (April survey). 3
Student HUSID ERROR There must not be multiple occurrences of the same Student.HUSID with Student.APRJAN = 2 (January survey). 4
Student MIMPACT WARNING Student.MIMPACT should not be coded 9 where Student.ALLACT = 1 or 2. 1
Student STATUS ERROR More than 10% of records have been returned with Student.STATUS = 05 or 06. 1
Student Teaching ERROR Where the instance is in the DLHE population, Student.Teaching must exist where Cyy051.Course.TTCID = 1, 8, G, H, L, M, N or P and Student.STATUS is not equal to 07 or 08 as the leaver's qualification gave them newly qualified teacher status. 1
Student Teaching ERROR Where the instance is in the DLHE population, Student.Teaching must not exist where Cyy051.Course.TTCID is not equal to 1, 8, G, H, L, M, N or P as the leaver's qualification did not give them newly qualified teacher status. 2
Study JACS 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. 1
Study JACS 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. 2
Study STUDYFUND 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. 1
Study TYPEQUAL 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. 1
Study TYPEQUAL 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. 2
Study UCNAME 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. 1

Contact Liaison by email or on +44 (0)1242 388 531.