Quality Rules Directory for C21025

QR.C21025.Activity.ACTSOC.1

There must not be multiple occurrences of the same Activity.ACTSOC and Activity.CCENTRE on the same Contract.CONTID

QR.C21025.Activity.ACTSOC.2

Activity.ACTSOC must be 231 (Teaching and Educational Professionals) where Contract.LEVELS = A0.

QR.C21025.Activity.CCPROP.1

Where only one Activity returned Activity.CCPROP must be 100

QR.C21025.Activity.CCPROP.2

Where Multiple Activity entities are returned the sum of all Activity.CCPROP must be in the range 99.7 and 100.3

QR.C21025.Contract.ACEMPFUN.1

Contract.ACEMPFUN (Academic employment function) must exist where any Activity.ACTSOC begins with 1, 2 or 3.

QR.C21025.Contract.ACEMPFUN.2

Contract.ACEMPFUN (Academic employment function) must not exist unless at least one Activity.ACTSOC under that Contract begins with 1, 2 or 3.

QR.C21025.Contract.ACEMPFUN.3

There are no occurrences of Contract.ACEMPFUN (Academic employment function) = 1, 2, 3 or 9 in the Staff return.

QR.C21025.Contract.Activity.1

There must not be more than three occurrences of Contract.Activity where ((Contract.LEVELS does not equal A0, B0, C1, C2, D1 or D2) and Contract.ACEMPFUN(Academic employment function) does not equal 4 and (any Activity.ACTSOC = major groups 1, 2 or 3)).

QR.C21025.Contract.CLINICAL.1

Contract.CLINICAL must exist where (Contract.ACEMPFUN = 1, 2 or 3) and (Contract.TERMS = 1 or 2) and any Activity.CCENTRE = 101, 102, 103, 104, 105, 106, 107, 108, 112, 127 or 131.

QR.C21025.Contract.CLINICAL.2

Contract.CLINICAL must not exist where all Activity.CCENTRE not equal to 101, 102, 103, 104, 105, 106, 107, 108, 112, 127 or 131.

QR.C21025.Contract.CLINICAL.3

A provider has a Medical or Dental school but has not returned any Contract.CLINICAL = 1.(Clinical academic doctors and dentists)

QR.C21025.Contract.CLINSUB.1

Contract.CLINSUB (Clinical sub-speciality) must exist where Contract.CLINICAL = 1.(Clinical academic doctors and dentists)

QR.C21025.Contract.CLINSUB.2

Contract.CLINSUB (Clinical sub-speciality) must not exist where Contract.CLINICAL not equal to 1.(Clinical academic doctors and dentists)

QR.C21025.Contract.CLINSUB.3

Where there is more than one occurrence of Contract.CLINSUB (Clinical sub-speciality) they must not be identical.

QR.C21025.Contract.CONFTE.1

Contract.CONFTE must be 0 where Contract.MOEMP (Mode of employment) = 6 (Dormant)

QR.C21025.Contract.CONFTE.2

Where Mode of employment(Contract.MOEMP is 3, 4 or 5) then Contract.CONFTE must not be 100.

QR.C21025.Contract.CONFTE.3

Where exists (Contract.ENDCON > (Y1)-07-31 and Contract.ENDCON < (Y2)-07-31), then Contract.CONFTE must not be 100

QR.C21025.Contract.CONFTE.4

