Skip to main content

Quality Rules Directory for C15025

Download all the C15025 rules

Filter

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

QR.C15025.Person.ABLWELSH.1

Person.ABLWELSH must not exist for providers in England, Scotland or Northern Ireland.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.ABLWELSH.BusinessRule.1

QR.C15025.Person.ABLWELSH.2

Person.ABLWELSH must exist for providers in Wales where any (Contract.ACEMPFUN = 1 or 3 and Contract.TERMS = 1 or 2).
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.ABLWELSH.BusinessRule.2

QR.C15025.Person.ACTCHQUAL.1

Person.ACTCHQUAL must exist for providers in England, Wales and Northern Ireland where any (Contract.ACEMPFUN = 1 or 3) and (Contract.TERMS = 1 or 2).
Business RuleErrorN/A
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
C14025.Person.ACTCHQUAL.BusinessRule.1

QR.C15025.Person.ACTCHQUAL.2

Only one occurrence of Person.ACTCHQUAL = 02, 03, 04 or 05 can apply at a given point of time.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.ACTCHQUAL.BusinessRule.2

QR.C15025.Person.ACTCHQUAL.3

Where there is more than one occurrence of Person.ACTCHQUAL they must not be identical.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.ACTCHQUAL.BusinessRule.3

QR.C15025.Person.ACTLEAVE.1

Person.ACTLEAVE 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 RuleErrorN/A
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
C14025.Person.ACTLEAVE.BusinessRule.1

QR.C15025.Person.ACTLEAVE.2

Person.ACTLEAVE must not exist where Person.DATELEFT is null.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.ACTLEAVE.BusinessRule.2

QR.C15025.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 RuleErrorAmended
Plain English
Staff must be older than 15 at the start of the reporting period.
Further Guidance
N/A
Reason for Change
Wording change only.
Previous Name of Rule
C14025.Person.BIRTHDTE.BusinessRule.3

QR.C15025.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 RuleErrorAmended
Plain English
Staff are older than 91 at the start of the reporting period.
Further Guidance
N/A
Reason for Change
Wording change only.
Previous Name of Rule
C14025.Person.BIRTHDTE.BusinessRule.4

QR.C15025.Person.CLINARD.1

Person.CLINARD must exist where any Contract.CLINICAL = 1.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.CLINARD.BusinessRule.1

QR.C15025.Person.CLINARD.2

Person.CLINARD must not exist where all Contract.CLINICAL not equal to 1.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.CLINARD.BusinessRule.2

QR.C15025.Person.CURACCDIS.1

Person.CURACCDIS must exist where any (Contract.ACEMPFUN = 1, 2 or 3) and Contract.TERMS = 1 or 2
Business RuleErrorN/A
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
C14025.Person.CURACCDIS.BusinessRule.1

QR.C15025.Person.CURACCDIS.2

Person.CURACCDIS must not exist where all Contract.ACEMPFUN = 4 or 9
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.CURACCDIS.BusinessRule.2

QR.C15025.Person.CURACCDIS.3

Where there is more than one occurrence of Person.CURACCDIS they must not be identical.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.CURACCDIS.BusinessRule.3

QR.C15025.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 RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.DATEFHEI.BusinessRule.1

QR.C15025.Person.DATEFHEI.2

Where exists Person.DATEFHEI must be before Y2-08-01
Business RuleErrorN/A
Plain English
Date appointed must be before the next reporting period.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.DATEFHEI.BusinessRule.4

QR.C15025.Person.DATEFHEI.3

Where exists Person.DATEFHEI must be after Person.BIRTHDTE.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.DATEFHEI.BusinessRule.5

QR.C15025.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 RuleErrorN/A
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
C14025.Person.DATELEFT.BusinessRule.1

QR.C15025.Person.DATELEFT.2

Person.DATELEFT must not exist where any (Contract.TERMS = 1 or 2 and Contract.ENDCON are null).
Business RuleErrorN/A
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
C14025.Person.DATELEFT.BusinessRule.2

QR.C15025.Person.DATELEFT.3

Where exists Person.DATELEFT must be equal to or after Person.DATEFHEI.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.DATELEFT.BusinessRule.3

QR.C15025.Person.DATELEFT.4

Person.DATELEFT must be between (Y1-1)-08-01 and (Y2)-07-31 (inclusive)
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.DATELEFT.BusinessRule.4

QR.C15025.Person.ETHNIC.1

For providers in England and Wales Person.ETHNIC must not equal 13, 14 or 19.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.ETHNIC.BusinessRule.1

