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
Previous name R144
Version 1
Status Active
Category Cross Record
Severity Error
Error message

The Learning actual end date for the latest programme aim must not be before the Learning actual end date of the latest component aim.

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 where the learning start date was on or before the 1st of August 2023 ?

  • 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 with the same contract reference?

  • 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