Derived Data for validation

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 R73
Description	Apprenticeship standard total negotiated price exceeds threshold for maximum core government contribution (calculated from matching programme aims)

Detailed error condition
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

Version 1	The rule has been rolled over from the previous year

Status summary

Current SLD severity	N/A
Current FIS severity	N/A
Is this rule in FIS?	No
Field values	Learner.LearnRefNumber LearningDelivery.AimType LearningDelivery.LearnStartDate LearningDelivery.OrigLearnStartDate LearningDelivery.FundModel LearningDelivery.ProgType LearningDelivery.StdCode AppFinRecord.AFinAmount AppFinRecord.AFinDate AppFinRecord.AFinCode AppFinRecord.AFinType

Need help understanding some of these terms?

View the validation rules glossary of terms