QR.C15025.Person.ETHNIC.2

For providers in Scotland Person.ETHNIC must not equal 10 or 14.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.ETHNIC.BusinessRule.2

QR.C15025.Person.ETHNIC.3

For providers in Northern Ireland Person.ETHNIC must not equal 13 or 19.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.ETHNIC.BusinessRule.3

QR.C15025.Person.HQHELD.1

Person.HQHELD must exist where (Contract.TERMS = 1 or 2) and any Activity.ACTSOC begins with 1, 2 or 3
Business RuleErrorN/A
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
C14025.Person.HQHELD.BusinessRule.1

QR.C15025.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 RuleErrorN/A
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
C14025.Person.LOCLEAVE.BusinessRule.1

QR.C15025.Person.LOCLEAVE.2

Person.LOCLEAVE must not exist where Person.DATELEFT does not exist.
Business RuleErrorN/A
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
C14025.Person.LOCLEAVE.BusinessRule.2

QR.C15025.Person.LOCLEAVE.3

Person.LOCLEAVE must not exist where Person.DATELEFT exists and any Contract.RESCON is coded 8.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.LOCLEAVE.BusinessRule.3

QR.C15025.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 RuleWarningAmended
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
Rule amended to business stage.
Previous Name of Rule
C14025.Person.LOCLEAVE.Exception.1

QR.C15025.Person.NATIOND.1

Person.NATIOND must exist for providers in Wales.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.NATIOND.BusinessRule.1

QR.C15025.Person.NATIOND.2

Person.NATIOND must not exist for providers in England, Scotland and Northern Ireland.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.NATIOND.BusinessRule.2

QR.C15025.Person.NATIOND.3

Where there is more than one occurrence of Person.NATIOND they must not be identical.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.NATIOND.BusinessRule.3

QR.C15025.Person.PARLEAVE.1

Person.PARLEAVE should not equal 1 where Person.SEX = 1.
Business RuleWarningAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule moved to business stage and removed percentage check.
Previous Name of Rule
C14025.Person.PARLEAVE.Exception.1

QR.C15025.Person.PARLEAVE.2

Person.PARLEAVE should not equal 2 where Person.SEX = 2.
Business RuleWarningAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule moved to business stage and removed percentage check.
Previous Name of Rule
C14025.Person.PARLEAVE.Exception.2

QR.C15025.Person.PARLEAVE.3

Where multiple occurrences of Person.PARLEAVE exist they must not be identical or equal '1' and '2'.
Business RuleErrorAdded
Plain English
Invalid combinations of Person.PARLEAVE have been returned.
Further Guidance
N/A
Reason for Change
New rule added to prevent invalid combinations.
Previous Name of Rule
N/A

QR.C15025.Person.PREVEMP.1

Person.PREVEMP must exist where (Contract.TERMS = 1 or 2) and any Activity.ACTSOC begins with 1, 2 or 3.
Business RuleErrorN/A
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
C14025.Person.PREVEMP.BusinessRule.1

QR.C15025.Person.PREVEMP.2

Person.PREVEMP must not equal 05 or 06 where Person.DATEFHEI >= 2012-08-01.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.PREVEMP.BusinessRule.2

QR.C15025.Person.PREVEMP.3

Person.PREVEMP must not equal 20 where Person.DATEFHEI is after 2014-07-31
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.PREVEMP.BusinessRule.3

QR.C15025.Person.PREVHEI.1

Person.PREVHEI must exist where Person.PREVEMP = 01 and any Activity.ACTSOC begins with 1, 2 or 3.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.PREVHEI.BusinessRule.1

QR.C15025.Person.PREVHEI.2

Person.PREVHEI must not exist where Person.PREVEMP not equal to 01 or 21.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.PREVHEI.BusinessRule.2

QR.C15025.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 RuleErrorN/A
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
C14025.Person.REGBODY.BusinessRule.1

QR.C15025.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 RuleWarningN/A
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
C14025.Person.REGBODY.BusinessRule.2

QR.C15025.Person.REGBODY.3

Where there is more than one occurrence of Person.REGBODY they must not be identical.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.REGBODY.BusinessRule.3

QR.C15025.Person.REGBODY.4

Person.REGBODY (must equal 01 or 02) where any Contract.CLINICAL = 1.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.REGBODY.BusinessRule.4

QR.C15025.Person.REGBODY.5

Person.REGBODY must equal 06 where any Contract.CLINICAL = 2.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.REGBODY.BusinessRule.5

QR.C15025.Person.REGBODY.6

