DD17
Changes to the latest version will be highlighted
View the validation rules glossary of terms
| Name | DD17 |
|---|---|
| Version | 1 |
| Status | Active |
| Category | Derived Data for validation |
| Severity | N/A |
| Error message |
N/A |
| Intent |
This shows the Derived data criteria for exceeding financial contributions |
| Guidance |
Validation rules that use this Derived data:
R72 |
| Description |
Apprenticeship standard total negotiated price exceeds threshold for maximum core government contribution (calculated from matching programme aims) |
| Detailed description |
If LearningDelivery.FundModel = 81 and LearningDelivery.ProgType = 25 AND 2/3 * ( ApprenticeshipFinancialRecord.AFinAmount where ( ApprenticeshipFinancialRecord.AFinType = TNP AND ApprenticeshipFinancialRecord.AFinCode = 1 where the ApprenticeshipFinancialRecord.AFinDate is the most recent) + ApprenticeshipFinancialRecord.AFinAmount where (ApprenticeshipFinancialRecord.AFinType = TNP AND ApprenticeshipFinancialRecord.AFinCode = 2 where the ApprenticeshipFinancialRecord.AFinDate is the most recent) for all programme aims with LearningDelivery.AimType = 1 and the same value of Learner.LearnRefNumber, LearningDelivery.ProgType, and LearningDelivery.StdCode) GREATER THAN LARS_CoreGovContributionCap in the LARS_StandardFunding table where LearningDelivery.StdCode = LARS_StandardCode and LARS_CoreGovContributionCap is the cap applicable on the earliest LearningDelivery.LearnStartDate or LearningDelivery.OrigLearnStartDate for all programme aims with the same value of Learner.LearnRefNumber, LerningDelivery.ProgType and LearningDelivery.StdCode in the LARS_StandardFunding table), set DD17 to Y, otherwise set to N |
|---|
Change summary
Status summary
| Current SLD severity |
N/A |
|---|---|
| Current FIS severity |
N/A |
| Is this rule in FIS? |
No |
| Field values |
LearningDelivery.LearnStartDate |
Need help understanding some of these terms?
View the validation rules glossary of terms