COMMIT-stage validation
Back to C11025
COMMIT-stage validation
Version 1.0 Produced 2011-04-27
COMMIT-stage validation checks are only run once a COMMIT request has been received from the institution by the data collection system. These checks can only operate within a database-type environment and, therefore, cannot be included in the submission-level validation kits.
Validation errors
Number |
Text |
|---|---|
| 11025001 | No two records on the person table can have the same STAFFID |
| 11025002 | For every STAFFID returned on the person table, there must be at least one record on the contract table |
| 11025003 | For every STAFFID on the contract table, there must be one record on the person table |
| 11025004 | The combination of CONTID and STAFFID must be unique within an institution |
| 11025006 | PREVEMP must be completed with a valid code, other than the default code, when any of ACT1, ACT2, ACT3 = '1', '2A', '2B', '3A', '3B', '3C' and the member of staff is not classed as 'Atypical' |
| 11025007 | PREVHEI must be completed with a valid code, other than the default code, when any of ACT1, ACT2, ACT3 = '1', '2A', '2B', '3A', '3B', '3C' and PREVEMP = '01' and DATEFHEI after 31 July of the reporting period (excluding 9999-12-31) and the member of staff is not classed as 'Atypical' |
| 11025008 | HQHELD must be completed with a valid code, other than the default code, when any of ACT1, ACT2, ACT3 = '1', '2A', '2B', '3A', '3B', '3C' and the member of staff is not classed as 'Atypical' |
| 11025009 | ACCDIS1 must be completed with a valid code, other than the default code, when any of ACT1, ACT2, ACT3 = '1', '2A', '2B', '3A', '3B', '3C' and HQHELD = '01-03', '09', '11-12', '19', '21', '22', '29' and the member of staff is not classed as 'Atypical' |
| 11025010 | REGBODY must be completed with a valid code, other than the default code, when any of ACT1, ACT2, ACT3 = '2A' and the related cost centre field has been coded '01-08', '29' and the member of staff is not classed as 'Atypical' |
| 11025011 | ABLWELSH must be completed with a valid code, other than the default code, when the contract held is with a Welsh institution and any of ACT1, ACT2, ACT3 = '2A' and the member of staff is not classed as 'Atypical' |
| 11025012 | LEDEST must be completed with a valid code, other than the default code, when any of ACT1, ACT2, ACT3 = '1', '2A', '2B', '3A', '3B', '3C' and the member of staff has left the HEI and the member of staff is not classed as 'Atypical' |
| 11025017 | The sum of the CONFTE for all contracts should not be more than 200% for any one individual |
| 11025018 | Incorrect INSTID in Person data |
| 11025036 | If the member of staff has left the HEI (i.e. DATELEFT not set to 9999-12-31), then all the standard contract records (i.e. TERMS not set to 3) for this person must have ended (i.e. ENDCON not set to 9999-12-31) |
| 11025037 | Any member of staff who was included in the Muster List last year must be returned in this year's staff data. This list included all members of staff holding a non-Atypical contract, with activity code '1', '2A', '2B', '3A', '3B', '3C', who did not finish during the last reporting period |
| 11025038 | Any new member of staff with any of ACT1, ACT2, ACT3 = '1', '2A', '2B', '3A', '3B', '3C' and the member of staff is not classed as 'Atypical', must have a valid DATEFHEI (other than the default date) |
| 11025048 | CAMPID must contain a valid CAMPID as held in the CAMPUS information returned to HESA |
| 11025053 | GRADID must contain a valid GRADID as held in the GRADE table |
| 11025061 | INSTGRAD must be unique within an institution's return |
| 11025063 | Indeterminate GENDER used more than once within an institution's return |
| 11025064 | Incorrect INSTID in Contract data |
| 11025065 | Incorrect INSTID in Grade data |
| 11025066 | Missing salary information in SALREF |
| 11025067 | Missing spine information in SPOINT |
| 11025070 | MINSAL is lower than the salary in the Framework Agreement for the spine point in MINSPINE |
| 11025089 | The proportion of non-Atypical Academic staff that have been returned as having a professorial contract exceeds 25% |
| 11025090 | The proportion of non-Atypical staff that are Senior Management Post Holders exceeds 10% |
| 11025102 | Comparing last year's Staff data with this year's Staff data, GENDER should be the same |
Validation warnings
Number |
Text |
|---|---|
| 11025021 | Comparing last year's Staff data with this year's Staff data, BIRTHDTE should be the same |
| 11025023 | Comparing last years Staff data with this year's Staff data, HQHELD is not known this year but was known last year |
| 11025025 | DATELEFT must be completed with a valid code, other than the default code, when the member of staff has left the HEI and is not classed as 'Atypical' |
| 11025026 | Comparing last year's Staff data with this year's Staff data, DATEFHEI should be the same |
| 11025027 | Comparing last year's Staff data with this year's Staff data, ETHNIC should be the same |
| 11025029 | Comparing last year's Staff data with this year's Staff data, PREVHEI should be the same |
| 11025030 | Comparing last year's Staff data with this year's Staff data, PREVEMP should be the same |
| 11025031 | Comparing last year's Staff data with this year's Staff data, ACCDIS1 will not usually change |
| 11025032 | Comparing last year's Staff data with this year's Staff data, ACCDIS2 will not usually change |
| 11025033 | Comparing last year's Staff data with this year's Staff data, NATID1 should be the same |
| 11025034 | Comparing last year's Staff data with this year's Staff data, NATID2 should be the same |
| 11025035 | Comparing last year's Staff data with this year's Staff data, REGBODY should be the same |
| 11025039 | Any existing member of staff with any of ACT1, ACT2, or ACT3 = '1', '2A', '2B', '3A', '3B' or '3C' and the member of staff is not classed as 'Atypical', should have a valid DATEFHEI date other than the default date |
| 11025040 | Any member of staff that has left during the reporting period with any of ACT1, ACT2, ACT3 = '1', '2A', '2B', '3A', '3B', '3C', and the member of staff is not classed as 'Atypical', should have a valid LEDEST code of 01-15, 21, 22, 31 |
| 11025041 | All new members of staff (excluding Atypicals) where PREVEMP is unknown |
| 11025042 | CONFTE should NOT be 000.00 unless an exception has been agreed for this STAFFID |
| 11025043 | Full-time contract with CONFTE of less than 080.0 (not a starter or leaver within the reporting period) |
| 11025047 | Comparing last year's Staff data with this year's Staff data, are you sure SALREF should change by this amount? |
| 11025054 | SALREF contains a value greater than MAXSAL in the GRADE table |
| 11025055 | SALREF contains a value less than MINSAL in the GRADE table |
| 11025056 | SPOINT contains a value greater than MAXSPINE in the GRADE table |
| 11025057 | SPOINT contains a value less than MINSPINE in the GRADE table |
| 11025060 | This grade identifier (INSTGRAD) has not been used in the Contract table (GRADID) |
| 11025071 | MINSAL is more than 30% greater than the salary in the Framework Agreement for the spine point in MINSPINE |
| 11025072 | MAXSAL is more than 30% greater than the salary in the Framework Agreement for the spine point in MAXSPINE |
| 11025073 | Part time contracts of more than 90% CONFTE (excluding term-time only), are these genuinely part time or should they be full time? |
| 11025074 | Atypical contracts of more than 50% CONFTE, are these genuinely Atypical contracts? |
| 11025075 | All Staff under 16 years of age at start of contract (STARTCON) |
| 11025078 | All Staff (excluding Atypicals) with duplicate disability in DISABLE1 and DISABLE2 |
| 11025079 | All staff with 10 or more contracts |
| 11025080 | All SOC2A Staff (including Atypicals) not teaching and/or research |
| 11025081 | All staff (excluding Atypicals) with salaries between £4500 and £10000 |
| 11025082 | All Staff (excluding Atypicals) with Professorial contracts or Senior management post holders with salaries less than 50k |
| 11025083 | All Staff (excluding Atypicals) with salaries over 150k |
| 11025084 | All Staff (excluding Atypicals) with zero salary information (SALREF / SPOINT), can this be provided? |
| 11025085 | All Staff with HSPEC default (XX), and clinical status (not 0 or X) |
| 11025086 | All Staff with contracts with 'other' Grade (900) |
| 11025087 | The following staff 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 institution this year. Can this data be provided for all those staff who have not previously worked at your institution? |
| 11025088 | All Staff (including Atypicals) with CONFTE 000.0 and ENDCON after 31 July of the reporting period |
| 11025091 | Comparing last year's Staff data with this year's Staff data, DISABLE1 will not usually change |
| 11025092 | Comparing last year's Staff data with this year's Staff data, DISABLE2 will not usually change |
| 11025093 | All non-Atypical staff where DISABLE2 returned but no DISABLE1. Please return the disability in DISABLE1 |
| 11025094 | All non-Atypical staff where BIRTHDTE is unknown |
| 11025095 | All Atypical staff where BIRTHDTE is unknown |
| 11025096 | All non-Atypical staff where GENDER is unknown |
| 11025097 | All Atypical staff where GENDER is unknown |
| 11025101 | Comparing last year's Staff data with this year's Staff data, GENDER should be the same |
| 11025103 | Comparing last year's Staff data with this year's Staff returns, if the same STAFFID appears in both returns, and last years GENDER = '0', then GENDER should not = '9' |
| 11025104 | BIRTHDTE, GENDER, NATION, ETHNIC, DATEFHEI, PREVEMP, PREVHEI for non-atypical staff match but have different STAFFIDs |
