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

LearnAimRef_156

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name LearnAimRef_156
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 must be between the start date and the end date 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 Start Date of the aim must be between the validity start date and end date of the GROWTH_SKILLS_SHORT_COURSES 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 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.FundModel = 39
and
LearningDelivery.LearnStartDate < LARS_StartDate or > LARS_EndDate in the LARS_Validity table where ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory = GROWTH_SKILLS_SHORT_COURSES)

Flow chart LearnAimRef_156

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnAimRef_156' rule

1 . Is the aim funded through Growth and Skills Short Course Offer?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2 . Is the Learning start date of the aim between the validity start date and end date for the corresponding 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 1

This rule is New at version 1

Status summary

Current SLD severity

Warning
Current FIS severity

Warning
Is this rule in FIS?

Yes
Field values

LearningDelivery.FundModel

LearningDelivery.LearnStartDate

LearningDelivery.LearnAimRef

Need help understanding some of these terms?

View the validation rules glossary of terms