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

LearnAimRef_121

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

The Learning aim reference is not valid in the LARS database for this Source of Funding for this teaching year

Intent

To ensure that learning aims are returned for the correct valid dates in the LARS service for Devolved delivery

Guidance

Ensure that, where the learning aims are specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), the validity end date (if entered) on the record with the latest validity start date in the LARS database for the Learning aim reference is after the end of the previous teaching year for the corresponding Validity in the LARS database, shown through the FALA service

Description

If the learning aim is funded as aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), then the validity end date (if entered) on the record with the latest validity start date in the LARS database for this Learning aim reference must be after the end of the previous teaching year for the corresponding Validity in the LARS database

Detailed error condition
Detailed description

If the learning aim is funded as aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), then the validity end date (if entered) on the record with the latest validity start date in the LARS database for this Learning aim reference must be after the end of the previous teaching year for the corresponding Validity in the LARS database.

(error where DD35 = Y and LARS_EndDate in the LARS_Validity table <= end of previous teaching year using the record with the latest validity start date from the LARS_Validity table where ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory = MCA_GLA))
Exclusions

Rule excludes: Adult Level 3 Offer ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 378)

Flow chart LearnAimRef-121

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnAimRef_121' rule

1. Is LDM 378 returned on the aim record?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is the aim specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA)?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. Is the validity end date on the record with the latest validity start date in the LARS database for the aim blank?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

4. Is the validity end date on the record with the latest validity start date in the LARS database for this Learning aim reference after the end of the previous teaching year for the corresponding Validity in the LARS database?

  • 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

LearningDeliveryFAM.LearnDelFAMType

LearningDeliveryFAM.LearnDelFAMCode

LearningDelivery.LearnAimRef

Need help understanding some of these terms?

View the validation rules glossary of terms