# KIS collection 2013/14

## KIS collection 2013/14## Summary of business rules |
return to index |

Version 1.5 Produced 2013-08-20

Entity | Field or Entity Name | Status | Rule | Number |
---|---|---|---|---|

Accreditation | ACCDEPENDURL | Error | Accreditation.ACCDEPENDURL must exist where Accreditation.ACCDEPEND = 1 | 1 |

Accreditation | ACCDEPENDURL | Error | Accreditation.ACCDEPENDURL must not exist where Accreditation.ACCDEPEND = 0 | 2 |

Accreditation | ACCDEPENDURLW | Error | Accreditation.ACCDEPENDURLW must not exist where Accreditation.ACCDEPEND = 0 | 1 |

Accreditation | ACCDEPENDURLW | Error | Accreditation.ACCDEPENDURLW must not exist where institution is not in Wales | 2 |

CourseStage | STAGE | Error | CourseStage.STAGE fields must be consecutive within a KISCourse.CourseStage entity | 1 |

CourseStage | STAGE | Error | CourseStage.STAGE field must be unique within a KISCourse.CourseStage entity | 2 |

HESACourse | HESACOURSEID | Error | The combination of HESACourse.HESACOURSEID, HESACourse.HESAYEAR, HESACourse.REGUKPRN, HESACourse.TEACHUKPRN and HESACourse.JOINTUKPRN must be unique within a KIS course. | 1 |

HESACourse | HESAYEAR | Warning | Within a KISCourse, where (HESACourse.HESAYEAR = Y1 minus 4 or HESACourse.HESAYEAR = Y1 minus 2) exists then either (HESACourse.HESAYEAR = Y1 minus 3 or ILRAims.ILRYEAR = Y1 minus 3) should exist. | 1 |

HESACourse | HESAYEAR | Warning | Within a KISCourse where either KISCourse.HESACourse or KISCourse.ILRAims entities exist, either (HESACourse.HESAYEAR = Y1 minus 2 or ILRAims.ILRYEAR = Y1 minus 2) should exist. | 2 |

HESACourse | REGUKPRN | Error | HESACourse.REGUKPRN must exist in Institution.OTHERINST. | 1 |

HESACourse | REGUKPRN | Error | HESACourse.REGUKPRN must not equal Institution.UKPRN. | 2 |

HESACourse | REGUKPRN | Error | HESACourse.REGUKPRN and HESACourse.TEACHUKPRN must not both exist | 3 |

HESACourse | REGUKPRN | Error | If Institution.UKPRN is an FEC and HESACourse entity exists then HESACourse.REGUKPRN must exist. | 4 |

HESACourse | TEACHUKPRN | Error | HESACourse.TEACHUKPRN must not equal Institution.UKPRN. | 1 |

HESACourse | TEACHUKPRN | Error | HESACourse.TEACHUKPRN must be a valid UKPRN. | 2 |

ILRAims | ILRAIMID | Error | The combination of ILRAims.ILRAIMID, ILRAims.ILRYEAR, ILRAims.REGUKPRN and ILRAims.TEACHUKPRN combination must be unique within a KIS course | 1 |

ILRAims | ILRYEAR | Warning | Within a KISCourse, where (ILRAims.ILRYEAR = Y1 minus 4 or ILRAims.ILRYEAR = Y1 minus 2) exists then either (HESACourse.HESAYEAR = Y1 minus 3 or ILRAims.ILRYEAR = Y1 minus 3) should exist. | 1 |

ILRAims | REGUKPRN | Error | ILRAims.REGUKPRN must exist in Institution.OTHERINST. | 1 |

ILRAims | REGUKPRN | Error | ILRAims.REGUKPRN must not equal Institution.UKPRN. | 2 |

ILRAims | REGUKPRN | Error | ILRAims.REGUKPRN and ILRAims.TEACHUKPRN must not both exist | 3 |

ILRAims | REGUKPRN | Error | If Institution.UKPRN is an HEI and ILRAims entity exists then ILRAims.REGUKPRN must exist | 4 |

ILRAims | TEACHUKPRN | Error | ILRAims.TEACHUKPRN must not equal Institution.UKPRN. | 1 |