Contract.CONFTE must not be 000.0 where mode of employment(Contract.MOEMP in (1, 2, 3, 4, 5) and (Contract.ENDCON > '(Y1)-07-31' or Contract.ENDCON does not exist).

QR.C21025.Contract.CONFTE.8

Total of Contract.CONFTE for all the contract records for a person must not be greater than 200.

QR.C21025.Contract.ENDCON.1

Contract.ENDCON should exist where Contract.TERMS = 1 or 2. If the Contract has not ended an empty element must be returned.

QR.C21025.Contract.ENDCON.2

Where exists Contract.ENDCON must be less than Y2-08-01

QR.C21025.Contract.ENDCON.3

Where exists Contract.ENDCON must be equal to or after the date returned in Contract.STARTCON.

QR.C21025.Contract.ENDCON.4

Contract.ENDCON must be before or equal to Person.DATELEFT where all Contract.TERMS = 1 or 2

QR.C21025.Contract.ENDCON.5

Where exists, Contract.ENDCON.5 should not be before (Y1-1)-08-01.

QR.C21025.Contract.HEIJOINT.1

Contract.HEIJOINT (HEP joint contract) must not be the returning provider.

QR.C21025.Contract.HEIJOINT.2

Contract.HEIJOINT (HEP joint contract) should not exist where Contract.TERMS is not equal to 1 or 2.

QR.C21025.Contract.HOURLYPAID.1

Contract.HOURLYPAID must exist where Contract.TERMS = 1 or 2.

QR.C21025.Contract.HSPEC.1

Contract.HSPEC (Healthcare professional speciality) must exist where Contract.CLINICAL = 1, 2, 3 or 4.

QR.C21025.Contract.HSPEC.2

Contract.HSPEC (Healthcare professional speciality) must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.

QR.C21025.Contract.HSPEC.3

Where there is more than one occurrence of Contract.HSPEC (Healthcare professional speciality) they must not be identical.

QR.C21025.Contract.LEVELS.4

Contract.LEVELS should not equal 'C2', 'E2', 'F2', 'N0', 'O0' or 'P0' where Contract.ACEMPFUN (Academic employment function) = '1', '2', '3' or '9'.

QR.C21025.Contract.LEVELS.5

Contract.LEVELS should not equal 'C1', 'D1', 'D2', 'D3', 'E1' or 'F1' where Contract.ACEMPFUN (Academic employment function)= '4' or null.

QR.C21025.Contract.NHSCON.1

Contract.NHSCON (NHS contracts) must exist where Contract.CLINICAL is equal to 1, 2, 3 or 4.

QR.C21025.Contract.NHSCON.2

Contract.NHSCON (NHS contracts) must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.

QR.C21025.Contract.NHSCONGR.1

Where Contract.STARTCON is after 2009-08-01 Contract.NHSCONGR (NHS contract grade) must not equal 02, 03, 06 or 07

QR.C21025.Contract.NHSCONGR.2

Contract.NHSCONGR (NHS contract grade) must exist where Contract.CLINICAL = 1, 2, 3 or 4.

QR.C21025.Contract.NHSCONGR.3

Contract.NHSCONGR (NHS contract grade) must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.

QR.C21025.Contract.PSCAG.1

Contract.PSCAG must exist where Contract.TERMS = 1 or 2.

QR.C21025.Contract.PSCAG.2

Where Contract.SOBS (Source of basic salary ) = 01 then Contract.PSCAG must be 100.

QR.C21025.Contract.PSCAG.3

Where Contract.SOBS (Source of basic salary ) not equal to 01 then Contract.PSCAG must not be 100.

QR.C21025.Contract.RESAST.1

Contract.RESAST (Research assistant) must exist where Contract.ACEMPFUN (Academic employment function) = 2 and Contract.TERMS = 1 or 2.

QR.C21025.Contract.RESAST.2

Contract.RESAST (Research assistant) must not exist where Contract.ACEMPFUN (Academic employment function) does not equal 2 or Contract.TERMS = 3.

QR.C21025.Contract.RESCON.1

Where Contract.RESCON (Reason for the end of contract) = 8 (Death) there must be no new contracts starting after that Contract.ENDCON.

QR.C21025.Contract.RESCON.2

Contract.RESCON (Reason for the end of contract) must exist where Contract.TERMS = 1 or 2 and Contract.ENDCON exists.

QR.C21025.Contract.RESCON.3

Contract.RESCON (Reason for the end of contract) must not exist where (Contract.ENDCON does not exist and Contract.TERMS = 1 or 2.)

QR.C21025.Contract.RESCON.5

Where Contract.RESCON equals 3 (End of fixed-term contract) Contract.TERMS must equal 2 (Fixed-term).

QR.C21025.Contract.RESCON.6

Where Contract.RESCON = 10 (Non-academic contract issued) the provider must be in England or Northern Ireland.

QR.C21025.Contract.SALREF.1

Where Contract.SALREF (Basic salary at reference date) exists, then Contract.SALREF must not be greater than 500000.

QR.C21025.Contract.SALREF.2

Where Contract.SALREF (Basic salary at reference date) exists, then Contract.SALREF must not be less than 7200.

QR.C21025.Contract.SALREF.3

Contract.SALREF (Basic salary at reference date) must not exist where Contract.SPOINT (Salary point) begins with C. (Clinical spine)

QR.C21025.Contract.SALREF.4

Contract.SALREF (Basic salary at reference date) must exist where (Contract.TERMS = 1 or 2) and Contract.SPOINT (Salary point) does not exist.

QR.C21025.Contract.SIGRES.1

Contract.SIGRES must exist where the contract is active on the (Y2)-07-31 and Contract.TERMS = 1 or 2 and ((Contract.ACEMPFUN = 2 and Contract.RESAST is not 1) or (Contract.ACEMPFUN = 3)).

QR.C21025.Contract.SIGRES.2

Contract.SIGRES must not exist where the contract is not active on the (Y2)-07-31 or Contract.TERMS does not = 1 or 2 or (Contract.ACEMPFUN does not = 2 or 3 or (Contract.ACEMPFUN = 2 and Contract.RESAST = 1)).

QR.C21025.Contract.SIGRES.3

Contract.SIGRES must = 1 where the contract is active on (Y2)-07-31 and Contract.ACEMPFUN = 2 and Contract.TERMS = 1 or 2 and Contract.RESAST = 0

QR.C21025.Contract.SOBS.1

Where there is more than one occurrence of Contract.SOBS (Source of basic salary) they must not be identical.

QR.C21025.Contract.SOBS.2

Where Contract.SOBS (Source of basic salary) = 01 there must be no other occurrences of Contract.SOBS.

QR.C21025.Contract.SOBS.3

Contract.SOBS (Source of basic salary) must exist where Contract.TERMS = 1 or 2.

QR.C21025.Contract.STARTCON.1

Contract.STARTCON must not be after Y2-07-31

QR.C21025.Contract.STARTCON.2

Where exists Contract.STARTCON must not be after Contract.ENDCON.

QR.C21025.Contract.STARTCON.3

Contract.STARTCON must exist where Contract.TERMS = 1 or 2. If the Contract.STARTCON is not known an empty element must be returned.

QR.C21025.Contract.STARTCON.4

Where Contract.STARTCON exists it must be after Person.BIRTHDTE.

QR.C21025.Contract.STARTCON.5

Contract.STARTCON must be before or on Person.DATELEFT where all Contract.TERMS = 1 or 2

QR.C21025.Contract.TCHWLH.1

Contract.TCHWLH (Teaching through the medium of Welsh) must not exist for providers in England, Scotland or Northern Ireland.

QR.C21025.Contract.TCHWLH.2

Contract.TCHWLH (Teaching through the medium of Welsh) must exist for Welsh providers where (Contract.ACEMPFUN = 1 or 3) and Contract.TERMS = 1 or 2.

QR.C21025.Contract.TCHWLH.3

Contract.TCHWLH (Teaching through the medium of Welsh) must not equal 1 where Person.ABLWELSH = 2.(Not able to teach through the medium of Welsh)

QR.C21025.Contract.TERMS.1

Where Contract.MOEMP = 5 (Atypical) then Contract.TERMS must equal 3 (Atypical).

QR.C21025.Contract.TERMS.2

Where Contract.TERMS = 3 (Atypical) then Contract.ACEMPFUN must not equal 4 or null. (Not an academic contract)

QR.C21025.Governor.ENDGOV.1

Governor.ENDGOV, if it exists, must be on or after Y1-08-01.

QR.C21025.Governor.ENDGOV.2

Where Governor.ENDGOV exists, it must not be greater than Person.BIRTHDTE + 91 years (where Person.BIRTHDTE not equal to 1900-01-01).

QR.C21025.Governor.ENDGOV.3

Where exists Governor.ENDGOV must be less than Y2-08-01.

QR.C21025.Governor.EXPENDGOV.1

Governor.EXPENDGOV, if it exists, must be on or after Y1-08-01.

QR.C21025.Governor.EXPENDGOV.2

Where Governor.EXPENDGOV exists, it must not be greater than Person.BIRTHDTE + 91 years (where Person.BIRTHDTE not equal to 1900-01-01).

QR.C21025.Governor.STARTGOV.1

Governor.STARTGOV must be on or before Y2-07-31.

QR.C21025.Person.ABLWELSH.1

Person.ABLWELSH (Ability to teach through the medium of Welsh) must not exist for providers in England, Scotland or Northern Ireland.

QR.C21025.Person.ABLWELSH.2

Person.ABLWELSH (Ability to teach through the medium of Welsh) must exist for providers in Wales where any (Contract.ACEMPFUN = 1 or 3 and Contract.TERMS = 1 or 2).

QR.C21025.Person.ACTCHQUAL.1

Person.ACTCHQUAL (Academic teaching qualification) must exist for providers in England, Wales and Northern Ireland where any (Contract.ACEMPFUN = 1 or 3) and (Contract.TERMS = 1 or 2).

QR.C21025.Person.ACTCHQUAL.2

Only one occurrence of Person.ACTCHQUAL (Academic teaching qualification) = 11, 12, 13 or 14 can apply at a given point of time.

QR.C21025.Person.ACTCHQUAL.3

Where there is more than one occurrence of Person.ACTCHQUAL (Academic teaching qualification) they must not be identical.

QR.C21025.Person.ACTLEAVE.1

Person.ACTLEAVE (Activity after leaving) must exist where Person.DATELEFT is not null and (Contract.TERMS = 1 or 2) and (no Contract.RESCON = 8) where any Activity.ACTSOC begins with 1, 2 or 3.

QR.C21025.Person.ACTLEAVE.2

Person.ACTLEAVE (Activity after leaving) must not exist where Person.DATELEFT is null.

QR.C21025.Person.BIRTHDTE.7

Where Person.GOVFLAG= 1 (Yes) and Person.BIRTHDTE not equal to 1900-01-01 then Person.BIRTHDTE must be between (Y1-91)-07-31 and (Y1-10)-08-01

QR.C21025.Person.CLINARD.1

Person.CLINARD (Clinical excellence award) must exist where any Contract.CLINICAL = 1.(Clinical academic doctors and dentists)

QR.C21025.Person.CLINARD.2

Person.CLINARD(Clinical excellence award) must not exist where all Contract.CLINICAL not equal to 1.(Clinical academic doctors and dentists)

QR.C21025.Person.Contract.1

Person.Contract must exist where Person.GOVFLAG = 2 or Person.GOVFLAG does not exist

QR.C21025.Person.CURACCDIS.1

Person.CURACCDIS (Current academic discipline) must exist where any (Contract.ACEMPFUN = 1, 2 or 3) and Contract.TERMS = 1 or 2

QR.C21025.Person.CURACCDIS.2

Person.CURACCDIS (Current academic discipline) must not exist where all Contract.ACEMPFUN = 4 or 9

QR.C21025.Person.CURACCDIS.3

Where there is more than one occurrence of Person.CURACCDIS (Current academic discipline) they must not be identical.

QR.C21025.Person.DATELEFT.1

Person.DATELEFT must exist where all (Contract.TERMS = 1 or 2 and all Contract.ENDCON are not null) and all Contract.RESCON not equal to 1, 2 or 10.

QR.C21025.Person.DATELEFT.2

Person.DATELEFT must not exist where any (Contract.TERMS = 1 or 2 and Contract.ENDCON are null).

QR.C21025.Person.DATELEFT.4

Person.DATELEFT must be between (Y1-1)-08-01 and (Y2)-07-31 (inclusive)

QR.C21025.Person.ETHNIC.1

For providers in England and Wales Person.ETHNIC must not equal 13, 14 or 19.

QR.C21025.Person.ETHNIC.2

For providers in Scotland Person.ETHNIC must not equal 10 or 14.

QR.C21025.Person.ETHNIC.3

For providers in Northern Ireland Person.ETHNIC must not equal 13 or 19.

QR.C21025.Person.Governor.1

The Governor entity must exist where Person.GOVFLAG = 1 (Yes).

QR.C21025.Person.Governor.4

At least Governor.ENDGOV or Governor.EXPENDGOV must exist if the Governor entity exists.

QR.C21025.Person.GOVFLAG.1

Person.GOVFLAG must exist if provider is English, Scottish or Welsh.

QR.C21025.Person.GOVFLAG.2

At least one occurrence of Person.GOVFLAG = 1 (Yes) must exist for providers in England, Scotland and Wales.

QR.C21025.Person.GOVFLAG.3

Where Person.GOVFLAG = 2 then Person.Governor entity must not exist

QR.C21025.Person.HQHELD.1

Person.HQHELD must exist where ((Contract.TERMS = 1 or 2) and any Activity.ACTSOC begins with 1, 2 or 3) or Person.GOVFLAG = 1 (Yes)

QR.C21025.Person.LOCLEAVE.1

Person.LOCLEAVE must exist where Person.DATELEFT exists and (no Contract.RESCON = 8) and any (Contract.TERMS = 1 or 2 and any (Activity.ACTSOC begins with 1, 2 or 3)).

QR.C21025.Person.LOCLEAVE.2

Person.LOCLEAVE must not exist where Person.DATELEFT does not exist.

QR.C21025.Person.LOCLEAVE.3

Person.LOCLEAVE must not exist where Person.DATELEFT exists and any Contract.RESCON is coded 8.(Death)

QR.C21025.Person.LOCLEAVE.4

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.

QR.C21025.Person.ORCID.1

Person.ORCID should exist for staff where any Contract.SIGRES = 1

QR.C21025.Person.ORCID.2

Person.ORCID should exist for at least 50% of eligible staff with any Contract.SIGRES = 1

QR.C21025.Person.PARLEAVE.1

Person.PARLEAVE (Parental leave) should not equal 1 (Maternity leave) where Person.SEXID = 1. (Male)

QR.C21025.Person.PARLEAVE.2

Person.PARLEAVE (Parental leave) should not equal 5 (Paternity leave) where Person.SEXID = 2.(Female)

QR.C21025.Person.PARLEAVE.3

Where multiple occurrences of Person.PARLEAVE (Parental leave) exist they must not be identical or equal '1' and '5' (Maternity and Paternity leave).

QR.C21025.Person.PREVEMP.1

Person.PREVEMP must exist where (Contract.TERMS = 1 or 2) and any Activity.ACTSOC begins with 1, 2 or 3.

QR.C21025.Person.PREVHEI.1

Person.PREVHEI (Previous higher education institution) must exist where Person.PREVEMP = 01 and any Activity.ACTSOC begins with 1, 2 or 3.

QR.C21025.Person.PREVHEI.2

Person.PREVHEI (Previous higher education institution) must not exist where Person.PREVEMP not equal to 01 or 21.

QR.C21025.Person.REGBODY.1

Person.REGBODY must exist where any Contract.CLINICAL = 1, 2, 3 or 4 or (any Activity.CCENTRE = 109 and Contract.ACEMPFUN = 1, 2, or 3 and Contract.TERMS = 1 or 2).

QR.C21025.Person.REGBODY.2

Person.REGBODY exists where there is no contract with (any Activity.CCENTRE = 109 and Contract.ACEMPFUN = 1, 2, or 3 and Contract.TERMS = 1 or 2) or Contract.CLINICAL = 1, 2, 3, or 4. Please check that although staff do not hold a clinical contract or a non-atypical academic contract with activity in veterinary science, they are registered to practice with a statutory health and social care regulatory body.

QR.C21025.Person.REGBODY.3

Where there is more than one occurrence of Person.REGBODY they must not be identical.

QR.C21025.Person.REGBODY.4

Person.REGBODY (must equal 01 or 02) where any Contract.CLINICAL = 1.(clinical academic doctors and dentists)

QR.C21025.Person.REGBODY.5

Person.REGBODY must equal 06 (The Nursing and Midwifery Council (NMC)) where any Contract.CLINICAL = 2 (Clinical academic nurses and midwives).

QR.C21025.Person.REGBODY.6

Person.REGBODY must equal 07 where any Contract.CLINICAL = 3(clinical academic health professions).

QR.C21025.Person.RELBLF.1

For providers in England and Wales Person.RELBLF (Religion or belief) must not equal 04, 05, 06, 07, 08 or 09.

QR.C21025.Person.RELBLF.2

For providers in Scotland Person.RELBLF (Religion or belief) must not equal 03, 06, 07 or 08.

QR.C21025.Person.RELBLF.3

For providers in Northern Ireland Person.RELBLF (Religion or belief) must not equal 03 or 04 (Christian or Christian - Church of Scotland).

QR.C21025.Person.STAFFID.1

No two records can have the same Person.STAFFID

QR.C21025.Person.STAFFID.2

Person.STAFFID must not contain all zeroes.

QR.C21025.Person.STAFFID.3

Characters 3 to 6 of Person.STAFFID must be a valid INSTID.

QR.C21025.Person.STAFFID.4

Character 13 of Person.STAFFID must pass the checksum test given in the coding manual

QR.C21025.Person.STAFFID.9

The combination of Person.STAFFID and Contract.CONTID field must be unique within a HEP's submission.

QR.C21025.Activity.CCENTRE.1

The Activity.CCENTRE code must be one of AcademicCostCentres.ACCENTRE codes submitted for the Provider profile record.

QR.C21025.Activity.CCENTRE.2

Where AcademicCostCentres.ACCENTRE have been submitted in the Provider profile record but it is not coded in any occurrence of Activity.CCENTRE.

QR.C21025.Activity.CCENTRE.3

The cost centre was returned in last year's Student, Staff (excluding atypical) and Finance collections but Activity.CCENTRE has not been submitted in this year's Staff return.

QR.C21025.Activity.CCENTRE.4

The Activity.CCENTRE was returned in last year's but not in this year's return.

QR.C21025.Activity.CCENTRE.5

The Activity.CCENTRE was returned in this year's but not in last year's return.

QR.C21025.Activity.CCENTRE.6

For non-atypical contracts, the FTE for an Activity.CCENTRE has changed more than 30% between years. (This rule has a population restriction applied through the derived field XPSESC01 = 1, contract counted within the session population).

QR.C21025.Activity.CCENTRE.7

For atypical contracts, the total FTE for an Activity.CCENTRE has changed by more than 50% each year.

QR.C21025.Activity.CCENTRE.8

For non-atypical contracts, the FTE for an Activity.CCENTRE is less than 0.05.

QR.C21025.Contract.CAMPID.1

Contract.CAMPID (Campus identifier) must have been submitted in the Provider profile collection.

QR.C21025.Contract.CONFTE.10

Contract.CONFTE should be reduced to less than 40 percent to take account of the partial year worked (less than 183 days) by staff on a part-time contract (Contract.MOEMP = 3 or 4) that started and/or ended during the reporting period (1 August - 31 July).

QR.C21025.Contract.CONFTE.5

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).

