1. Home
  2. Validation rules
  3. R_157
Cross Record

R_157

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_157
Previous name R157
Version 1
Status New
Category Cross Record
Severity Error
Error message

Advanced Learner Loans (ALB) must not have more than one Learning Delivery FAM record with the same Learning Delivery FAM Date From

Intent

To ensure Advanced Learner Loans (ALB) Learning Delivery FAM records are not returned with the same Learning Delivery FAM Date From on one learning aim

Guidance

Check there are not more than one Advanced Learner Loans (ALB) records with the same Date From

Description

For new starts on or after 1 August 2026, where there is more than one record of Learning Delivery FAM type Advanced Learner Loans Bursary (ALB), the records must not have the same Learning Delivery FAM Date From.

Detailed error condition
Detailed description

For new starts on or after 1 August 2026, where there is more than one record of Learning Delivery FAM type Advanced Learner Loans Bursary (ALB), the records must not have the same Learning Delivery FAM Date From.

(error where

LearningDelivery.LearnStartDate >= 2026-08-01

and there is more than one record of LearningDeliveryFAM.LearnDelFAMType = ALB
and
the corresponding 'Date From' ( LearningDeliveryFAM.LearnDelFAMDateFrom ) is the same

Flow chart R157

Open flow chart in a new window

Flow chart details

Flowchart for 'R157' rule

1. Did the learner start the learning aim on or after 1 August 2026?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is there more than one Advanced Learner Loans (ALB) LearnDelFAMType with the same Date From?

  • If 'Yes' then the rule is triggered

  • If 'No' then the rule is not triggered

Change summary

Version 1

This rule is New at version 1

Status summary

Current SLD severity

Error
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

LearningDelivery.LearnStartDate

LearningDeliveryFAM.LearnDelFAMType

LearningDeliveryFAM.LearnDelFAMDateFrom

Need help understanding some of these terms?

View the validation rules glossary of terms