Quality Rules Directory for C20025
Filter
QR.C20025.Activity.ACTSOC.1
There must not be multiple occurrences of the same Activity.ACTSOC and Activity.CCENTRE on the same Contract.CONTIDShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Activity.ACTSOC.1
QR.C20025.Activity.ACTSOC.2
Activity.ACTSOC must be 231 (Teaching and Educational Professionals) where Contract.LEVELS = A0.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Activity.ACTSOC.2
QR.C20025.Activity.CCPROP.1
Where only one Activity returned Activity.CCPROP must be 100Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Activity.CCPROP.1
QR.C20025.Activity.CCPROP.2
Where Multiple Activity entities are returned the sum of all Activity.CCPROP must be in the range 99.7 and 100.3Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Activity.CCPROP.2
QR.C20025.Contract.ACEMPFUN.1
Contract.ACEMPFUN (Academic employment function) must exist where any Activity.ACTSOC begins with 1, 2 or 3.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.ACEMPFUN.1
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.ACEMPFUN.2
QR.C20025.Contract.ACEMPFUN.3
There are no occurrences of Contract.ACEMPFUN (Academic employment function) = 1, 2, 3 or 9 in the Staff return.Show more
- Plain English
- No academic staff have been returned.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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)).Show more
- Plain English
- There can only be more than three activities for specific contracts i.e. Levels is above D2 or not an academic contract or SOC2010 major groups 4-9.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.Activity.1
QR.C20025.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.Show more
- Plain English
- Clinical status must exist for any medical or health related HESA cost centre.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CLINICAL.1
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CLINICAL.2
QR.C20025.Contract.CLINICAL.3
A provider has a Medical or Dental school but has not returned any Contract.CLINICAL = 1.(Clinical academic doctors and dentists)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CLINICAL.3
QR.C20025.Contract.CLINSUB.1
Contract.CLINSUB (Clinical sub-speciality) must exist where Contract.CLINICAL = 1.(Clinical academic doctors and dentists)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CLINSUB.1
QR.C20025.Contract.CLINSUB.2
Contract.CLINSUB (Clinical sub-speciality) must not exist where Contract.CLINICAL not equal to 1.(Clinical academic doctors and dentists)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CLINSUB.2
QR.C20025.Contract.CLINSUB.3
Where there is more than one occurrence of Contract.CLINSUB (Clinical sub-speciality) they must not be identical.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CLINSUB.3
QR.C20025.Contract.CONFTE.1
Contract.CONFTE must be 0 where Contract.MOEMP (Mode of employment) = 6 (Dormant)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CONFTE.1
QR.C20025.Contract.CONFTE.2
Where Mode of employment(Contract.MOEMP is 3, 4 or 5) then Contract.CONFTE must not be 100.Show more
- Plain English
- FTE for part-time and atypical contracts must not be 100.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CONFTE.2
QR.C20025.Contract.CONFTE.3
Where exists (Contract.ENDCON > (Y1)-07-31 and Contract.ENDCON < (Y2)-07-31), then Contract.CONFTE must not be 100Show more
- Plain English
- FTE must not be 100 for contracts that have ended during the reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CONFTE.3
QR.C20025.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).Show more
- Plain English
- FTE must not be zero for contracts that are active during the reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CONFTE.4
QR.C20025.Contract.CONFTE.8
Total of Contract.CONFTE for all the contract records for a person must not be greater than 200.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CONFTE.8
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.ENDCON.1
QR.C20025.Contract.ENDCON.2
Where exists Contract.ENDCON must be less than Y2-08-01Show more
- Plain English
- End date of contract must be before the next reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.ENDCON.2
QR.C20025.Contract.ENDCON.3
Where exists Contract.ENDCON must be equal to or after the date returned in Contract.STARTCON.Show more
- Plain English
- End date of contract must be the same or after the start date of contract.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.ENDCON.3
QR.C20025.Contract.ENDCON.4
Contract.ENDCON must be before or equal to Person.DATELEFT where all Contract.TERMS = 1 or 2Show more
- Plain English
- End date of contract must be before or equal to the date that the person left.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.ENDCON.4
QR.C20025.Contract.HEIJOINT.1
Contract.HEIJOINT (HEP joint contract) must not be the returning provider.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.HEIJOINT.1
QR.C20025.Contract.HEIJOINT.2
Contract.HEIJOINT (HEP joint contract) should not exist where Contract.TERMS is not equal to 1 or 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.HEIJOINT.2
QR.C20025.Contract.HOURLYPAID.1
Contract.HOURLYPAID must exist where Contract.TERMS = 1 or 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Contract.HSPEC.1
Contract.HSPEC (Healthcare professional speciality) must exist where Contract.CLINICAL = 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.HSPEC.1
QR.C20025.Contract.HSPEC.2
Contract.HSPEC (Healthcare professional speciality) must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.HSPEC.2
QR.C20025.Contract.HSPEC.3
Where there is more than one occurrence of Contract.HSPEC (Healthcare professional speciality) they must not be identical.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.HSPEC.3
QR.C20025.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'.Show more
- Plain English
- Contract.LEVELS normally associated with non-academic contracts have been returned as academic.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Contract.LEVELS.5
Contract.LEVELS should not equal 'C1', 'D1', 'D2', 'D3', 'E1' or 'F1' where Contract.ACEMPFUN (Academic employment function)= '4' or null.Show more
- Plain English
- Contract.LEVELS normally associated with academic contracts have been returned as non-academic.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Contract.NHSCON.1
Contract.NHSCON (NHS contracts) must exist where Contract.CLINICAL is equal to 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.NHSCON.1
QR.C20025.Contract.NHSCON.2
Contract.NHSCON (NHS contracts) must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.NHSCON.2
QR.C20025.Contract.NHSCONGR.1
Where Contract.STARTCON is after 2009-08-01 Contract.NHSCONGR (NHS contract grade) must not equal 02, 03, 06 or 07Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.NHSCONGR.1
QR.C20025.Contract.NHSCONGR.2
Contract.NHSCONGR (NHS contract grade) must exist where Contract.CLINICAL = 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.NHSCONGR.2
QR.C20025.Contract.NHSCONGR.3
Contract.NHSCONGR (NHS contract grade) must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.NHSCONGR.3
QR.C20025.Contract.PSCAG.1
Contract.PSCAG must exist where Contract.TERMS = 1 or 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.PSCAG.1
QR.C20025.Contract.PSCAG.2
Where Contract.SOBS (Source of basic salary ) = 01 then Contract.PSCAG must be 100.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.PSCAG.2
QR.C20025.Contract.PSCAG.3
Where Contract.SOBS (Source of basic salary ) not equal to 01 then Contract.PSCAG must not be 100.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.PSCAG.3
QR.C20025.Contract.RESAST.1
Contract.RESAST (Research assistant) must exist where Contract.ACEMPFUN (Academic employment function) = 2 and Contract.TERMS = 1 or 2.Show more
- Plain English
- Research assistant must exist for non-atypical academic contracts that are research only.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.RESAST.1
QR.C20025.Contract.RESAST.2
Contract.RESAST (Research assistant) must not exist where Contract.ACEMPFUN (Academic employment function) does not equal 2 or Contract.TERMS = 3.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.RESAST.2
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.RESCON.1
QR.C20025.Contract.RESCON.2
Contract.RESCON (Reason for the end of contract) must exist where Contract.TERMS = 1 or 2 and Contract.ENDCON exists.Show more
- Plain English
- Reason for ending the contract must exist where the contract has ended.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.RESCON.2
QR.C20025.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.)Show more
- Plain English
- Reason for ending the contract must not exist where the contract has not ended.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.RESCON.3
QR.C20025.Contract.RESCON.5
Where Contract.RESCON equals 3 (End of fixed-term contract) Contract.TERMS must equal 2 (Fixed-term).Show more
- Plain English
- Where the reason for ending a contract is 'the end of a fixed-term contract' the contract's terms of employment must be 'Fixed-term'.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Contract.RESCON.6
Where Contract.RESCON = 10 (Non-academic contract issued) the provider must be in England or Northern Ireland.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- 12/03/2021: Added new rule due to new code in Contract.RESCON.
- Previous Name of Rule
- N/A
QR.C20025.Contract.SALREF.1
Where Contract.SALREF (Basic salary at reference date) exists, then Contract.SALREF must not be greater than 500000.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SALREF.1
QR.C20025.Contract.SALREF.2
Where Contract.SALREF (Basic salary at reference date) exists, then Contract.SALREF must not be less than 6600.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SALREF.2
QR.C20025.Contract.SALREF.3
Contract.SALREF (Basic salary at reference date) must not exist where Contract.SPOINT (Salary point) begins with C. (Clinical spine)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SALREF.3
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SALREF.4
QR.C20025.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).Show more
- Plain English
- SIGRES (significant responsibility for research) must be completed for staff who have an active contract of employment on (Y2)-07-31, are not atypical and have either a research only contract (but are not a research assistant) or a teaching and research contract.
- Further Guidance
- N/A
- Reason for Change
- Amended date from '31 July 2020' to '(Y2)-07-31'
- Previous Name of Rule
- N/A
QR.C20025.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)).Show more
- Plain English
- Contract.SIGRES must not exist where staff do not have a REF eligible contract.
- Further Guidance
- N/A
- Reason for Change
- Amended date from 31 July 2020 to (Y2)-07-31.
- Previous Name of Rule
- N/A
QR.C20025.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 = 0Show more
- Plain English
- Staff who have an active research only contract, are not atypical and are not a research assistant, must have a significant responsibility for research.
- Further Guidance
- Rule applies only to those providers participating in the REF exercise.
- Reason for Change
- Amended date from 31 July 2020 to (Y2)-07-31.
- Previous Name of Rule
- QR.C19025.Contract.SIGRES.3
QR.C20025.Contract.SOBS.1
Where there is more than one occurrence of Contract.SOBS (Source of basic salary) they must not be identical.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SOBS.1
QR.C20025.Contract.SOBS.2
Where Contract.SOBS (Source of basic salary) = 01 there must be no other occurrences of Contract.SOBS.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SOBS.2
QR.C20025.Contract.SOBS.3
Contract.SOBS (Source of basic salary) must exist where Contract.TERMS = 1 or 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SOBS.3
QR.C20025.Contract.STARTCON.1
Contract.STARTCON must not be after Y2-07-31Show more
- Plain English
- Start date of contract must not be after the current reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.STARTCON.1
QR.C20025.Contract.STARTCON.2
Where exists Contract.STARTCON must not be after Contract.ENDCON.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.STARTCON.2
QR.C20025.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.Show more
- Plain English
- Start date of contract must exist for non-atypical contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.STARTCON.3
QR.C20025.Contract.STARTCON.4
Where Contract.STARTCON exists it must be after Person.BIRTHDTE.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.STARTCON.4
QR.C20025.Contract.STARTCON.5
Contract.STARTCON must be before or on Person.DATELEFT where all Contract.TERMS = 1 or 2Show more
- Plain English
- Start date of contract must be before or on the date the person left for non-atypical contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.STARTCON.5
QR.C20025.Contract.TCHWLH.1
Contract.TCHWLH (Teaching through the medium of Welsh) must not exist for providers in England, Scotland or Northern Ireland.Show more
- Plain English
- Teaching through the medium of welsh must not exist for providers outside of Wales.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.TCHWLH.1
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.TCHWLH.2
QR.C20025.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)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.TCHWLH.3
QR.C20025.Contract.TERMS.1
Where Contract.MOEMP = 5 (Atypical) then Contract.TERMS must equal 3 (Atypical).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.TERMS.1
QR.C20025.Contract.TERMS.2
Where Contract.TERMS = 3 (Atypical) then Contract.ACEMPFUN must not equal 4 or null. (Not an academic contract)Show more
- Plain English
- Non-academic atypical staff must not be returned.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Governor.ENDGOV.1
Governor.ENDGOV, if it exists, must be on or after Y1-08-01.Show more
- Plain English
- The governor end date must be after the start of the collection.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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).Show more
- Plain English
- The governor end date is greater than expected based on the birthdate.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Governor.ENDGOV.3
Where exists Governor.ENDGOV must be less than Y2-08-01.Show more
- Plain English
- End date of governorship must be before the next reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Governor.EXPENDGOV.1
Governor.EXPENDGOV, if it exists, must be on or after Y1-08-01.Show more
- Plain English
- The governor expected end date must be after the start of the collection.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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).Show more
- Plain English
- The governor expected end date is greater than expected based on the birthdate.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Governor.STARTGOV.1
Governor.STARTGOV must be on or before Y2-07-31.Show more
- Plain English
- The governor expected start date must be before the end of the collection.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.ABLWELSH.1
Person.ABLWELSH (Ability to teach through the medium of Welsh) must not exist for providers in England, Scotland or Northern Ireland.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ABLWELSH.1
QR.C20025.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).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ABLWELSH.2
QR.C20025.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).Show more
- Plain English
- Academic teaching qualifications must exist for non-atypical academic contracts that involve teaching.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ACTCHQUAL.1
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Removed codes 02, 03, 04, 05 as they are no longer available in the field.
- Previous Name of Rule
- QR.C19025.Person.ACTCHQUAL.2
QR.C20025.Person.ACTCHQUAL.3
Where there is more than one occurrence of Person.ACTCHQUAL (Academic teaching qualification) they must not be identical.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ACTCHQUAL.3
QR.C20025.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.Show more
- Plain English
- Activity after leaving must exist for non-atypical staff that have left the provider.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ACTLEAVE.1
QR.C20025.Person.ACTLEAVE.2
Person.ACTLEAVE (Activity after leaving) must not exist where Person.DATELEFT is null.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ACTLEAVE.2
QR.C20025.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-01Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.CLINARD.1
Person.CLINARD (Clinical excellence award) must exist where any Contract.CLINICAL = 1.(Clinical academic doctors and dentists)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.CLINARD.1
QR.C20025.Person.CLINARD.2
Person.CLINARD(Clinical excellence award) must not exist where all Contract.CLINICAL not equal to 1.(Clinical academic doctors and dentists)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.CLINARD.2
QR.C20025.Person.Contract.1
Person.Contract must exist where Person.GOVFLAG = 2 or Person.GOVFLAG does not existShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.CURACCDIS.1
Person.CURACCDIS (Current academic discipline) must exist where any (Contract.ACEMPFUN = 1, 2 or 3) and Contract.TERMS = 1 or 2Show more
- Plain English
- Current academic discipline must exist where any non-atypical contract is academic teaching and/or research.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.CURACCDIS.1
QR.C20025.Person.CURACCDIS.2
Person.CURACCDIS (Current academic discipline) must not exist where all Contract.ACEMPFUN = 4 or 9Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.CURACCDIS.2
QR.C20025.Person.CURACCDIS.3
Where there is more than one occurrence of Person.CURACCDIS (Current academic discipline) they must not be identical.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.CURACCDIS.3
QR.C20025.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.Show more
- Plain English
- Date left HEP must exist for non-atypical staff where all contracts have ended and no new contracts issued.
- Further Guidance
- N/A
- Reason for Change
- Amended to include new Contract.RESCON code 10.
- Previous Name of Rule
- QR.C19025.Person.DATELEFT.1
QR.C20025.Person.DATELEFT.2
Person.DATELEFT must not exist where any (Contract.TERMS = 1 or 2 and Contract.ENDCON are null).Show more
- Plain English
- Date left HEP must not exist where any non-atypical contracts are active.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.DATELEFT.2
QR.C20025.Person.DATELEFT.4
Person.DATELEFT must be between (Y1-1)-08-01 and (Y2)-07-31 (inclusive)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.DATELEFT.4
QR.C20025.Person.ETHNIC.1
For providers in England and Wales Person.ETHNIC must not equal 13, 14 or 19.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ETHNIC.1
QR.C20025.Person.ETHNIC.2
For providers in Scotland Person.ETHNIC must not equal 10 or 14.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ETHNIC.2
QR.C20025.Person.ETHNIC.3
For providers in Northern Ireland Person.ETHNIC must not equal 13 or 19.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ETHNIC.3
QR.C20025.Person.Governor.1
The Governor entity must exist where Person.GOVFLAG = 1 (Yes).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.Governor.4
At least Governor.ENDGOV or Governor.EXPENDGOV must exist if the Governor entity exists.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.GOVFLAG.1
Person.GOVFLAG must exist if provider is English, Scottish or Welsh.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.GOVFLAG.2
At least one occurrence of Person.GOVFLAG = 1 (Yes) must exist for providers in England, Scotland and Wales.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.GOVFLAG.3
Where Person.GOVFLAG = 2 then Person.Governor entity must not existShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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)Show more
- Plain English
- Highest qualification held must exist for non-atypical contracts where any SOC2010 major groups are 1-3.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.HQHELD.1
QR.C20025.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)).Show more
- Plain English
- Location after leaving must exist for staff that have left the provider.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.LOCLEAVE.1
QR.C20025.Person.LOCLEAVE.2
Person.LOCLEAVE must not exist where Person.DATELEFT does not exist.Show more
- Plain English
- Location after leaving must not exist for staff that have not left the provider.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.LOCLEAVE.2
QR.C20025.Person.LOCLEAVE.3
Person.LOCLEAVE must not exist where Person.DATELEFT exists and any Contract.RESCON is coded 8.(Death)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.LOCLEAVE.3
QR.C20025.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.Show more
- Plain English
- Location after leaving should be known for non-atypical staff that have left the provider in the current reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.LOCLEAVE.4
QR.C20025.Person.NATIOND.1
Person.NATIOND (National identity) must exist for providers in Wales.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.NATIOND.1
QR.C20025.Person.NATIOND.2
Person.NATIOND (National identity) must not exist for providers in England, Scotland and Northern Ireland.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.NATIOND.2
QR.C20025.Person.NATIOND.3
Where there is more than one occurrence of Person.NATIOND (National identity) they must not be identical.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.NATIOND.3
QR.C20025.Person.ORCID.1
Person.ORCID should exist for staff where any Contract.SIGRES = 1Show more
- Plain English
- REF eligible staff should have an ORCID.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ORCID.1
QR.C20025.Person.ORCID.2
Person.ORCID should exist for at least 50% of eligible staff with any Contract.SIGRES = 1Show more
- Plain English
- At least 50% of REF eligible staff members should return an ORCID.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ORCID.2
QR.C20025.Person.PARLEAVE.1
Person.PARLEAVE (Parental leave) should not equal 1 (Maternity leave) where Person.SEXID = 1. (Male)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.PARLEAVE.1
QR.C20025.Person.PARLEAVE.2
Person.PARLEAVE (Parental leave) should not equal 5 (Paternity leave) where Person.SEXID = 2.(Female)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.PARLEAVE.2
QR.C20025.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).Show more
- Plain English
- Invalid combinations of Person.PARLEAVE have been returned.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.PREVEMP.1
Person.PREVEMP must exist where (Contract.TERMS = 1 or 2) and any Activity.ACTSOC begins with 1, 2 or 3.Show more
- Plain English
- Previous employment must exist for non-atypical staff where any SOC2010 major groups are 1-3.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.PREVEMP.1
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.PREVHEI.1
QR.C20025.Person.PREVHEI.2
Person.PREVHEI (Previous higher education institution) must not exist where Person.PREVEMP not equal to 01 or 21.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.PREVHEI.2
QR.C20025.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).Show more
- Plain English
- Regulatory body must exist for any clinical academic contracts or any non-atypical academic teaching or research contracts with veterinary science activities.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.REGBODY.1
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Description amended so that rule is consistent with guidance.
- Previous Name of Rule
- QR.C19025.Person.REGBODY.2
QR.C20025.Person.REGBODY.3
Where there is more than one occurrence of Person.REGBODY they must not be identical.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.REGBODY.3
QR.C20025.Person.REGBODY.4
Person.REGBODY (must equal 01 or 02) where any Contract.CLINICAL = 1.(clinical academic doctors and dentists)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.REGBODY.4
QR.C20025.Person.REGBODY.5
Person.REGBODY must equal 06 (The Nursing and Midwifery Council (NMC)) where any Contract.CLINICAL = 2 (Clinical academic nurses and midwives).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.REGBODY.5
QR.C20025.Person.REGBODY.6
Person.REGBODY must equal 07 where any Contract.CLINICAL = 3(clinical academic health professions).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.REGBODY.6
QR.C20025.Person.RELBLF.1
For providers in England and Wales Person.RELBLF (Religion or belief) must not equal 04, 05, 06, 07, 08 or 09.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.RELBLF.1
QR.C20025.Person.RELBLF.2
For providers in Scotland Person.RELBLF (Religion or belief) must not equal 03, 06, 07 or 08.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.RELBLF.2
QR.C20025.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).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.RELBLF.3
QR.C20025.Person.STAFFID.1
No two records can have the same Person.STAFFIDShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.STAFFID.1
QR.C20025.Person.STAFFID.2
Person.STAFFID must not contain all zeroes.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.STAFFID.2
QR.C20025.Person.STAFFID.3
Characters 3 to 6 of Person.STAFFID must be a valid INSTID.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.STAFFID.3
QR.C20025.Person.STAFFID.4
Character 13 of Person.STAFFID must pass the checksum test given in the coding manualShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.STAFFID.4
QR.C20025.Person.STAFFID.9
The combination of Person.STAFFID and Contract.CONTID field must be unique within a HEP's submission.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.STAFFID.9
QR.C20025.Activity.CCENTRE.1
The Activity.CCENTRE code must be one of AcademicCostCentres.ACCENTRE codes submitted for the Provider profile record.Show more
- Plain English
- A HESA cost centre that exists in the Staff return must have been returned in the Provider profile record.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Activity.CCENTRE.1
QR.C20025.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.Show more
- Plain English
- A HESA cost centre returned in the Provider profile record has not been returned in the Staff record.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Activity.CCENTRE.2
QR.C20025.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.Show more
- Plain English
- A HESA cost centre has been returned in last year's Student, Staff and Finance but has not been returned in Staff this year.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Activity.CCENTRE.4
The Activity.CCENTRE was returned in last year's but not in this year's return.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Activity.CCENTRE.5
The Activity.CCENTRE was returned in this year's but not in last year's return.Show more
- Plain English
- A new HESA cost centre has been returned.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Revised description only.
- Previous Name of Rule
- N/A
QR.C20025.Activity.CCENTRE.7
For atypical contracts, the total FTE for an Activity.CCENTRE has changed by more than 50% each year.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Activity.CCENTRE.8
For non-atypical contracts, the FTE for an Activity.CCENTRE is less than 0.05.Show more
- Plain English
- A HESA cost centre has a very low full-time equivalent for non-atypical contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Contract.CAMPID.1
Contract.CAMPID (Campus identifier) must have been submitted in the Provider profile collection.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CAMPID.1
QR.C20025.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).Show more
- Plain English
- FTE should be reduced to take account of a partial year worked by staff on part-time contracts that started or ended during the reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CONFTE.10
QR.C20025.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).Show more
- Plain English
- FTE should not be less than 80.0 for full-time contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CONFTE.5
QR.C20025.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.Show more
- Plain English
- FTE should not be greater than 90.0 for part-time contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CONFTE.6
QR.C20025.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.Show more
- Plain English
- FTE should not be greater than 50.0 for atypical contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CONFTE.7
QR.C20025.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).Show more
- Plain English
- FTE should be reduced to take account of a partial year worked by staff on full-time contracts that started or ended during the reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.CONFTE.9
QR.C20025.Contract.LEVELS.2
More than 2% (or more than 10) of contracts have Contract.LEVELS = B0 (UCEA Level 2).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.LEVELS.2
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.LEVELS.3
QR.C20025.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.Show more
- Plain English
- Contract.LEVELS has changed this year compared to last year.
- Further Guidance
- N/A
- Reason for Change
- Revised description only.
- Previous Name of Rule
- N/A
QR.C20025.Contract.LEVELS.7
Where Contract.ACEMPFUN = 4 (Not an academic contract) then Contract.LEVELS should not equal F1 (Professor).Show more
- Plain English
- N/A
- Further Guidance
- It is expected that professors will be coded as academic.
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is more FPE assigned to 'Professor' and/or 'Other senior academic' compared to 'Other contract levels'.
- Further Guidance
- It is not expected that there will be significantly more FPE assigned to 'Professor' and/or 'Other senior academic' compared to 'Other contract levels'.
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Contract.LEVELS.9
It is typically expected that there will be at least one staff member coded as a professor (Contract.LEVELS = F1).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- Where the reason for ending a contract is that a new contract has been generated then another contract should exist.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.RESCON.4
QR.C20025.Contract.SALREF.10
Contract.SALREF (Basic salary at reference date) should not be less than 40,000 (but greater than 6599) 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.Show more
- Plain English
- Salaries are low for non-atypical staff with contract levels of C2, E2 or F2.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- Salaries are low for non-atypical staff with contract levels of A0, B0, C1, D1, D2, D3 or E1.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Contract.SALREF.12
Contract.SALREF (Basic salary at reference date) should not be between 15,200 and 17,400 (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.Show more
- Plain English
- Salary is low for non-atypical staff over 21 years of age for contract levels I0, J0, K0, L0, M0, N0, O0 or P0.
- Further Guidance
- The rule is based on national minimum wage for 40 hours over 52 weeks.
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Contract.SALREF.5
Contract.SALREF (Basic salary at reference date) should not be between 6600 and 15300 where (Contract.TERMS = 1 or 2 and Contract.MOEMP in (1,2,3,4,6) and Contract.APPRENTICESHIP = 9 (Not on an apprenticeship).Show more
- Plain English
- Salary should not be between 6600 and 15300 for non-atypical contracts where the staff member is older than 21 at the start of the reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SALREF.5
QR.C20025.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%.Show more
- Plain English
- Salary has changed by more than 25% between years.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SALREF.6
QR.C20025.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).Show more
- Plain English
- Salary should not be greater than 200,000 where levels does not equal Vice-Chancellor/Principal or Head of Institution.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SALREF.7
QR.C20025.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)Show more
- Plain English
- Salary should not be less than £46,435 for professors.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SALREF.8
QR.C20025.Contract.SALREF.9
Contract.SALREF (Basic salary at reference date) should not be greater than 325000.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SALREF.9
QR.C20025.Contract.SPOINT.1
Contract.SPOINT (Salary point) should start with C (Clinical spine) where Contract.CLINICAL does not equal 0.(Not clinical academic)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SPOINT.1
QR.C20025.Contract.SPOINT.2
Contract.SPOINT (Salary point) must contain a valid entry.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.SPOINT.2
QR.C20025.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'.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Contract.STARTCON.6
QR.C20025.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.Show more
- Plain English
- Contract.STARTCON (for contracts with Contract.TERMS = 1 or 2) has changed this year compared to last year.
- Further Guidance
- N/A
- Reason for Change
- Amended rule to exclude atypical contracts (Contract.TERMS = 3).
- Previous Name of Rule
- N/A
QR.C20025.Contract.TERMS.3
More than 50% of contracts have Contract.TERMS = 3 (atypical).Show more
- Plain English
- It would not be expected for over 50% of contracts to be atypical.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Contract.ZEROHRS.1
More than 99.0% of contracts have Contract.ZEROHRS = 1 (zero hours contract).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Contract.ZEROHRS.2
The proportion of zero hours contracts has changed by 10% or more between years.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.ABLWELSH.3
More than 5% of staff where Person.ABLWELSH (Ability to teach through the medium of Welsh) = 9.(Information not sought)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ABLWELSH.3
QR.C20025.Person.ACTCHQUAL.11
New starters must not be coded 01 in Person.ACTCHQUAL.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C19025.Person.ACTCHQUAL.9
QR.C20025.Person.ACTCHQUAL.4
Where Person.ACTCHQUAL (Academic teaching qualification) = 90 or 99, then no other occurrence of Person.ACTCHQUAL should existShow more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ACTCHQUAL.4
QR.C20025.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).Show more
- Plain English
- Staff with non-atypical academic teaching contracts do not have an academic teaching qualification.
- Further Guidance
- N/A
- Reason for Change
- Revised description only.
- Previous Name of Rule
- QR.C19025.Person.ACTCHQUAL.5
QR.C20025.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).Show more
- Plain English
- Staff with non-atypical academic teaching contracts have an academic teaching qualification of 'Other'
- Further Guidance
- N/A
- Reason for Change
- Revised description only.
- Previous Name of Rule
- QR.C19025.Person.ACTCHQUAL.6
QR.C20025.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).Show more
- Plain English
- There is a high percentage of unknown academic teaching qualifications for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- Revised description only.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of unknown academic teaching qualifications for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by MIN(Contract.STARTCON) > Y1-07-31 where MIN identifies the first occurrence.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of Not available in Person.ACTLEAVE for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where there a high levels of new valid entry not available, for Person.ACTLEAVE.
- Previous Name of Rule
- N/A
QR.C20025.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).Show more
- Plain English
- NHS/General medical practice/General dental practice' activity after leaving should be located in the UK.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ACTLEAVE.3
QR.C20025.Person.ACTLEAVE.4
More than 1% of staff have Person.ACTLEAVE (Activity after leaving) = 11 (Retired) and Person.BIRTHDTE after '(Y1-50)-07-31'Show more
- Plain English
- Staff under the age of 50 at the start of the reporting period have an activity after leaving of retired.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.ACTLEAVE.4
QR.C20025.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).Show more
- Plain English
- There is a high percentage of unknown Person.ACTLEAVE for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- Revised description only.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of unknown Person.ACTLEAVE for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by MIN(Contract.STARTCON) > Y1-07-31 where MIN identifies the first occurrence.
- Previous Name of Rule
- N/A
QR.C20025.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.)Show more
- Plain English
- There is a high percentage of information refused Person.ACTLEAVE for non-atypical staff .
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where non-atypical staff have a high percentage of new valid entry information refused, for activity after leaving.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of information refused in Person.ACTLEAVE for non-atypical new starters.
- Further Guidance
- New rule to warn where there are high levels of new valid entry information refused, for Person.ACTLEAVE.
- Reason for Change
- New rule to warn where there are high levels of new valid entry information refused, for Person.ACTLEAVE.
- Previous Name of Rule
- N/A
QR.C20025.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.)Show more
- Plain English
- There is a high percentage of not available Person.ACTLEAVE for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where non-atypical staff have a high percentage of new valid entry not available, for activity after leaving.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- Staff date of birth should be consistent between years.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.BIRTHDTE.5
QR.C20025.Person.BIRTHDTE.6
Person.BIRTHDTE must be between (Y1-100)-07-31 and (Y1-10)-08-01.Show more
- Plain English
- Staff must be between the ages of 10 and 100.
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by MIN(Contract.STARTCON).
- Previous Name of Rule
- QR.C19025.Person.BIRTHDTE.6
QR.C20025.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.Show more
- Plain English
- Clinical excellence award should be consistent between years.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.CLINARD.3
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.DISABLE.1
More than 99.0% of staff where Person.DISABLE = 00.(No known disability)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.DISABLE.1
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- 20/04/2021: Amended description to define disability code 96 - no change to implementation.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- 20/04/2021: Amended description to define disability code 08.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where a high percentage of staff have new code not available, returned for Person.DISABLE.
- Previous Name of Rule
- N/A
QR.C20025.Person.ETHNIC.10
More than 20% of staff with atypical contracts only (XPOPPA01 = 1) have Person.ETHNIC = 99 (Not available).Show more
- Plain English
- There is a high percentage of not available Person.ETHNIC for staff with only atypical contracts.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where staff with only atypical contracts have a high percentage of new valid entry not available, for ethnicity.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of ethnicities returned as information refused for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where non-atypical new starters have a high percentage of new valid entry information refused, for ethnicity.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of information refused in Person.ETHNIC for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where non-atypical staff have a high percentage of new valid entry information refused, for ethnicity.
- Previous Name of Rule
- N/A
QR.C20025.Person.ETHNIC.13
More than 20% of staff with atypical contracts only (XPOPPA01 = 1) have Person.ETHNIC = 98 (Information refused).Show more
- Plain English
- There is a high percentage of ethnicities returned as Information refused for staff with only atypical contracts.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn there is a high percentage of new valid entry information refused, in ethnicity for staff with atypicial contracts only.
- Previous Name of Rule
- Person.OWNSTAFFID
QR.C20025.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).Show more
- Plain English
- Ethnicity was previously known but this year it is unknown.
- Further Guidance
- N/A
- Reason for Change
- This rule has been amended to include new code 99 (Not available).
- Previous Name of Rule
- QR.C19025.Person.ETHNIC.4
QR.C20025.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.)Show more
- Plain English
- There is a high percentage of unknown ethnicities for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- 20/04/2021: Amended specification to highlight derived field.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of unknown ethnicities for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by MIN(Contract.STARTCON).
- Previous Name of Rule
- N/A
QR.C20025.Person.ETHNIC.7
More than 20% of staff with atypical contracts only (XPOPPA01 = 1) have Person.ETHNIC = 90 (Not known).Show more
- Plain English
- There is a high percentage of unknown ethnicities for staff with only atypical contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.)Show more
- Plain English
- There is a high percentage of not available Person.ETHNIC for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where non-atypical staff have a high percentage of new valid entry not available, for ethnicity.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of ethnicities returned as not available for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where non-atypical new starters have a high percentage of new valid entry not available, for ethnicity.
- Previous Name of Rule
- N/A
QR.C20025.Person.GENREASSIGN.1
Where optional field Person.GENREASSIGN has been returned, there are more than 3% of staff where Person.GENREASSIGN = 2 (No).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Revised description only.
- Previous Name of Rule
- QR.C19025.Person.GENREASSIGN.1
QR.C20025.Person.GENREASSIGN.2
Where optional field Person.GENREASSIGN has been returned, there are more than 3% of staff where Person.GENREASSIGN = 3 (Information refused).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Revised description only.
- Previous Name of Rule
- N/A
QR.C20025.Person.GENREASSIGN.3
Where optional field Person.GENREASSIGN has been returned, there are more than 3% of staff where Person.GENREASSIGN = 4 (Not available.)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where there are high levels of new valid entry not available, for Person.GENREASSIGN.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- A governor that was active at the end of the previous reporting period should be returned this year.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.GOVFLAG.4
Three or more occurrences of Person.GOVFLAG = 1 (Yes) must exist for providers in England, Scotland and Wales.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- 19/04/2021: New rule added to check that a provider returns at least 3 governors.
- Previous Name of Rule
- N/A
QR.C20025.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)).Show more
- Plain English
- Highest qualification held has changed between years.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.HQHELD.2
QR.C20025.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).Show more
- Plain English
- Staff that have started in the current reporting period with any SOC2010 major groups 1-3 should have a qualification.
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by MIN(Contract.STARTCON) > Y1-07-31 where MIN identifies the first occurrence.
- Previous Name of Rule
- QR.C19025.Person.HQHELD.3
QR.C20025.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.Show more
- Plain English
- There is a high percentage of unknown highest qualification held for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of unknown highest qualification held for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by MIN(Contract.STARTCON) > Y1-07-31 where MIN identifies the first occurrence.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of location of employment returned as information refused for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where non-atypical new starters have a high percentage of new valid entry information refused, for location of employment.
- Previous Name of Rule
- N/A
QR.C20025.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.)Show more
- Plain English
- There is a high percentage of unknown location of employment for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- 20/04/2021: Amended rule description only to highlight derived field.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of unknown location of employment for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by a person's first contract MIN(Contract.STARTCON).
- Previous Name of Rule
- N/A
QR.C20025.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.)Show more
- Plain English
- There is a high percentage of not available location of employment for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where non-atypical staff have a high percentage of new valid entry not available, for location of employment.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of location of employment returned as not available for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where non-atypical new starters have a high percentage of new valid entry not available, for location of employment.
- Previous Name of Rule
- N/A
QR.C20025.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.)Show more
- Plain English
- There is a high percentage of information refused location of employment for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where non-atypical staff have a high percentage of new valid entry information refused, for location of employment.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- Nationality should be consistent between years.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.NATION.1
QR.C20025.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.Show more
- Plain English
- There is a high percentage of unknown nationalities for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of unknown nationalities for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by MIN(Contract.STARTCON) > Y1-07-31 where MIN identifies the first occurrence.
- Previous Name of Rule
- N/A
QR.C20025.Person.NATION.4
More than 10% of staff with atypical contracts only (XPOPPA01 = 1) have Person.NATION = ZZ (Not known).Show more
- Plain English
- There is a high percentage of unknown nationalities for staff with only atypical contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- This rule has been amended to include new NATIOND code N - 'Not available' in the rule.
- Previous Name of Rule
- QR.C19025.Person.NATIOND.4
QR.C20025.Person.NATIOND.5
For providers in Wales, more than 5% of staff have Person.NATIOND (National identity) = R (Information refused).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.NATIOND.6
For providers in Wales, more than 5% of staff have Person.NATIOND (National identity)= U (Unknown).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.NATIOND.7
For providers in Wales, more than 5% of staff have Person.NATIOND (National identity)= N (Not Available).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule added to warn where a high percentage of staff have new code not available, in Person.NATIOND.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by the person's first contract at the provider. Rule downgraded from Error to Warning to address historic contracts.
- Previous Name of Rule
- QR.C19025.Person.PREVEMP.2
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- This rule has been amended from a Business Rule to an Exception to accomodate the need to validate against a person's first contract at the provider. Downgraded rule from Error to Warning to address historic contracts.
- Previous Name of Rule
- QR.C19025.Person.PREVEMP.3
QR.C20025.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.Show more
- Plain English
- Previous employment should be consistent between years.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.PREVEMP.4
QR.C20025.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).Show more
- Plain English
- There is a high percentage of unknown Person.PREVEMP for non-atypical staff.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- There is a high percentage of unknown Person.PREVEMP for non-atypical new starters.
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by MIN(Contract.STARTCON) > Y1-07-31 where MIN identifies the first occurrence.
- Previous Name of Rule
- N/A
QR.C20025.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).Show more
- Plain English
- Staff that have started in the reporting period should have a known previous employment.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.PREVEMP.5
QR.C20025.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.Show more
- Plain English
- Previous HEI should be consistent between years.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.PREVHEI.3
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Revised description only.
- Previous Name of Rule
- QR.C19025.Person.PREVHEI.4
QR.C20025.Person.PREVHEI.5
Where Person.PREVEMP = 21 (Not in regular employment) and Person.PREVHEI exists it must be the same as the returning provider.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.PREVHEI.5
QR.C20025.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.Show more
- Plain English
- Regulatory body should be consistent between years.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.REGBODY.7
QR.C20025.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)Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.REGBODY.8
QR.C20025.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).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where there are high levels of new valid entry (Information refused) for Person.RELBLF.
- Previous Name of Rule
- N/A
QR.C20025.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).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where there are high levels of new valid entry (Not Available) for Person.RELBLF.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- Sexual identification should be consistent between years.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.SEXID.1
QR.C20025.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).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.SEXORT.1
QR.C20025.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).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.SEXORT.2
QR.C20025.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).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.SEXORT.3
QR.C20025.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).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where there are high levels of new valid entry, not available for Person.SEXORT.
- Previous Name of Rule
- N/A
QR.C20025.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).Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule to warn where there are high levels of new valid entry information refused, for Person.SEXORT.
- Previous Name of Rule
- N/A
QR.C20025.Person.STAFFID.10
No two records can have the same Person.STAFFID.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.STAFFID.10
QR.C20025.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.Show more
- Plain English
- Academic staff member and/or Vice Chancellor/Head of Institution returned last year has not been returned this year.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.STAFFID.11
QR.C20025.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.Show more
- Plain English
- Non-academic staff member returned last year has not been returned this year.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.Person.STAFFID.13
More than 50% of Staff have a Person.STAFFID that has not been issued by the provider.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- 19/04/2021: New rule created to check that providers are issuing Person.STAFFID numbers using their 4-digit INSTID
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- Staff appear to have been given a new STAFFID when a previous ID exists.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.STAFFID.5
QR.C20025.Person.STAFFID.6
All staff with 10 or more contracts.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.STAFFID.6
QR.C20025.Person.STAFFID.7
Potential duplicate entries for non-atypical staff exist but have different Person.STAFFIDs.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.STAFFID.7
QR.C20025.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.Show more
- Plain English
- Staff member returned last year has not been returned this year.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.STAFFID.8
QR.C20025.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).Show more
- Plain English
- ECRSTAT (Early Careers Researcher Status) must be completed for staff who have an active contract of employment on 31 July 2020, are not atypical and have either a research only contract (but are not a research assistant) or a teaching and research contract.
- Further Guidance
- N/A
- Reason for Change
- The field has been removed from the record following the REF exercise.
- Previous Name of Rule
- QR.C19025.Contract.ECRSTAT.1
QR.C20025.Contract.ECRSTAT.2
Contract.ECRSTAT must not exist where Contract.ACEMPFUN not equal to 2 or 3.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field removed following the REF exercise.
- Previous Name of Rule
- QR.C19025.Contract.ECRSTAT.2
QR.C20025.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)).Show more
- Plain English
- Contract.ECRSTAT must not exist where the person does not have a valid REF contract.
- Further Guidance
- N/A
- Reason for Change
- Field removed following REF exercise.
- Previous Name of Rule
- QR.C19025.Contract.ECRSTAT.3
QR.C20025.Contract.ECRSTAT.4
Contract.ECRSTAT should exist where Contract.SIGRES is equal to 1 or 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field deleted following REF exercise.
- Previous Name of Rule
- QR.C19025.Contract.ECRSTAT.4
QR.C20025.Contract.REFFTE.1
Where Person.REFUOA2021 exists, Contract.REFFTE must exist on at least one contract.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field is being removed from the record following REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.Contract.REFFTE.2
Contract.REFFTE must not exist where Person.REFUOA2021 does not exist.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field is being removed from the record following the REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.Contract.REFFTE.3
Contract.REFFTE should equal 100 where Contract.MOEMP = 1.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field is being removed from the record following the REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.Contract.REFFTE.4
Contract.REFFTE should not not equal 100 where Contract.MOEMP = 2, 3, 4, 5 or 6.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field is being removed from the record following the REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.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)).Show more
- Plain English
- Contract.REFFTE must exist where the contract is a valid REF contract.
- Further Guidance
- N/A
- Reason for Change
- Field is being removed from the record following the REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.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)).Show more
- Plain English
- Contract.REFFTE must not exist where the contract is not a valid REF contract.
- Further Guidance
- N/A
- Reason for Change
- Field is being removed from the record following the REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.Contract.REFFTE.7
Total of Contract.REFFTE for all the contract records for a person must not be greater than 100.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field is being removed from the record following the REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.Person.ACTCHQUAL.10
Staff coded 02-05 in Person.ACTCHQUAL this year will need to be recoded next year (C20025) as these codes are being discontinued. Please note, codes 02-05 directly map to new codes 11-14.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule no longer required as codes have been removed from the field.
- Previous Name of Rule
- N/A
QR.C20025.Person.ACTCHQUAL.9
New starters must not be coded 01 in Person.ACTCHQUAL.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule has been removed and will be replaced by a new exception rule covering the same scenario.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- New staff members within the reporting period are younger than 15.
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by MIN(Contract.STARTCON).
- Previous Name of Rule
- QR.C19025.Person.BIRTHDTE.3
QR.C20025.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-31Show more
- Plain English
- New staff members within the reporting period are older than 91.
- Further Guidance
- N/A
- Reason for Change
- Removal of Person.DATEFHEI to create a new starter population defined by MIN(Contract.STARTCON).
- Previous Name of Rule
- QR.C19025.Person.BIRTHDTE.4
QR.C20025.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.Show more
- Plain English
- New staff members within the reporting period are younger than 15.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C19025.Person.BIRTHDTE.3
QR.C20025.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.Show more
- Plain English
- New staff members within the reporting period are older than 91.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- Person.BIRTHDTE.4
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field removed from record as no longer required.
- Previous Name of Rule
- QR.C19025.Person.DATEFHEI.1
QR.C20025.Person.DATEFHEI.2
Where exists Person.DATEFHEI must be before Y2-08-01Show more
- Plain English
- Date appointed must be before the next reporting period.
- Further Guidance
- N/A
- Reason for Change
- Field removed from record as no longer required.
- Previous Name of Rule
- QR.C19025.Person.DATEFHEI.2
QR.C20025.Person.DATEFHEI.3
Where exists Person.DATEFHEI must be after Person.BIRTHDTE.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field removed from record as no longer required.
- Previous Name of Rule
- QR.C19025.Person.DATEFHEI.3
QR.C20025.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.Show more
- Plain English
- Date appointed should be consistent between years.
- Further Guidance
- N/A
- Reason for Change
- Field removed from the record as no longer required.
- Previous Name of Rule
- QR.C19025.Person.DATEFHEI.4
QR.C20025.Person.DATELEFT.3
Where exists Person.DATELEFT must be equal to or after Person.DATEFHEI.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule no longer required as Person.DATEFHEI has been removed from the record.
- Previous Name of Rule
- QR.C19025.Person.DATELEFT.3
QR.C20025.Person.GENDERID.1
More than 3% of staff where Person.GENDERID = 02.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C16025.Person.GENDERID.1
QR.C20025.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).Show more
- Plain English
- Staff that have started in the reporting period should have a known previous employment.
- Further Guidance
- N/A
- Reason for Change
- This rule has been removed and replaced with PREVEMP.8 which is now an exception.
- Previous Name of Rule
- QR.C19025.Person.PREVEMP.5
QR.C20025.Person.REFUOA2021.1
Person.REFUOA2021 should not exist where all Contract.ACEMPFUN not equal to 2 or 3.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field removed following the REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.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)).Show more
- Plain English
- Person.REFUOA2021 must not exist where the person does not have a valid REF contract
- Further Guidance
- N/A
- Reason for Change
- Field removed following the REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.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)).Show more
- Plain English
- Person.REFUOA2021 must exist where the person has a valid REF contract.
- Further Guidance
- N/A
- Reason for Change
- Field removed following REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.Person.REFUOA2021.4
Person.REFUOA2021 must exist where any contract exists with Contract.SIGRES equal to 1 or 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field removed following REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.Person.REFUOA2021.5
Person.REFUOA2021 must not exist where there are no contracts with Contract.SIGRES equal to 1 or 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Field removed following REF exercise.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- New rule which replaces Person.REGBODY.2 allowing the field to be completed for staff who, although registered to practice with a statutory health and social care regulatory body, do not hold a clinical contract.
- Previous Name of Rule
- N/A
QR.C20025.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.Show more
- Plain English
- Legal sex should be consistent between years.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- QR.C16025.Person.SEX.1