Skip to main content

Quality Rules Directory for C17025

Download all the C17025 rules

Filter

Keyword filter
Filter by stage
Filter by tolerance
Filter by status
Recently changed

QR.C17025.Activity.ACTSOC.1

There must not be multiple occurrences of the same Activity.ACTSOC and Activity.CCENTRE on the same Contract.CONTID
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Activity.ACTSOC.1

QR.C17025.Activity.ACTSOC.2

Activity.ACTSOC must be 231(Teaching and Educational Professionals)where Contract.LEVELS = A0.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Activity.ACTSOC.2

QR.C17025.Activity.CCPROP.1

Where only one Activity returned Activity.CCPROP must be 100
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Activity.CCPROP.1

QR.C17025.Activity.CCPROP.2

Where Multiple Activity entities are returned the sum of all Activity.CCPROP must be in the range 99.7 and 100.3
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Activity.CCPROP.2

QR.C17025.Contract.ACEMPFUN.1

Contract.ACEMPFUN (Academic employment function) must exist where any Activity.ACTSOC begins with 1, 2 or 3.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.ACEMPFUN.1

QR.C17025.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.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.ACEMPFUN.2

QR.C17025.Contract.ACEMPFUN.3

There are no occurrences of Contract.ACEMPFUN (Academic employment function) = 1, 2, 3 or 9 in the Staff return.
Business RuleErrorAmended
Show more
Plain English
No academic staff have been returned.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
N/A

QR.C17025.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)).
Business RuleErrorAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.Activity.1

QR.C17025.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.
Business RuleErrorCarried Forward
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.C16025.Contract.CLINICAL.1

QR.C17025.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.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Contract.CLINICAL.2

QR.C17025.Contract.CLINICAL.3

A provider has a Medical or Dental school but has not returned any Contract.CLINICAL = 1.(Clinical academic doctors and dentists)
Business RuleWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Contract.CLINICAL.3

QR.C17025.Contract.CLINSUB.1

Contract.CLINSUB (Clinical sub-speciality) must exist where Contract.CLINICAL = 1.(Clinical academic doctors and dentists)
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.CLINSUB.1

QR.C17025.Contract.CLINSUB.2

Contract.CLINSUB (Clinical sub-speciality) must not exist where Contract.CLINICAL not equal to 1.(Clinical academic doctors and dentists)
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.CLINSUB.2

QR.C17025.Contract.CLINSUB.3

Where there is more than one occurrence of Contract.CLINSUB (Clinical sub-speciality) they must not be identical.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.CLINSUB.3

QR.C17025.Contract.CONFTE.1

Contract.CONFTE must be 0 where Contract.MOEMP (Mode of employment) = 6 (Dormant)
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.CONFTE.1

QR.C17025.Contract.CONFTE.2

Where Mode of employment(Contract.MOEMP is 3, 4 or 5) then Contract.CONFTE must not be 100.
Business RuleErrorAmended
Show more
Plain English
FTE for part-time and atypical contracts must not be 100.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.CONFTE.2

QR.C17025.Contract.CONFTE.3

Where exists (Contract.ENDCON > (Y1)-07-31 and Contract.ENDCON < (Y2)-07-31), then Contract.CONFTE must not be 100
Business RuleWarningCarried Forward
Show 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.C16025.Contract.CONFTE.3

QR.C17025.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).
Business RuleErrorAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.CONFTE.4

QR.C17025.Contract.CONFTE.8

Total of Contract.CONFTE for all the contract records for a person must not be greater than 200.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Contract.CONFTE.8

QR.C17025.Contract.ENDCON.1

Contract.ENDCON must exist where Contract.TERMS = 1 or 2. If the Contract has not ended an empty element must be returned.
Business RuleWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Contract.ENDCON.1

QR.C17025.Contract.ENDCON.2

Where exists Contract.ENDCON must be less than Y2-08-01
Business RuleErrorCarried Forward
Show 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.C16025.Contract.ENDCON.2

QR.C17025.Contract.ENDCON.3

Where exists Contract.ENDCON must be equal to or after the date returned in Contract.STARTCON.
Business RuleErrorCarried Forward
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.C16025.Contract.ENDCON.3

QR.C17025.Contract.ENDCON.4

Contract.ENDCON must be before or equal to Person.DATELEFT where all Contract.TERMS = 1 or 2
Business RuleErrorCarried Forward
Show 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.C16025.Contract.ENDCON.4

QR.C17025.Contract.HEIJOINT.1

Contract.HEIJOINT (HEP joint contract) must not be the returning provider.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.HEIJOINT.1

QR.C17025.Contract.HEIJOINT.2

Contract.HEIJOINT (HEP joint contract) should not exist where Contract.TERMS is not equal to 1 or 2.
Business RuleWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.HEIJOINT.2

QR.C17025.Contract.HOURLYPAID.1

Contract.HOURLYPAID must exist where Contract.TERMS = 1 or 2.
Business RuleErrorAdded
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Enforces coverage of field
Previous Name of Rule
N/A

