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

R_149

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_149
Version 4
Status New
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 subject 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, the learning start date of the subject learning 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, the learning start date of the subject learning aim 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. AimType = 1
and
LearningDelivery.ProgType = 32
and
LearningDelivery.LearnStartDate of the Subject Learning aim (LARS_CategoryRef = 62 (where LearningDelivery.LearnAimRef = LARS_LearnAimRef)) < the earliest LearnStartDate of any programme aims ( LearningDelivery.AimType = 1) with the same contract reference number ( LearningDelivery.ConRefNumber )
Flow chart R149

Open flow chart in a new window

Flow chart details

Flowchart for 'R149' rule

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

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the start date of the subject 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

New rule for 24/25

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.LearnAimRef

LearningDelivery.ConRefNumber

Need help understanding some of these terms?

View the validation rules glossary of terms