Skip to main content

Institution profile record 2013/14

Back to C13041

COMMIT-stage rules


Version 1.0 Produced 2014-02-28

This document lists the validation rules that will be applied during the COMMIT transaction of the data collection system.

Validation at COMMIT

Field Name Number Severity Rule
AcademicCostCentres.ACCENTRE 1 Warning The AcademicCostCentres.ACCENTRE was returned in last year's but not in this year's return.
AcademicCostCentres.ACCENTRE 2 Warning The AcademicCostCentres.ACCENTRE was returned in this year's but not in last year's return.
AcademicCostCentres.ACCENTRE 3 Warning Where ModuleSubject.COSTCN has been submitted in the Student record but is not coded in any occurrence of AcademicCostCentres.ACCENTRE.
AcademicCostCentres.ACCENTRE 4 Warning Where Activity.CCENTRE has been submitted in the Staff record but is not coded in any occurrence of AcademicCostCentres.ACCENTRE.
AcademicCostCentres.ACCENTRE 5 Warning Where CCENTRE has been returned in the Finance record but is not coded in any occurrence of AcademicCostCentres.ACCENTRE.
AcademicCostCentres.ACCENTRE 6 Warning Where AcademicCostCentres.ACCENTRE has been submitted but is not coded in any occurrence of ModuleSubject.COSTCN in the Student record.
AcademicCostCentres.ACCENTRE 7 Warning Where AcademicCostCentres.ACCENTRE has been submitted but is not coded in any occurrence of Activity.CCENTRE in the Staff record.
AcademicCostCentres.ACCENTRE 8 Warning Where AcademicCostCentres.ACCENTRE has been submitted but is not coded in any occurrence of CCENTRE in the Finance record.
AcademicCostCentres.ACCENTRE 9 Warning Multiple occurrences with same AcademicCostCentres.ACCENTRE and AcademicCostCentres.DEPARTMENT relationship.
AcademicCostCentres.PROPACC 1 Error The sum of AcademicCostCentres.PROPACC must add up to 100 for all distinct instances of AcademicCostCentres.DEPARTMENT.
AcademicCostCentres.PROPDEPT 1 Error The sum of AcademicCostCentres.PROPDEPT must add up to 100 for all distinct instances of AcademicCostCentres.ACCENTRE.
Campus.CAMPID 1 Warning Campus.CAMPID is in this year's but not in last year's Campus return.
Campus.CAMPID 2 Warning Campus.CAMPID is in last year's but not in this year's Campus return.
Campus.CAMPID 3 Warning If the same Campus.CAMPID appears in last year's and this year's return then Campus.EASTING and Campus.NORTHING should be consistent within 500 metres.
Campus.COUNTRY 1 Error Campus.CAMPID = 'A' then Campus.CAMPID must be valid in relation to the location of the institution.
Campus.POSTCODE 1 Error Where Campus.COUNTRY = IM, XL, XF, XI, XG or XH then Campus.POSTCODE must contain a valid postcode.
Campus.POSTCODE 2 Warning If the same Campus.CAMPID appears in both last year's and this year's return then Campus.POSTCODE should be consistent.

Contact Liaison by email or on 01242 211144.