Learning delivery

LearnDelFAMType_83

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	LearnDelFAMType_83
Version	1
Status	Active
Category	Learning delivery
Severity	Error
Error message	This LDM code is not valid for this UKPRN
Intent	To ensure that LDM codes are valid for the relevant UKPRN
Guidance	Ensure that, where a Short Funding Initiative Learning Delivery Monitoring code has been returned for the UKPRN, the Learning Start Date is between the Effective From date and Effective To date in the Short Term Initiative table
Description	Where a Short Funding Initiative Learning Delivery Monitoring code has been returned for this UKPRN, the Learning Start Date must be between the Effective From date and Effective To date in the Short Term Initiative table

Detailed error condition

Detailed description

Where a Short Funding Initiative Learning Delivery Monitoring code has been returned for this UKPRN, the Learning Start Date must be between the Effective From date and Effective To date in the Short Term Initiative table (error where a record exists where ( LearningDeliveryFAM.LearnDelFAMType = LDM) = ShortTermFundingInitiative.LDMCode and there is no matching record where LearningProvider.UKPRN = ShortTermFundingInitiative.UKPRN and ( LearningDeliveryFAM.LearnDelFAMType = LDM) = ShortTermFundingInitiative.LDMCode and LearningDelivery.LearnStartDate >= ShortTermFundingInitiative.EffectiveFrom and LearningDelivery.LearnStartDate <= ShortTermFundingInitiative.EffectiveTo where the ShortTermFundingInitiative.EffectiveTo is not null)

Flow chart

Open flow chart in a new window Flow chart details Flowchart for 'LearnDelFAMType_83' rule 1. Is a Short Funding Initiative Learning Delivery Monitoring code returned? If 'No' then the rule is not triggered If 'Yes' then: 2. Is the Learning Start Date between the Effective From date and Effective To date in the Short Term Initiative table for this UKPRN? If 'No' then the rule is triggered If 'Yes' then the rule is not 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	LearningProvider.UKPRN LearningDelivery.LearnStartDate LearningDeliveryFAM.LearnDelFAMType

Need help understanding some of these terms?

View the validation rules glossary of terms