Learning delivery

LearnAimRef_158

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	LearnAimRef_158
Version	1
Status	New
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 only valid aims are recorded for Growth and Skills Short Course Offer
Guidance	Ensure that where the aim is funded through the Growth and Skills Short Course Offer funding model the learning start date of the aim is not before the start date or after the last date for new starts of the GROWTH_SKILLS_SHORT_COURSES Validity Category in the Validity table in the LARS database.
Description	If the learning aim is funded through Growth and Skills Short Course Offer, then the learning aim start date must not be before the validity start date or be after the last date for new starts (unless the restart indicator is present) for the corresponding validity category in the Validity table in the LARS database.

Detailed error condition

Detailed description

If the learning aim is funded through Growth and Skills Short Course Offer, then the learning aim start date must not be before the validity start date or be after the last date for new starts (unless the restart indicator is present) for the corresponding validity category in the Validity table in the LARS database. error where LearningDelivery.FundModel = 39 and ( LearningDelivery.LearnStartDate < LARS_StartDate in the LARS Validity table or ( LearningDelivery.LearnStartDate > LARS_LastNewStartDate in the LARS_Validity table and LearningDeliveryFAM.LearnDelFamType = RES does not exist)) where ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory = GROWTH_SKILLS_SHORT_COURSES)

Flow chart

Open flow chart in a new window Flow chart details Flowchart for 'LearnAimRef_158' rule 1. Is the aim a Restart? If 'Yes' then the rule is not triggered If 'No' then: 2. Is the aim funded through the Growth and Skills Short Course Offer? If 'No' then the rule is not triggered If 'Yes' then: 4. Is the learning aim start date before the validity start date or after the last date for new starts for the corresponding validity category in the Validity table in the LARS database? If 'Yes' then the rule is triggered If 'No' then the rule is not triggered

Change summary

Version 1	This rule is New at version 1

Status summary

Current SLD severity	Error
Current FIS severity	Error
Is this rule in FIS?	Yes
Field values	LearningDelivery.LearnStartDate LearningDeliveryFAM.LearnDelFAMType LearningDelivery.LearnAimRef LearningDelivery.FundModel

Need help understanding some of these terms?

View the validation rules glossary of terms