Quality Rules Directory for C15025
Filter
QR.C15025.Person.HQHELD.1
Person.HQHELD must exist where (Contract.TERMS = 1 or 2) and any Activity.ACTSOC begins with 1, 2 or 3Show more
- Plain English
- Highest qualification held must exist for non-atypical contracts where any SOC2010 major groups are 1-3.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- 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)).Show more
- 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.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
- 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).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
- 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).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
- New rule added to warn where non-atypical new starters have a high percentage of unknown Person.HQHELD.
- Previous Name of Rule
- N/A