C08025 COMMIT Stage Validation Rules

 

Staff Collection 2008/09

COMMIT stage validation rules

Version 1.5 Produced 2009-08-28

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

Specification

Text

8025001 No two records on the person table can have the same STAFFID No two records on the person table can have the same STAFFID
8025002 For every STAFFID returned on the person table there must be at least one record on the contract table For every STAFFID returned on the person table there must be at least one record on the contract table
8025003 For every STAFFID on the contract table there must be one record on the person table For every STAFFID on the contract table there must be one record on the person table
8025004 The combination of CONTID and STAFFID must be unique within an institution The combination of CONTID and STAFFID must be unique within an institution
8025006 If any contract record for this person record has (ACT1, ACT2 or ACT3 = 1, 2A, 2B, 3A, 3B, 3C and TERMS<>3) then PREVEMP must not be XX PREVEMP must be completed with a valid code other than the default code when any of ACT1, ACT2, or ACT3 = ‘1’, ‘2’ or ‘3’ and the member of staff is not classed as ‘atypical’
8025007 If PREVEMP=01 and (DATEFHEI>20080731 and DATEFHEI<>99991231) and any contract record for this person has (ACT1, ACT2 or ACT3 = 1, 2A, 2B, 3A, 3B, 3C and TERMS<>3) then PREVHEI must not be XXXX PREVHEI must be completed with a valid code other than the default code when any of ACT1, ACT2, or ACT3 = ‘1’, ‘2’ or ‘3’ and PREVEMP =‘01’ and DATEFHEI > 20080731 (excluding 99991231) and the member of staff is not classed as ‘atypical’
8025008 If any contract record for this person has (ACT1, ACT2 or ACT3 = 1, 2A, 2B, 3A, 3B, 3C and TERMS<>3) then HQHELD must not be XX HQHELD must be completed with a valid code other than the default code when any of ACT1, ACT2, or ACT3 = ‘1’, ‘2’ or ‘3’ and the member of staff is not classed as ‘atypical’
8025009 If (HQHELD is 01, 02, 03, 09, 11, 12, 19, 21, 22 or 29) and any contract record for this person has (ACT1, ACT2 or ACT3 = 1, 2A, 2B, 3A, 3B, 3C and TERMS<>3) then ACCDIS1 must not be XXXX ACCDIS1 must be completed with a valid code other than the default code when any of ACT1, ACT2, or ACT3 = ‘1’, ‘2’ or ‘3’ and HQHELD= ‘01-03’, ‘09’, ’11-12’, ‘19’, ‘21’, ‘22’ or ‘29’ and the member of staff is not classed as ‘atypical’
8025010 If any contract record for this person has ((ACT1=2A and CCENTRE1=01- 09 or 29) or (ACT2 =2A and CCENTRE2=01- 09, or 29) or (ACT3 = 2A and CCENTRE3=01- 09, or 29) and TERMS <> 3 then REGBODY must not be XX REGBODY must be completed with a valid code other than the default code when any of ACT1, ACT2, or ACT3 = ‘2A’ and the related cost centre field has been coded ‘01-09’ or ‘29’ and the member of staff is not classed as ‘atypical’
8025011 If this is a Welsh institution and any contract record for this person has (ACT1, ACT2 or ACT3 = 2A and TERMS<>3) then ABLWELSH must not be X 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, or ACT3 =‘2A’ and the member of staff is not classed as ‘atypical’
8025012 If DATELEFT<>99991231 and any of the contract records for this person has (ACT1, ACT2, ACT3 = 1, 2A, 2B, 3A, 3B, 3C and TERMS<>3) then LEDEST must not be XX LEDEST must be completed with a valid code other than the default code when any of ACT1, ACT2, or ACT3= ‘1’, ‘2’ or ‘3’ and the member of staff has left the HEI and the member of staff is not classed as ‘atypical’
8025017 If sum of CONFTE for all the contract records for this person is greater than 200 then fail Check to reject any individuals for whom the sum of their CONFTE for all contracts is more than 200%
8025018 Incorrect instid in Person file if it does not match the submitting institution Incorrect INSTID in Person data
8025020 Comparing the 2007/08 and 2008/09 Staff returns, if the same STAFFID appears in both returns and GENDER is 2 in 2008/09 and was M in 2007/08, or is 1 in 2008/09 and was F in 2007/08, or is 9 in 2008/09 and was F, M or U in 2007/08 or is 0 in 2008/09 and was M or F in 2007/08, then GENDER should be consistent
Comparing 2007/08 Staff data with this years Staff data, GENDER should be the same
8025036 If DATELEFT <> 99991231 then all of the contract records, except where TERMS=3, for this person must have ENDCON<>99991231 If the member of staff has left the HEI (DATELEFT <> 99991231) then all the standard (TERM<>3) contract records for this person must have ended (ENDCON<>99991231).
8025037 If a member of staff was included in the 2007/08 Staff person table, and if any contract record for this person had (ACT1, ACT2, ACT3 = 1, 2A, 2B, 3A, 3B or 3C and TERMS <>3 and ENDCON = 99991231) and DATELEFT = 99991231 in that return, a record must be included on the 2008/09 STAFF person table 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 or 3C, which did not finish during the reporting period 2007/08.
8025038 If a member of staff was NOT included in the 2007/08 Staff person table, and if any contract record for this person has (ACT1, ACT2, ACT3 = 1, 2A, 2B, 3A, 3B or 3C and TERMS <>3), then DATEFHEI <> 99991231 Any new member of staff with any of ACT1, ACT2, or ACT3 = ‘1’, ‘2’ or ‘3’ and the member of staff is not classed as ‘atypical’, must have a valid DATEFHEI other than the default date
8025048 CAMPID must contain a valid CAMPID as held in the CAMPUS information returned to HESA CAMPID must contain a valid CAMPID as held in the CAMPUS information returned to HESA
8025053
GRADID must contain a valid entry from INSTGRAD, 400, 410, 420, 430, 500, 510, 520, 900 or XXXXXXXXXX
GRADID must contain a valid GRADID as held in the GRADE table.
8025061 INSTGRAD must be unique within an institution's return INSTGRAD must be unique within an institution's return
8025063 If the number of code 9 in GENDER is > 1 in an institution’s return then error
GENDER Indeterminate (code 9) used more than once within an institution’s return
8025064
Incorrect INSTID in Contract file if it does not match the submitting institution
Incorrect INSTID in Contract data
8025065
Incorrect INSTID in Grade file if it does not match the submitting institution
Incorrect INSTID in Grade data
8025066
Where TERMS<>3, if MAXSAL is not XXXXXXX and MAXSPINE is not F99, then the corresponding SALREF must not be XXXXXXX. Missing salary information in SALREF
8025067 Where TERMS<>3, if MAXSPINE is not XXX or F99, then the corresponding SPOINT must not be XXX. Missing spine information in SPOINT
8025070 If MINSAL is not XXXXXXX and MINSPINE is not XXX, then MINSAL must not be less than the salary for the corresponding spine point for MINSPINE on the Framework Agreement look-up. MINSAL is lower than the salary in the Framework Agreement for the spine point in MINSPINE.

Validation warnings 

Number

Specification

Text

8025021 Comparing the 2007/08 and 2008/09 Staff returns, if the same STAFFID appears in both returns and BIRTHDTE is not coded 99991231 or 19010101 (unknown) in 2007/08, then BIRTHDTE should be consistent Comparing 2007/08 Staff data with this years Staff data, BIRTHDTE should be the same
8025023 If the same STAFFID appears in both the 2007/08 and 2008/09 Staff returns, and HQHELD is not coded 99 (unknown) or XX (not applicable/required) in 2007/08 return, then HQHELD must not be coded 99 (unknown) in the 2008/09 return for the same STAFFID Comparing 2007/08 Staff data with this years Staff data, HQHELD is not known this year
8025025 If all of the contract records for this person have (ENDCON<>99991231 and TERMS<>3) then DATELEFT must not be 99991231 DATELEFT must be completed with a valid code other than the default code when the member of staff has left the HEI and the member of staff is not classed as ‘atypical’
8025026 Comparing the 2007/08 and 2008/09 Staff returns, if the same STAFFID appears in both returns and DATEFHEI is not coded 99991231 in either return, then DATEFHEI should be consistent Comparing 2007/08 Staff data with this years Staff data, DATEFHEI should be the same
8025027 Comparing the 2007/08 and 2008/09 Staff returns, if the same STAFFID appears in both returns, and ETHNIC was coded other than 90 (not known) or 98 (information refused) last year, then ETHNIC must be consistent Comparing 2007/08 Staff data with this years Staff data, ETHNIC should be the same
8025029 Comparing the 2007/08 and 2008/09 Staff returns, if the same STAFFID appears in both returns and PREVHEI is not coded XXXX in either return, then PREVHEI should be consistent Comparing 2007/08 Staff data with this years Staff data, PREVHEI should be the same
8025030 Comparing the 2007/08 and 2008/09 Staff returns, if the same STAFFID appears in both returns and PREVEMP is not coded XX in either return, and PREVEMP is not coded 99 in 2007/08, then PREVEMP should be consistent Comparing 2007/08 Staff data with this years Staff data, PREVEMP should be the same
8025031 Comparing the 2007/08 and 2008/09 Staff returns, if the same STAFFID appears in both returns and ACCDIS1 is not coded XXXX in either return, then ACCDIS1 must be consistent Comparing 2007/08 Staff data with this years Staff data, ACCDIS1 should be the same
8025032 Comparing the 2007/08 and 2008/09 Staff returns, if the same STAFFID appears in both returns and ACCDIS2 is not coded XXXX in either return, then ACCDIS2 should be consistent Comparing 2007/08 Staff data with this years Staff data, ACCDIS2 should be the same
8025033 Comparing the 2007/08 and 2008/09 Staff returns, if the same STAFFID appears in both returns, and NATID1 was coded other than R (information refused) or U (unknown), then NATID1 should be consistent Comparing 2007/08 Staff data with this years Staff data, are you sure NATID1 should change?
8025034 Comparing the 2007/08 and 2008/09 Staff returns, if the same STAFFID appears in both returns, and NATID2 contains a valid code, then NATID2 should be consistent Comparing 2007/08 Staff data with this years Staff data, are you sure NATID2 should change?
8025035 Comparing the 2007/08 and 2008/09 Staff returns, if the same STAFFID appears in both returns and REGBODY is not coded XX in either return, then REGBODY should be consistent Comparing 2007/08 Staff data with this years Staff data, are you sure REGBODY should change?
8025039 If a member of staff was included in the 2007/08 Staff person table, and if any contract record for this person has (ACT1, ACT2, ACT3 = 1, 2A, 2B, 3A, 3B or 3C and TERMS <>3), then DATEFHEI <> 99991231 Any existing member of staff with any of ACT1, ACT2, or ACT3 = ‘1’, ‘2’ or ‘3’ and the member of staff is not classed as ‘atypical’, should have a valid DATEFHEI date other than the default date
8025040 (If DATELEFT>= 20080801 and DATELEFT<>99991231) and any contract record for this person record has (ACT1, ACT2, ACT3 = 1, 2A, 2B, 3A, 3B, 3C and TERMS<>3) then LEDEST should not be 99 Any member of staff that has left during the reporting period with any of ACT1, ACT2, or ACT3 = ‘1’, ‘2’ or ‘3’ and the member of staff is not classed as ‘atypical’, should have a valid LEDEST code between 01-15, 21, 22, 31
8025041 (If DATEFHEI>= 20080801 and DATEFHEI<>99991231) and any contract record for this person record has (ACT1, ACT2, ACT3 = 1, 2A, 2B, 3A, 3B, 3C and TERMS<>3) then PREVEMP should not be 99 Any new member of staff with any of ACT1, ACT2, or ACT3 = ‘1’, ‘2’ or ‘3’ and the member of staff is not classed as ‘atypical’, should have a valid PREVEMP code between 01-21
8025042 If TERMS<>3 and (ENDCON>20080801 or ENDCON = 99991231) for this contract then CONFTE must not be 000.0 CONFTE should NOT be 000.00 unless an exception has been agreed for this STAFFID
8025043 If field 7 MOEMP is 1, and field 23 ENDCON = 99991231 and field 22 STARTCON < 20080801, then field 9 CONFTE must NOT be < 080.0 Full-time contract with CONFTE of less than 080.0 (not a starter or leaver within the reporting period)
8025047 Comparing the 2007/08 and 2008/09 Staff returns, the percentage change in field 17 SALREF between 2007/08 and 2008/09 should not be more that 25% Comparing 2007/08 Staff data with this years Staff data, are you sure SALREF should change?
8025054 SALREF contains a value greater than MAXSAL
SALREF contains a value greater than MAXSAL in the GRADE table
8025055 SALREF contains a value less than MINSAL
SALREF contains a value less than MINSAL in the GRADE table
8025056 SPOINT contains a value greater than MAXSPINE
SPOINT contains a value greater than MAXSPINE in the GRADE table
8025057 SPOINT contains a value less than MINSPINE
SPOINT contains a value less than MINSPINE in the GRADE table
8025060 Identify any INSTGRAD that have not been used in GRADID This grade identifier (INSTGRAD) has not been used in the Contract table (F033 GRADID)
8025071 Where MINSAL is not XXXXXXX and MINSPINE is not XXX, MINSAL is more than 30% greater than the salary for the corresponding spine point for MINSPINE on the Framework Agreement look-up MINSAL is more than 30% greater than the salary in the Framework Agreement for the spine point in MINSPINE
8025072
Where MAXSAL is not XXXXXXX and MAXSPINE is not XXX or F99, MAXSAL is more than 30% greater than the salary for the corresponding spine point for MAXSPINE on the Framework Agreement look-up
MAXSAL is more than 30% greater than the salary in the Framework Agreement for the spine point in MAXSPINE