Institution profile record 2014/15
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 +44 (0)1242 388 531.