COMMIT-stage validation
Destinations of Leavers from Higher Education (DLHE) Collection 2008/09
COMMIT-stage validation
Version 1.0 Produced 2010-02-08
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 |
If the incorrect INSTID is used in the file, raise an error | 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'. Raise an error if it is not | 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'. Raise an error if it is not | TCHEMP must be '9' as this is NOT an ITT student |
| 18012 |
If multiple occurrences of the same HUSID where APRJAN is coded '1', then raise an error | Multiple occurrences of HUSID in April survey |
| 18013 |
If multiple occurrences of the same HUSID where APRJAN is coded '2', then raise an error | Multiple occurrences of HUSID in January survey |
| 18015 | Where there is only one occurrence of HUSID in DLHE and XPDLHE01 is coded '3' in DLHE, 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' in DLHE, 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' in DLHE, 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' in DLHE, and there are no matching HUSID and INSTID with XPDLHE01 coded '1' in Cyy051, then no more than one survey can be returned | 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'. Raise a warning if it is | 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'. Raise a warning if it is not. | 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). If 10 or more records are returned with any of these codes, raise a warning | 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_09NOV. If it does not, raise a warning | Full postcode should be valid |
| 18011 |
Where XPDLHE01 is coded '1' in DLHE and LOCEMP contains an outward part only, as appears in OUTPC_LOOKUP_09NOV, then raise a warning |
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 |
| 18019 |
Where XPDLHE01 is coded '1' in DLHE and EMPCIR is coded '01', MODSTUDY should NOT be coded '1'. Raise a warning if it is | MODSTUDY should not be '1' when EMPCIR is coded '01' |
