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

LearnAimRef_133

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name LearnAimRef_133
Version 1
Status Changed
Category Learning delivery
Severity Error
Error message

The aim must have MCA_GLA Validity category in the Validity table in the LARS database

Intent

To ensure aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), have the correct Validity Category in the Validity table in the LARS database

Guidance

Ensure that, for new starts on or after 1 August 2023 and aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), the aims must have MCA_GLA Validity Category or COMM_LEARN or Tailored_Learning Validity Category in the Validity table in the LARS database, shown through the FALA service

Description

For new starts on or after 1 August 2023 and aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), then the aims must have MCA_GLA Validity Category or COMM_LEARN or Tailored_Learning Validity Category in the Validity table in the LARS database

Detailed error condition
Detailed description

For new starts on or after 1 August 2023 and aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), then the aims must have MCA_GLA Validity Category or COMM_LEARN OR Tailored_Learning Validity Category in the Validity table in the LARS database.

(error where LearningDelivery.LearnStartDate >= 2023-08-01 and DD35 = Y and ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory <> MCA_GLA) or ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory <> COMM_LEARN) or ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory <> Tailored_Learning))

Exclusions

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

Flow chart LearnAimRef-133

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnAimRef_133' rule

1. Is the aim funded through the Adult Level 3 Offer?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is the aim start date on or after 1 August 2023?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

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

4. Does the aim have MCA_GLA Validity Category or COMM_LEARN OR Tailored_Learning 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

Addition of text -'or ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory <> Tailored_Learning)' (highlighted)

Status summary

Current SLD severity

Error
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

LearningDelivery.LearnStartDate

LearningDelivery.LearnAimRef

LearningDeliveryFAM.LearnDelFAMType

Need help understanding some of these terms?

View the validation rules glossary of terms