Staff record 2012/13
COMMIT-stage validation
Version 1.4 Produced 2013-09-25
This document lists the COMMIT validation checks that will be applied during the COMMIT transaction of the data collection system. An explanation of the different stages of validation is shown in the Validation overview document.
Validation Checks at COMMIT
| Field Name | Number | Severity | Rule |
|---|---|---|---|
| Activity.ACTSOC | 1 | Error | Activity.ACTSOC must be 231 where Contract.LEVELS = A0. |
| Activity.CCENTRE | 1 | Error | The Activity.CCENTRE code must be one of AcademicCostCentres.ACCENTRE codes submitted for the Institution profile record. |
| Contract.CAMPID | 1 | Error | Contract.CAMPID must have been submitted in the Institution profile collection. |
| Contract.CLINICAL | 1 | Warning | An institution has a Medical or Dental school but has not returned any Contract.CLINICAL = 1. |
| Contract.CONFTE | 1 | Warning | Contract.CONFTE should not be less than 80.0 where (Contract.MOEMP = 1 and Contract.STARTCON < '(Y1)-08-01' and Contract.ENDCON is null) |
| Contract.CONFTE | 2 | Warning | Contract.CONFTE should not be greater than 90.0 where Contract.MOEMP = 3 or 4. |
| Contract.CONFTE | 3 | Warning | Contract.CONFTE should not be greater than 50.0 where Contract.MOEMP = 5. |
| Contract.CONFTE | 4 | 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 is null)). |
| Contract.CONFTE | 5 | Error | Total of Contract.CONFTE for all the contract records for a person must not be greater than 200. |
| Contract.LEVELS | 1 | Warning | More than 10 people or 2% (whichever is less) where Contract.LEVELS = B1. |
| Contract.LEVELS | 2 | Error | Contract.LEVELS = A0 must exist at least once and no more than twice for an institution. |
| Contract.RESCON | 1 | Warning | Where Contract.RESCON = 1 there should be another contract where Contract.STARTCON is greater than or equal to the Contract.ENDCON of the initial contract. Except where any Contract.STARTCON does not exist. |
| Contract.SALREF | 1 | Warning | Contract.SALREF should not be between 4500 and 10000 where (Contract.TERMS = 1 or 2 and Contract.MOEMP in (1,2,3,4,6) and Person.BIRTHDTE <= '(Y1-18)-07-31'). |
| Contract.SALREF | 2 | 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% |
| Contract.SALREF | 3 | Warning | Contract.SALREF should not be greater than 150000 where (Contract.MOEMP in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS does not equal A0). |
| Contract.SALREF | 5 | 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) |
| Contract.SPOINT | 1 | Warning | Contract.SPOINT should start with C where Contract.CLINICAL does not equal 0. |
| Contract.SPOINT | 2 | Error | Contract.SPOINT must contain a valid entry. |
| Contract.STARTCON | 1 | 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) |
| Person.ABLWELSH | 1 | Warning | More than 5% of staff where Person.ABLWELSH = 9. |
| Person.ACTCHQUAL | 1 | Warning | Where multiple occurrences of Person.ACTCHQUAL exist for a single Person.STAFFID, and an occurrence of Person.ACTCHQUAL does not equal 90 or 99, then no other occurrence of Person.ACTCHQUAL should equal 90 or 99. |
| Person.ACTLEAVE | 1 | Warning | Where Person.ACTLEAVE = 05 then Person.LOCLEAVE should be in (1, 2, 3, 4, 5). |
| Person.ACTLEAVE | 2 | Warning | Where Person.ACTLEAVE = 11 at least one Contract.RESCON should equal 7. |
| Person.ACTLEAVE | 3 | Warning | More than 5% of staff have Person.ACTLEAVE = 11 and Person.BIRTHDTE after '(Y1-50)-07-31' |
| Person.BIRTHDTE | 1 | Warning | If the same Person.STAFFID appears in both last year's and this year's Staff returns, and (Person.BIRTHDTE does not equal '99991231' or '19010101' in last year's return), then Person.BIRTHDTE should be consistent. |
| Person.DATEFHEI | 1 | Warning | If the same Person.STAFFID appears in both last year's and this year's Staff returns, and the Person.DATEFHEI does not equal '99991231' in last year's return, then Person.DATEFHEI should be consistent. |
| Person.DISABLE | 1 | Warning | If the same Person.STAFFID appears in both last year's and this year's Staff returns, and Person.DISABLE1 does not equal 97 and Person.DISABLE2 = XX in last year's return then Person.DISABLE should be consistent. |
| Person.DISABLE | 2 | Warning | More than 5% of staff where (Person.DISABLE2 does not equal XX in last year's return and Person.DISABLE does not equal 08 this year). |
| Person.DISABLE | 3 | Warning | More than 98% of staff where Person.DISABLE = 00. |
| Person.ETHNIC | 1 | Warning | If the same Person.STAFFID appears in both last year's and this year's Staff returns, and (Person.ETHNIC was not in (11, 12, 14, 19, 90, 98) last year's return, and Person.ETHNIC is not equal to 98 in this year's return), then Person.ETHNIC should be consistent. |
| Person.ETHNIC | 2 | 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). |
| Person.ETHNIC | 3 | Warning | For institutions in England, Wales, or Northern Ireland, more than 20% of staff have (Person.ETHNIC = 11 or 12 in last year's return and Person.ETHNIC does not equal 10 in this year's return). |
| Person.ETHNIC | 4 | Warning | For institutions in Northern Ireland, more than 20% of staff have (Person.ETHNIC = 14 in last year's return and Person.ETHNIC does not equal 14 or 15 in this year's return). |
| Person.ETHNIC | 5 | Warning | For institutions in Scotland, where Person.ETHNIC = 11, 12 or 19 in last year's return, Person.ETHNIC does not equal 19 in this year's return. |
| Person.ETHNIC | 6 | Warning | For institutions in England, Wales or Northern Ireland, where Person.ETHNIC = 19 in last year's return, Person.ETHNIC does not equal 10 in this year's return. |
| Person.GENDERID | 1 | Warning | More than 20% of staff where Person.GENDERID = 02. |
| Person.HQHELD | 1 | Warning | If the same Person.STAFFID appears in both last year's and this year's Staff returns, and Person.HQHELD does not equal 98, 99 or XX in last year's return, then Person.HQHELD should not equal 98 or 99 in this year's return. |
| Person.HQHELD | 2 | 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. |
| Person.HQHELD | 3 | Warning | If 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. |
| Person.LOCLEAVE | 1 | 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. |
| Person.NATION | 1 | Warning | If 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, then Person.NATION should be consistent. |
| Person.NATIOND | 1 | Warning | Where there is an occurrence of Person.NATIOND = R or U, then no other occurrence of Person.NATIOND should exist. |
| Person.NATIOND | 2 | Warning | If the same Person.STAFFID appears in both last year's and this year's Staff returns for institutions in Wales, and Person.NATID1 does not equal U or X in last year's return, then an occurrence of Person.NATIOND should be consistent. |
| Person.NATIOND | 3 | Warning | If the same Person.STAFFID appears in both last year's and this year's Staff returns for institutions in Wales, and Person.NATID2 does not equal X in last year's return, then an occurrence of Person.NATIOND should be consistent. |
| Person.PARLEAVE | 1 | Warning | More than 20% of staff have Person.PARLEAVE = 1 and Person.SEX does not equal 2. |
| Person.PARLEAVE | 2 | Warning | More than 20% of staff have Person.PARLEAVE = 2 and Person.SEX does not equal 1. |
| Person.PREVEMP | 1 | Warning | If 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 XX or 99 in last year's return, then Person.PREVEMP should be consistent between years. Except where there are Person.PREVEMP = 05 in last year's return then Person.PREVEMP can equal 05, 16, or 18 this year, or where Person.PREVEMP = 06 in last year's return then Person.PREVEMP can equal 06, 17, or 19 this year. |
| Person.PREVEMP | 2 | 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. |
| Person.PREVEMP | 3 | Warning | If the same Person.STAFFID appears in both last year's and this year's Staff returns, and Person.PREVEMP does not equal 99 or XX in last year's return, then Person.PREVEMP should not equal 99 in this year's return. |
| Person.PREVHEI | 1 | Warning | If the same Person.STAFFID appears in both last year's and this year's Staff returns, and Person.PREVHEI does not equal 4001 or XXXX in last year's return, then Person.PREVHEI should be consistent. |
| Person.PREVHEI | 2 | Error | Where Person.PREVEMP = 01, then Person.PREVHEI must not be the same as the returning institution. |
| Person.PREVHEI | 3 | Error | Where Person.PREVEMP = 21 and Person.PREVHEI exists it must be the same as the returning institution. |
| Person.REGBODY | 1 | 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 and does not equal 00, 04 or XX in last year's return, then an occurrence of Person.REGBODY should be consistent. |
| Person.RESAST | 1 | Warning | If a member of staff holds multiple contracts, and at least one Contract.ACEMPFUN does not equal 2, then Person.RESAST should equal 1. |
| Person.SEX | 1 | Warning | If the same Person.STAFFID appears in both last year's and this year's Staff returns, and Person.GENDER = 1 or 2 in last year's return then Person.SEX should be consistent. |
| Person.SEXORT | 1 | Warning | More than 5% of staff have Person.SEXORT = 02 and Person.SEX does not equal 1. |
| Person.SEXORT | 2 | Warning | More than 5% of staff have Person.SEXORT = 03 and Person.SEX does not equal 2. |
| Person.SEXORT | 3 | Warning | More than 20% of staff where Person.SEXORT = 05. |
| Person.STAFFID | 1 | Warning | The following staff have been given new Person.STAFFID when a previous ID exists (based on their Person.PREVHEI and Person.PREVEMP) and the member of staff is new at your institution this year. |
| Person.STAFFID | 2 | Warning | All staff with 10 or more contracts. |
| Person.STAFFID | 3 | Warning | Potential duplicate entries for non-atypical staff exist but have different Person.STAFFIDs. |
| Person.STAFFID | 4 | Error | If a member of staff was included in last year's Staff return, where any contract record for this person has (Contract.ACT1, or Contract.ACT2, or Contract.ACT3 = 1, 2A, 2B, 3A, 3B, 3C and Contract.TERMS = 1 or 2 and Contract.ENDCON = '9999-12-31') and Person.DATELEFT = '9999-12-31' in last year's return, then a record must be included in this year's Staff return. |
| Person.STAFFID | 5 | Error | The combination of Person.STAFFID and Contract.CONTID field must be unique within an HEI's submission. |
Contact Liaison by email or on +44 (0)1242 388 531.