Quality Rules Directory for C16061
Filter
QR.C16061.KISCourse.NUMSTAGE.1
KISCourse.NUMSTAGE must exist where KISCourse.KISTYPE = 2 and any linked KISCourse.RELATEDKIS.KISTYPE = 3.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- 29/03/2016: Rule amended to trigger only when any RELATEDKIS Courses have KISTYPE = 3.
- Previous Name of Rule
- QR.C15061.KISCourse.NUMSTAGE.1
QR.C16061.KISCourse.NUMSTAGE.3
KISCourse.NUMSTAGE must not exist where KISCourse.KISTYPE = 2 and all linked KISCourse.RELATEDKIS.KISTYPE = 1.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- 08/03/2016: Rule amended to trigger only when all RELATEDKIS Courses have KISTYPE = 1.
- Previous Name of Rule
- QR.C15061.KISCourse.NUMSTAGE.3
QR.C16061.KISCourse.RELATEDKIS.1
KISCourse.KISTYPE 2 courses must contain a KISCourse.RELATEDKIS fieldQR.C16061.KISCourse.RELATEDKIS.2
KISCourse.KISTYPE 1 and 3 courses cannot contain a KISCourse.RELATEDKIS fieldQR.C16061.KISCourse.RELATEDKIS.3
KISCourse.RELATEDKIS must exist as a KISCourse.KISCOURSEID within the fileQR.C16061.KISCourse.RELATEDKIS.5
KISCourse.KISTYPE must equal 1 or 3 where the KISCourse.KISCOURSEID is referenced in any KISCourse.RELATEDKIS.QR.C16061.KISCourse.RELATEDKIS.6
KISCourse.RELATEDKIS must be unique within KIS course.QR.C16061.KISCourse.RELATEDKIS.10
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.QR.C16061.KISCourse.RELATEDKIS.11
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.QR.C16061.KISCourse.RELATEDKIS.12
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.QR.C16061.KISCourse.RELATEDKIS.13
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.QR.C16061.KISCourse.RELATEDKIS.14
Where KISCourse.RELATEDKIS exists and KISCourse.TEACHUKPRN exists then KISCourse.TEACHUKPRN must be referenced in the related (KISCourse.TEACHUKPRN, HESACourse.TEACHUKPRN or ILRAims.TEACHUKPRN).QR.C16061.KISCourse.NUMSTAGE.5
KISCourse.NUMSTAGE must not exist where KISCourse.KISTYPE = 2 and KISCourse.RELATEDKIS.KISTYPE = 1.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- 08/03/2016: Rule deleted as a duplicate of QR.C16061.KISCourse.NUMSTAGE.3.
- Previous Name of Rule
- QR.C15061.KISCourse.NUMSTAGE.5