1. Home
  2. Validation rules
  3. R_72
Cross Record

R_72

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_72
Version 1
Status Active
Category Cross Record
Severity Error
Error message

The payment amounts must not exceed the employer contribution proportion of the total negotiated price

Intent

This rule ensures that there is no over payment of employer contributions for apprenticeship trailblazers.

Guidance

Check that the PMR record to ensure that the employer contribution does not exceed one third of the total negotiated price.

Description

For Apprenticeship trailblazer standards the employer contribution payments recorded for an apprenticeship standard must not exceed the employer contribution proportion of the total negotiated price for the programme.

Detailed error condition
Detailed description

For Apprenticeship trailblazer standards ( LearningDelivery.FundModel = 81 and LearningDelivery.ProgType = 25), for all programme aims ( LearningDelivery.AimType = 1) with the same combination of LearningDelivery.LearnRefNumber , LearningDelivery.ProgType and LearningDelivery.StdCode and where 2/3 of the total negotiated price is less than or equal to the core government contribution cap for the standard (DD17 = N).

The employer contribution payments recorded for an apprenticeship standard must not exceed the employer contribution proportion of the total negotiated price for the programme.

(error where (SUM( AFinAmount where AFinType = PMR and AFinCode = 1, 2 )
MINUS
SUM( AFinAmount where AFinType = PMR and AFinCode = 3 ))
GREATER THAN
1/3 * (
(AFinAmount where AFinType = TNP and AFinCode = 1 and AFinDate is the most recent)
PLUS
(AFinAmount where AFinType = TNP and AFinCode = 2 and AFinDate is the most recent))

Flow chart R72

Open flow chart in a new window

Flow chart details

Flowchart for 'R72' rule

1. Has the learner been recorded on a trailblazer standard?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2 . Has more than one Apprenticeship financial record been returned?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3 . Do the financial records add up to over 1 third of the total value of the negotiated price?

  • If 'No' then the rule is not triggered

  • If 'Yes' then the rule is triggered

Change summary

Version 1

The rule has been rolled over from the previous year

Status summary

Current SLD severity

Error
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

LearningDelivery.ProgType

LearningDelivery.AimType

LearningDelivery.StdCode

LearningDelivery.FworkCode

LearningDelivery.PwayCode

AppFinRecord.AFinDate

AppFinRecord.AFinCode

Need help understanding some of these terms?

View the validation rules glossary of terms