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

R_144

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_144
Version 1
Status Active
Category Cross Record
Severity Error
Error message

The Achievement date must not be before the earliest Learning start date of any Skills Bootcamp programme aims.

Intent

This rule ensures that the Skills Bootcamp achievement date is not recorded before the start date of any associated skills bootcamp programme aims start date

Guidance

Ensure that the achievement date is recorded correctly for the skills bootcamp and the date must not be before the learning start date of the programme aim

Description

For a Skills Bootcamp learner started on or after 1 August 2023, the Achievement date 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 started on or after 1 August 2023, the Achievement date must not be before the earliest start date of any programme aims with the same contract reference number.

(error where
LearningDelivery. AimType = 1
and
LearningDelivery.LearnStartDate >= 2023-08-01
and
LearningDelivery.ProgType = 32
and
LearningDelivery.AchDate is returned
and
LearningDelivey.AchDate < the earliest LearnStartDate of any programme aims ( LearningDelivery. AimType = 1) with the same Contract Reference Number ( LearningDelivery.ConRefNumber )
Flow chart R144

Open flow chart in a new window

Flow chart details

Flowchart for 'R144' rule

1. Has an achievement date been recorded on a skills bootcamp programme aim?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the achievement date before the learning 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

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

LearningDelivery.ProgType

LearningDelivery.ConRefNumber

LearningDelivery.LearnStartDate

Need help understanding some of these terms?

View the validation rules glossary of terms