ILRAims | TEACHUKPRN | Error | ILRAims.TEACHUKPRN must be a valid UKPRN. | 2 |

Institution | NSP | Error | Institution.NSP must exist for institutions in England | 1 |

Institution | NSP | Error | Institution.NSP cannot exist for institutions in Wales, Scotland or Northern Ireland | 2 |

Institution | OTHERINST | Error | Institution.OTHERINST must not equal Institution.UKPRN. | 1 |

Institution | OTHERINST | Error | Institution.OTHERINST must be a valid UKPRN. | 2 |

Institution | OTHERINST | Error | Where there is more than one occurrence of Institution.OTHERINST each value must be unique. | 3 |

Institution | SUURLW | Error | Institutions outside of Wales cannot return Institution.SUURLW. | 1 |

Institution | UKPRN | Error | Institution.UKPRN must be valid | 1 |

KISCourse | HESACourse | Error | KISCourse.KISTYPE 2 and 3 courses cannot contain KISCourse.HESACourse entities | 1 |

KISCourse | HESACourse | Warning | It is expected that HEIs would return a HESACourse entity where KISCourse.KISTYPE = 1 and KISCourse.JACS does not exist. | 3 |

KISCourse | ILRAims | Error | KISCourse.KISTYPE 2 and 3 courses cannot contain KISCourse.ILRAims entities | 1 |

KISCourse | CourseStage | Error | KISCourse.KISTYPE 2 courses cannot contain KISCourse.CourseStage entities | 1 |

KISCourse | CourseStage | Error | CourseStage.WRITTEN, CourseStage.COURSEWORK and CourseStage.PRACTICAL fields must sum to 100 or 0 within any KISCourse.CourseStage entity | 2 |

KISCourse | CourseStage | Error | CourseStage.SCHEDULED, CourseStage.INDEPENDENT and CourseStage.PLACEMENT fields must sum to 100 within any KISCourse.CourseStage entity | 3 |

KISCourse | CourseStage | Error | KISCourse.KISTYPE 1 or KISCourse.KISTYPE 3 courses must contain KISCourse.CourseStage entities | 4 |

KISCourse | CourseStage | Error | Only one KISCourse.CourseStage entity has been returned. | 5 |

KISCourse | CourseStage | Error | The sum of CourseStage.WRITTEN, CourseStage.PRACTICAL and CourseStage.COURSEWORK for at least one CourseStage within a KISCourse must not be zero. | 6 |

KISCourse | Accreditation | Error | KISCourse.KISTYPE 3 courses cannot contain KISCourse.Accreditation entities | 1 |

KISCourse | ASSURL | Error | KISCourse.KISTYPE 2 courses must not contain KISCourse.ASSURL | 1 |

KISCourse | ASSURL | Error | KISCourse.KISTYPE 1 and 3 courses must contain KISCourse.ASSURL | 2 |

KISCourse | ASSURLW | Error | KISCourse.KISTYPE 2 courses must not contain KISCourse.ASSURLW | 1 |

KISCourse | ASSURLW | Error | Institutions outside of Wales cannot return KISCourse.ASSURLW | 2 |

KISCourse | CRSEURL | Error | KISCourse.KISTYPE 1 and 2 courses must contain KISCourse.CRSEURL | 1 |

KISCourse | CRSEURLW | Error | KISCourse.CRSEURLW can only exist at Welsh institutions | 1 |

KISCourse | DISTANCE | Error | Where KISCourse.KISTYPE = 1 or 2 KISCourse.DISTANCE must exist. | 1 |

KISCourse | DISTANCE | Error | Where KISCourse.KISTYPE = 3 KISCourse.DISTANCE must not exist. | 2 |

KISCourse | EMPLOYURL | Error | KISCourse.KISTYPE 2 courses must not contain KISCourse.EMPLOYURL | 1 |

KISCourse | EMPLOYURL | Error | KISCourse.KISTYPE 1 and 3 courses must contain KISCourse.EMPLOYURL | 2 |

KISCourse | EMPLOYURLW | Error | KISCourse.KISTYPE 2 courses must not contain KISCourse.EMPLOYURLW | 1 |

