Skip to main content

KIS record 2013/14

Back to C13061

KIS record 2013/14

COMMIT-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.