QR.C21025.Contract.CONFTE.6

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.

QR.C21025.Contract.CONFTE.7

Contract.CONFTE should not be greater than 50.0 for more than 5% of contracts (and more than 5 contracts) where Contract.MOEMP = 5.

QR.C21025.Contract.CONFTE.9

Contract.CONFTE should be reduced to less than 50 percent to take account of the partial year worked (less than 183 days) by staff on a full-time contract (Contract.MOEMP = 1 or 2) that started and/or ended during the reporting period (1 August - 31 July).

QR.C21025.Contract.LEVELS.2

More than 2% (or more than 10) of contracts have Contract.LEVELS = B0 (UCEA Level 2).

QR.C21025.Contract.LEVELS.3

Contract.LEVELS = A0 (Vice-Chancellor/Principal/Head of Institution) must exist at least once and no more than twice for a provider.

QR.C21025.Contract.LEVELS.6

For all non-atypical contracts and academic atypical contracts (Contract.ACEMPFUN = 1, 2, 3 or 9), Contract.LEVELS should be consistent where the same Person.STAFFID and Contract.CONTID appears in both last year's and this year's returns.

QR.C21025.Contract.LEVELS.7

Where Contract.ACEMPFUN = 4 (Not an academic contract) then Contract.LEVELS should not equal F1 (Professor).