QR.C17025.Contract.HSPEC.1

Contract.HSPEC (Healthcare professional speciality) must exist where Contract.CLINICAL = 1, 2, 3 or 4.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.HSPEC.1

QR.C17025.Contract.HSPEC.2

Contract.HSPEC (Healthcare professional speciality) must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.HSPEC.2

QR.C17025.Contract.HSPEC.3

Where there is more than one occurrence of Contract.HSPEC (Healthcare professional speciality) they must not be identical.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.HSPEC.3

QR.C17025.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'.
Business RuleWarningAmended
Show more
Plain English
Contract.LEVELS normally associated with non-academic contracts have been returned as academic.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
N/A

QR.C17025.Contract.LEVELS.5

Contract.LEVELS should not equal 'C1', 'D1', 'D2', 'D3', 'E1' or 'F1' where Contract.ACEMPFUN (Academic employment function)= '4' or null.
Business RuleWarningAmended
Show more
Plain English
Contract.LEVELS normally associated with academic contracts have been returned as non-academic.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
N/A

QR.C17025.Contract.NHSCON.1

Contract.NHSCON (NHS contracts) must exist where Contract.CLINICAL is equal to 1, 2, 3 or 4.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.NHSCON.1

QR.C17025.Contract.NHSCON.2

Contract.NHSCON (NHS contracts) must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.NHSCON.2

QR.C17025.Contract.NHSCONGR.1

Where Contract.STARTCON is after 2009-08-01 Contract.NHSCONGR (NHS contract grade) must not equal 02, 03, 06 or 07
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.NHSCONGR.1

QR.C17025.Contract.NHSCONGR.2

Contract.NHSCONGR (NHS contract grade) must exist where Contract.CLINICAL = 1, 2, 3 or 4.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.NHSCONGR.2

QR.C17025.Contract.NHSCONGR.3

Contract.NHSCONGR (NHS contract grade) must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.NHSCONGR.3

QR.C17025.Contract.PSCAG.1

Contract.PSCAG must exist where Contract.TERMS = 1 or 2.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Contract.PSCAG.1

QR.C17025.Contract.PSCAG.2

Where Contract.SOBS (Source of basic salary ) = 01 then Contract.PSCAG must be 100.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.PSCAG.2

QR.C17025.Contract.PSCAG.3

Where Contract.SOBS (Source of basic salary ) not equal to 01 then Contract.PSCAG must not be 100.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.PSCAG.3

QR.C17025.Contract.RESAST.1

Contract.RESAST (Research assistant) must exist where Contract.ACEMPFUN (Academic employment function) = 2 and Contract.TERMS = 1 or 2.
Business RuleErrorAmended
Show more
Plain English
Research assistant must exist for non-atypical academic contracts that are research only.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.RESAST.1

QR.C17025.Contract.RESAST.2

Contract.RESAST (Research assistant) must not exist where Contract.ACEMPFUN (Academic employment function) does not equal 2 or Contract.TERMS = 3.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.RESAST.2

QR.C17025.Contract.RESCON.1

Where Contract.RESCON (Reason for the end of contract) = 8 (Retirement, excluding ill-health) there must be no new contracts starting after that Contract.ENDCON.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.RESCON.1

QR.C17025.Contract.RESCON.2

Contract.RESCON (Reason for the end of contract) must exist where Contract.TERMS = 1 or 2 and Contract.ENDCON exists.
Business RuleErrorAmended
Show more
Plain English
Reason for ending the contract must exist where the contract has ended.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.RESCON.2

QR.C17025.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.)
Business RuleErrorAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.RESCON.3

QR.C17025.Contract.SALREF.1

Where Contract.SALREF (Basic salary at reference date) exists, then Contract.SALREF must not be greater than 500000.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SALREF.1

QR.C17025.Contract.SALREF.2

Where Contract.SALREF (Basic salary at reference date) exists, then Contract.SALREF must not be less than 5800.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SALREF.2

QR.C17025.Contract.SALREF.3

Contract.SALREF (Basic salary at reference date) must not exist where Contract.SPOINT (Salary point) begins with C. (Clinical spine)
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SALREF.3

QR.C17025.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.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SALREF.4

QR.C17025.Contract.SOBS.1

Where there is more than one occurrence of Contract.SOBS (Source of basic salary) they must not be identical.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SOBS.1

QR.C17025.Contract.SOBS.2

Where Contract.SOBS (Source of basic salary) = 01 there must be no other occurrences of Contract.SOBS.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SOBS.2

QR.C17025.Contract.SOBS.3

Contract.SOBS (Source of basic salary) must exist where Contract.TERMS = 1 or 2.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SOBS.3

QR.C17025.Contract.STARTCON.1

Contract.STARTCON must not be after Y2-07-31
Business RuleErrorCarried Forward
Show 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.C16025.Contract.STARTCON.1

QR.C17025.Contract.STARTCON.2

Where exists Contract.STARTCON must not be after Contract.ENDCON.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Contract.STARTCON.2

QR.C17025.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.
Business RuleErrorCarried Forward
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.C16025.Contract.STARTCON.3

