Quality Rules Directory for C15025
Filter
QR.C15025.Contract.ACEMPFUN.1
Contract.ACEMPFUN must exist where any Activity.ACTSOC begins with 1, 2 or 3.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.ACEMPFUN.BusinessRule.1
QR.C15025.Contract.ACEMPFUN.2
Contract.ACEMPFUN must not exist unless at least one Activity.ACTSOC under that Contract begins with 1, 2 or 3.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.ACEMPFUN.BusinessRule.2
QR.C15025.Contract.ACEMPFUN.3
There are no occurrences of Contract.ACEMPFUN = 1, 2, 3 or 9 in the Staff return.Show more
- Plain English
- No academic staff have been returned.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- N/A
QR.C15025.Contract.Activity.1
There must not be more than three occurrences of Contract.Activity where ((Contract.LEVELS does not equal A0, B1, B2, C1, C2, D1 or D2) and Contract.ACEMPFUN does not equal 4 and (any Activity.ACTSOC = major groups 1, 2 or 3)).Show more
- Plain English
- There can only be more than three activities for specific contracts i.e. Levels is above D2 or not an academic contract or SOC2010 major groups 4-9.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.Activity.BusinessRule.1
QR.C15025.Contract.CLINICAL.1
Contract.CLINICAL must exist where (Contract.ACEMPFUN = 1, 2 or 3) and (Contract.TERMS = 1 or 2) and any Activity.CCENTRE = 101, 102, 103, 104, 105, 106, 107, 108, 112, 127 or 131.Show more
- Plain English
- Clinical status must exist for any medical or health related HESA cost centre.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CLINICAL.BusinessRule.1
QR.C15025.Contract.CLINICAL.2
Contract.CLINICAL must not exist where all Activity.CCENTRE not equal to 101, 102, 103, 104, 105, 106, 107, 108, 112, 127 or 131.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CLINICAL.BusinessRule.2
QR.C15025.Contract.CLINICAL.3
A provider has a Medical or Dental school but has not returned any Contract.CLINICAL = 1.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CLINICAL.Exception.1
QR.C15025.Contract.CLINSUB.1
Contract.CLINSUB must exist where Contract.CLINICAL = 1.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CLINSUB.BusinessRule.1
QR.C15025.Contract.CLINSUB.2
Contract.CLINSUB must not exist where Contract.CLINICAL not equal to 1.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CLINSUB.BusinessRule.2
QR.C15025.Contract.CLINSUB.3
Where there is more than one occurrence of Contract.CLINSUB they must not be identical.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CLINSUB.BusinessRule.3
QR.C15025.Contract.CONFTE.1
Contract.CONFTE must be 0 where Contract.MOEMP = 6Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CONFTE.BusinessRule.1
QR.C15025.Contract.CONFTE.2
Where (Contract.MOEMP is 3, 4 or 5) then Contract.CONFTE must not be 100.Show more
- Plain English
- FTE for part-time and atypical contracts must not be 100.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CONFTE.BusinessRule.2
QR.C15025.Contract.CONFTE.3
Where exists (Contract.ENDCON > (Y1)-07-31 and Contract.ENDCON < (Y2)-07-31), then Contract.CONFTE must not be 100Show more
- Plain English
- FTE must not be 100 for contracts that have ended during the reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CONFTE.BusinessRule.3
QR.C15025.Contract.CONFTE.4
Contract.CONFTE must not be 000.0 where (Contract.MOEMP in (1, 2, 3, 4, 5) and (Contract.ENDCON > '(Y1)-07-31' or Contract.ENDCON does not exist).Show more
- Plain English
- FTE must not be zero for contracts that are active during the reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CONFTE.BusinessRule.4
QR.C15025.Contract.CONFTE.8
Total of Contract.CONFTE for all the contract records for a person must not be greater than 200.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule moved to business stage.
- Previous Name of Rule
- C14025.Contract.CONFTE.Exception.5
QR.C15025.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.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.ENDCON.BusinessRule.1
QR.C15025.Contract.ENDCON.2
Where exists Contract.ENDCON must be less than Y2-08-01Show more
- Plain English
- End date of contract must be before the next reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.ENDCON.BusinessRule.4
QR.C15025.Contract.ENDCON.3
Where exists Contract.ENDCON must be equal to or after the date returned in Contract.STARTCON.Show more
- Plain English
- End date of contract must be the same or after the start date of contract.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.ENDCON.BusinessRule.5
QR.C15025.Contract.ENDCON.4
Contract.ENDCON must be before or equal to Person.DATELEFT where all Contract.TERMS = 1 or 2Show more
- Plain English
- End date of contract must be before or equal to the date that the person left.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.ENDCON.BusinessRule.6
QR.C15025.Contract.HEIJOINT.1
Contract.HEIJOINT must not be the returning provider.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.HEIJOINT.BusinessRule.1
QR.C15025.Contract.HEIJOINT.2
Contract.HEIJOINT should not exist where Contract.TERMS is not equal to 1 or 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.HEIJOINT.BusinessRule.2
QR.C15025.Contract.HSPEC.1
Contract.HSPEC must exist where Contract.CLINICAL = 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.HSPEC.BusinessRule.1
QR.C15025.Contract.HSPEC.2
Contract.HSPEC must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.HSPEC.BusinessRule.2
QR.C15025.Contract.HSPEC.3
Where there is more than one occurrence of Contract.HSPEC they must not be identical.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.HSPEC.BusinessRule.3
QR.C15025.Contract.LEVELS.3
Contract.LEVELS = A0 must exist at least once and no more than twice for a provider.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule moved to business stage.
- Previous Name of Rule
- C14025.Contract.LEVELS.Exception.2
QR.C15025.Contract.LEVELS.4
Contract.LEVELS should not equal 'C2', 'E2', 'F2', 'N0', 'O0' or 'P0' where Contract.ACEMPFUN = '1', '2', '3' or '9'.Show more
- Plain English
- Contract.LEVELS normally associated with non-academic contracts have been returned as academic.
- Further Guidance
- N/A
- Reason for Change
- New rule added to warn where contract levels normally associated with non-academic contracts are returned as academic.
- Previous Name of Rule
- N/A
QR.C15025.Contract.LEVELS.5
Contract.LEVELS should not equal 'C1', 'D1', 'D2', 'D3', 'E1' or 'F1' where Contract.ACEMPFUN = '4' or null.Show more
- Plain English
- Contract.LEVELS normally associated with academic contracts have been returned as non-academic.
- Further Guidance
- N/A
- Reason for Change
- New rule added to warn where contract levels normally associated with academic contracts are returned as non-academic.
- Previous Name of Rule
- N/A
QR.C15025.Contract.NHSCON.1
Contract.NHSCON must exist where Contract.CLINICAL is equal to 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.NHSCON.BusinessRule.1
QR.C15025.Contract.NHSCON.2
Contract.NHSCON must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.NHSCON.BusinessRule.2
QR.C15025.Contract.NHSCONGR.1
Where Contract.STARTCON is after 2009-08-01 Contract.NHSCONGR must not equal 02, 03, 06 or 07Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.NHSCONGR.BusinessRule.1
QR.C15025.Contract.NHSCONGR.2
Contract.NHSCONGR must exist where Contract.CLINICAL = 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.NHSCONGR.BusinessRule.2
QR.C15025.Contract.NHSCONGR.3
Contract.NHSCONGR must not exist where Contract.CLINICAL is not equal to 1, 2, 3 or 4.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.NHSCONGR.BusinessRule.3
QR.C15025.Contract.PSCAG.1
Contract.PSCAG must exist where Contract.TERMS = 1 or 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.PSCAG.BusinessRule.1
QR.C15025.Contract.PSCAG.2
Where Contract.SOBS = 01 then Contract.PSCAG must be 100.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.PSCAG.BusinessRule.2
QR.C15025.Contract.PSCAG.3
Where Contract.SOBS not equal to 01 then Contract.PSCAG must not be 100.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.PSCAG.BusinessRule.3
QR.C15025.Contract.RESAST.1
Contract.RESAST must exist where Contract.ACEMPFUN = 2 and Contract.TERMS = 1 or 2.Show more
- Plain English
- Research assistant must exist for non-atypical academic contracts that are research only.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.RESAST.BusinessRule.1
QR.C15025.Contract.RESAST.2
Contract.RESAST must not exist where Contract.ACEMPFUN does not equal 2 or Contract.TERMS = 3.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.RESAST.BusinessRule.2
QR.C15025.Contract.RESCON.1
Where Contract.RESCON = 8 there must be no new contracts starting after that Contract.ENDCON.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.RESCON.BusinessRule.1
QR.C15025.Contract.RESCON.2
Contract.RESCON must exist where Contract.TERMS = 1 or 2 and Contract.ENDCON exists.Show more
- Plain English
- Reason for ending the contract must exist where the contract has ended.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.RESCON.BusinessRule.2
QR.C15025.Contract.RESCON.3
Contract.RESCON must not exist where (Contract.ENDCON does not exist and Contract.TERMS = 1 or 2.)Show more
- Plain English
- Reason for ending the contract must not exist where the contract has not ended.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.RESCON.BusinessRule.3
QR.C15025.Contract.SALREF.1
Where Contract.SALREF exists, then Contract.SALREF must not be greater than 500000.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.SALREF.BusinessRule.1
QR.C15025.Contract.SALREF.2
Where Contract.SALREF exists, then Contract.SALREF must not be less than 5500.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Rule amended to increase the minimum salary threshold in line with National Minimum Wage rates
- Previous Name of Rule
- C14025.Contract.SALREF.BusinessRule.2
QR.C15025.Contract.SALREF.3
Contract.SALREF must not exist where Contract.SPOINT begins with C.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.SALREF.BusinessRule.3
QR.C15025.Contract.SALREF.4
Contract.SALREF must exist where (Contract.TERMS = 1 or 2) and Contract.SPOINT does not exist.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.SALREF.BusinessRule.4
QR.C15025.Contract.SOBS.1
Where there is more than one occurrence of Contract.SOBS they must not be identical.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.SOBS.BusinessRule.1
QR.C15025.Contract.SOBS.2
Where Contract.SOBS = 01 there must be no other occurrences of Contract.SOBS.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.SOBS.BusinessRule.2
QR.C15025.Contract.SOBS.3
Contract.SOBS must exist where Contract.TERMS = 1 or 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.SOBS.BusinessRule.3
QR.C15025.Contract.STARTCON.1
Contract.STARTCON must not be after Y2-07-31Show more
- Plain English
- Start date of contract must not be after the current reporting period.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.STARTCON.BusinessRule.1
QR.C15025.Contract.STARTCON.2
Where exists Contract.STARTCON must not be after Contract.ENDCON.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.STARTCON.BusinessRule.2
QR.C15025.Contract.STARTCON.3
Contract.STARTCON must exist where Contract.TERMS = 1 or 2. If the Contract.STARTCON is not known an empty element must be returned.Show more
- Plain English
- Start date of contract must exist for non-atypical contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.STARTCON.BusinessRule.3
QR.C15025.Contract.STARTCON.4
Where Contract.STARTCON exists it must be after Person.BIRTHDTE.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Wording change to remove additional check on Person.BIRTHDTE as it will always exist.
- Previous Name of Rule
- C14025.Contract.STARTCON.BusinessRule.6
QR.C15025.Contract.STARTCON.5
Contract.STARTCON must be before or on Person.DATELEFT where all Contract.TERMS = 1 or 2Show more
- Plain English
- Start date of contract must be before or on the date the person left for non-atypical contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.STARTCON.BusinessRule.7
QR.C15025.Contract.TCHWLH.1
Contract.TCHWLH must not exist for providers in England, Scotland or Northern Ireland.Show more
- Plain English
- Teaching through the medium of welsh must not exist for providers outside of Wales.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.TCHWLH.BusinessRule.1
QR.C15025.Contract.TCHWLH.2
Contract.TCHWLH must exist for Welsh providers where (Contract.ACEMPFUN = 1 or 3) and Contract.TERMS = 1 or 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.TCHWLH.BusinessRule.2
QR.C15025.Contract.TCHWLH.3
Contract.TCHWLH must not equal 1 where Person.ABLWELSH = 2.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.TCHWLH.BusinessRule.3
QR.C15025.Contract.TERMS.1
Where Contract.MOEMP = 5 then Contract.TERMS must equal 3.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.TERMS.BusinessRule.1
QR.C15025.Contract.TERMS.2
Where Contract.TERMS = 3 then Contract.ACEMPFUN must not equal 4 or null.Show more
- Plain English
- Non-academic atypical staff must not be returned.
- Further Guidance
- N/A
- Reason for Change
- New rule to prevent the return of non-academic atypical staff.
- Previous Name of Rule
- N/A
QR.C15025.Contract.CAMPID.1
Contract.CAMPID must have been submitted in the Provider profile collection.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- Wording amended to refer to 'Provider profile'.
- Previous Name of Rule
- C14025.Contract.CAMPID.Exception.1
QR.C15025.Contract.CONFTE.5
Contract.CONFTE should not be less than 80.0 for more than 5% of contracts (and more than 5 contracts) where (Contract.MOEMP = 1 and Contract.STARTCON is before '(Y1)-08-01' and Contract.ENDCON does not exist).Show more
- Plain English
- FTE should not be less than 80.0 for full-time contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CONFTE.Exception.1
QR.C15025.Contract.CONFTE.6
Contract.CONFTE should not be greater than 90.0 for more than 5% of contracts (and more than 5 contracts) where Contract.MOEMP = 3 or 4.Show more
- Plain English
- FTE should not be greater than 90.0 for part-time contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CONFTE.Exception.2
QR.C15025.Contract.CONFTE.7
Contract.CONFTE should not be greater than 50.0 for more than 5% of contracts (and more than 5 contracts) where Contract.MOEMP = 5.Show more
- Plain English
- FTE should not be greater than 50.0 for atypical contracts.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.CONFTE.Exception.3
QR.C15025.Contract.LEVELS.2
More than 10 people or 2% (whichever is less) where Contract.LEVELS = B1.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.LEVELS.Exception.1
QR.C15025.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.Show more
- Plain English
- Contract.LEVELS has changed this year compared to last year.
- Further Guidance
- N/A
- Reason for Change
- New rule added to warn where contract level changes between years.
- Previous Name of Rule
- N/A
QR.C15025.Contract.LEVELS.7
Where Contract.ACEMPFUN = 4 (Not an academic contract) then Contract.LEVELS should not equal F1 (Professor).Show more
- Plain English
- N/A
- Further Guidance
- It is expected that professors will be coded as academic.
- Reason for Change
- New rule added to warn where professors are coded as non-academic.
- Previous Name of Rule
- N/A
QR.C15025.Contract.LEVELS.8
The sum of XSFPE01 for Contract.LEVELS = F1, A0, B1, B2, C1, C2, D1, D2, D3, E1, E2 is greater than the sum of XSFPE01 for Contract.LEVELS = F2, I0, J0, K0, L0, M0, N0, O0, P0.Show more
- Plain English
- There is more FPE assigned to 'Professor' and/or 'Other senior academic' compared to 'Other contract levels'.
- Further Guidance
- It is not expected that there will be significantly more FPE assigned to 'Professor' and/or 'Other senior academic' compared to 'Other contract levels'.
- Reason for Change
- New rule added to warn where there is more FPE assigned to 'Professor' and/or 'Other senior academic' compared to 'Other contract levels'.
- Previous Name of Rule
- N/A
QR.C15025.Contract.RESCON.4
Where Contract.RESCON = 1 and Contract.ENDCON exists and does not equal '(Y2)-07-31' there should be another active contract on or after the Contract.ENDCON of this original contract.Show more
- Plain English
- Where the reason for ending a contract is that a new contract has been generated then another contract should exist.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.RESCON.Exception.1
QR.C15025.Contract.SALREF.10
Contract.SALREF should not be less than 40,000 (but greater than 5499) where Contract.MOEMP in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS = C2, E2 or F2.Show more
- Plain English
- Salaries are low for non-atypical staff with contract levels of C2, E2 or F2.
- Further Guidance
- N/A
- Reason for Change
- New rule added at the request of UCEA to warn where salaries are low for non-atypical staff with contract levels of C2, E2 or F2.
- Previous Name of Rule
- N/A
QR.C15025.Contract.SALREF.11
Contract.SALREF should not be less than 45,000 where Contract.MOEMP in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS = A0, B1, B2, C1, D1, D2, D3 or E1.Show more
- Plain English
- Salaries are low for non-atypical staff with contract levels of A0, B1, B2, C1, D1, D2, D3 or E1.
- Further Guidance
- N/A
- Reason for Change
- New rule added at the request of UCEA to warn where salaries are low for non-atypical staff with specific contract levels.
- Previous Name of Rule
- N/A
QR.C15025.Contract.SALREF.12
Contract.SALREF should not be between 12,000 and 13,936 (exclusive) where Person.BIRTHDTE <= '(Y1-21)-07-31') and Contract.MOEMP in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS = I0, J0, K0, L0, M0, N0, O0 or P0.Show more
- Plain English
- Salary is low for non-atypical staff over 21 years of age for contract levels I0, J0, K0, L0, M0, N0, O0 or P0.
- Further Guidance
- The rule is based on national minimum wage for 40 hours over 52 weeks.
- Reason for Change
- New rule added at the request of UCEA to warn where a salary is low for specific contract levels.
- Previous Name of Rule
- N/A
QR.C15025.Contract.SALREF.5
Contract.SALREF should not be between 5500 and 12000 where (Contract.TERMS = 1 or 2 and Contract.MOEMP in (1,2,3,4,6) and Person.BIRTHDTE <= '(Y1-21)-07-31').Show more
- Plain English
- Salary should not be between 5500 and 12000 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 amended to increase the salary thresholds
- Previous Name of Rule
- C14025.Contract.SALREF.Exception.1
QR.C15025.Contract.SALREF.6
Where Contract.SALREF 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%Show more
- Plain English
- Salary has changed by more than 25% between years.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.SALREF.Exception.2
QR.C15025.Contract.SALREF.7
Contract.SALREF should not be greater than 200,000 where (Contract.MOEMP in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS does not equal A0).Show more
- Plain English
- Salary should not be greater than 200,000 where levels does not equal Vice-Chancellor/Principal or Head of Institution.
- Further Guidance
- N/A
- Reason for Change
- Rule amended to increase the salary threshold to 200,000.
- Previous Name of Rule
- C14025.Contract.SALREF.Exception.3
QR.C15025.Contract.SALREF.8
Contract.SALREF should not be less than 50000 where (Contract.MOEMP in (1,2,3,4,6) and Contract.TERMS = 1 or 2 and Contract.LEVELS = F1)Show more
- Plain English
- Salary should not be less than 50,000 for professors.
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.SALREF.Exception.5
QR.C15025.Contract.SALREF.9
Contract.SALREF should not be greater than 325000.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.SALREF.Exception.6
QR.C15025.Contract.SPOINT.1
Contract.SPOINT should start with C where Contract.CLINICAL does not equal 0.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.SPOINT.Exception.1
QR.C15025.Contract.SPOINT.2
Contract.SPOINT must contain a valid entry.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.SPOINT.Exception.2
QR.C15025.Contract.STARTCON.6
Where exists Person.BIRTHDTE is less than 16 years of age at the start of contract (i.e. Contract.STARTCON – (minus) Person.BIRTHDTE < 16 years) and Contract.STARTCON greater than or on '(Y1)-08-01'.Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.STARTCON.Exception.1
QR.C15025.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.Show more
- Plain English
- Contract.STARTCON has changed this year compared to last year.
- Further Guidance
- N/A
- Reason for Change
- New rule added to warn where the contract start date changes between years.
- Previous Name of Rule
- N/A
QR.C15025.Contract.LEVELS.1
Contract.LEVELS must exist where (Person.DATELEFT is after (Y1)-07-31 or Person.DATELEFT does not exist) and ((Contract.TERMS = 1 or 2) or (Contract.ACEMPFUN = 1, 2, 3 or 9 and Contract.TERMS = 3))Show more
- Plain English
- N/A
- Further Guidance
- N/A
- Reason for Change
- N/A
- Previous Name of Rule
- C14025.Contract.LEVELS.BusinessRule.1