Staff record 2014/15
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.