Staff record 2014/15
Business stage quality rules
Version 1.1 Produced 2015-04-30
The Business stage quality rules have been updated for the 2014/15 collection.
Entity Name | Field Name | Severity | Description | Number |
Person | ABLWELSH | ERROR | Person.ABLWELSH must not exist for providers in England, Scotland or Northern Ireland. | 1 |
Person | ABLWELSH | ERROR | Person.ABLWELSH must exist for providers in Wales where any (Contract.ACEMPFUN = 1 or 3 and Contract.TERMS = 1 or 2). | 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 |
Person | ACTCHQUAL | ERROR | Person.ACTCHQUAL must exist for providers 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 |
Contract | Activity | ERROR | There must not be more than three occurrences of Contract.Activity where ((Contract.LEVELS does not equal A0, B1, B2, C1, C2, D1 or D2) and Contract.ACEMPFUN does not equal 4 and (any Activity.ACTSOC = major groups 1, 2 or 3)). | 1 |
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 |
Activity | ACTSOC | ERROR | There must not be multiple occurrences of the same Activity.ACTSOC and Activity.CCENTRE on the same Contract.CONTID | 1 |
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 |
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 |
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 |
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 | 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 |
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 | DATEFHEI | ERROR | Person.DATEFHEI must exist where any Contract.TERMS = 1 or 2. | 1 |
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 |
Contract | ENDCON | ERROR | Contract.ENDCON must exist where Contract.TERMS = 1 or 2. If the Contract has not ended an empty element must be returned. | 1 |
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 |
Person | ETHNIC | ERROR | For providers in England and Wales Person.ETHNIC must not equal 13, 14 or 19. | 1 |
Person | ETHNIC | ERROR | For providers in Scotland Person.ETHNIC must not equal 10 or 14. | 2 |
Person | ETHNIC | ERROR | For providers in Northern Ireland Person.ETHNIC must not equal 13 or 19. | 3 |
Contract | HEIJOINT | ERROR | Contract.HEIJOINT must not be the returning provider. | 1 |
Contract | HEIJOINT | WARNING | Contract.HEIJOINT should not exist where Contract.TERMS is not equal to 1 or 2. | 2 |
Person | HQHELD | ERROR | Person.HQHELD must exist where (Contract.TERMS = 1 or 2) and any Activity.ACTSOC begins with 1, 2 or 3 | 1 |
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 |
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 providers in Wales. | 1 |
Person | NATIOND | ERROR | Person.NATIOND must not exist for providers 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 |
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 |
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 | PREVEMP | ERROR | Person.PREVEMP must not equal 20 where Person.DATEFHEI is after 2014-07-31 | 3 |
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 |
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 |
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 providers in England and Wales Person.RELBLF must not equal 04, 05, 06, 07, 08 or 09. | 1 |
Person | RELBLF | ERROR | For providers in Scotland Person.RELBLF must not equal 03, 06, 07 or 08. | 2 |
Person | RELBLF | ERROR | For providers in Northern Ireland Person.RELBLF must not equal 03 or 04. | 3 |
Contract | RESAST | ERROR | Contract.RESAST must exist where Contract.ACEMPFUN = 2 and Contract.TERMS = 1 or 2. | 1 |
Contract | RESAST | ERROR | Contract.RESAST must not exist where Contract.ACEMPFUN does not equal 2 or Contract.TERMS = 3. | 2 |
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 500000. | 1 |
Contract | SALREF | ERROR | Where Contract.SALREF exists, then Contract.SALREF must not be less than 4900. | 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 |
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 |
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 |
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-1230 or 3001 (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 |
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. If the Contract.STARTCON is not known an empty element must be returned. | 3 |
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 providers in England, Scotland or Northern Ireland. | 1 |
Contract | TCHWLH | ERROR | Contract.TCHWLH must exist for Welsh providers 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 |
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.