QR.C17025.Contract.STARTCON.4

Where Contract.STARTCON exists it must be after Person.BIRTHDTE.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Contract.STARTCON.4

QR.C17025.Contract.STARTCON.5

Contract.STARTCON must be before or on Person.DATELEFT where all Contract.TERMS = 1 or 2
Business RuleErrorCarried Forward
Show 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.C16025.Contract.STARTCON.5

QR.C17025.Contract.TCHWLH.1

Contract.TCHWLH (Teaching through the medium of Welsh) must not exist for providers in England, Scotland or Northern Ireland.
Business RuleErrorAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.TCHWLH.1

QR.C17025.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.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.TCHWLH.2

QR.C17025.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)
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.TCHWLH.3

QR.C17025.Contract.TERMS.1

Where Contract.MOEMP = 5 (Atypical) then Contract.TERMS must equal 3. (Atypical)
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.TERMS.1

QR.C17025.Contract.TERMS.2

Where Contract.TERMS = 3(Atypical) then Contract.ACEMPFUN must not equal 4 or null. (Not an academic contract)
Business RuleErrorAmended
Show more
Plain English
Non-academic atypical staff must not be returned.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
N/A

QR.C17025.Governor.ENDGOV.1

Governor.ENDGOV, if it exists, must be on or after Y1-08-01.
Business RuleErrorAdded
Show more
Plain English
The governor end date must be after the start of the collection.
Further Guidance
N/A
Reason for Change
New rule added following record review.
Previous Name of Rule
N/A

QR.C17025.Governor.EXPENDGOV.1

Governor.EXPENDGOV, if it exists, must be on or after Y1-08-01.
Business RuleErrorAdded
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.C17025.Governor.STARTGOV.1

Governor.STARTGOV must be on or before Y2-07-31.
Business RuleErrorAdded
Show more
Plain English
The governor expected start date must be before the end of the collection.
Further Guidance
N/A
Reason for Change
New rule added following record review.
Previous Name of Rule
N/A

QR.C17025.Person.ABLWELSH.1

Person.ABLWELSH (Ability to teach through the medium of Welsh) must not exist for providers in England, Scotland or Northern Ireland.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ABLWELSH.1

QR.C17025.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).
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ABLWELSH.2

QR.C17025.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).
Business RuleErrorAmended
Show more
Plain English
Academic teaching qualifications must exist for non-atypical academic contracts that involve teaching.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ACTCHQUAL.1

QR.C17025.Person.ACTCHQUAL.2

Only one occurrence of Person.ACTCHQUAL (Academic teaching qualification) = 02, 03, 04 or 05 can apply at a given point of time.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ACTCHQUAL.2

QR.C17025.Person.ACTCHQUAL.3

Where there is more than one occurrence of Person.ACTCHQUAL (Academic teaching qualification) they must not be identical.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ACTCHQUAL.3

QR.C17025.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.
Business RuleErrorAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ACTLEAVE.1

QR.C17025.Person.ACTLEAVE.2

Person.ACTLEAVE (Activity after leaving) must not exist where Person.DATELEFT is null.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ACTLEAVE.2

QR.C17025.Person.BIRTHDTE.3

Where Person.DATEFHEI is greater than or equal to (Y1)-08-01 then Person.BIRTHDTE must be before (Y1-15)-08-01.
Business RuleErrorCarried Forward
Show more
Plain English
Staff must be older than 15 at the start of the reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.BIRTHDTE.3

QR.C17025.Person.BIRTHDTE.4

Where Person.DATEFHEI is greater than or equal to (Y1)-08-01 then Person.BIRTHDTE must be after (Y1-91)-07-31
Business RuleErrorCarried Forward
Show more
Plain English
Staff are older than 91 at the start of the reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.BIRTHDTE.4

QR.C17025.Person.BIRTHDTE.7

Where Person.GOVFLAG= 1 (Yes) and Person.BIRTHDTE not equal to 1900-01-01 then Person.BIRTHDTE must be between (Y1-91)-07-31 and (Y1-10)-08-01
Business RuleErrorAdded
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added following record review.
Previous Name of Rule
N/A

QR.C17025.Person.CLINARD.1

Person.CLINARD (Clinical excellence award) must exist where any Contract.CLINICAL = 1.(Clinical academic doctors and dentists)
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.CLINARD.1

QR.C17025.Person.CLINARD.2

Person.CLINARD(Clinical excellence award) must not exist where all Contract.CLINICAL not equal to 1.(Clinical academic doctors and dentists)
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.CLINARD.2

QR.C17025.Person.Contract.1

Person.Contract must exist where Person.GOVFLAG = 2 or Person.GOVFLAG does not exist
Business RuleErrorAdded
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added following record review.
Previous Name of Rule
N/A

QR.C17025.Person.CURACCDIS.1

Person.CURACCDIS (Current academic discipline) must exist where any (Contract.ACEMPFUN = 1, 2 or 3) and Contract.TERMS = 1 or 2
Business RuleErrorAmended
Show 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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.CURACCDIS.1