KISCourse | EMPLOYURLW | Error | Institutions outside of Wales cannot return KISCourse.EMPLOYURLW | 2 |

KISCourse | ENGFEE | Error | Courses where KISCourse.FEETBC=1 must contain KISCourse.ENGFEE | 2 |

KISCourse | ENGFEE | Error | Value of KISCourse.ENGFEE must be between 0 and 9000 inclusive. | 3 |

KISCourse | ENGFEE | Warning | KISCourse.ENGFEE has been returned with a value of 0 | 5 |

KISCourse | FEETBC | Error | Where KISCourse.KISTYPE = 1 or 2 and KISCourse.UCASCOURSEID does not exist KISCourse.FEETBC must exist. | 1 |

KISCourse | FEETBC | Error | KISCourse.FEETBC must equal 1 when any of the following exist: KISCourse.ENGFEE, KISCourse.NIFEE, KISCourse.WAFEE, KISCourse.SCOTFEE or KISCourse.VARFEE. | 2 |

KISCourse | FEETBC | Error | Where KISCourse.UCASCOURSEID exists then KISCourse.FEETBC must not exist. | 3 |

KISCourse | FEETBC | Error | Where KISCourse.KISTYPE equals 3 then KISCourse.FEETBC must not exist. | 4 |

KISCourse | FEETBC | Error | Where any of the fields KISCourse.WAIVER, KISCourse.MEANSSUP or KISCourse.OTHSUP exists then KISCourse.FEETBC must exist. | 5 |

KISCourse | FEETBC | Error | Where Institution.UKPRN is equal to 10007773 and KISCourse.KISTYPE = 1 or 2 then KISCourse.FEETBC must exist. | 6 |

KISCourse | FOUNDATION | Error | KISCourse.FOUNDATION must exist where KISCourse.KISTYPE = 1 or 2. | 1 |

KISCourse | FOUNDATION | Error | KISCourse. FOUNDATION must not exist where KISCourse.KISTYPE = 3. | 2 |

KISCourse | HONOURS | Error | KISCourse.HONOURS must not exist where KISCourse.KISTYPE = 3. | 1 |

KISCourse | HONOURS | Error | KISCourse.HONOURS must exist where KISCourse.KISTYPE = 1 or 2. | 2 |

KISCourse | HONOURS | Error | KISCourse.HONOURS must equal 0 where KISCourse.KISAIM = 028-038, 080, 126 or 130. | 3 |

KISCourse | JACS | Error | KISCourse.KISTYPE 1 courses where none of (KISCourse.HESACourse entity, KISCourse.ILRAims entity and KISCourse.LDCS) exist must have a KISCourse.JACS field | 1 |

KISCourse | JACS | Error | KISCourse.KISTYPE 2 and 3 courses cannot contain a KISCourse.JACS field | 2 |

KISCourse | JACS | Error | Where either KISCourse.HESACourse entity or KISCourse.ILRAims entity are returned KISCourse.JACS must not exist. | 3 |

KISCourse | JACS | Error | English FECs cannot return a KISCourse.JACS field | 4 |

KISCourse | JACS | Error | Welsh FECs must return either KISCourse.LDCS or KISCourse.JACS for KISCourse.KISTYPE 1 courses where no (KISCourse.ILRAims or KISCourse.HESACourse) entities exist | 5 |

KISCourse | JACSL2 | Error | KISCourse.KISTYPE 3 courses must contain a KISCourse.JACSL2 field | 1 |

KISCourse | JACSL2 | Error | Only KISCourse.KISTYPE 3 courses can contain a KISCourse.JACSL2 field | 2 |

KISCourse | KISAIM | Error | KISCourse.KISAIM must not exist where KISCourse.KISTYPE = 3. | 1 |

KISCourse | KISAIM | Error | KISCourse.KISAIM must exist where KISCourse.KISTYPE = 1 or 2. | 2 |

KISCourse | KISAIM | Warning | KISCourse.KISAIM codes 040 and 076 (MA and MSc) should only be returned for an undergraduate degree where the normal entry requirements are A-levels, Highers or equivalent. Courses where the normal entry requirements are a degree must not have a KIS returned. | 3 |

