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

LearnAimRef_148

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name LearnAimRef_148
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 aims valid for Tailored learning provision are recorded

Guidance

Ensure that, for learning aims ending on or after 1 August 2024, that are Tailored Learning funded, 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, as shown through the FALA service

Description

For learning aims ending on or after 1 August 2024 and are Tailored Learning funded, 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

Detailed error condition
Detailed description

For learning aims ending on or after 1 August 2024 and are Tailored Learning funded, 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 >= 2024-08-01 and LearningDelivery.FundModel = 11 and LearningDelivery.LearnActEndDate < LARS_StartDate or > LARS_EndDate in the LARS_Validity table where ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory = Tailored_Learning))

Flow chart LearnAimRef-148

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnAimRef_148' rule

1. Is the Actual end date on or after 1 August 2024?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the aim part of Tailored learning provision?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. 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

New rule for 24/25

Status summary

Current SLD severity

Error
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

LearningDelivery.LearnStartDate

LearningDelivery.FundModel

LearningDelivery.LearnAimRef

Need help understanding some of these terms?

View the validation rules glossary of terms