QR.C17025.Person.CURACCDIS.2

Person.CURACCDIS (Current academic discipline) must not exist where all Contract.ACEMPFUN = 4 or 9
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.CURACCDIS.2

QR.C17025.Person.CURACCDIS.3

Where there is more than one occurrence of Person.CURACCDIS (Current academic discipline) they must not be identical.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.CURACCDIS.3

QR.C17025.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.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.DATEFHEI.1

QR.C17025.Person.DATEFHEI.2

Where exists Person.DATEFHEI must be before Y2-08-01
Business RuleErrorCarried Forward
Show more
Plain English
Date appointed must be before the next reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.DATEFHEI.2

QR.C17025.Person.DATEFHEI.3

Where exists Person.DATEFHEI must be after Person.BIRTHDTE.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.DATEFHEI.3

QR.C17025.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 or 2.
Business RuleErrorCarried Forward
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
N/A
Previous Name of Rule
QR.C16025.Person.DATELEFT.1

QR.C17025.Person.DATELEFT.2

Person.DATELEFT must not exist where any (Contract.TERMS = 1 or 2 and Contract.ENDCON are null).
Business RuleErrorCarried Forward
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.C16025.Person.DATELEFT.2

QR.C17025.Person.DATELEFT.3

Where exists Person.DATELEFT must be equal to or after Person.DATEFHEI.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.DATELEFT.3

QR.C17025.Person.DATELEFT.4

Person.DATELEFT must be between (Y1-1)-08-01 and (Y2)-07-31 (inclusive)
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.DATELEFT.4

QR.C17025.Person.ETHNIC.1

For providers in England and Wales Person.ETHNIC must not equal 13, 14 or 19.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.ETHNIC.1

QR.C17025.Person.ETHNIC.2

For providers in Scotland Person.ETHNIC must not equal 10 or 14.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.ETHNIC.2

QR.C17025.Person.ETHNIC.3

For providers in Northern Ireland Person.ETHNIC must not equal 13 or 19.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.ETHNIC.3

QR.C17025.Person.Governor.1

The Governor entity must exist where Person.GOVFLAG = 1 (Yes).
Business RuleErrorAdded
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added following record review.
Previous Name of Rule
N/A

QR.C17025.Person.Governor.4

At least Governor.ENDGOV or Governor.EXPENDGOV must exist if the Governor entity exists.
Business RuleErrorAdded
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added following record review.
Previous Name of Rule
N/A

QR.C17025.Person.GOVFLAG.1

Person.GOVFLAG must exist if provider is English, Scottish or Welsh.
Business RuleErrorAdded
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added following record review.
Previous Name of Rule
N/A

QR.C17025.Person.GOVFLAG.2

At least one occurrence of Person.GOVFLAG = 1 (Yes) must exist for providers in England, Scotland and Wales.
Business RuleErrorAdded
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added following record review.
Previous Name of Rule
N/A

QR.C17025.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)
Business RuleErrorAmended
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
Description changed to include the new Governor entity
Previous Name of Rule
QR.C16025.Person.HQHELD.1

QR.C17025.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)).
Business RuleErrorCarried Forward
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.C16025.Person.LOCLEAVE.1

QR.C17025.Person.LOCLEAVE.2

Person.LOCLEAVE must not exist where Person.DATELEFT does not exist.
Business RuleErrorCarried Forward
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.C16025.Person.LOCLEAVE.2

QR.C17025.Person.LOCLEAVE.3

Person.LOCLEAVE must not exist where Person.DATELEFT exists and any Contract.RESCON is coded 8.(Death)
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.LOCLEAVE.3

QR.C17025.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.
Business RuleWarningCarried Forward
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.C16025.Person.LOCLEAVE.4

QR.C17025.Person.NATIOND.1

Person.NATIOND (National identity) must exist for providers in Wales.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.NATIOND.1

QR.C17025.Person.NATIOND.2

Person.NATIOND (National identity) must not exist for providers in England, Scotland and Northern Ireland.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.NATIOND.2

QR.C17025.Person.NATIOND.3

Where there is more than one occurrence of Person.NATIOND (National identity) they must not be identical.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.NATIOND.3

QR.C17025.Person.PARLEAVE.1

Person.PARLEAVE (Parental leave) should not equal 1 (Maternity leave) where Person.SEXID = 1. (Male)
Business RuleWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.PARLEAVE.1

QR.C17025.Person.PARLEAVE.2

Person.PARLEAVE (Parental leave) should not equal 2 (Additional paternity leave) where Person.SEXID = 2.(Female)
Business RuleWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.PARLEAVE.2

QR.C17025.Person.PARLEAVE.3

Where multiple occurrences of Person.PARLEAVE (Parental leave) exist they must not be identical or equal '1' and '2' (Maternity and additional paternity leave).
Business RuleErrorAmended
Show more
Plain English
Invalid combinations of Person.PARLEAVE have been returned.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
N/A

QR.C17025.Person.PREVEMP.1

