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

R_150

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_150
Previous name R150
Version 1
Status Changed
Category Cross Record
Severity Error
Error message

The learning start date of this aim cannot before the learning start date of the programme aim

Intent

This rule ensures that the Skills Bootcamp programme is recorded correctly

Guidance

Ensure that the start date of the event learning aim is not before the start date of any associated programme aim

Description

For a Skills Bootcamp learner starting a programme on or after 1 August 2024 and on or prior to 31 July 2025, the learning start date of the event aim must not be before the earliest start date of any programme aims with the same contract reference number.

Detailed error condition
Detailed description

For a Skills Bootcamp learner starting a programme on or after 1 August 2024
and on or prior to 31 July 2025 (LearningDelivery.LearnStartDate <= 2025-07-31) , if returned, the learning start date of the event aims must not be before the earliest start date of any programme aims with the same contract reference number.

error where
LearningDelivery.LearnStartDate >= 2024-08-01
and
LearningDelivery.LearnStartDate <= 2025-07-31
and
LearningDelivery.AimType = 1
and
LearningDelivery.ProgType = 32
and
LearningDelivery.LearnStartDate of event aims ( LearningDelivery.LearnAimRef = Z0059747, Z0059748, Z0059749, Z0060439, Z0009541,Z0060440, Z0060441, Z0060442, Z0060443 ) < the earliest LearnStartDate of any programme aims ( LearningDelivery.AimType = 1) with the same contract reference number ( LearningDelivery.ConRefNumber )

Flow chart R150

Open flow chart in a new window

Flow chart details

Flowchart for 'R150' rule

1. Has a Skills Bootcamp programme started on or after 1 August 2024 and on or prior to 31 July 2025?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2 . Has a Skills Bootcamp subject learning aim been recorded?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3 . Is the start date of the event learning aim before the start date of any associated programme aims?

  • If 'No' then the rule is not triggered

  • If 'Yes' then then the rule is triggered

Change summary

Version 1

Amendment to the rule to add LearningDelivery.LearnStartDate <= 2025-07-31

Status summary

Current SLD severity

Error
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

LearningDelivery.AimType

LearningDelivery.ProgType

LearningDelivery.LearnStartDate

LearningDelivery.ConRefNumber

LearningDelivery.ConRefNumber

Need help understanding some of these terms?

View the validation rules glossary of terms