Skip to main content

Institution profile record 2014/15

Back to C14041

COMMIT-stage rules

Version 1.0 Produced 2015-02-26

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

Validation at COMMIT

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

Contact Liaison by email or on 01242 211144.