Person.PREVEMP must exist where (Contract.TERMS = 1 or 2) and any Activity.ACTSOC begins with 1, 2 or 3.
Business RuleErrorCarried Forward
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.C16025.Person.PREVEMP.1

QR.C17025.Person.PREVEMP.2

Person.PREVEMP must not equal 05 or 06 where Person.DATEFHEI >= 2012-08-01.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.PREVEMP.2

QR.C17025.Person.PREVEMP.3

Person.PREVEMP must not equal 20 (Working in the voluntary sector) where Person.DATEFHEI is after 2014-07-31
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.PREVEMP.3

QR.C17025.Person.PREVEMP.5

Where (Person.DATEFHEI > '(Y1)-07-31' and any contract record for this person record has (Activity.ACTSOC major groups 1, 2 or 3 and Contract.TERMS = 1 or 2)) then Person.PREVEMP should not equal 99 (Not known).
Business RuleWarningAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.PREVEMP.5

QR.C17025.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.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.PREVHEI.1

QR.C17025.Person.PREVHEI.2

Person.PREVHEI (Previous higher education institution) must not exist where Person.PREVEMP not equal to 01 or 21.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.PREVHEI.2

QR.C17025.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).
Business RuleErrorCarried Forward
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.C16025.Person.REGBODY.1

QR.C17025.Person.REGBODY.2

Person.REGBODY should only exist where there is a Contract.CLINICAL = 1, 2, 3, or 4 or there is a Contract with (any Activity.CCENTRE = 109 and Contract.ACEMPFUN = 1, 2, or 3 and Contract.TERMS = 1 or 2).
Business RuleWarningCarried Forward
Show more
Plain English
Regulatory body should not exist for non-clinical academic staff or contracts that are not academic or are academic but involve no teaching or research and have an activity other than veterinary science.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.REGBODY.2

QR.C17025.Person.REGBODY.3

Where there is more than one occurrence of Person.REGBODY they must not be identical.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.REGBODY.3

QR.C17025.Person.REGBODY.4

Person.REGBODY (must equal 01 or 02) where any Contract.CLINICAL = 1.(clinical academic doctors and dentists)
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.REGBODY.4

QR.C17025.Person.REGBODY.5

Person.REGBODY must equal 06 (The Nursing and Midwifery Council (NMC)) where any Contract.CLINICAL = 2 (Clinical academic nurses and midwives).
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.REGBODY.5

QR.C17025.Person.REGBODY.6

Person.REGBODY must equal 07 where any Contract.CLINICAL = 3(clinical academic health professions).
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.REGBODY.6

QR.C17025.Person.RELBLF.1

For providers in England and Wales Person.RELBLF (Religion or belief) must not equal 04, 05, 06, 07, 08 or 09.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.RELBLF.1

QR.C17025.Person.RELBLF.2

For providers in Scotland Person.RELBLF (Religion or belief) must not equal 03, 06, 07 or 08.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.RELBLF.2

QR.C17025.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).
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.RELBLF.3

QR.C17025.Person.STAFFID.1

No two records can have the same Person.STAFFID
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.STAFFID.1

QR.C17025.Person.STAFFID.2

Person.STAFFID must not contain all zeroes.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.STAFFID.2

QR.C17025.Person.STAFFID.3

Characters 3 to 6 of Person.STAFFID must be a valid INSTID.
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.STAFFID.3

QR.C17025.Person.STAFFID.4

Character 13 of Person.STAFFID must pass the checksum test given in the coding manual
Business RuleErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.STAFFID.4

QR.C17025.Person.STAFFID.9

The combination of Person.STAFFID and Contract.CONTID field must be unique within a HEP's submission.
Business RuleErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Details changed from SEX to SEXID.
Previous Name of Rule
QR.C16025.Person.STAFFID.9

QR.C17025.Activity.CCENTRE.1

The Activity.CCENTRE code must be one of AcademicCostCentres.ACCENTRE codes submitted for the Provider profile record.
ExceptionErrorCarried Forward
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.C16025.Activity.CCENTRE.1

QR.C17025.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.
ExceptionErrorCarried Forward
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.C16025.Activity.CCENTRE.2

QR.C17025.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.
ExceptionWarningCarried Forward
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.C17025.Activity.CCENTRE.4

The Activity.CCENTRE was returned in last year's but not in this year's return.
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Activity.CCENTRE.5

The Activity.CCENTRE was returned in this year's but not in last year's return.
ExceptionWarningCarried Forward
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.C17025.Activity.CCENTRE.6

For each Activity.CCENTRE, the total staff (excluding atypical) FTE has changed by more than 30% between years.
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Activity.CCENTRE.7

For each Activity.CCENTRE the total staff FTE for atypical contracts has changed by more than 50% between years.
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Activity.CCENTRE.8

For each Activity.CCENTRE the FTE for staff (excluding atypical) is less than 0.05.
ExceptionWarningCarried Forward
Show more
Plain English
A HESA cost centre has a very low full-time equivalent for non-atypical staff.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Contract.CAMPID.1

