Skip to main content

KIS record 2014/15

Back to C14061

KIS record 2014/15

COMMIT-stage validation


return to index

Version 1.3 Produced 2015-01-30

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.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.ASSURL 1 Error Where KISCourse.ASSURL exists, more than 30% of courses have an identical KISCourse.ASSURL. Applies only where more than 10 KIS courses have KISCourse.ASSURL returned.
KISCourse.CourseStage 1 Error Where KISCourse.KISTYPE = 1 or 3 and the level of the course is First Degree the number of Course Stages returned must be 2 or more. Add 1 to the number of stages expected where KISCourse.SANDWICH = 2, also add 1 to the number of stages expected where KISCourse.FOUNDATION = 2.
KISCourse.CourseStage 2 Error Where KISCourse.KISTYPE = 1 or 3 and the level of the course is Other Undergraduate the number of Course Stages returned must be 1 or more. Add 1 to the number of stages expected where KISCourse.SANDWICH = 2, also add 1 to the number of stages expected where KISCourse.FOUNDATION = 2.
KISCourse.CRSEURL 1 Error Where KISCourse.CRSEURL exists, more than 30% of courses have an identical KISCourse.CRSEURL. Applies only where more than 10 KIS courses have KISCourse.CRSEURL returned.
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.HESACourse 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.HESACourse 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.HESACourse when mapped to a qualification level, should also be enhanced first degree.
KISCourse.KISAIM 5 Warning Where KISCourse.KISAIM is coded 030 - 036 or 130 then all the linked KISCourse.HESACourse 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.HESACourse 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.HESACourse and KISCourse.ILRAims should have full time students in the tables.
KISCourse.KISMODE 2 Warning Where KISCourse.KISMODE = 2 all the linked KISCourse.HESACourse 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 provider.
KISCourse.KISTYPE 2 Error Where KISCourse.KISTYPE = 3 then the combination of KISCourse.JACSL2, KISCourse.LEVEL, KISCourse.KISMODE and KISCourse.TEACHUKPRN must be unique within the KIS file returned.
KISCourse.KISTYPE 3 Error Where KISCourse.KISTYPE equals 1 or 2 more than one KIS Course found with matching KISCourse.TITLE, KISCourse.KISAIM, KISCourse.FOUNDATION, KISCourse.SANDWICH, KISCourse.YEARABROAD, (teaching provider UKPRN (where KIS submitted on their behalf) or Institution.UKPRN), CourseLocation.LOCID and KISCourse.KISMODE (treat KISCourse.KISMODE = 3 as matching both KISCourse.KISMODE = 1 and 2).
KISCourse.KISTYPE 4 Error Where there are more than 8 KISTYPE=1 courses then at least 66% of them must have either a HESACourse and / or ILRAims entity associated with them.
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.LTURL 1 Error Where KISCourse.LTURL exists, more than 30% of courses have an identical KISCourse.LTURL. Applies only where more than 10 KIS courses have KISCourse.LTURL returned.
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 CourseLocation.LOCID from the related KIS must equal one of the CourseLocation.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 sub-string of KISCourse.TITLE (case insensitive).
KISCourse.TITLE 2 Error A KISAIM label must not exist as a substring at the start of KISCourse.TITLE.
KISCourse.UCASPROGID 1 Warning Where KISCourse.UCASPROGID and CourseLocation.UCASCOURSEID exist within a KIS Course they should exist as a pair in the latest UCAS lookup file.
KISCourse.UCASPROGID 2 Error More than 5% of KISCourse.UCASPROGID and CourseLocation.UCASCOURSEID pairs returned do not exist in the latest UCAS lookup file.
KISCourse.UCASPROGID 3 Warning Where KISCourse.UCASPROGID exists, it should exist for that KISCourse.UKPRNAPPLY, teaching provider UKPRN (where KIS submitted on their behalf) or Institution.UKPRN in the latest UCAS lookup file.
Location.LONGITUDE 1 Error Locations must be at least 1 kilometre apart.

Contact Liaison by email or on +44 (0)1242 388 531.