QR.C21025.Contract.LEVELS.8

The sum of XSFPE01 for Contract.LEVELS = F1, A0, B0, C1, C2, D1, D2, D3, E1, E2 is greater than the sum of XSFPE01 for Contract.LEVELS = F2, I0, J0, K0, L0, M0, N0, O0, P0.

QR.C21025.Contract.LEVELS.9

It is typically expected that there will be at least one staff member coded as a professor (Contract.LEVELS = F1).

QR.C21025.Contract.RESCON.4

Where Contract.RESCON = 1 (New contract record generated) 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.

QR.C21025.Contract.SALREF.10

Contract.SALREF (Basic salary at reference date) should not be less than 40,000 (but greater than 7199) where Contract.MOEMP (Mode of employment) in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS = C2, E2 or F2.

QR.C21025.Contract.SALREF.11

Contract.SALREF (Basic salary at reference date) should not be less than 45,000 where Contract.MOEMP (Mode of employment) in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS = A0, B0, C1, D1, D2, D3 or E1.

QR.C21025.Contract.SALREF.12

Contract.SALREF (Basic salary at reference date) should not be between 16,700 and 19,100 (exclusive) where Person.BIRTHDTE <= '(Y1-21)-07-31') and Contract.MOEMP in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS = I0, J0, K0, L0, M0, N0, O0 or P0.