KISCourse | KISTYPE | Error | Where KISCourse.KISTYPE = 3 then the corresponding KISCourse.KISCOURSEID must exist at least once in the KISCourse.RELATEDKIS fields returned by the institution. | 1 |

KISCourse | KISTYPE | 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. | 2 |

KISCourse | LDCS | Error | Where KISCourse.KISTYPE = 1 and institution is an FEC in England and no (KISCourse.ILRAims or KISCourse.HESACourse) entities exist then KISCourse.LDCS must exist. | 1 |

KISCourse | LDCS | Error | KISCourse.KISTYPE 2 and 3 courses cannot contain a KISCourse.LDCS field | 2 |

KISCourse | LDCS | Error | Where either KISCourse.ILRAims entity or KISCourse.HESACourse entity are returned KISCourse.LDCS field must not exist. | 3 |

KISCourse | LDCS | Error | Only FECs can return a KISCourse.LDCS field | 4 |

KISCourse | LEVEL | Error | Where KISCourse.KISTYPE = 1 or 2 KISCourse.LEVEL must not exist. | 2 |

KISCourse | LEVEL | Error | KISCourse.KISTYPE 3 courses must contain a KISCourse.LEVEL field | 3 |

KISCourse | LOCCHNGE | Error | KISCourse.LOCCHNGE must exist where KISCourse.KISTYPE = 1 or 2 and KISCourse.DISTANCE = 0. | 1 |

KISCourse | LOCCHNGE | Error | KISCourse.LOCCHNGE must not exist where KISCourse.KISTYPE = 3. | 2 |

KISCourse | LOCCHNGE | Error | KISCourse.LOCCHNGE must not exist where KISCourse.DISTANCE = 1. | 3 |

KISCourse | LOCID | Error | KISCourse.LOCID must exist where KISCourse.DISTANCE equals 0. | 1 |

KISCourse | LOCID | Error | KISCourse.LOCID must be a value in Location.LOCID | 2 |

KISCourse | LOCID | Error | KISCourse.LOCID must not exist where KISCourse.KISTYPE equals 3. | 3 |

KISCourse | LOCID | Error | KISCourse.LOCID must not exist where KISCourse.DISTANCE equals 1. | 4 |

KISCourse | LTURL | Error | KISCourse.KISTYPE 2 courses must not contain KISCourse.LTURL | 1 |

KISCourse | LTURL | Error | KISCourse.KISTYPE 1 and 3 courses must contain KISCourse.LTURL | 2 |

KISCourse | LTURLW | Error | KISCourse.KISTYPE 2 courses must not contain KISCourse.LTURLW | 1 |

KISCourse | LTURLW | Error | Institutions outside of Wales cannot return KISCourse.LTURLW | 2 |

KISCourse | MEANSSUP | Error | Courses where KISCourse.FEETBC = 1 must contain KISCourse.MEANSSUP | 2 |

KISCourse | NHS | Error | KISCourse.NHS must exist where KISCourse.KISTYPE = 1 or 2 and no (KISCourse.HESACourse or KISCourse.ILRAims) entities exist. | 1 |

KISCourse | NHS | Error | KISCourse.NHS must not exist where KISCourse.KISTYPE = 3. | 2 |

KISCourse | NHS | Error | KISCourse.NHS must not exist where (KISCourse.HESACourse or KISCourse.ILRAims) entities exist | 3 |

KISCourse | NIFEE | Error | Courses where KISCourse.FEETBC=1 must contain a KISCourse.NIFEE field | 2 |

KISCourse | NIFEE | Error | Value of KISCourse.NIFEE must be between 1 and 9000 inclusive. | 3 |

KISCourse | NONCREDITASSESS | Error | Where KISCourse.KISTYPE = 1 or 2 KISCourse.NONCREDITASSESS must exist. | 1 |

KISCourse | NONCREDITASSESS | Error | Where KISCourse.KISTYPE = 3 KISCourse.NONCREDITASSESS must not exist. | 2 |

KISCourse | NUMSTAGE | Error | KISCourse.NUMSTAGE must exist where KISCourse.KISTYPE = 2 and KISCourse.RELATEDKIS.KISTYPE = 3. | 1 |