Contract.CAMPID (Campus identifier) must have been submitted in the Provider profile collection.
ExceptionErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.CAMPID.1

QR.C17025.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).
ExceptionWarningCarried Forward
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.C16025.Contract.CONFTE.5

QR.C17025.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.
ExceptionWarningCarried Forward
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.C16025.Contract.CONFTE.6

QR.C17025.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.
ExceptionWarningCarried Forward
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.C16025.Contract.CONFTE.7

QR.C17025.Contract.LEVELS.2

More than 10 people or 2% (whichever is less) where Contract.LEVELS = B0.(UCEA level 2)
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.LEVELS.2

QR.C17025.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.
ExceptionErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.LEVELS.3

QR.C17025.Contract.LEVELS.6

Contract.LEVELS should be consistent where the same Person.STAFFID and Contract.CONTID appears in both last year's and this year's returns.
ExceptionWarningCarried Forward
Show more
Plain English
Contract.LEVELS has changed this year compared to last year.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Contract.LEVELS.7

Where Contract.ACEMPFUN = 4 (Not an academic contract) then Contract.LEVELS should not equal F1 (Professor).
ExceptionWarningCarried Forward
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.C17025.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.
ExceptionWarningCarried Forward
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.C17025.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.
ExceptionWarningAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.RESCON.4

QR.C17025.Contract.SALREF.10

Contract.SALREF (Basic salary at reference date) should not be less than 40,000 (but greater than 5799) 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.
ExceptionWarningAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
N/A

QR.C17025.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.
ExceptionWarningAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
N/A

QR.C17025.Contract.SALREF.12

Contract.SALREF (Basic salary at reference date) should not be between 13,400 and 15,350 (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.
ExceptionWarningAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
N/A

QR.C17025.Contract.SALREF.5

Contract.SALREF (Basic salary at reference date) should not be between 5800 and 13400 where (Contract.TERMS = 1 or 2 and Contract.MOEMP in (1,2,3,4,6) and Contract.APPRENTICESHIP = 9 (Not on an apprenticeship).
ExceptionWarningAmended
Show more
Plain English
Salary should not be between 5800 and 13400 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
Rule description amended to identify non-apprenticeship contracts.
Previous Name of Rule
QR.C16025.Contract.SALREF.5

QR.C17025.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 year's should not be more than 25%
ExceptionWarningAmended
Show more
Plain English
Salary has changed by more than 25% between years.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SALREF.6

QR.C17025.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).
ExceptionWarningAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SALREF.7

QR.C17025.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)
ExceptionWarningAmended
Show more
Plain English
Salary should not be less than £46,435 for professors.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SALREF.8

QR.C17025.Contract.SALREF.9

Contract.SALREF (Basic salary at reference date) should not be greater than 325000.
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SALREF.9

QR.C17025.Contract.SPOINT.1

Contract.SPOINT (Salary point) should start with C (Clinical spine) where Contract.CLINICAL does not equal 0.(Not clinical academic)
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SPOINT.1

QR.C17025.Contract.SPOINT.2

Contract.SPOINT (Salary point) must contain a valid entry.
ExceptionErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Contract.SPOINT.2

QR.C17025.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'.
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Contract.STARTCON.6

QR.C17025.Contract.STARTCON.7

Contract.STARTCON should be consistent where the same Person.STAFFID and Contract.CONTID appears in both last year's and this year's returns.
ExceptionWarningCarried Forward
Show more
Plain English
Contract.STARTCON has changed this year compared to last year.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Person.ABLWELSH.3

More than 5% of staff where Person.ABLWELSH (Ability to teach through the medium of Welsh) = 9.(Information not sought)
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ABLWELSH.3

QR.C17025.Person.ACTCHQUAL.4

Where Person.ACTCHQUAL (Academic teaching qualification) = 90 or 99, then no other occurrence of Person.ACTCHQUAL should exist
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ACTCHQUAL.4

QR.C17025.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)
ExceptionWarningAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ACTCHQUAL.5

QR.C17025.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.
ExceptionWarningCarried Forward
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
N/A
Previous Name of Rule
QR.C16025.Person.ACTCHQUAL.6

QR.C17025.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).
ExceptionWarningCarried Forward
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
N/A
Previous Name of Rule
N/A

QR.C17025.Person.ACTCHQUAL.8

For providers in England, Northern Ireland and Wales, more than 10% of staff where Person.DATEFHEI > '(Y1)-07-31' and (any Contract.ACEMPFUN = 1 or 3 and Contract.TERMS = 1 or 2) have Person.ACTCHQUAL = 90 (Not known).
ExceptionWarningCarried Forward
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
N/A
Previous Name of Rule
N/A

QR.C17025.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).
ExceptionWarningAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ACTLEAVE.3

QR.C17025.Person.ACTLEAVE.4

More than 1% of staff have Person.ACTLEAVE (Activity after leaving) = 11 (Retired) and Person.BIRTHDTE after '(Y1-50)-07-31'
ExceptionWarningAmended
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
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.ACTLEAVE.4

