Skip to main content

Institution profile record 2014/15

Back to C14041

Summary of business rules

Version 1.0 Produced 2015-02-26

This document lists the business rules that enforce the business logic of the schema.

Entity Field or Entity Name Status Rule Number
AcademicCostCentres DEPARTMENT Error The first character in AcademicCostCentres.DEPARTMENT must be a capital letter (A-Z). 1
AcademicCostCentres PROPACC Error AcademicCostCentres.PROPACC must be greater than 0. 1
AcademicCostCentres PROPDEPT Error AcademicCostCentres.PROPDEPT must be greater than 0. 1
AcademicCostCentres TIER1 Error The first character in AcademicCostCentres.TIER1 must be a capital letter (A-Z). 1
AcademicCostCentres TIER2 Error The first character in AcademicCostCentres.TIER2 must be a capital letter (A-Z). 1
AcademicCostCentres TIER2 Error Where AcademicCostCentres.TIER2 is completed then AcademicCostCentres.TIER1 (in the same record) must also be completed. 2
Campus CAMPID Error No two records can have the same Campus.CAMPID. 1
Campus CAMPID Error Campus.CAMPID must equal 'A' where Campus.CAMPNAME = 'Entire HEP' or 'Main campus' 2
Campus CAMPNAME Error The first character in Campus.CAMPNAME must be a capital letter (A-Z). 1
Campus CAMPNAME Error Campus.CAMPID = 'A', and this is the only campus, then Campus.CAMPNAME must equal 'Entire HEP'. 2
Campus CAMPNAME Error Campus.CAMPID = 'A', and there is more than one campus, then Campus.CAMPNAME must = 'Main campus'. 3
Campus EASTING Error Campus.COUNTRY = IM, XL, XF, XI, XH or XG then Campus.EASTING must exist. 1
Campus EASTING Error If Campus.COUNTRY is not coded IM, XL, XF, XI, XH or XG then Campus.EASTING must not exist. 3
Campus NORTHING Error Campus.COUNTRY = IM, XL, XF, XI, XH or XG then Campus.NORTHING must exist. 1
Campus NORTHING Error If Campus.COUNTRY is not coded IM, XL, XF, XI, XH or XG then Campus.NORTHING must not exist. 3
Campus POSTCODE Error Where Campus.COUNTRY = IM, XL, XF, XI, XG or XH then Campus.POSTCODE must exist. 1
Campus POSTCODE Error Where Campus.COUNTRY is not coded IM, XL, XF, XI, XG or XH then Campus.POSTCODE must not exist. 2
Institution AcademicCostCentres Error Institution.AcademicCostCentres entity must exist for providers in England 1
Institution AcademicCostCentres Warning Institution.AcademicCostCentres entity does not exist for providers in Scotland, Northern Ireland or Wales. 2
Institution AcademicCostCentres Error Institution.AcademicCostCentres entity must not exist for providers with INSTID between 0214 - 0219. 3

Contact Liaison by email or on 01242 211144.