C07018 COMMIT-stage validation
HESA DLHE Collection 2007/08
Version 1.2 Produced 2009-04-22
This document lists the validation checks that will be applied during the COMMIT transaction of the data collection system. COMMIT-stage validation checks are only run once a COMMIT request has been received from the institution by the data collection system. These checks can only operate within a database-type environment and, therefore, cannot be included in the submission-level validation kits.
Validation errors
| Number |
Specification |
Text |
| 18001 |
The incorrect INSTID is used in the file | Incorrect INSTID in data |
| 18003 |
Where XPDLHE01 is coded '1' in DLHE and Cyy051.TTCID from student record is in '1' or '8' and METHOD from DLHE record is NOT coded '8' or '9', then TCHEMP from DLHE record must be coded either '1', '2' or '3' | TCHEMP must be '1', '2' or '3' as this is an ITT student |
| 18006 |
Where XPDLHE01 is coded '1' in DLHE and Cyy051.TTCID from student record is not in '1' or '8' and METHOD from DLHE record is NOT coded '8' or '9', then TCHEMP from DLHE record must be coded '9' | TCHEMP must be '9' as this is NOT an ITT student |
| 18012 |
Multiple occurrences of the same HUSID where APRJAN is coded '1' | Multiple occurrences of HUSID in April survey |
| 18013 |
Multiple occurrences of the same HUSID where APRJAN is coded '2' | Multiple occurrences of HUSID in January survey |
| 18015 | Where there is only one occurrence of HUSID in DLHE and XPDLHE01 is coded, and the count of instances matching HUSID and INSTID with XPDLHE01 coded '1' in Cyy051 is one, and APRJAN is coded '2', then APRJAN should be coded '1' | APRJAN should be '1' as instance ended between Y1-08-01 and Y1-12-31 |
| 18016 |
Where there is only one occurrence of HUSID in DLHE and XPDLHE01 is coded '3', and the count of instances matching HUSID and INSTID with XPDLHE01 coded '1' in Cyy051 is one, and APRJAN is coded '1', then APRJAN should be coded '2' | APRJAN should be '2' as instance ended between Y2-01-01 and Y2-07-31 |
| 18017 | Where there are two occurrences of HUSID in DLHE and for at least one of these XPDLHE01 is coded '3', and the count of instances matching HUSID and INSTID with XPDLHE01 coded '1' in Cyy051 is one, then the number of surveys returned must be one | Where a HUSID has only one instance in POPDLHE, only one survey response can be returned |
| 18018 |
Where there are two occurrences of HUSID in DLHE and for at least one of these XPDLHE01 is coded '3', and there are no matching HUSID and INSTID with XPDLHE01 coded '1' in Cyy051, then no more than one survey can be submitted |
Where a HUSID has only one instance in Student and it is not in POPDLHE, a maximum of one survey response can be returned |
Validation warnings
| Number |
Specification |
Text |
| 18007 |
Where XPDLHE01 is coded '1' in DLHE and XQMODE01 from the student record is coded '2' and METHOD from DLHE record is NOT coded '8' or '9', then INTENT from DLHE record should NOT be coded 'X' | INTENT should not be 'X' as this is a part-time leaver |
| 18008 |
Where XPDLHE01 is coded '1' in DLHE and XQMODE01 from the student record is NOT coded '2' and METHOD from DLHE record is NOT coded '8' or '9' then INTENT from DLHE record should be coded 'X' | INTENT should be 'X' as this is a full-time leaver |
| 18009 |
Where XPDLHE01 is coded '1' in DLHE no more than 9 records should be returned in any combination of the following: LOCEMP '1782' (country code not known), LOCEMP '5826' (England Unknown), LOCEMP '6826' (Wales Unknown), LOCEMP '7826' (Scotland Unknown) and LOCEMP '8826' (Northern Ireland Unknown) | 10 or more records returned as LOCEMP '1782' (country code not known), LOCEMP '5826' (England Unknown), LOCEMP '6826' (Wales Unknown), LOCEMP '7826' (Scotland Unknown) or LOCEMP '8826' (Northern Ireland Unknown) |
| 18010 |
Where XPDLHE01 is coded '1' in DLHE and LOCEMP contains a full postcode (i.e. outward plus inward) then this entry should appear in the table FULLPC_LOOKUP_08NOV | Full postcode should be valid |
| 18011 |
XPDLHE01 is coded '1' in DLHE and LOCEMP contains an outward part only, as appears in OUTPC_LOOKUP_08NOV | Only supplied outward part of postcode |
| 18014 |
Where XPDLHE01 is coded '1' in DLHE and EMPCIR from DLHE is coded '01', '02', '03' or '15' and METHOD from DHLE is NOT coded '3' or '4' and Cyy051_Instance.RCSTDNT is coded '01'-'09' then EMPNAME should not be 'XXXX' | EMPNAME should not be 'XXXX' when leaver was funded by a Research Council |