QR.C17025.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).
ExceptionWarningCarried Forward
Show more
Plain English
There is a high percentage of unknown Person.ACTLEAVE for non-atypical staff.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Person.ACTLEAVE.6

More than 30% of staff where Person.DATELEFT is not null and Person.DATEFHEI > '(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.ACTLEAVE = 90 (Not known).
ExceptionWarningCarried Forward
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
N/A
Previous Name of Rule
N/A

QR.C17025.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.
ExceptionWarningCarried Forward
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.C16025.Person.BIRTHDTE.5

QR.C17025.Person.BIRTHDTE.6

Where (Person.DATEFHEI is before (Y1)-08-01 or does not exist and contract entity exists) then Person.BIRTHDTE must be between (Y1-100)-07-31 and (Y1-10)-08-01.
ExceptionErrorAmended
Show more
Plain English
Staff must be between the ages of 10 and 100.
Further Guidance
N/A
Reason for Change
Rule description updated to include contract entity.
Previous Name of Rule
QR.C16025.Person.BIRTHDTE.6

QR.C17025.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.
ExceptionWarningAmended
Show more
Plain English
Clinical excellence award should be consistent between years.
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.CLINARD.3

QR.C17025.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.
ExceptionWarningCarried Forward
Show more
Plain English
Date appointed should be consistent between years.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.DATEFHEI.4

QR.C17025.Person.DISABLE.1

More than 99.0% of staff where Person.DISABLE = 00.(No known disability)
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.DISABLE.1

QR.C17025.Person.DISABLE.2

More than 5% (and more than 20 records) of staff have a Person.DISABLE = 97 (Information refused).
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Person.DISABLE.3

More than 5% (and more than 20 records) of staff have a Person.DISABLE = 96.
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Person.DISABLE.4

More than 5% (and more than 20 records) of staff have a Person.DISABLE = 08.
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Person.ETHNIC.4

More than 3% of staff where (Person.ETHNIC does not equal 90 or 98 in last year's return and Person.ETHNIC = 90 or 98 in this year's return).
ExceptionWarningCarried Forward
Show more
Plain English
Ethnicity was previously known but this year it is unknown.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.ETHNIC.4

QR.C17025.Person.ETHNIC.5

More than 7.5% of staff (where any Contract.TERMS = 1 or 2) have Person.ETHNIC = 90 (Not known).
ExceptionWarningCarried Forward
Show more
Plain English
There is a high percentage of unknown ethnicities for non-atypical staff.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Person.ETHNIC.6

More than 7.5% of staff where Person.DATEFHEI > '(Y1)-07-31' and (any Contract.TERMS = 1 or 2) have Person.ETHNIC = 90 (Not known).
ExceptionWarningCarried Forward
Show more
Plain English
There is a high percentage of unknown ethnicities for non-atypical new starters.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Person.ETHNIC.7

More than 20% of staff with atypical contracts only (XPOPPA01 = 1) have Person.ETHNIC = 90 (Not known).
ExceptionWarningCarried Forward
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.C17025.Person.GENREASSIGN.1

More than 3% of staff where Person.GENREASSIGN = 2 (No).
ExceptionWarningAdded
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule added to replace old GENDERID.1 rule.
Previous Name of Rule
QR.C16025.Person.GENDERID.1

QR.C17025.Person.GENREASSIGN.2

More than 3% of staff where Person.GENREASSIGN = 3 (Information refused).
ExceptionWarningAdded
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added following record review.
Previous Name of Rule
N/A

QR.C17025.Person.Governor.2

The number of governors returned in the staff return differs by more than +/- 50% of the number returned in the HE-BCI collection
ExceptionErrorAdded
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added following record review.
Previous Name of Rule
N/A

QR.C17025.Person.Governor.3

The number of governors returned in the staff return differs by between +/-15% and +/-50% from the number returned in the HE-BCI collection
ExceptionWarningAdded
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added following record review.
Previous Name of Rule
N/A

QR.C17025.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)).
ExceptionWarningCarried Forward
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.C16025.Person.HQHELD.2

QR.C17025.Person.HQHELD.3

If (Person.DATEFHEI is greater than or equal to '(Y1)-08-01)' and any contract record for this person has (Contract.TERMS = 1 or 2 and any Activity.ACTSOC = major groups 1, 2 or 3) then Person.HQHELD should not equal 98.
ExceptionWarningCarried Forward
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
N/A
Previous Name of Rule
QR.C16025.Person.HQHELD.3

QR.C17025.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).
ExceptionWarningCarried Forward
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.C17025.Person.HQHELD.5

More than 15% of staff where Person.DATEFHEI > '(Y1)-07-31' and (any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3) have Person.HQHELD = 99 (Not known).
ExceptionWarningCarried Forward
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
N/A
Previous Name of Rule
N/A

QR.C17025.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).
ExceptionWarningCarried Forward
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
N/A
Previous Name of Rule
N/A

QR.C17025.Person.LOCLEAVE.6

