Skip to main content

Staff record 2014/15

Back to C14025

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.