HESA Staff record 2013/14
Summary of business rules
Version 1.1 Produced 2014-04-30
The business rules below have been updated for the 2013/14 collection.
| Entity | Field Name | Status | Rule | Number |
| Activity | ACTSOC | Error | There must not be multiple occurrences of the same Activity.ACTSOC and Activity.CCENTRE on the same Contract.CONTID | 1 |
| Activity | CCPROP | Error | Where only one Activity returned Activity.CCPROP must be 100 | 1 |
| Activity | CCPROP | Error | Where Multiple Activity entities are returned the sum of all Activity.CCPROP must be in the range 99.7 and 100.3 | 2 |
| Contract | ACEMPFUN | Error | Contract.ACEMPFUN must exist where any Activity.ACTSOC begins with 1, 2 or 3. | 1 |
| Contract | ACEMPFUN | Error | Contract.ACEMPFUN must not exist unless at least one Activity.ACTSOC under that Contract begins with 1, 2 or 3. | 2 |
| Contract | CLINICAL | Error | Contract.CLINICAL must exist where (Contract.ACEMPFUN = 1, 2 or 3) and (Contract.TERMS = 1 or 2) and any Activity.CCENTRE = 101, 102, 103, 104, 105, 106, 107, 108, 112, 127 or 131. | 1 |
| Contract | CLINICAL | Error | Contract.CLINICAL must not exist where all Activity.CCENTRE not equal to 101, 102, 103, 104, 105, 106, 107, 108, 112, 127 or 131. | 2 |
| Contract | CLINSUB | Error | Contract.CLINSUB must exist where Contract.CLINICAL = 1. | 1 |
| Contract | CLINSUB | Error | Contract.CLINSUB must not exist where Contract.CLINICAL not equal to 1. | 2 |
| Contract | CLINSUB | Error | Where there is more than one occurrence of Contract.CLINSUB they must not be identical. | 3 |
| Contract | CLINSUB | Warning | Where Contract.CLINSUB and Person.REFUOA2014 exist, then the first two characters of Person.REFUOA2014 should equal 01, 02, 03 or 04 | 4 |
| Contract | CONFTE | Error | Contract.CONFTE must be 0 where Contract.MOEMP = 6 | 1 |
| Contract | CONFTE | Error | Where (Contract.MOEMP is 3, 4 or 5) then Contract.CONFTE must not be 100. | 2 |
| Contract | CONFTE | Warning | Where exists (Contract.ENDCON > (Y1)-07-31 and Contract.ENDCON < (Y2)-07-31), then Contract.CONFTE must not be 100 | 3 |
| Contract | CONFTE | Error | Contract.CONFTE must not be 000.0 where (Contract.MOEMP in (1, 2, 3, 4, 5) and (Contract.ENDCON > '(Y1)-07-31' or Contract.ENDCON does not exist)). | 4 |
| Contract | ENDCON | Error | Contract.ENDCON must exist where Contract.TERMS = 1 or 2 and ReasonForNull does not equal 1 | 1 |
| Contract | ENDCON | Error | Contract.ENDCON must be null where ReasonForNull = 1. | 2 |
| Contract | ENDCON | Error | Where Contract.ENDCON is null ReasonForNull must equal 1. | 3 |
| Contract | ENDCON | Error | Where exists Contract.ENDCON must be less than Y2-08-01 | 4 |
| Contract | ENDCON | Error | Where exists Contract.ENDCON must be equal to or after the date returned in Contract.STARTCON. | 5 |
| Contract | ENDCON | Error | Contract.ENDCON must be before or equal to Person.DATELEFT where all Contract.TERMS = 1 or 2 | 6 |
| Contract | HEIJOINT | Error | Contract.HEIJOINT must not be the returning institution. | 1 |
| Contract | HEIJOINT | Warning | Contract.HEIJOINT should not exist where Contract.TERMS is not equal to 1 or 2. | 2 |
| Contract | HSPEC | Error | Contract.HSPEC must exist where Contract.CLINICAL = 1, 2, 3 or 4. | 1 |
| Contract | HSPEC | Error | Contract.HSPEC must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4. | 2 |
| Contract | HSPEC | Error | Where there is more than one occurrence of Contract.HSPEC they must not be identical. | 3 |
| Contract | LEVELS | Error | Contract.LEVELS must exist where (Person.DATELEFT is after (Y1)-07-31 or Person.DATELEFT does not exist) and ((Contract.TERMS = 1 or 2) or (Contract.ACEMPFUN = 1, 2, 3 or 9 and Contract.TERMS = 3)) | 1 |
| Contract | NHSCON | Error | Contract.NHSCON must exist where Contract.CLINICAL is equal to 1, 2, 3 or 4. | 1 |
| Contract | NHSCON | Error | Contract.NHSCON must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4. | 2 |
| Contract | NHSCONGR | Error | Where Contract.STARTCON is after 2009-08-01 Contract.NHSCONGR must not equal 02, 03, 06 or 07 | 1 |
| Contract | NHSCONGR | Error | Contract.NHSCONGR must exist where Contract.CLINICAL = 1, 2, 3 or 4. | 2 |
| Contract | NHSCONGR | Error | Contract.NHSCONGR must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4. | 3 |
| Contract | PSCAG | Error | Contract.PSCAG must exist where Contract.TERMS = 1 or 2. | 1 |
| Contract | PSCAG | Error | Where Contract.SOBS = 01 then Contract.PSCAG must be 100. | 2 |
| Contract | PSCAG | Error | Where Contract.SOBS not equal to 01 then Contract.PSCAG must not be 100. | 3 |
| Contract | RESCON | Error | Where Contract.RESCON = 8 there must be no new contracts starting after that Contract.ENDCON. | 1 |
| Contract | RESCON | Error | Contract.RESCON must exist where Contract.TERMS = 1 or 2 and Contract.ENDCON exists. | 2 |
| Contract | RESCON | Error | Contract.RESCON must not exist where (Contract.ENDCON does not exist and Contract.TERMS = 1 or 2.) | 3 |
| Contract | SALREF | Error | Where Contract.SALREF exists, then Contract.SALREF must not be greater than 325000. | 1 |
| Contract | SALREF | Error | Where Contract.SALREF exists, then Contract.SALREF must not be less than 4800. | 2 |
| Contract | SALREF | Error | Contract.SALREF must not exist where Contract.SPOINT begins with C. | 3 |
| Contract | SALREF | Error | Contract.SALREF must exist where (Contract.TERMS = 1 or 2) and Contract.SPOINT does not exist. | 4 |
| Contract | SOBS | Error | Where there is more than one occurrence of Contract.SOBS they must not be identical. | 1 |
| Contract | SOBS | Error | Where Contract.SOBS = 01 there must be no other occurrences of Contract.SOBS. | 2 |
| Contract | SOBS | Error | Contract.SOBS must exist where Contract.TERMS = 1 or 2. | 3 |
| Contract | STARTCON | Error | Contract.STARTCON must not be after Y2-07-31 | 1 |
| Contract | STARTCON | Error | Where exists Contract.STARTCON must not be after Contract.ENDCON. | 2 |
| Contract | STARTCON | Error | Contract.STARTCON must exist where Contract.TERMS = 1 or 2. | 3 |
| Contract | STARTCON | Error | Contract.STARTCON must be null where ReasonForNull = 1 | 4 |
| Contract | STARTCON | Error | Where Contract.STARTCON is null ReasonForNull must equal 1. | 5 |
| Contract | STARTCON | Error | Where Contract.STARTCON exists it must be after Person.BIRTHDTE where it exists or after (Y1-100)-07-31 where Person.BIRTHDTE does not exist. | 6 |
| Contract | STARTCON | Error | Contract.STARTCON must be before or on Person.DATELEFT where all Contract.TERMS = 1 or 2 | 7 |
| Contract | TCHWLH | Error | Contract.TCHWLH must not exist for institutions in England, Scotland or Northern Ireland. | 1 |
| Contract | TCHWLH | Error | Contract.TCHWLH must exist for Welsh institutions where (Contract.ACEMPFUN = 1 or 3) and Contract.TERMS = 1 or 2. | 2 |
| Contract | TCHWLH | Error | Contract.TCHWLH must not equal 1 where Person.ABLWELSH = 2. | 3 |
| Contract | TERMS | Error | Where Contract.MOEMP = 5 then Contract.TERMS must equal 3. | 1 |
| Person | ABLWELSH | Error | Person.ABLWELSH must not exist for institutions in England, Scotland or Northern Ireland. | 1 |
| Person | ABLWELSH | Error | Person.ABLWELSH must exist for institutions in Wales where any Contract.ACEMPFUN = 1 or 3 and Contract.TERMS = 1 or 2. | 2 |
| Person | ACTCHQUAL | Error | Person.ACTCHQUAL must exist for institutions in England, Wales and Northern Ireland where any (Contract.ACEMPFUN = 1 or 3) and Contract.TERMS = 1 or 2. | 1 |
| Person | ACTCHQUAL | Error | Only one occurrence of Person.ACTCHQUAL = 02, 03, 04 or 05 can apply at a given point of time. | 2 |
| Person | ACTCHQUAL | Error | Where there is more than one occurrence of Person.ACTCHQUAL they must not be identical. | 3 |
| Person | ACTLEAVE | Error | Person.ACTLEAVE must exist where Person.DATELEFT is not null and (Contract.TERMS = 1 or 2) and (no Contract.RESCON = 8) where any Activity.ACTSOC begins with 1, 2 or 3. | 1 |
| Person | ACTLEAVE | Error | Person.ACTLEAVE must not exist where Person.DATELEFT is null. | 2 |
| Person | BIRTHDTE | Error | Person.BIRTHDTE must exist where any Contract.TERMS = 1 or 2. | 1 |
| Person | BIRTHDTE | Error | Person.BIRTHDTE must exist where any Contract.TERMS = 3 and Contract.ACEMPFUN = 1, 2, 3, or 9. | 2 |
| Person | BIRTHDTE | Error | Where Person.BIRTHDTE exists and Person.DATEFHEI greater than or equal to (Y1)-08-01 then Person.BIRTHDTE must be before (Y1-15)-08-01. | 3 |
| Person | BIRTHDTE | Error | Where Person.BIRTHDTE exists and Person.DATEFHEI greater than or equal to (Y1)-08-01 then Person.BIRTHDTE must be after (Y1-91)-07-31 | 4 |
| Person | CLINARD | Error | Person.CLINARD must exist where any Contract.CLINICAL = 1. | 1 |
| Person | CLINARD | Error | Person.CLINARD must not exist where all Contract.CLINICAL not equal to 1. | 2 |
| Person | CURACCDIS | Error | Person.CURACCDIS must exist where any (Contract.ACEMPFUN = 1, 2 or 3) and Contract.TERMS = 1 or 2 | 1 |
| Person | CURACCDIS | Error | Person.CURACCDIS must not exist where all Contract.ACEMPFUN = 4 or 9 | 2 |
| Person | CURACCDIS | Error | Where there is more than one occurrence of Person.CURACCDIS they must not be identical. | 3 |
| Person | CURACCDIS | Error | Person.CURACCDIS must not equal 'XXXX' | 4 |
| Person | DATEFHEI | Error | Person.DATEFHEI must exist where any Contract.TERMS = 1 or 2. | 1 |
| Person | DATEFHEI | Error | Person.DATEFHEI must be null where ReasonForNull = 1. | 2 |
| Person | DATEFHEI | Error | Where Person.DATEFHEI is null ReasonForNull must equal 1. | 3 |
| Person | DATEFHEI | Error | Where exists Person.DATEFHEI must be before Y2-08-01 | 4 |
| Person | DATEFHEI | Error | Where exists Person.DATEFHEI must be after Person.BIRTHDTE. | 5 |
| Person | DATELEFT | Error | Person.DATELEFT must exist where all (Contract.TERMS = 1 or 2 and all Contract.ENDCON are not null) and all Contract.RESCON not equal to 1 or 2. | 1 |
| Person | DATELEFT | Error | Person.DATELEFT must not exist where any (Contract.TERMS = 1 or 2 and Contract.ENDCON are null). | 2 |
| Person | DATELEFT | Error | Where exists Person.DATELEFT must be equal to or after Person.DATEFHEI. | 3 |
| Person | DATELEFT | Error | Person.DATELEFT must be between (Y-1)-08-01 and (Y2)-07-31 (inclusive) | 4 |
| Person | ECRSTAT | Error | Person.ECRSTAT must exist where Person.RESAST <> 1 and any contract exists where (Contract.ACEMPFUN = 2 or 3 and Contract.TERMS = 1 or 2 and the contract is active on the '(Y1)-10-31') | 1 |
| Person | ECRSTAT | Error | Person.ECRSTAT must not exist where all Contract.ACEMPFUN not equal to 2 or 3. | 2 |
| Person | ECRSTAT | Error | Person.ECRSTAT must not exist where Person.RESAST = 1 or no contract exists where (Contract.ACEMPFUN = 2 or 3 and Contract.TERMS = 1 or 2 and the contract is active on '(Y1)-10-31') | 3 |
| Person | ECRSTAT | Warning | Person.ECRSTAT should not exist where Person.DATEFHEI greater than '(Y1)-10-31' | 4 |
| Person | ETHNIC | Error | For institutions in England and Wales Person.ETHNIC must not equal 13, 14 or 19. | 1 |
| Person | ETHNIC | Error | For institutions in Scotland Person.ETHNIC must not equal 10 or 14. | 2 |
| Person | ETHNIC | Error | For institutions in Northern Ireland Person.ETHNIC must not equal 13 or 19. | 3 |
| Person | HQHELD | Error | Person.HQHELD must exist where (Contract.TERMS = 1 or 2) and any Activity.ACTSOC begins with 1, 2 or 3 | 1 |
| Person | LOCLEAVE | Error | Person.LOCLEAVE must exist where Person.DATELEFT exists and (no Contract.RESCON = 8) and any Contract.TERMS = 1 or 2 and any Activity.ACTSOC begins with 1, 2 or 3. | 1 |
| Person | LOCLEAVE | Error | Person.LOCLEAVE must not exist where Person.DATELEFT does not exist. | 2 |
| Person | LOCLEAVE | Error | Person.LOCLEAVE must not exist where Person.DATELEFT exists and any Contract.RESCON is coded 8. | 3 |
| Person | NATIOND | Error | Person.NATIOND must exist for institutions in Wales. | 1 |
| Person | NATIOND | Error | Person.NATIOND must not exist for institutions in England, Scotland and Northern Ireland. | 2 |
| Person | NATIOND | Error | Where there is more than one occurrence of Person.NATIOND they must not be identical. | 3 |
| Person | PREVEMP | Error | Person.PREVEMP must exist where (Contract.TERMS = 1 or 2) and any Activity.ACTSOC begins with 1, 2 or 3. | 1 |
| Person | PREVEMP | Error | Person.PREVEMP must not equal 05 or 06 where Person.DATEFHEI >= 2012-08-01. | 2 |
| Person | PREVHEI | Error | Person.PREVHEI must exist where Person.PREVEMP = 01 and any Activity.ACTSOC begins with 1, 2 or 3. | 1 |
| Person | PREVHEI | Error | Person.PREVHEI must not exist where Person.PREVEMP not equal to 01 or 21. | 2 |
| Person | REFUOA2014 | Warning | Person.REFUOA2014 should not exist where all Contract.ACEMPFUN not equal to 2 or 3 | 1 |
| Person | REFUOA2014 | Error | Person.REFUOA2014 must not exist where Person.RESAST = 1 or no contract exists where (Contract.ACEMPFUN = 2 or 3 and Contract.TERMS = 1 or 2 and the contract is active on '(Y1)-10-31') | 2 |
| Person | REFUOA2014 | Warning | Person.REFUOA2014 should exist where Person.RESAST 1 and any contract exists where (Contract.ACEMPFUN = 2 or 3 and Contract.TERMS = 1 or 2 and the contract is active on '(Y1)-10-31') | 3 |
| Person | REGBODY | Error | Person.REGBODY must exist where any Contract.CLINICAL = 1, 2, 3 or 4 or (any Activity.CCENTRE = 109 and Contract.ACEMPFUN = 1, 2, or 3 and Contract.TERMS = 1 or 2). | 1 |
| Person | REGBODY | Warning | Person.REGBODY should only exist where there is a Contract.CLINICAL = 1, 2, 3, or 4 or there is a Contract with (any Activity.CCENTRE = 109 and Contract.ACEMPFUN = 1, 2, or 3 and Contract.TERMS = 1 or 2). | 2 |
| Person | REGBODY | Error | Where there is more than one occurrence of Person.REGBODY they must not be identical. | 3 |
| Person | REGBODY | Error | Person.REGBODY (must equal 01 or 02) where any Contract.CLINICAL = 1. | 4 |
| Person | REGBODY | Error | Person.REGBODY must equal 06 where any Contract.CLINICAL = 2. | 5 |
| Person | REGBODY | Error | Person.REGBODY must equal 07 where any Contract.CLINICAL = 3 . | 6 |
| Person | RELBLF | Error | For institutions in England and Wales Person.RELBLF must not equal 04, 05, 06, 07, 08 or 09. | 1 |
| Person | RELBLF | Error | For institutions in Scotland Person.RELBLF must not equal 03, 06, 07 or 08. | 2 |
| Person | RELBLF | Error | For institutions in Northern Ireland Person.RELBLF must not equal 03 or 04. | 3 |
| Person | RESAST | Error | Person.RESAST must exist where any Contract.ACEMPFUN = 2 and Contract.TERMS = 1 or 2. | 1 |
| Person | RESAST | Error | Person.RESAST must not exist where all Contract.ACEMPFUN not equal to 2 or all Contract.TERMS = 3. | 2 |
| Person | SEX | Error | Person.SEX must exist where any Contract.TERMS = 1 or 2. | 1 |
| Person | SEX | Error | Person.SEX must exist where any Contract.TERMS = 3 and Contract.ACEMPFUN = 1, 2, 3 or 9. | 2 |
| Person | STAFFID | Error | No two records can have the same Person.STAFFID | 1 |
| Person | STAFFID | Error | Person.STAFFID must not contain all zeroes. | 2 |
| Person | STAFFID | Error | Characters 3 to 6 of Person.STAFFID must be in the range 0000-0099 or 1001-1211 or 1228 excluding 1005, 1093, 1094, 1130, 1166 and 1183. | 3 |
| Person | STAFFID | Error | Character 13 of Person.STAFFID must pass the checksum test given in the coding manual | 4 |
Contact Liaison by email or on +44 (0)1242 388 531.