More than 20% of staff where Person.DATELEFT is not null and Person.DATEFHEI > '(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).
ExceptionWarningCarried Forward
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
N/A
Previous Name of Rule
N/A

QR.C17025.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.
ExceptionWarningCarried Forward
Show more
Plain English
Nationality should be consistent between years.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.NATION.1

QR.C17025.Person.NATION.2

More than 7.5% of staff (where any Contract.TERMS = 1 or 2) have Person.NATION = ZZ (Not known).
ExceptionWarningCarried Forward
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.C17025.Person.NATION.3

More than 7.5% of staff where Person.DATEFHEI > '(Y1)-07-31' and (any Contract.TERMS = 1 or 2) have Person.NATION = ZZ (Not known).
ExceptionWarningCarried Forward
Show more
Plain English
There is a high percentage of unknown nationalities for non-atypical new starters.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
N/A

QR.C17025.Person.NATION.4

More than 10% of staff with atypical contracts only (XPOPPA01 = 1) have Person.NATION = ZZ (Not known).
ExceptionWarningCarried Forward
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.C17025.Person.NATIOND.4

Where there is an occurrence of Person.NATIOND (National identity) = R or U (Information refused or Unknown), then no other occurrence of Person.NATIOND should exist.
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.NATIOND.4

QR.C17025.Person.NATIOND.5

For providers in Wales, more than 5% of staff have Person.NATIOND (National identity) = R (Information refused).
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
N/A

QR.C17025.Person.NATIOND.6

For providers in Wales, more than 5% of staff have Person.NATIOND (National identity)= U (Unknown).
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
N/A

QR.C17025.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.
ExceptionWarningCarried Forward
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.C16025.Person.PREVEMP.4

QR.C17025.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).
ExceptionWarningCarried Forward
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.C17025.Person.PREVEMP.7

More than 15% of staff where Person.DATEFHEI > '(Y1)-07-31' and (any Contract.TERMS = 1 or 2 and Activity.ACTSOC = major groups 1, 2 or 3) have Person.PREVEMP = 99 (Not known).
ExceptionWarningCarried Forward
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
N/A
Previous Name of Rule
N/A

QR.C17025.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.
ExceptionWarningCarried Forward
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.C16025.Person.PREVHEI.3

QR.C17025.Person.PREVHEI.4

Where Person.PREVEMP = 01, then Person.PREVHEI must not be the same as the returning provider.
ExceptionErrorCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.PREVHEI.4

QR.C17025.Person.PREVHEI.5

Where Person.PREVEMP = 21 (Not in regular employment) and Person.PREVHEI exists it must be the same as the returning provider.
ExceptionErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.PREVHEI.5

QR.C17025.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.
ExceptionWarningCarried Forward
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.C16025.Person.REGBODY.7

QR.C17025.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)
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.REGBODY.8

QR.C17025.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.
ExceptionWarningAdded
Show more
Plain English
Sexual identification should be consistent between years.
Further Guidance
N/A
Reason for Change
Rule added to replace old Person.SEX.1 rule.
Previous Name of Rule
QR.C16025.Person.SEX.1

QR.C17025.Person.SEXORT.1

There should not be more than 10% of staff where Person.SEXORT = 02 (Gay man) and Person.SEXID = 2 (Female).
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.SEXORT.1

QR.C17025.Person.SEXORT.2

There should not be more than 10% of staff where Person.SEXORT = 03 (Gay woman/lesbian) and Person.SEXID = 1 (Male).
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.SEXORT.2

QR.C17025.Person.SEXORT.3

There should not be more than 5% of staff (and more than 5 records) where Person.SEXORT = 05 (Other).
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Description changed to clarify the meaning of the rule
Previous Name of Rule
QR.C16025.Person.SEXORT.3

QR.C17025.Person.STAFFID.10

No two records can have the same Person.STAFFID.
ExceptionErrorAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Details changed from SEX to SEXID.
Previous Name of Rule
QR.C16025.Person.STAFFID.10

QR.C17025.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.
ExceptionWarningCarried Forward
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.C16025.Person.STAFFID.5

QR.C17025.Person.STAFFID.6

All staff with 10 or more contracts.
ExceptionWarningCarried Forward
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
QR.C16025.Person.STAFFID.6

QR.C17025.Person.STAFFID.7

Potential duplicate entries for non-atypical staff exist but have different Person.STAFFIDs.
ExceptionWarningAmended
Show more
Plain English
N/A
Further Guidance
N/A
Reason for Change
Details changed from SEX to SEXID.
Previous Name of Rule
QR.C16025.Person.STAFFID.7

QR.C17025.Person.STAFFID.8

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.
ExceptionErrorAmended
Show more
Plain English
Staff member returned last year has not been returned this year.
Further Guidance
N/A
Reason for Change
Details changed from SEX to SEXID.
Previous Name of Rule
QR.C16025.Person.STAFFID.8

QR.C17025.Person.GENDERID.1

More than 3% of staff where Person.GENDERID = 02.
ExceptionWarningDeleted
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.C17025.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.
ExceptionWarningDeleted
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