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