KIS record 2013/14
KIS record 2013/14COMMIT-stage validation |
return to index |
Version 1.4 Produced 2013-07-31
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 |
---|---|---|---|
Accreditation.ACCTYPE | 1 | Error | Accreditation.ACCTYPE must exist in the list of accrediting bodies and types. |
HESACourse.HESACOURSEID | 1 | Error | (HESACourse.JOINTUKPRN or HESACourse.REGUKPRN or Institution.UKPRN) combined with HESACourse.HESACOURSEID and HESACourse.TEACHUKPRN (where it exists) must exist within the Course list for the year given in HESACourse.HESAYEAR. |
ILRAims.ILRAIMID | 1 | Error | (ILRAims.REGUKPRN or Institution.UKPRN) combined with ILRAims.ILRAIMID and ILRAims.TEACHUKPRN (where it exists) must exist within the Course list for the year given in ILRAims.ILRYEAR. |
Institution.OTHERINST | 1 | Warning | Institution.OTHERINST and Institution.UKPRN should exist as a Registering UKPRN/Teaching UKPRN pair in the Course list. |
KISCourse.DISTANCE | 1 | Error | Where KISCourse.DISTANCE = 1 all linked courses identified in KISCourse.HESACourse and KISCourse.ILRAims entities must be distance learning. |
KISCourse.ENGFEE | 1 | Error | KISCourse.ENGFEE must not be 0. |
KISCourse.HESACourse | 1 | Error | Where a single Institution.KISCourse is linked to multiple HESACourses/ILRAims, then when mapped to JACS level 3, the set of JACS codes for each KISCourse.HESACourse and KISCourse.ILRAims must be the same. |
KISCourse.HESACourse | 2 | Error | For each KISCourse with KISCourse.KISTYPE = 1 linked to a KISCourse.KISTYPE = 2, all KISCourse.HESACourse, KISCourse.ILRAims and KISCourse.JACS must have only one JACS Level 3 subject, and all of these level 3 subjects must be the same. |
KISCourse.HESACourse | 4 | Error | Where a single Institution.KISCourse is linked to multiple HESACourses/ILRAims and the KISCourse.KISCOURSEID has not been approved, then when mapped to JACS level 3, the set of JACS codes for each KISCourse.HESACourse and KISCourse.ILRAims must be the same. |
KISCourse.KISAIM | 1 | Error | Where KISCourse.KISAIM exists it must be a valid entry in the look up table. |
KISCourse.KISAIM | 2 | Error | Where KISCourse.KISAIM is at first degree level all the linked KISCourse.HESACourses and KISCourse.ILRAims, when mapped to a qualification level, must also be first degree. |
KISCourse.KISAIM | 3 | Error | Where KISCourse.KISAIM is at other undergraduate level all the linked KISCourse.HESACourses and KISCourse.ILRAims, when mapped to a qualification level, must also be other undergraduate. |
KISCourse.KISAIM | 4 | Warning | Where KISCourse.KISAIM is an enhanced first degree then all the linked KISCourse.HESACourses when mapped to a qualification level, should also be enhanced first degree. |
KISCourse.KISAIM | 5 | Warning | Where KISCourse.KISAIM is coded 030 - 036 then all the linked KISCourse.HESACourses and KISCourse.ILRAims, when mapped to a qualification level, should also be Foundation Degrees. |
KISCourse.KISAIM | 6 | Warning | Where KISCourse.KISAIM is 038 then all the linked KISCourse.HESACourses and KISCourse.ILRAims, when mapped to a qualification level, should also be HNDs. |
KISCourse.KISMODE | 1 | Warning | Where KISCourse.KISMODE = 1 all the linked KISCourse.HESACourses and KISCourse.ILRAims should have full time students in the tables. |
KISCourse.KISMODE | 2 | Warning | Where KISCourse.KISMODE = 2 all the linked KISCourse.HESACourses and KISCourse.ILRAims should have part time students in the tables. |
KISCourse.KISTYPE | 1 | Error | Where KISCourse.KISTYPE = 3 then the corresponding KISCourse.KISCOURSEID must exist at least once in the KISCourse.RELATEDKIS fields returned by the institution. |
KISCourse.KISTYPE | 2 | Error | Where KISCourse.KISTYPE = 3 then the combination of KISCourse.JACSL2, KISCourse.LEVEL, KISCourse.KISMODE and KISCourse.TEACHUKPRNs must be unique within the KIS file returned. |
KISCourse.LEVEL | 1 | Error | Where KISCourse.LEVEL = F, or KISCourse.KISAIM maps to level F, all related KISCourse.KISTYPE 2 records must have a KISCourse.KISAIM which maps to first degree. |
KISCourse.LEVEL | 2 | Error | Where KISCourse.LEVEL = U, or KISCourse.KISAIM maps to level U, all related KISCourse.KISTYPE 2 records must have a KISCourse.KISAIM which maps to other undergraduate. |
KISCourse.NUMSTAGE | 1 | Error | KISCourse.NUMSTAGE must exist where KISCourse.KISTYPE = 2 and KISCourse.RELATEDKIS.KISTYPE = 3. |
KISCourse.NUMSTAGE | 2 | Error | KISCourse.NUMSTAGE must not exist where KISCourse.KISTYPE = 2 and KISCourse.RELATEDKIS.KISTYPE = 1. |
KISCourse.RELATEDKIS | 1 | Error | KISCourse.RELATEDKIS must exist as a KISCourse.KISCOURSEID within the file. |
KISCourse.RELATEDKIS | 2 | Error | All KISCourse.RELATEDKIS must be of the same KISCourse.KISTYPE within a KIS course |
KISCourse.RELATEDKIS | 3 | Error | KISCourse.KISTYPE must equal 1 or 3 where the KISCourse.KISCOURSEID is referenced in any KISCourse.RELATEDKIS. |
KISCourse.RELATEDKIS | 4 | Error | Where KISCourse.RELATEDKIS exists and links to KISCourse.KISTYPE = 1 then KISCourse.UKPRNAPPLY from the related KIS must equal the KISCourse.UKPRNAPPLY from the current KISCourse. |
KISCourse.RELATEDKIS | 5 | Error | Where KISCourse.RELATEDKIS exists and links to KISCourse.KISTYPE = 1 then KISCourse.LOCID from the related KIS must equal one of the KISCourse.LOCID from the current KISCourse. |
KISCourse.RELATEDKIS | 6 | Error | Where KISCourse.RELATEDKIS exists and KISCourse.TEACHUKPRN exists then all (KISCourse.TEACHUKPRN, HESACourse.TEACHUKPRN or ILRAims.TEACHUKPRN) from the related KIS must be referenced in KISCourse.TEACHUKPRN from the current KISCourse. |
KISCourse.RELATEDKIS | 7 | Error | Where KISCourse.RELATEDKIS exists and KISCourse.TEACHUKPRN does not exist then (KISCourse.TEACHUKPRN, HESACourse.TEACHUKPRN and ILRAims.TEACHUKPRN) must not exist in any of the related KIS referenced from the current KISCourse. |
KISCourse.RELATEDKIS | 8 | Error | Where KISCourse.RELATEDKIS exists and KISCourse.TEACHUKPRN exists then KISCourse.TEACHUKPRN must be referenced in the related (KISCourse.TEACHUKPRN, HESACourse.TEACHUKPRN or ILRAims.TEACHUKPRN). |
KISCourse.TITLE | 1 | Warning | None of the entries in the labels of KISAIM should exist as a substring of KISCourse.TITLE (case insensitive). |
KISCourse.UCASCOURSEID | 1 | Error | Where KISCourse.UCASCOURSEID exists for an institution with UKPRN not equal to 10007773, it must exist for that KISCourse.UKPRNAPPLY, teaching institution UKPRN (where KIS submitted on their behalf) or Institution.UKPRN in the latest UCAS lookup file. |
KISCourse.UCASCOURSEID | 2 | Warning | No KISCourse.UCASCOURSEID fields have been returned in the KIS file. KISCourse.UKPRNAPPLY, teaching institution UKPRN (where KIS submitted on their behalf) or Institution.UKPRN has data supplied in the UCAS fee file. Where an Institution uses UCAS the fee data must be provided via the UCAS website. |
KISCourse.UCASCOURSEID | 3 | Error | Where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file then UCAS FEETBC must exist and must equal 0 or 1. |
KISCourse.UCASCOURSEID | 4 | Error | Where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file and UCAS FEETBC = 1 then all the UCAS fields ENGFEE, NIFEE, SCOTFEE, WALFEE, VARFEE, WAIVER, MEANSSUP and OTHSUP must exist and must not be null. |
KISCourse.UCASCOURSEID | 5 | Error | Where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file and UCAS FEETBC = 1 then UCAS ENGFEE must be between 0 and 9000 inclusive. |
KISCourse.UCASCOURSEID | 6 | Error | Where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file and UCAS FEETBC = 1 then UCAS ENGFEE must not be 0. |
KISCourse.UCASCOURSEID | 7 | Error | Where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file and UCAS FEETBC = 1 then UCAS NIFEE must be between 1 and 9000 inclusive. |
KISCourse.UCASCOURSEID | 8 | Error | Where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file and UCAS FEETBC = 1 then UCAS WALFEE must be between 1 and 9000 inclusive. |
KISCourse.UCASCOURSEID | 9 | Error | For non-Scottish institutions, where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file and UCAS FEETBC = 1 then UCAS SCOTFEE must be between 1 and 9000 inclusive. |
KISCourse.UCASCOURSEID | 10 | Error | For Scottish institutions, where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file and UCAS FEETBC = 1 then UCAS SCOTFEE must be between 0 and 9000 inclusive. |
KISCourse.UCASCOURSEID | 11 | Error | Where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file and UCAS FEETBC = 1 and UCAS VARFEE = 11 or 21 then UCAS ENGFEE must be less than 9000. |
KISCourse.UCASCOURSEID | 12 | Error | Where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file and UCAS FEETBC = 1 and KISCourse.YEARABROAD = 2 then UCAS VARFEE must equal 11 or 21. |
KISCourse.UCASCOURSEID | 13 | Error | Where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file and KISCourse.SANDWICH = 2 then, where they exist, all UCAS ENGFEE, NIFEE, SCOTFEE and WAFEE must be less than 9000. |
KISCourse.UCASCOURSEID | 14 | Error | Where a corresponding record exists for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID and KISCourse.KISCOURSEID where applicable) in the UCAS file and UCAS FEETBC = 1 and KISCourse.SANDWICH = 2 then UCAS VARFEE must equal 11 or 21. |
KISCourse.UCASCOURSEID | 15 | Error | Where more than one corresponding record exists in the latest UCAS file for (KISCourse.UKPRNAPPLY/teaching institution UKPRN/Institution.UKPRN combined with KISCourse.UCASCOURSEID) and a unique UCAS KISCOURSEID is not supplied, then all the UCAS fee fields in those records must be consistent. |
Location.LONGITUDE | 1 | Error | Locations must be at least 1 kilometre apart. |
Contact Liaison by email or on +44 (0)1242 388 531.