KISCourse | NUMSTAGE | Error | KISCourse.NUMSTAGE must not exist where KISCourse.KISTYPE = 1 or 3. | 2 |

KISCourse | NUMSTAGE | Error | KISCourse.NUMSTAGE must not exist where KISCourse.KISTYPE = 2 and KISCourse.RELATEDKIS.KISTYPE = 1. | 3 |

KISCourse | OTHSUP | Error | Courses where KISCourse.FEETBC = 1 must contain KISCourse.OTHSUP field | 2 |

KISCourse | RELATEDKIS | Error | KISCourse.KISTYPE 2 courses must contain a KISCourse.RELATEDKIS field | 1 |

KISCourse | RELATEDKIS | Error | KISCourse.KISTYPE 1 and 3 courses cannot contain a KISCourse.RELATEDKIS field | 2 |

KISCourse | RELATEDKIS | Error | KISCourse.RELATEDKIS must exist as a KISCourse.KISCOURSEID within the file | 3 |

KISCourse | RELATEDKIS | Error | All KISCourse.RELATEDKIS must be of the same KISCourse.KISTYPE within a KIS course | 4 |

KISCourse | RELATEDKIS | Error | KISCourse.KISTYPE must equal 1 or 3 where the KISCourse.KISCOURSEID is referenced in any KISCourse.RELATEDKIS. | 5 |

KISCourse | SANDWICH | Error | KISCourse.SANDWICH must exist where KISCourse.KISTYPE = 1 or 2. | 1 |

KISCourse | SANDWICH | Error | KISCourse.SANDWICH must not exist where KISCourse.KISTYPE = 3. | 2 |

KISCourse | SANDWICH | Error | Where KISCourse.SANDWICH = 2 then, where they exist, all KISCourse.ENGFEE, KISCourse.NIFEE, KISCourse.SCOTFEE and KISCourse.WAFEE must be less than 9000. | 3 |

KISCourse | SANDWICH | Error | Where KISCourse.SANDWICH = 2 then the sum of all CourseStage.PLACEMENT must be greater than 75 | 4 |

KISCourse | SANDWICH | Warning | Where KISCourse.SANDWICH = 2 then the sum of all CourseStage.PLACEMENT should be at least 100 | 5 |

KISCourse | SANDWICH | Error | Where KISCourse.SANDWICH = 2 and KISCourse.FEETBC = 1 then KISCourse.VARFEE must be 11 or 21 | 6 |

KISCourse | SANDWICH | Error | Where KISCourse.KISTYPE = 1 or 2 and KISCourse.KISMODE = 2 then KISCourse.SANDWICH must equal 0. | 8 |

KISCourse | SANDWICH | Error | Where KISCourse.KISTYPE = 1 or 2 and KISCourse.KISMODE = 3 then KISCourse.SANDWICH must equal 0 or 1. Separate full time and part time KISCourses should be returned to reflect the different codes of KISCourse.SANDWICH. | 9 |

KISCourse | SCOTFEE | Error | Courses where KISCourse.FEETBC=1 must contain a KISCourse.SCOTFEE field | 2 |

KISCourse | SCOTFEE | Error | Value of KISCourse.SCOTFEE must be between 1 and 9000 inclusive for non-Scottish institutions | 3 |

KISCourse | SCOTFEE | Error | Value of KISCourse.SCOTFEE must be between 0 and 9000 inclusive for Scottish institutions | 4 |

KISCourse | SUPPORTURL | Error | KISCourse.KISTYPE 3 courses must not contain KISCourse.SUPPORTURL | 1 |

KISCourse | SUPPORTURL | Error | KISCourse.KISTYPE 1 and 2 courses must contain KISCourse.SUPPORTURL | 2 |

KISCourse | SUPPORTURLW | Error | KISCourse.KISTYPE 3 courses must not contain KISCourse.SUPPORTURLW | 1 |

KISCourse | SUPPORTURLW | Error | Institutions outside of Wales cannot return KISCourse.SUPPORTURLW | 2 |

KISCourse | TEACHUKPRN | Warning | Where KISCourse.KISTYPE = 1 and (HESACourse entity or ILRAims entity) exist KISCourse.TEACHUKPRN should not exist. | 1 |

