Skip to main content

Institution profile record 2013/14

Back to C13041

Summary of business rules

Version 1.0 Produced 2014-02-28

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 institution' 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 institution'. 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 not be blank. 1
Campus EASTING Error If Campus.COUNTRY is not coded IM, XL, XF, XI, XH or XG then Campus.EASTING must be blank. 3
Campus NORTHING Error Campus.COUNTRY = IM, XL, XF, XI, XH or XG then Campus.NORTHING must not be blank. 1
Campus NORTHING Error If Campus.COUNTRY is not coded IM, XL, XF, XI, XH or XG then Campus.NORTHING must be blank. 3
Campus POSTCODE Error Where Campus.COUNTRY = IM, XL, XF, XI, XG or XH then Campus.POSTCODE must not be blank. 1
Campus POSTCODE Error Where Campus.COUNTRY is not coded IM, XL, XF, XI, XG or XH then Campus.POSTCODE must be blank. 2
Institution AcademicCostCentres Error Institution.AcademicCostCentres entity must exist for institutions in England 1
Institution AcademicCostCentres Warning Institution.AcademicCostCentres entity does not exist for institutions in Scotland, Northern Ireland or Wales. 2
Institution AcademicCostCentres Error Institution.AcademicCostCentres entity must not exist for institutions with INSTID between 0214 - 0219. 3

Contact Liaison by email or on 01242 211144.