KIS collection 2012/13

Back to C12061

Summary of business rules

Version 1.5 Produced 2012-09-24

Entity Field 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 fields must be unique within a KISCourse.CourseStage entity 2
HESACourse HESACOURSEID Error HESACourse.HESACOURSEID must be unique within a KIS course 1
ILRAims ILRAIMID Error ILRAims.ILRAIMID must be unique within a KIS course 1
Institution ACCOMURLW Error Institution.ACCOMURLW cannot exist if you are not a Welsh institution 1
Institution INSTBEDS Error If Institution.INSTBEDS exists then Institution.INSTUPPER and Institution.INSTLOWER must be returned 1
Institution INSTBEDS Error If Institution.INSTBEDS does not exist then both Institution.INSTUPPER and Institution.INSTLOWER must not be returned 2
Institution INSTBEDS Error The value of Institution.INSTBEDS must lie between 1 and 15000 3
Institution INSTLOWER Error The value of Institution.INSTLOWER must lie between 1500 and 15000 1
Institution INSTUPPER Error Institution.INSTUPPER must be greater than Institution.INSTLOWER 1
Institution INSTUPPER Error The value of Institution.INSTUPPER must lie between 1500 and 15000 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 PRIVATELOWER Error The value of Institution.PRIVATELOWER must lie between 1500 and 15000 1
Institution PRIVATEUPPER Error Institution.PRIVATEUPPER must be greater than Institution.PRIVATELOWER 1
Institution PRIVATEUPPER Error The value of Institution.PRIVATEUPPER must lie between 1500 and 15000 2
Institution UKPRN Error Institution.UKPRN must be valid 1
KISCourse Error KISCourse.KISTYPE 2 and 3 courses cannot contain KISCourse.HESACourse entities 1
KISCourse Error KISCourse.HESACourse entities can only be returned by an HEI 2
KISCourse Error KISCourse.KISTYPE 2 and 3 courses cannot contain KISCourse.ILRAims entities 1
KISCourse Error Kiscourse.ILRAims entities can only be returned by an FEC 2
KISCourse Error KISCourse.KISTYPE 2 courses cannot contain KISCourse.CourseStage entities 1
KISCourse Error CourseStage.WRITTEN, CourseStage.COURSEWORK and CourseStage.PRACTICAL fields must sum to 100 or 0 within any KISCourse.CourseStage entity 2
KISCourse Error CourseStage.SCHEDULED, CourseStage.INDEPENDENT and CourseStage.PLACEMENT fields must sum to 100 within any KISCourse.CourseStage entity 3
KISCourse Error KISCourse.KISTYPE 1 or KISCourse.KISTYPE 3 courses must contain KISCourse.CourseStage entities 4
KISCourse Error KISCourse.KISTYPE 2 and 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 KISCourse.KISTYPE 1 courses where both KISCourse.HESACourse and KISCourse.ILRAim entities are missing must contain a KISCourse.DISTANCE field 1
KISCourse DISTANCE Error KISCourse.KISTYPE 2 courses cannot contain a KISCourse.DISTANCE field 2
KISCourse DISTANCE Error KISCourse.KISTYPE 3 courses must contain a KISCourse.DISTANCE field 3
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 KISCourse.KISTYPE 2 courses must not contain KISCourse.ENGFEE 1
KISCourse ENGFEE Error KISCourse.KISTYPE 1 courses where no KISCourse.UCASCOURSEID exists and KISCourse.FEETBC=1 must contain a KISCourse.ENGFEE field 2
KISCourse ENGFEE Error Value of KISCourse.ENGFEE must be between 1 and 9000 3
KISCourse ENGFEE Error Where any of the fields KISCourse.ENGFEE, KISCourse.SCOTFEE, KISCourse.WAFEE, KISCourse.NIFEE, KISCourse.WAIVER, KISCourse.MEANSSUP, KISCourse.VARFEE or KISCourse.OTHSUP exist then all must exist 4
KISCourse FEETBC Error KISCourse.KISTYPE 1 courses where no KISCourse.UCASCOURSEID field exists must contain a KISCourse.FEETBC field 1
KISCourse FEETBC Error KISCourse.FEETBC must equal 1 when any of the following exist: KISCourse.ENGFEE, KISCourse.NIFEE, KISCourse.WAFEE, KISCourse.SCOTFEE, KISCourse.VARFEE , KISCourse.WAIVER, KISCourse.MEANSSUP, KISCourse.OTHSUP 2
KISCourse JACS Error KISCourse.KISTYPE 1 courses with no KISCourse.HESACourse entities 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 KISCourse.HESACourse entity and KISCourse.JACS field cannot both be returned 3
KISCourse JACS Error 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 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 LDCS Error KISCourse.KISTYPE 1 courses with no KISCourse.ILRAims entities must have a KISCourse.LDCS field 1
KISCourse LDCS Error KISCourse.KISTYPE 2 and 3 courses cannot contain a KISCourse.LDCS field 2
KISCourse LDCS Error KISCourse.ILRAIMS entity and KISCourse.LDCS field cannot both be returned 3
KISCourse LDCS Error Only FECs can return a KISCourse.LDCS field 4
KISCourse LEVEL Error KISCourse.KISTYPE 1 courses where both KISCourse.HESACourse and KISCourse.ILRAim entities are missing must contain a KISCourse.LEVEL field 1
KISCourse LEVEL Error KISCourse.KISTYPE 2 courses cannot contain a KISCourse.LEVEL field 2
KISCourse LEVEL Error KISCourse.KISTYPE 3 courses must contain a KISCourse.LEVEL field 3
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 KISCourse.KISTYPE 2 courses must not contain KISCourse.MEANSSUP 1
KISCourse MEANSSUP Error KISCourse.KISTYPE 1 courses where KISCourse.UCASCOURSEID does not exist and KISCourse.FEETBC = 1 must contain KISCourse.MEANSSUP field 2
KISCourse MEANSSUP Error KIS courses where KISCourse.UCASCOURSEID exists cannot contain a KISCourse.MEANSSUP field 3
KISCourse NIFEE Error KISCourse.KISTYPE 2 courses must not contain KISCourse.NIFEE 1
KISCourse NIFEE Error KISCourse.KISTYPE 1 courses where no KISCourse.UCASCOURSEID exists and KISCourse.FEETBC=1 must contain a KISCourse.NIFEE field 2
KISCourse NIFEE Error Value of KISCourse.NIFEE must be between 1 and 9000 3
KISCourse NONCREDITASSESS Error KISCourse.KISTYPE 1 courses must contain KISCourse.NONCREDITASSESS 1
KISCourse NONCREDITASSESS Error KISCourse.KISTYPE 2 and 3 courses must not contain KISCourse.NONCREDITASSESS 2
KISCourse OTHSUP Error KISCourse.KISTYPE 2 courses must not contain KISCourse.OTHSUP 1
KISCourse OTHSUP Error KISCourse.KISTYPE 1 courses where KISCourse.UCASCOURSEID does not exist and KISCourse.FEETBC = 1 must contain KISCourse.OTHSUP field 2
KISCourse OTHSUP Error KIS courses where KISCourse.UCASCOURSEID exists cannot contain a KISCourse.OTHSUP field 3
KISCourse PTONLY Error KISCourse.KISTYPE 1 courses where both KISCourse.HESACourse and KISCourse.ILRAim entities are missing must contain a KISCourse.PTONLY field 1
KISCourse PTONLY Error KISCourse.KISTYPE 2 courses cannot contain a KISCourse.PTONLY field 2
KISCourse PTONLY Error KISCourse.KISTYPE 3 courses must contain a KISCourse.PTONLY field 3
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.RELATEDKIS must be KISCourse.KISTYPE 1 or 3 5
KISCourse SCOTFEE Error KISCourse.KISTYPE 2 courses must not contain KISCourse.SCOTFEE 1
KISCourse SCOTFEE Error KISCourse.KISTYPE 1 courses where no KISCourse.UCASCOURSEID exists and KISCourse.FEETBC=1 must contain a KISCourse.SCOTFEE field 2
KISCourse SCOTFEE Error Value of KISCourse.SCOTFEE must be between 1 and 9000 for non-Scottish institutions 3
KISCourse SCOTFEE Error Value of KISCourse.SCOTFEE must be between 0 and 9000 for Scottish institutions 4
KISCourse SUPPORTURL Error KISCourse.KISTYPE 2 courses must not contain KISCourse.SUPPORTURL 1
KISCourse SUPPORTURL Error KISCourse.KISTYPE 1 and 3 courses must contain KISCourse.SUPPORTURL 2
KISCourse SUPPORTURLW Error KISCourse.KISTYPE 2 courses must not contain KISCourse.SUPPORTURLW 1
KISCourse SUPPORTURLW Error Institutions outside of Wales cannot return KISCourse.SUPPORTURLW 2
KISCourse TITLE Error KISCourse.KISTYPE 1 and 2 courses must contain a KISCourse.TITLE 1
KISCourse TITLE Error KISCourse.KISTYPE 3 courses must not contain a KISCourse.TITLE 2
KISCourse TITLEW Error KISCourse.KISTYPE 1 and 2 courses in Welsh institutions must contain a KISCourse.TITLEW field 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 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 (JACSL2=41) cannot contain a KISCourse.UCASCOURSEID 1
KISCourse UCASPROGID Error KISCourse.KISTYPE 3 courses that are not Combined studies (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 KISCourse.KISTYPE 2 courses must not contain KISCourse.VARFEE 1
KISCourse VARFEE Error KISCourse.KISTYPE 1 courses where no KISCourse.UCASCOURSEID field exists and KISCourse.FEETBC=1 must contain a KISCourse.VARFEE field 2
KISCourse WAFEE Error KISCourse.KISTYPE 2 courses must not contain KISCourse.WAFEE 1
KISCourse WAFEE Error KISCourse.KISTYPE 1 courses where no KISCourse.UCASCOURSEID exists and KISCourse.FEETBC=1 must contain a KISCourse.WAFEE field 2
KISCourse WAFEE Error Value of KISCourse.WAFEE must be between 1 and 9000 3
KISCourse WAIVER Error KISCourse.KISTYPE 2 courses must not contain KISCourse.WAIVER 1
KISCourse WAIVER Error KISCourse.KISTYPE 1 courses where KISCourse.UCASCOURSEID does not exist and KISCourse.FEETBC = 1 must contain KISCourse.WAIVER field 2
KISCourse WAIVER Error KIS courses where KISCourse.UCASCOURSEID exists cannot contain a KISCourse.WAIVER field 3
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
Contact Institutional Liaison: liaison@hesa.ac.uk, tel 01242 211144