Skip to main content

HESA Staff record 2012/13

Back to C12025

Summary of business rules


Version 1.8 Produced 2013-10-24

This is the first release of business rules for 2012/13, and the first for the staff record following the move to XML format.

Entity Field Name Status Rule Number
Activity ACTSOC Error Where there are multiple occurrences of Activity.ACTSOC, Activity.CCENTRE and Activity.CCPROP they must not be identical. 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 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 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 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 Warning Contract.RESCON must exist where Contract.TERMS = 1 or 2 and Contract.ENDCON exists. 2
Contract RESCON Warning Contract.RESCON must not exist where Contract.ENDCON does not exist. 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 4500. 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 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 then must be before (Y1-15)-08-01. 3
Person BIRTHDTE Error Where Person.BIRTHDTE exists then 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. 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 any (Contract.ACEMPFUN = 2 or 3 and Contract.TERMS = 1 or 2) and where Person.RESAST exists it does not equal 1. 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 any Contract.ACEMPFUN = 2 or 3 and Person.RESAST = 1. 3
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 any Contract.ACEMPFUN = 2 or 3 and Person.RESAST = 1. 2
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. 2
Person RESAST Error Person.RESAST must not exist where all Contract.TERMS = 3. 3
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 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.