Person.REGBODY must equal 07 where any Contract.CLINICAL = 3 .
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.REGBODY.BusinessRule.6

QR.C15025.Person.RELBLF.1

For providers in England and Wales Person.RELBLF must not equal 04, 05, 06, 07, 08 or 09.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.RELBLF.BusinessRule.1

QR.C15025.Person.RELBLF.2

For providers in Scotland Person.RELBLF must not equal 03, 06, 07 or 08.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.RELBLF.BusinessRule.2

QR.C15025.Person.RELBLF.3

For providers in Northern Ireland Person.RELBLF must not equal 03 or 04.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.RELBLF.BusinessRule.3

QR.C15025.Person.STAFFID.1

No two records can have the same Person.STAFFID
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.STAFFID.BusinessRule.1

QR.C15025.Person.STAFFID.2

Person.STAFFID must not contain all zeroes.
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.STAFFID.BusinessRule.2

QR.C15025.Person.STAFFID.3

Characters 3 to 6 of Person.STAFFID must be a valid INSTID.
Business RuleErrorAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule wording amended
Previous Name of Rule
C14025.Person.STAFFID.BusinessRule.3

QR.C15025.Person.STAFFID.4

Character 13 of Person.STAFFID must pass the checksum test given in the coding manual
Business RuleErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.STAFFID.BusinessRule.4

QR.C15025.Person.STAFFID.9

The combination of Person.STAFFID and Contract.CONTID field must be unique within a HEP's submission.
Business RuleErrorAmended
Plain English
N/A
Further Guidance
N/A
Reason for Change
Rule moved to business stage.
Previous Name of Rule
C14025.Person.STAFFID.Exception.5

QR.C15025.Person.ABLWELSH.3

More than 5% of staff where Person.ABLWELSH = 9.
ExceptionWarningN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.ABLWELSH.Exception.1

QR.C15025.Person.ACTCHQUAL.4

Where Person.ACTCHQUAL = 90 or 99, then no other occurrence of Person.ACTCHQUAL should exist
ExceptionWarningN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.ACTCHQUAL.Exception.1

QR.C15025.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.
ExceptionWarningN/A
Plain English
Staff with non-atypical academic teaching contracts do not have an academic teaching qualification.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.ACTCHQUAL.Exception.2

QR.C15025.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.
ExceptionWarningN/A
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
C14025.Person.ACTCHQUAL.Exception.3

QR.C15025.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).
ExceptionWarningAdded
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.C15025.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).
ExceptionWarningAdded
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.C15025.Person.ACTLEAVE.3

Where Person.ACTLEAVE = 05 then Person.LOCLEAVE should be in (1, 2, 3, 4, 5).
ExceptionWarningN/A
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
C14025.Person.ACTLEAVE.Exception.1

QR.C15025.Person.ACTLEAVE.4

More than 5% of staff have Person.ACTLEAVE = 11 and Person.BIRTHDTE after '(Y1-50)-07-31'
ExceptionWarningN/A
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
C14025.Person.ACTLEAVE.Exception.3

QR.C15025.Person.ACTLEAVE.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.ACTLEAVE = 90 (Not known).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown Person.ACTLEAVE for non-atypical staff.
Further Guidance
N/A
Reason for Change
New rule added to warn where non-atypical staff have a high percentage of unknown activity after leaving.
Previous Name of Rule
N/A

QR.C15025.Person.ACTLEAVE.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.ACTLEAVE = 90 (Not known).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown Person.ACTLEAVE for non-atypical new starters.
Further Guidance
N/A
Reason for Change
New rule added to warn where non-atypical new starters have a high percentage of unknown activity after leaving.
Previous Name of Rule
N/A

QR.C15025.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.
ExceptionWarningN/A
Plain English
Staff date of birth should be consistent between years.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.BIRTHDTE.Exception.1

QR.C15025.Person.BIRTHDTE.6

Where (Person.DATEFHEI is before (Y1)-08-01 or does not exist) then Person.BIRTHDTE should be between (Y1-100)-07-31 and (Y1-10)-08-01.
ExceptionWarningAmended
Plain English
Staff should be between the ages of 10 and 100.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.BIRTHDTE.Exception.2

QR.C15025.Person.CLINARD.3

More than 10% of staff members (and more than 10 staff) where Person.CLINARD differs between years, excluding where Person.CLINARD = 00 in last year's return.
ExceptionWarningN/A
Plain English
Clinical excellence award should be consistent between years.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.CLINARD.Exception.1

QR.C15025.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.
ExceptionWarningN/A
Plain English
Date appointed should be consistent between years.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.DATEFHEI.Exception.1