KISCourse | TEACHUKPRN | Error | Where KISCourse.KISTYPE = 3 then KISCourse.TEACHUKPRN must not exist more than once. | 2 |

KISCourse | TEACHUKPRN | Error | Where KISCourse.TEACHUKPRN equals Institution.UKPRN and no (HESACourse or ILRAims entities) exist then KISCourse.TEACHUKPRN must exist more than once. | 3 |

KISCourse | TEACHUKPRN | Error | KISCourse.TEACHUKPRN must be unique within the KISCourse entity. | 4 |

KISCourse | TEACHUKPRN | Error | KISCourse.TEACHUKPRN must be a valid UKPRN. | 5 |

KISCourse | TEACHUKPRN | Error | Where all KISCourse.TEACHUKPRN, HESACourse.TEACHUKPRN and ILRAims.TEACHUKPRN are the same within a KISCourse then that UKPRN must not exist in our list of KIS submitting institutions. | 6 |

KISCourse | TITLE | Error | Where KISCourse.KISTYPE equals 1 or 2 and KISCourse.KISAIM does not equal 039, 044, 045, 083, 085 and 086 KISCourse.TITLE must exist. | 1 |

KISCourse | TITLE | Error | KISCourse.KISTYPE 3 courses must not contain a KISCourse.TITLE | 2 |

KISCourse | TITLE | Error | KISCourse.TITLE must not be returned completely in upper case. | 3 |

KISCourse | TITLE | Warning | KISCourse.TITLE should not include the words HONS or HONOURS (case insensitive). | 4 |

KISCourse | TITLEW | Error | For institutions in Wales where KISCourse.KISTYPE equals 1 or 2 and KISCourse.KISAIM does not equal 039, 044, 045, 083, 085 and 086 KISCourse.TITLEW must exist. | 1 |

KISCourse | TITLEW | Error | KISCourse.KISTYPE 3 courses in Welsh institutions must not contain a KISCourse.TITLEW field | 2 |

KISCourse | TITLEW | Error | KISCourse.TITLEW cannot be returned by institutions outside of Wales | 3 |

KISCourse | TITLEW | Error | KISCourse.TITLEW must not be returned completely in upper case. | 4 |

KISCourse | TITLEW | Warning | Where KISCourse.TITLEW exists it should not be the same as KISCourse.TITLE. | 5 |

KISCourse | TTCID | Error | KISCourse.KISTYPE 1 courses where both KISCourse.HESACourse and KISCourse.ILRAim entities are missing must contain a KISCourse.TTCID field | 1 |

KISCourse | TTCID | Error | KISCourse.KISTYPE 2 and 3 courses cannot contain a KISCourse.TTCID field | 2 |

KISCourse | UCASCOURSEID | Error | KISCourse.KISTYPE 3 courses that are not Combined studies (KISCourse.JACSL2=41) cannot contain a KISCourse.UCASCOURSEID | 1 |

KISCourse | UCASCOURSEID | Warning | KISCourse.UCASCOURSEID should exist for those institutions supplying UCAS course data where KISCourse.KISTYPE = 1 or 2 and KISCourse.KISMODE = 1 or 3. | 2 |

KISCourse | UCASPROGID | Error | KISCourse.KISTYPE 3 courses that are not Combined studies (KISCourse.JACSL2=41) cannot contain a KISCourse.UCASPROGID | 1 |

KISCourse | UCASPROGID | Error | KISCourse.KISTYPE 2 courses cannot contain a KISCourse.UCASPROGID | 2 |

KISCourse | UKPRNAPPLY | Error | KISCourse.UKPRNAPPLY must not be equal to Institution.UKPRN | 1 |

KISCourse | UKPRNAPPLY | Error | KISCourse.UKPRNAPPLY must be a valid UKPRN | 2 |

KISCourse | VARFEE | Error | Courses where KISCourse.FEETBC=1 must contain a KISCourse.VARFEE field | 2 |

KISCourse | VARFEE | Error | Where KISCourse.VARFEE = 11 or 21 then KISCourse.ENGFEE must be less than 9000. | 3 |

KISCourse | WAFEE | Error | Courses where KISCourse.FEETBC=1 must contain a KISCourse.WAFEE field | 2 |

