Learning delivery

LearnAimRef_98

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	LearnAimRef_98
Version	3
Status	Deleted
Category	Learning delivery
Severity	Error
Error message	The Learning aim reference is not valid in the LARS database for this Funding model and this Learning start date
Intent	To ensure that Apprenticeship component learning aims are returned for the correct valid dates in the LARS service
Guidance	Ensure that, for learning aims ending on or after 1 August 2020 that are Apprenticeship funded component aims, the Learning start date of the aim is between the validity dates in the Validity table in the LARS database, shown through the FALA service
Description	For learning aims ending on or after 1 August 2020, that are Apprenticeship funded component aims, the Learning start date of the aim must be between the validity start date and end date for the corresponding validity category in the Validity table in the LARS database

Detailed error condition

Detailed description	For learning aims ending on or after 1 August 2020 and are Apprenticeship funded component aims, then the Learning start date of the aim must be between the validity start date and end date for the corresponding validity category in the Validity table in the LARS database. (error where LearningDelivery.LearnActEndDate >= 2020-08-01 and DD07 = Y and LearningDelivery.AimType = 3 and LearningDelivery.FundModel = 35 or 36 and LearningDelivery.LearnStartDate < LARS_StartDate or > LARS_EndDate in the LARS_Validity table where ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory = APPRENTICESHIPS))
Exclusions	This rule excludes Apprenticeship standards ( LearningDelivery.Progtype = 25)
Flow chart	Open flow chart in a new window Flow chart details Flowchart for 'LearnAimRef_98' rule 1. Is the aim part of an apprenticeship standard? If 'Yes' then the rule is not triggered If 'No' then: 2. Is the aim an Apprenticeship component? If 'No' then the rule is not triggered If 'Yes' then: 3. Is the aim Actual end date after 1 August 2020? If 'No' then the rule is not triggered If 'Yes' then: 4. Is the Learning start date between the validity start date and end dates for the aim validity category in the Validity table in the LARS database? If 'No' then the rule is triggered If 'Yes' then the rule is not triggered

Change summary

Version 3	This rule has been deleted at version 3
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.LearnActEndDate LearningDelivery.FundModel LearningDelivery.AimType LearningDelivery.ProgType LearningDelivery.LearnAimRef LearningDelivery.LearnStartDate

Need help understanding some of these terms?

View the validation rules glossary of terms