Destinations of Leavers from Higher Education record 2013/14
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.