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

LearnAimRef_131

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name LearnAimRef_131
Version 4
Status Changed
Category Learning delivery
Severity Error
Error message

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

Intent

To ensure that Advanced learner loan aims are returned for the correct valid dates in the LARS service

Guidance

Ensure that, for new starts on or after 1 August 2023 that are financed by an Advanced Learner Loan, the aim must have ADV_LEARN_LOAN 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 are financed by an Advanced Learner Loan, then the aims must have ADV_LEARN_LOAN 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 are financed by an Advanced Learner Loan, then the aims must have ADV_LEARN_LOAN Validity Category in the Validity table in the LARS database.

(error where LearningDelivery.LearnStartDate >= 2021-08-01 and LearningDelivery.FundModel = 99 and LearningDeliveryFAM.LearnDelFAMType = ADL and LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory <> ADV_LEARN_LOAN)

Flow chart LearnAimRef-131

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnAimRef_131' rule

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

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the aim Advanced Learner Loan funded?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. Does the aim have ADV_LEARN_LOAN 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 4

Removal of text - 'Project S Pilot for Adult Skills Fund Providers ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 395)' from the rule exclusions

Version 2

Addition of text - 'Project S Pilot for Adult Skills Fund Providers ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 395)' to the rule exclusions (highlighted)

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

LearningDelivery.LearnStartDate

LearningDelivery.FundModel

LearningDelivery.LearnAimRef

Need help understanding some of these terms?

View the validation rules glossary of terms