1. Home
  2. Validation rules
  3. LearnDelFAMType_104
Learning delivery

LearnDelFAMType_104

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name LearnDelFAMType_104
Version 1
Status Active
Category Learning delivery
Severity Error
Error message

The FAM type and code is not valid for this Learning start date

Intent

To ensure that the LDM codes are used within the correct date range

Guidance

Ensure that, the Learning start date is not before the 'EffectiveFrom' date for the Learning delivery monitoring code in the ILR Lookup SubCategory table

Description

The Learning start date must not be before the 'EffectiveFrom' date for the Learning delivery monitoring code in the ILR Lookup SubCategory table

Detailed error condition
Detailed description

The Learning start date must not be before the 'EffectiveFrom' date for the Learning delivery monitoring code in the ILR Lookup SubCategory table

(error where LearningDelivery.LearnStartDate < LookupSubCategory.EffectiveFrom where LearningDeliveryFAM.LearnDelFAMType = LookupSubCategory.Name = LDM and LearningDeliveryFAM.LearnDelFAMCode = LookupSubCategory.Code where the LookupSubCategory.EffectiveFrom is not null)

Exclusions

This rule is not triggered where LDM = 368 or 369 ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 368 or LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 369)

Flow chart LearnDelFAMType-104

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnDelFAMType_104' rule

1. Does the aim have Learning delivery monitoring code 368 or 369 returned?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2 . Is the Learning start date before the 'EffectiveFrom' date for the code in the ILR Lookup SubCategory table?

  • If 'Yes' then the rule is triggered

  • If 'No' 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

LearningDelivery.LearnStartDate

LearningDeliveryFAM.LearnDelFAMType

Need help understanding some of these terms?

View the validation rules glossary of terms