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

R_139

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

At least one subject learning aim must be closed if the Skills Bootcamp programme has been completed.

Intent

This rule ensures a skills bootcamp is recorded correctly

Guidance

Ensure that if the skills bootcamp programme has been recorded as completed at least one of the subject learning aims must also be closed with an actual end date

Description

For completed Skills Bootcamp programmes, the Achievement Date must be returned on the latest programme aim or at least one of the Skills Bootcamp event aims must be present in the Learning Delivery record.

Detailed error condition
Detailed description

If the Skills Bootcamp programme has been completed, one of the subject learning aims must be closed

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

Open flow chart in a new window

Flow chart details

Flowchart for 'R139' rule

1. Has a completed Skills bootcamp programme aim been returned?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Has at least one of the subject learning aims been recorded as completed ?

  • 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