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

R_141

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

There must be a Skills Bootcamp subject learning aim in an open Skills Bootcamp programme

Intent

This rule ensures that an open skills bootcamp programme has an open skills bootcamp subject learning aim associated with it

Guidance

Ensure that all open Skills bootcamp programme aims have an open subject learning aim which has the same contract reference

Description

If there is an open Skills Bootcamp programme then there must be one of the subject learning aim present in the programme with the same contract reference number.

Detailed error condition
Detailed description

If there is an open Skills Bootcamp programme then there must be one of the subject learning aim present in the programme with the same contract reference number.

error where
the contract reference number ( LearningDelivery.ConRefNumber) on the component aim ( AimType = 3) is the same as the programme aim (AimType =1)
and
LearningDelivery.ProgType = 32
And
LearningDelivery.AimType = 1
and
LearningDelivery.LearnActEndDate is not returned
and a subject learning aim does not exist
LearningDelivery.AimType = 3
and
LARS_CategoryRef = 62 (where LearningDelivery.LearnAimRef = LARS_LearnAimRef and LearningDelivery.LearnStartDate >= LARS_EffectiveFrom and <= LARS_EffectiveTo in LARS_LearningDeliveryCategory)

Flow chart R141

Open flow chart in a new window

Flow chart details

Flowchart for 'R141' rule

1. Is there an open skills bootcamp programme aim?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Has skills bootcamp subject aim been added with the same contract reference?

  • If 'Yes' then the rule is not triggered

  • If 'No' 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.CompStatus

LearningDelivery.AchDate

LearningDelivery.LearnAimRef

LearningDelivery.LearnActEndDate

Need help understanding some of these terms?

View the validation rules glossary of terms