QR.C15025.Person.DISABLE.1

More than 99.0% of staff where Person.DISABLE = 00.
ExceptionWarningN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.DISABLE.Exception.3

QR.C15025.Person.DISABLE.2

More than 5% (and more than 20 records) of staff have a Person.DISABLE = 97 (Information refused).
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added to warn where a high percentage of staff have a disability code of 97 'Information refused'
Previous Name of Rule
N/A

QR.C15025.Person.DISABLE.3

More than 5% (and more than 20 records) of staff have a Person.DISABLE = 96.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added to warn where a high percentage of staff have a disability code of 96 'A disability, impairment or medical condition that is not listed above'.
Previous Name of Rule
N/A

QR.C15025.Person.DISABLE.4

More than 5% (and more than 20 records) of staff have a Person.DISABLE = 08.
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added to warn where a high percentage of staff have a disability code of 08 'Two or more impairments and/or disabling medical conditions'.
Previous Name of Rule
N/A

QR.C15025.Person.ETHNIC.4

More than 20% 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).
ExceptionWarningN/A
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
C14025.Person.ETHNIC.Exception.2

QR.C15025.Person.ETHNIC.5

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

QR.C15025.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).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown ethnicities for non-atypical new starters.
Further Guidance
N/A
Reason for Change
New rule added to warn where non-atypical new starters have a high percentage of unknown ethnicity.
Previous Name of Rule
N/A

QR.C15025.Person.ETHNIC.7

More than 20% of staff with atypical contracts only (XPOPPA01 = 1) have Person.ETHNIC = 90 (Not known).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown ethnicities for staff with only atypical contracts.
Further Guidance
N/A
Reason for Change
New rule added to warn where staff with only atypical contracts have a high percentage of unknown ethnicity.
Previous Name of Rule
N/A

QR.C15025.Person.GENDERID.1

More than 20% of staff where Person.GENDERID = 02.
ExceptionWarningN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.GENDERID.Exception.1

QR.C15025.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)).
ExceptionWarningN/A
Plain English
Highest qualification held has changed between years.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.HQHELD.Exception.2

QR.C15025.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.
ExceptionWarningN/A
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
C14025.Person.HQHELD.Exception.3

QR.C15025.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).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown highest qualification held for non-atypical staff.
Further Guidance
N/A
Reason for Change
New rule added to warn where non-atypical staff have a high percentage of unknown Person.HQHELD.
Previous Name of Rule
N/A

QR.C15025.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).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown highest qualification held for non-atypical new starters.
Further Guidance
N/A
Reason for Change
New rule added to warn where non-atypical new starters have a high percentage of unknown Person.HQHELD.
Previous Name of Rule
N/A

QR.C15025.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).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown location of employment for non-atypical staff.
Further Guidance
N/A
Reason for Change
New rule added to warn where non-atypical staff have a high percentage of unknown location of employment.
Previous Name of Rule
N/A

QR.C15025.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).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown location of employment for non-atypical new starters.
Further Guidance
N/A
Reason for Change
New rule added to warn where non-atypical new starters have a high percentage of unknown location of employment.
Previous Name of Rule
N/A

QR.C15025.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.
ExceptionWarningN/A
Plain English
Nationality should be consistent between years.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.NATION.Exception.1

QR.C15025.Person.NATION.2

More than 7.5% of staff (where any Contract.TERMS = 1 or 2) have Person.NATION = ZZ (Not known).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown nationalities for non-atypical staff.
Further Guidance
N/A
Reason for Change
New rule added to warn where non-atypical staff have a high percentage of unknown nationality.
Previous Name of Rule
N/A

QR.C15025.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).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown nationalities for non-atypical new starters.
Further Guidance
N/A
Reason for Change
New rule added to warn where non-atypical new starters have a high percentage of unknown nationality.
Previous Name of Rule
N/A

QR.C15025.Person.NATION.4

More than 20% of staff with atypical contracts only (XPOPPA01 = 1) have Person.NATION = ZZ (Not known).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown nationalities for staff with only atypical contracts.
Further Guidance
N/A
Reason for Change
New rule added to warn where staff with only atypical contracts have a high percentage of unknown nationality.
Previous Name of Rule
N/A

QR.C15025.Person.NATIOND.4

Where there is an occurrence of Person.NATIOND = R or U, then no other occurrence of Person.NATIOND should exist.
ExceptionWarningN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.NATIOND.Exception.1

QR.C15025.Person.NATIOND.5