QR.C21025.Contract.SALREF.5

Contract.SALREF (Basic salary at reference date) should not be between 7200 and 16800 where (Contract.TERMS = 1 or 2 and Contract.MOEMP in (1,2,3,4,6) and Contract.APPRENTICESHIP = 9 (Not on an apprenticeship).

QR.C21025.Contract.SALREF.6

Where Contract.SALREF (Basic salary at reference date) 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 years should not be more than 25%.

QR.C21025.Contract.SALREF.7

Contract.SALREF (Basic salary at reference date) should not be greater than 200,000 where (Contract.MOEMP in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS does not equal A0).

QR.C21025.Contract.SALREF.8

Contract.SALREF (Basic salary at reference date) should not be less than £46,435 where (Contract.MOEMP in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS = F1)

QR.C21025.Contract.SALREF.9

Contract.SALREF (Basic salary at reference date) should not be greater than 325000.

QR.C21025.Contract.SPOINT.1

Contract.SPOINT (Salary point) should start with C (Clinical spine) where Contract.CLINICAL does not equal 0.(Not clinical academic)

QR.C21025.Contract.SPOINT.2

Contract.SPOINT (Salary point) must contain a valid entry.

QR.C21025.Contract.STARTCON.6

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'.

QR.C21025.Contract.STARTCON.7

Where Contract.TERMS = 1 or 2, Contract.STARTCON should be consistent where the same Person.STAFFID and Contract.CONTID appears in both last year's and this year's returns.

QR.C21025.Contract.TERMS.3

More than 50% of contracts have Contract.TERMS = 3 (atypical).

QR.C21025.Contract.ZEROHRS.1

More than 99.0% of contracts have Contract.ZEROHRS = 1 (zero hours contract).

QR.C21025.Contract.ZEROHRS.2

The proportion of zero hours contracts has changed by 10% or more between years.

QR.C21025.Person.ABLWELSH.3

More than 5% of staff where Person.ABLWELSH (Ability to teach through the medium of Welsh) = 9.(Information not sought)

QR.C21025.Person.ACTCHQUAL.11

New starters must not be coded 01 in Person.ACTCHQUAL.

QR.C21025.Person.ACTCHQUAL.4

Where Person.ACTCHQUAL (Academic teaching qualification) = 90 or 99, then no other occurrence of Person.ACTCHQUAL should exist

QR.C21025.Person.ACTCHQUAL.5

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 (No academic teaching qualification held). (This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population).

QR.C21025.Person.ACTCHQUAL.6

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 (Other). (This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population).

QR.C21025.Person.ACTCHQUAL.7

For providers in England, Northern Ireland and Wales, more than 10% of staff where any (Contract.ACEMPFUN = 1 or 3 and Contract.TERMS = 1 or 2) have Person.ACTCHQUAL = 90 (Not known). (This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population).

QR.C21025.Person.ACTCHQUAL.8

For providers in England, Northern Ireland and Wales, more than 10% of staff whose first contract with the provider has Contract.STARTCON > '(Y1)-07-31' and for any contract (Contract.ACEMPFUN = 1 or 3 and Contract.TERMS = 1 or 2) have Person.ACTCHQUAL = 90 (Not known). This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.

QR.C21025.Person.ACTLEAVE.10

More than 30% of staff where Person.DATELEFT is not null and whose first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and for any contract (Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.ACTLEAVE = 92 (Not available). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.ACTLEAVE.3

Where Person.ACTLEAVE(Activity after leaving) = 05 (NHS/General medical practice/General dental practice) then Person.LOCLEAVE (Location after leaving) should be in (1, 2, 3, 4, 5).

QR.C21025.Person.ACTLEAVE.4

More than 1% of staff have Person.ACTLEAVE (Activity after leaving) = 11 (Retired) and Person.BIRTHDTE after '(Y1-50)-07-31'

QR.C21025.Person.ACTLEAVE.5

More than 30% of staff where Person.DATELEFT is not null and (any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.ACTLEAVE = 90 (Not known). (This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population).

QR.C21025.Person.ACTLEAVE.6

More than 30% of staff where Person.DATELEFT is not null and whose first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and for any contract (Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.ACTLEAVE = 90 (Not known). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.ACTLEAVE.7

More than 30% of staff where Person.DATELEFT is not null and (any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.ACTLEAVE = 91 (Information refused). (This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.)

QR.C21025.Person.ACTLEAVE.8

More than 30% of staff where Person.DATELEFT is not null and whose first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and for any contract (Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.ACTLEAVE = 91 (Information refused). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.ACTLEAVE.9

More than 30% of staff where Person.DATELEFT is not null and (any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.ACTLEAVE = 92 (Not available).​ (This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.)

QR.C21025.Person.BIRTHDTE.5

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.

QR.C21025.Person.BIRTHDTE.6

Person.BIRTHDTE must be between (Y1-100)-07-31 and (Y1-10)-08-01.

QR.C21025.Person.CLINARD.3

More than 10% of staff members (and more than 10 staff) where Person.CLINARD (Clinical excellence award) differs between years, excluding where Person.CLINARD = 00 in last year's return.

QR.C21025.Person.DATELEFT.5

There are no staff that have left in the reporting period. It is expected that there would be at least a member of staff that has left.

QR.C21025.Person.DISABLE.1

More than 99.0% of staff where Person.DISABLE = 00.(No known disability)

QR.C21025.Person.DISABLE.2

More than 5% (and more than 20 records) of staff have a Person.DISABLE = 97 (Information refused). This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.

QR.C21025.Person.DISABLE.3

More than 5% (and more than 20 records) of staff have a Person.DISABLE = 96 (A disability, impairment or medical condition that is not listed). This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.

QR.C21025.Person.DISABLE.4

More than 5% (and more than 20 records) of staff have a Person.DISABLE = 08 (Two or more impairments and/or disabling medical conditions). This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.

QR.C21025.Person.DISABLE.5

More than 5% of staff (and more than 20 records) have a Person.DISABLE = 99 (Not available). This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.

QR.C21025.Person.ETHNIC.10

More than 20% of staff with atypical contracts only (XPOPPA01 = 1) have Person.ETHNIC = 99 (Not available).

QR.C21025.Person.ETHNIC.11

More than 7.5% of staff whose first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and (any Contract.TERMS = 1 or 2) have Person.ETHNIC = 98 (Information refused). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.ETHNIC.12

More than 7.5% of staff (where any Contract.TERMS = 1 or 2) have Person.ETHNIC = 98 (Information refused). This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.

QR.C21025.Person.ETHNIC.13

More than 20% of staff with atypical contracts only (XPOPPA01 = 1) have Person.ETHNIC = 98 (Information refused).

QR.C21025.Person.ETHNIC.4

More than 3% of staff where (Person.ETHNIC does not equal 90, 98 or 99 in last year's return and Person.ETHNIC = 90, 98 or 99 in this year's return).

QR.C21025.Person.ETHNIC.5

More than 7.5% of staff (where any Contract.TERMS = 1 or 2) have Person.ETHNIC = 90 (Not known). (This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.)

QR.C21025.Person.ETHNIC.6

More than 7.5% of staff whose first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and (any Contract.TERMS = 1 or 2) have Person.ETHNIC = 90 (Not known). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.ETHNIC.7

More than 20% of staff with atypical contracts only (XPOPPA01 = 1) have Person.ETHNIC = 90 (Not known).

QR.C21025.Person.ETHNIC.8

More than 7.5% of staff (where any Contract.TERMS = 1 or 2) have Person.ETHNIC = 99 (Not available). (This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.)

QR.C21025.Person.ETHNIC.9

More than 7.5% of staff whose first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and (any Contract.TERMS = 1 or 2) have Person.ETHNIC = 99 (Not available). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.GENREASSIGN.1

Where optional field Person.GENREASSIGN has been returned, there are more than 3% of staff where Person.GENREASSIGN = 2 (No).

QR.C21025.Person.GENREASSIGN.2

Where optional field Person.GENREASSIGN has been returned, there are more than 3% of staff where Person.GENREASSIGN = 3 (Information refused).

QR.C21025.Person.GENREASSIGN.3

Where optional field Person.GENREASSIGN has been returned, there are more than 3% of staff where Person.GENREASSIGN = 4 (Not available.)

QR.C21025.Person.Governor.6

If the same Person.STAFFID appears in both last year's and this year's Staff returns, Person.GOVFLAG = 1 existed last year and there is no Governor.ENDGOV or Governor.EXPENDGOV before (Y1)-07-31, then Person.GOVFLAG should be consistent between years.

QR.C21025.Person.Governor.7

Where more than one Governor entity exists for an individual, the dates of the entities should not overlap. The start date of the next governor entity must be after the end date of the previous governor entity.

QR.C21025.Person.Governor.8

The number of Governors active on the last day of the current reporting per​iod differs by more than 30% compared to the number of Governors active on the last day of the previous reporting per​iod.

QR.C21025.Person.GOVFLAG.4

Three or more occurrences of Person.GOVFLAG = 1 (Yes) must exist for providers in England, Scotland and Wales.

QR.C21025.Person.HQHELD.2

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)).

QR.C21025.Person.HQHELD.3

If first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and for any contract 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 (No qualifications).

QR.C21025.Person.HQHELD.4

More than 15% of staff (where any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3) have Person.HQHELD = 99 (Not known). This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.

QR.C21025.Person.HQHELD.5

More than 15% of staff whose first contract with the provider has Contract.STARTCON > '(Y1)-07-31' and for any contract (Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3) have Person.HQHELD = 99 (Not known). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.LOCLEAVE.10

More than 20% of staff where Person.DATELEFT is not null and whose first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and (any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.LOCLEAVE = 9 (Information refused). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.LOCLEAVE.5

More than 20% of staff where Person.DATELEFT is not null and (any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.LOCLEAVE = 8 (Not known). (This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.)

QR.C21025.Person.LOCLEAVE.6

More than 20% of staff where Person.DATELEFT is not null and whose first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and (any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.LOCLEAVE = 8 (Not known). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.LOCLEAVE.7

More than 20% of staff where Person.DATELEFT is not null and (any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.LOCLEAVE = 10 (Not available). (This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.)

QR.C21025.Person.LOCLEAVE.8

More than 20% of staff where Person.DATELEFT is not null and whose first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and (any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.LOCLEAVE = 10 (Not available). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.LOCLEAVE.9

More than 20% of staff where Person.DATELEFT is not null and (any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3 and no Contract.RESCON = 8) have Person.LOCLEAVE = 9 (Information refused). (This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.)

QR.C21025.Person.NATION.1

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.

QR.C21025.Person.NATION.2

More than 7.5% of staff (where any Contract.TERMS = 1 or 2) have Person.NATION = ZZ (Not known). This rule has a population restriction applied through the derived field XPOPP01 = 1, Person counted within 1 December population.

QR.C21025.Person.NATION.3

More than 7.5% of staff whose first contract with the provider has Contract.STARTCON > '(Y1)-07-31' and for any contract (Contract.TERMS = 1 or 2) have Person.NATION = ZZ (Not known). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.NATION.4

More than 10% of staff with atypical contracts only (XPOPPA01 = 1) have Person.NATION = ZZ (Not known).

QR.C21025.Person.PREVEMP.10

Where Person.PREVEMP was coded as 01-04, 07-19, 21-23 or 99 last year, it cannot be updated to 05, 06 or 20 this year.

QR.C21025.Person.PREVEMP.4

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.

QR.C21025.Person.PREVEMP.6

More than 15% of staff (where any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3) have Person.PREVEMP = 99 (Not known).

QR.C21025.Person.PREVEMP.7

More than 15% of staff whose first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and for any contract (Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3) have Person.PREVEMP = 99 (Not known). This rule has a population restriction applied through derived field XPOPPA01 = 0, Person not counted within atypical population.

QR.C21025.Person.PREVEMP.8

Staff whose first contract with the provider has Contract.STARTCON greater than '(Y1)-07-31' and for any contract record for this person record has (Activity.ACTSOC major groups 1, 2 or 3 and Contract.TERMS = 1 or 2) then Person.PREVEMP should not equal 99 (Not known).

QR.C21025.Person.PREVEMP.9

Person.PREVEMP must not equal 05, 06 or 20 for new members of staff. (This rule has a population restriction applied through the derived field XNEWSTAFFMRK = 1, Person counted within New Starter population).

QR.C21025.Person.PREVHEI.3

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.

QR.C21025.Person.PREVHEI.4

Where Person.PREVEMP = 01 (another publicly funded higher education institution in the UK), then Person.PREVHEI must not be the same as the returning provider.

QR.C21025.Person.PREVHEI.5

Where Person.PREVEMP = 21 (Not in regular employment) and Person.PREVHEI exists it must be the same as the returning provider.

QR.C21025.Person.REGBODY.7

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.

QR.C21025.Person.REGBODY.8

Where Person.REGBODY exists, an occurrence of Person.REGBODY should equal 14 (Royal College of Veterinary Surgeons) where all occurrences of Activity.CCENTRE = 109 (Veterinary science)

QR.C21025.Person.RELBLF.4

Where optional field Person.REFBLF has been returned, there should be no more than 10% of staff where Person.RELBLF = 98 (Information Refused).

QR.C21025.Person.RELBLF.5

Where optional field Person.REFBLF has been returned, there should be no more than 10% of staff where Person.RELBLF = 99 (Not Available).

QR.C21025.Person.SEXID.1

More than 1% of staff who appear in both last year's and this year's return (matching on STAFFID) have a different value of Person.SEXID to last year's Person.SEX, where both exist.

QR.C21025.Person.SEXORT.1

Where optional field Person.SEXORT has been returned, there should not be more than 10% of staff where Person.SEXORT = 02 (Gay man) and Person.SEXID = 2 (Female).

QR.C21025.Person.SEXORT.2

Where optional field Person.SEXORT has been returned, there should not be more than 10% of staff where Person.SEXORT = 03 (Gay woman/lesbian) and Person.SEXID = 1 (Male).

QR.C21025.Person.SEXORT.3

Where optional field Person.SEXORT has been returned, there should not be more than 5% of staff (and more than 5 records) where Person.SEXORT = 05 (Other).

QR.C21025.Person.SEXORT.4

Where optional field Person.SEXORT has been returned, there should not be more than 5% of staff (and more than 5 records) where Person.SEXORT= 99 (Not available).

QR.C21025.Person.SEXORT.5

Where optional field Person.SEXORT has been returned, there should not be more than 5% of staff (and more than 5 records) where Person.SEXORT= 98 (Information refused).

QR.C21025.Person.STAFFID.10

No two records can have the same Person.STAFFID.

QR.C21025.Person.STAFFID.11

For providers in England and Northern Ireland, if a member of staff was included in last year's Staff return, where any contract record for this person has (((Contract.ACEMPFUN = 1, 2, 3 or 9 and Contract.TERMS = 1 or 2) or Contract.LEVELS = A0) 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.

QR.C21025.Person.STAFFID.12

For providers in England and Northern Ireland that have opted in to return staff outside the coverage, if a member of staff was included in last year's Staff return where any contract record for this person has (Contract.ACEMPFUN = 4 and Contract.TERMS = 1 or 2 and Contract.ENDCON does not exist) and Person.DATELEFT does not exist in last year's return and no contracts for this person were returned with (((Contract.ACEMPFUN = 1, 2, 3 or 9 and Contract.TERMS = 1 or 2) or Contract.LEVELS = A0) and Contract.ENDCON does not exist), then a record should be included in this year's Staff return.

QR.C21025.Person.STAFFID.13

More than 50% of Staff have a Person.STAFFID that has not been issued by the provider.

QR.C21025.Person.STAFFID.5

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.

QR.C21025.Person.STAFFID.6

All staff with 10 or more contracts.

QR.C21025.Person.STAFFID.7

Potential duplicate entries for non-atypical staff exist but have different Person.STAFFIDs.

QR.C21025.Person.STAFFID.8

For providers in Scotland and Wales, 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.

QR.C21025.Contract.ECRSTAT.1

Contract.ECRSTAT must exist where the contract is active on 31 July 2020 and Contract.TERMS = 1 or 2 and ((Contract.ACEMPFUN = 2 and Contract.RESAST not equal 1) or Contract.ACEMPFUN = 3).

QR.C21025.Contract.ECRSTAT.2

Contract.ECRSTAT must not exist where Contract.ACEMPFUN not equal to 2 or 3.

QR.C21025.Contract.ECRSTAT.3

Contract.ECRSTAT must not exist where the contract is not active on 31 July 2020 or Contract.TERMS not equal to 1 or 2 or (Contract.ACEMPFUN does not = 2 or 3 or (Contract.ACEMPFUN = 2 and Contract.RESAST = 1)).

QR.C21025.Contract.ECRSTAT.4

Contract.ECRSTAT should exist where Contract.SIGRES is equal to 1 or 2.

QR.C21025.Contract.REFFTE.1

Where Person.REFUOA2021 exists, Contract.REFFTE must exist on at least one contract.

QR.C21025.Contract.REFFTE.2

Contract.REFFTE must not exist where Person.REFUOA2021 does not exist.

QR.C21025.Contract.REFFTE.3

Contract.REFFTE should equal 100 where Contract.MOEMP = 1.

QR.C21025.Contract.REFFTE.4

Contract.REFFTE should not not equal 100 where Contract.MOEMP = 2, 3, 4, 5 or 6.

QR.C21025.Contract.REFFTE.5

Contract.REFFTE must exist where the contract is active on 31 July 2020 and Contract.TERMS = 1 or 2 and ((Contract.ACEMPFUN = 2 and Contract.RESAST not equal 1) or (Contract.ACEMPFUN = 3)).

QR.C21025.Contract.REFFTE.6

Contract.REFFTE must not exist where the contract is not active on 31 July 2020 or Contract.TERMS not equal to 1 or 2 or (Contract.ACEMPFUN does not = 2 or 3 or (Contract.ACEMPFUN = 2 and Contract.RESAST = 1)).

QR.C21025.Contract.REFFTE.7

Total of Contract.REFFTE for all the contract records for a person must not be greater than 100.

QR.C21025.Person.ACTCHQUAL.10

Staff coded 02-05 in Person.ACTCHQUAL this year will need to be recoded next year (C21025) as these codes are being discontinued. Please note, codes 02-05 directly map to new codes 11-14.

QR.C21025.Person.ACTCHQUAL.9

New starters must not be coded 01 in Person.ACTCHQUAL.

QR.C21025.Person.BIRTHDTE.3

Where MIN(Contract.STARTCON) is greater than or equal to (Y1)-08-01 then Person.BIRTHDTE must be before (Y1-15)-08-01.

QR.C21025.Person.BIRTHDTE.4

Where MIN(Contract.STARTCON) is greater than or equal to (Y1)-08-01 then Person.BIRTHDTE must be after (Y1-91)-07-31

QR.C21025.Person.BIRTHDTE.8

Where first contract with the provider has Contract.STARTCON after (Y1)-07-31 then Person.BIRTHDTE must be before (Y1-15)-08-01.

QR.C21025.Person.BIRTHDTE.9

If first contract with the provider has Contract.STARTCON after (Y1)-07-31 then Person.BIRTHDTE must be after (Y1-91)-07-31.

QR.C21025.Person.DATEFHEI.1

Person.DATEFHEI must exist where any Contract.TERMS = 1 or 2. If the Person.DATEFHEI is not known an empty element must be returned.

QR.C21025.Person.DATEFHEI.2

Where exists Person.DATEFHEI must be before Y2-08-01

QR.C21025.Person.DATEFHEI.3

Where exists Person.DATEFHEI must be after Person.BIRTHDTE.

QR.C21025.Person.DATEFHEI.4

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.

QR.C21025.Person.DATELEFT.3

Where exists Person.DATELEFT must be equal to or after Person.DATEFHEI.

QR.C21025.Person.GENDERID.1

More than 3% of staff where Person.GENDERID = 02.

QR.C21025.Person.Governor.2

The number of governors active on the last day of the current reporting per​iod in the staff record, differs by more than +/- 50% when compared to the size of the governing body returned in the previous year's HE-BCI collection.

QR.C21025.Person.Governor.3

The number of governors active on the last day of the current reporting per​iod in the staff record differs by between +/-15% and +/-50% when compared to the size of the governing body returned in the previous year's HE-BCI collection.

QR.C21025.Person.Governor.5

The number of governors active on the last day of the current reporting per​iod in the staff record, differs by +/-2 when compared to the size of the governing body returned in the previous year's HE-BCI collection.

QR.C21025.Person.NATIOND.1

Person.NATIOND (National identity) must exist for providers in Wales.

QR.C21025.Person.NATIOND.2

Person.NATIOND (National identity) must not exist for providers in England, Scotland and Northern Ireland.

QR.C21025.Person.NATIOND.3

Where there is more than one occurrence of Person.NATIOND (National identity) they must not be identical.

QR.C21025.Person.NATIOND.4

Where there is an occurrence of Person.NATIOND (National identity) = R, U or N (Information refused, Unknown or Not available), then no other occurrence of Person.NATIOND should exist.

QR.C21025.Person.NATIOND.5

For providers in Wales, more than 5% of staff have Person.NATIOND (National identity) = R (Information refused).

QR.C21025.Person.NATIOND.6

For providers in Wales, more than 5% of staff have Person.NATIOND (National identity)= U (Unknown).

QR.C21025.Person.NATIOND.7

For providers in Wales, more than 5% of staff have Person.NATIOND (National identity)= N (Not Available).

QR.C21025.Person.PREVEMP.2

Person.PREVEMP must not equal 05 or 06 where the person's first contract at the provider is greater than or equal to 2012-08-01.

QR.C21025.Person.PREVEMP.3

Person.PREVEMP must not equal 20 (working in the voluntary sector) where first contract with the provider has Contract.STARTCON after 2014-07-31.

QR.C21025.Person.PREVEMP.5

Where (MIN(Contract.STARTCON) > '(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)) then Person.PREVEMP should not equal 99 (Not known).

QR.C21025.Person.REFUOA2021.1

Person.REFUOA2021 should not exist where all Contract.ACEMPFUN not equal to 2 or 3.

QR.C21025.Person.REFUOA2021.2

Person.REFUOA2021 must not exist where the staff member does not have an active contract on 31 July 2020 or Contract.TERMS not equal to 1 or 2 or (Contract.ACEMPFUN does not = 2 or 3 or (Contract.ACEMPFUN = 2 and Contract.RESAST = 1)).

QR.C21025.Person.REFUOA2021.3

Person.REFUOA2021 must exist where any contract exists with (contract active on 31 July 2020 and Contract.TERMS = 1 or 2 and ((Contract.ACEMPFUN = 2 and Contract.RESAST not equal 1) or (Contract.ACEMPFUN = 3)).

QR.C21025.Person.REFUOA2021.4

Person.REFUOA2021 must exist where any contract exists with Contract.SIGRES equal to 1 or 2.

QR.C21025.Person.REFUOA2021.5

Person.REFUOA2021 must not exist where there are no contracts with Contract.SIGRES equal to 1 or 2.

QR.C21025.Person.REFUOA2021.6

For each record in the RE look-up file, the combination of UKPRN, STAFFID and REFUOA2021 must exist in the HESA Staff return.

QR.C21025.Person.REFUOA2021.7

Where Person.REFUOA2021 exists and does not end with 'Z', the combination of UKPRN and REFUOA2021 must exist in the RE look-up file.

QR.C21025.Person.REGBODY.9

Where Person.REGBODY exists, Contract.ACEMPFUN must be coded 1, 2, or 3 and Contract.TERMS must be coded 1 or 2 and Activity.CCENTRE must be coded 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 127 or 131.

QR.C21025.Person.SEX.1

More than 1% 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.