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