KIS record 2014/15
KIS record 2014/15COMMIT-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.