KISCourse | WAFEE | Error | Value of KISCourse.WAFEE must be between 1 and 9000 inclusive. | 3 |

KISCourse | WAIVER | Error | Courses where KISCourse.FEETBC = 1 must contain KISCourse.WAIVER field | 2 |

KISCourse | WELSH | Error | KISCourse.KISTYPE 1 and 3 courses at Welsh institutions must contain a KISCourse.WELSH field | 1 |

KISCourse | WELSH | Error | KISCourse.KISTYPE 2 courses at Welsh institutions must not contain a KISCourse.WELSH field | 2 |

KISCourse | WELSH | Error | Institutions outside of Wales must not contain a KISCourse.WELSH field | 3 |

KISCourse | YEARABROAD | Error | KISCourse.YEARABROAD must exist where KISCourse.KISTYPE = 1 or 2. | 1 |

KISCourse | YEARABROAD | Error | KISCourse. YEARABROAD must not exist where KISCourse.KISTYPE = 3. | 2 |

KISCourse | YEARABROAD | Error | Where KISCourse.YEARABROAD = 2 and KISCourse.FEETBC = 1 then KISCourse.VARFEE must equal 11 or 21. | 3 |

KISCourse | YEARABROAD | Error | Where KISCourse.KISTYPE = 1 or 2 and KISCourse.KISMODE = 2 then KISCourse.YEARABROAD must equal 0. | 4 |

KISCourse | YEARABROAD | Error | Where KISCourse.KISTYPE = 1 or 2 and KISCourse.KISMODE = 3 then KISCourse.YEARABROAD must equal 0 or 1. Separate full time and part time KISCourses should be returned to reflect the different codes of KISCourse.YEARABROAD. | 5 |

Location | ACCOMURLW | Error | Location.ACCOMURLW cannot exist if you are not a Welsh institution | 1 |

Location | INSTBEDS | Error | If Location.INSTBEDS exists then Location.INSTUPPER and Location.INSTLOWER must be returned | 1 |

Location | INSTBEDS | Error | If Location.INSTBEDS does not exist then both Location.INSTUPPER and Location.INSTLOWER must not be returned | 2 |

Location | INSTBEDS | Error | The value of Location.INSTBEDS must lie between 1 and 15000 | 3 |

Location | INSTLOWER | Error | The value of Location.INSTLOWER must lie between 1500 and 15000 | 1 |

Location | INSTUPPER | Error | Location.INSTUPPER must be greater than or equal to Location.INSTLOWER | 1 |

Location | INSTUPPER | Error | The value of Location.INSTUPPER must lie between 1500 and 15000 | 2 |

Location | LATITUDE | Error | Location.LATITUDE must be between 49.852 and 60.875 | 1 |

Location | LOCID | Error | Location.LOCID must be unique within an institution. | 1 |

Location | LOCNAME | Error | Location.LOCNAME must be unique within an institution. | 1 |

Location | LOCNAME | Error | Location.LOCNAME must not be returned completely in upper case. | 2 |

Location | LOCNAMEW | Error | Location.LOCNAMEW must not exist where institution is not in Wales. | 1 |

Location | LOCNAMEW | Error | Location.LOCNAMEW must be unique within an institution. | 2 |

Location | LOCNAMEW | Error | Location.LOCNAMEW must not be returned completely in upper case. | 3 |

Location | LOCNAMEW | Error | Where Location.LOCNAMEW exists it should not be the same as Location.LOCNAME. | 4 |

Location | LOCUKPRN | Warning | Location.LOCUKPRN should be a valid UKPRN. | 1 |

Location | LONGITUDE | Error | Location.LONGITUDE must be between -8.174 and 1.824. | 1 |

Location | PRIVATELOWER | Error | The value of Location.PRIVATELOWER must lie between 1500 and 15000 | 1 |

Location | PRIVATEUPPER | Error | Location.PRIVATEUPPER must be greater than or equal to Location.PRIVATELOWER | 1 |

Location | PRIVATEUPPER | Error | The value of Location.PRIVATEUPPER must lie between 1500 and 15000 | 2 |

Location | SUURLW | Error | Institutions outside of Wales cannot return Location.SUURLW. | 1 |

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