For providers in Wales, more than 5% of staff have Person.NATIOND = R (Information refused).
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added to warn where a high percentage of staff have NATIOND of refused.
Previous Name of Rule
N/A

QR.C15025.Person.NATIOND.6

For providers in Wales, more than 5% of staff have Person.NATIOND = U (Unknown).
ExceptionWarningAdded
Plain English
N/A
Further Guidance
N/A
Reason for Change
New rule added to warn where a high percentage of staff have NATIOND of unknown.
Previous Name of Rule
N/A

QR.C15025.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.
ExceptionWarningN/A
Plain English
Previous employment should be consistent between years.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.PREVEMP.Exception.1

QR.C15025.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), and XPOPP01 = 1) then Person.PREVEMP should not equal 99.
ExceptionWarningN/A
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
C14025.Person.PREVEMP.Exception.2

QR.C15025.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).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown Person.PREVEMP for non-atypical staff.
Further Guidance
N/A
Reason for Change
New rule added to warn where non-atypical staff have a high percentage of unknown Person.PREVEMP.
Previous Name of Rule
N/A

QR.C15025.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).
ExceptionWarningAdded
Plain English
There is a high percentage of unknown Person.PREVEMP for non-atypical new starters.
Further Guidance
N/A
Reason for Change
New rule added to warn where non-atypical new starters have a high percentage of unknown Person.PREVEMP.
Previous Name of Rule
N/A

QR.C15025.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.
ExceptionWarningN/A
Plain English
Previous HEI should be consistent between years.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.PREVHEI.Exception.1

QR.C15025.Person.PREVHEI.4

Where Person.PREVEMP = 01, then Person.PREVHEI must not be the same as the returning provider.
ExceptionErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.PREVHEI.Exception.2

QR.C15025.Person.PREVHEI.5

Where Person.PREVEMP = 21 and Person.PREVHEI exists it must be the same as the returning provider.
ExceptionErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.PREVHEI.Exception.3

QR.C15025.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.
ExceptionWarningN/A
Plain English
Regulatory body should be consistent between years.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.REGBODY.Exception.1

QR.C15025.Person.REGBODY.8

Where Person.REGBODY exists, an occurrence of Person.REGBODY should equal 14 where all occurrences of Activity.CCENTRE = 109
ExceptionWarningN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.REGBODY.Exception.2

QR.C15025.Person.SEX.1

More than 5% 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.
ExceptionWarningN/A
Plain English
Legal sex should be consistent between years.
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.SEX.Exception.1

QR.C15025.Person.SEXORT.1

There should not be more than 10% of staff where Person.SEXORT = 02 and Person.SEX = 2.
ExceptionWarningN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.SEXORT.Exception.1

QR.C15025.Person.SEXORT.2

There should not be more than 10% of staff where Person.SEXORT = 03 and Person.SEX = 1.
ExceptionWarningN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.SEXORT.Exception.2

QR.C15025.Person.SEXORT.3

There should not be more than 5% of staff (and more than 5 records) where Person.SEXORT = 05.
ExceptionWarningN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.SEXORT.Exception.3

QR.C15025.Person.STAFFID.10

No two records can have the same Person.STAFFID.
ExceptionErrorN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.STAFFID.Exception.6

QR.C15025.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.
ExceptionWarningN/A
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
C14025.Person.STAFFID.Exception.1

QR.C15025.Person.STAFFID.6

All staff with 10 or more contracts.
ExceptionWarningN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.STAFFID.Exception.2

QR.C15025.Person.STAFFID.7

Potential duplicate entries for non-atypical staff exist but have different Person.STAFFIDs.
ExceptionWarningN/A
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.STAFFID.Exception.3

QR.C15025.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.
ExceptionErrorN/A
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
C14025.Person.STAFFID.Exception.4

QR.C15025.Person.BIRTHDTE.1

Person.BIRTHDTE must exist where any Contract.TERMS = 1 or 2.
Business RuleErrorDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.BIRTHDTE.BusinessRule.1

QR.C15025.Person.BIRTHDTE.2

Person.BIRTHDTE must exist where any Contract.TERMS = 3 and Contract.ACEMPFUN = 1, 2, 3, or 9.
Business RuleErrorDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.BIRTHDTE.BusinessRule.2

QR.C15025.Person.SEX.2

Person.SEX must exist where any Contract.TERMS = 3 and Contract.ACEMPFUN = 1, 2, 3 or 9.
Business RuleErrorDeleted
Plain English
N/A
Further Guidance
N/A
Reason for Change
N/A
Previous Name of Rule
C14025.Person.SEX.BusinessRule.2