Skip to main content

Staff record 2014/15

Back to C14025

Exception stage quality rules

Version 1.0 Produced 2015-04-30

The Exception stage quality rules have been updated for the 2014/15 collection.

Entity Name Field Name Severity Description Number
Activity ACTSOC ERROR Activity.ACTSOC must be 231 where Contract.LEVELS = A0. 1
Activity CCENTRE ERROR The Activity.CCENTRE code must be one of AcademicCostCentres.ACCENTRE codes submitted for the Institution profile record. 1
Activity CCENTRE ERROR Where AcademicCostCentres.ACCENTRE have been submitted in the Institutional profile record but it is not coded in any occurrence of Activity.CCENTRE. 2
Contract CAMPID ERROR Contract.CAMPID must have been submitted in the Institution profile collection. 1
Contract CLINICAL WARNING A provider has a Medical or Dental school but has not returned any Contract.CLINICAL = 1. 1
Contract CONFTE WARNING Contract.CONFTE should not be less than 80.0 for more than 5% of contracts (and more than 5 contracts) where (Contract.MOEMP = 1 and Contract.STARTCON is before '(Y1)-08-01' and Contract.ENDCON does not exist). 1
Contract CONFTE WARNING Contract.CONFTE should not be greater than 90.0 for more than 5% of contracts (and more than 5 contracts) where Contract.MOEMP = 3 or 4. 2
Contract CONFTE WARNING Contract.CONFTE should not be greater than 50.0 for more than 5% of contracts (and more than 5 contracts) where Contract.MOEMP = 5. 3
Contract CONFTE ERROR Total of Contract.CONFTE for all the contract records for a person must not be greater than 200. 5
Contract LEVELS WARNING More than 10 people or 2% (whichever is less) where Contract.LEVELS = B1. 1
Contract LEVELS ERROR Contract.LEVELS = A0 must exist at least once and no more than twice for a provider. 2
Contract RESCON WARNING Where Contract.RESCON = 1 and Contract.ENDCON exists and does not equal '(Y2)-07-31' there should be another active contract on or after the Contract.ENDCON of this original contract. 1
Contract SALREF WARNING Contract.SALREF should not be between 4900 and 11500 where (Contract.TERMS = 1 or 2 and Contract.MOEMP in (1,2,3,4,6) and Person.BIRTHDTE <= '(Y1-21)-07-31'). 1
Contract SALREF WARNING Where Contract.SALREF exists, if the same Person.STAFFID and Contract.CONTID appears in the contract table in both last year's and this year's returns, then the percentage change in Contract.SALREF between year's should not be more than 25% 2
Contract SALREF WARNING Contract.SALREF should not be greater than 175000 where (Contract.MOEMP in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS does not equal A0). 3
Contract SALREF WARNING Contract.SALREF should not be less than 50000 where (Contract.MOEMP in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS = F1) 5
Contract SALREF WARNING Contract.SALREF should not be greater than 325000. 6
Contract SPOINT WARNING Contract.SPOINT should start with C where Contract.CLINICAL does not equal 0. 1
Contract SPOINT ERROR Contract.SPOINT must contain a valid entry. 2
Contract STARTCON WARNING Where exists Person.BIRTHDTE is less than 16 years of age at the start of contract (i.e. Contract.STARTCON - (minus) Person.BIRTHDTE < 16 years) and Contract.STARTCON greater than or on '(Y1)-08-01'. 1
Person ABLWELSH WARNING More than 5% of staff where Person.ABLWELSH = 9. 1
Person ACTCHQUAL WARNING Where Person.ACTCHQUAL = 90 or 99, then no other occurrence of Person.ACTCHQUAL should exist 1
Person ACTCHQUAL WARNING For providers in England, Northern Ireland and Wales more than 40% of staff where any (Contract.ACEMPFUN = 1 or 3 and Contract.TERMS = 1 or 2) have Person.ACTCHQUAL = 99. 2
Person ACTCHQUAL WARNING For providers in England, Northern Ireland and Wales more than 5% of staff where any (Contract.ACEMPFUN = 1 or 3 and Contract.TERMS = 1 or 2) have an occurrence of Person.ACTCHQUAL = 09. 3
Person ACTLEAVE WARNING Where Person.ACTLEAVE = 05 then Person.LOCLEAVE should be in (1, 2, 3, 4, 5). 1
Person ACTLEAVE WARNING More than 5% of staff have Person.ACTLEAVE = 11 and Person.BIRTHDTE after '(Y1-50)-07-31' 3
Person BIRTHDTE WARNING If the same Person.STAFFID appears in both last year's and this year's Staff returns and Person.BIRTHDTE exists in both returns then Person.BIRTHDTE should be consistent. 1
Person BIRTHDTE WARNING Where Person.BIRTHDTE exists and (Person.DATEFHEI is before (Y1)-08-01 or does not exist) then Person.BIRTHDTE should be between (Y1-100)-07-31 and (Y1-10)-08-01. 2
Person CLINARD WARNING More than 10% of staff members (and more than 10 staff) where Person.CLINARD differs between years, excluding where Person.CLINARD = 00 in last year's return. 1
Person DATEFHEI WARNING If the same Person.STAFFID appears in both last year's and this year's Staff returns, and the Person.DATEFHEI exists in both returns and there is no Contract.STARTCON after (Y1)-07-31, then Person.DATEFHEI should be consistent. 1
Person DISABLE WARNING More than 99.0% of staff where Person.DISABLE = 00. 3
Person ETHNIC WARNING More than 20% of staff where (Person.ETHNIC does not equal 90 or 98 in last year's return and Person.ETHNIC = 90 or 98 in this year's return). 2
Person GENDERID WARNING More than 20% of staff where Person.GENDERID = 02. 1
Person HQHELD WARNING If the same Person.STAFFID appears in both last year's and this year's Staff returns, and Person.HQHELD exists in both returns, and Person.HQHELD does not equal 97, 98 or 99 this year, then Person.HQHELD should not be greater than Person.HQHELD last year. Except within each of the following groupings ((03 and 09), (11,12 and 19), (22 and 29)). 2
Person HQHELD WARNING If (Person.DATEFHEI is greater than or equal to '(Y1)-08-01)' and any contract record for this person has (Contract.TERMS = 1 or 2 and any Activity.ACTSOC = major groups 1, 2 or 3) then Person.HQHELD should not equal 98. 3
Person LOCLEAVE WARNING Person.LOCLEAVE should not equal 8 where Person.DATELEFT > '(Y1)-07-31' and any contract record for this person has Contract.TERMS = 1 or 2. 1
Person NATION WARNING More than 5% of all staff where (the same Person.STAFFID appears in both last year's and this year's Staff returns, and Person.NATION does not equal ZZ in last year's return), have different Person.NATION in last year and this year. 1
Person NATIOND WARNING Where there is an occurrence of Person.NATIOND = R or U, then no other occurrence of Person.NATIOND should exist. 1
Person PARLEAVE WARNING There should not be more than 1% of staff where Person.PARLEAVE = 1 and Person.SEX = 1. 1
Person PARLEAVE WARNING There should not be more than 1% of staff where Person.PARLEAVE = 2 and Person.SEX = 2. 2
Person PREVEMP WARNING More than 5% of all staff where (the same Person.STAFFID appears in both last year's and this year's Staff returns and Person.PREVEMP exists in both returns, and Person.PREVEMP does not equal 99 in last year's return), have different Person.PREVEMP in last year and this year. 1
Person PREVEMP WARNING Where (Person.DATEFHEI > '(Y1)-07-31' and any contract record for this person record has (Activity.ACTSOC major groups 1, 2 or 3 and Contract.TERMS = 1 or 2), and XPOPP01 = 1) then Person.PREVEMP should not equal 99. 2
Person PREVHEI WARNING If the same Person.STAFFID appears in both last year's and this year's Staff returns and Person.PREVHEI does not equal 9999 in last year's return, and there is no Contract.STARTCON greater than or equal to '(Y1-08-01)', then Person.PREVHEI should be consistent. 1
Person PREVHEI ERROR Where Person.PREVEMP = 01, then Person.PREVHEI must not be the same as the returning provider. 2
Person PREVHEI ERROR Where Person.PREVEMP = 21 and Person.PREVHEI exists it must be the same as the returning provider. 3
Person REGBODY WARNING If the same Person.STAFFID appears in both last year's and this year's Staff returns, and Person.REGBODY exists in both returns, then an occurrence of Person.REGBODY should be consistent. 1
Person REGBODY WARNING Where Person.REGBODY exists, an occurrence of Person.REGBODY should equal 14 where all occurrences of Activity.CCENTRE = 109 2
Person SEX WARNING More than 5% of staff (where the same Person.STAFFID appears in both last year's and this year's Staff returns and Person.SEX exists in both last year's and this year's returns), have different Person.Sex. 1
Person SEXORT WARNING There should not be more than 10% of staff where Person.SEXORT = 02 and Person.SEX = 2. 1
Person SEXORT WARNING There should not be more than 10% of staff where Person.SEXORT = 03 and Person.SEX = 1. 2
Person SEXORT WARNING There should not be more than 5% of staff (and more than 5 records) where Person.SEXORT = 05. 3
Person STAFFID WARNING The following staff appear to have been given new STAFFID when a previous ID exists (based on their PREVHEI and PREVEMP) and the member of staff is new at your organisation this year and Person.PREVHEI not equal to 9999. 1
Person STAFFID WARNING All staff with 10 or more contracts. 2
Person STAFFID WARNING Potential duplicate entries for non-atypical staff exist but have different Person.STAFFIDs. 3
Person STAFFID ERROR If a member of staff was included in last year's Staff return, where any contract record for this person has (any Activity.ACTSOC major group 1, 2 or 3 and Contract.TERMS = 1 or 2 and Contract.ENDCON does not exist) and Person.DATELEFT does not exist in last year's return, then a record must be included in this year's Staff return. 4
Person STAFFID ERROR The combination of Person.STAFFID and Contract.CONTID field must be unique within a HEP's submission. 5
Person STAFFID ERROR No two records can have the same Person.STAFFID. 6

Need help?

Contact Liaison by email or on +44 (0)1242 388 531.