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

R_138

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

The achievement date or an event learning aim for Skills Bootcamps (Z0059747, Z0059748, Z0059749) needs to be present in the learning delivery record

Intent

This rule ensures a skills bootcamp is recorded correctly

Guidance

Ensure that a completed skills bootcamp programme aim is recorded with the achievement date or at least one of the Skills Bootcamp event aims are present in the ILR file.

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

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.

error where
LearningDelivery.ProgType = 32
And
LearningDelivery.AimType = 1
And
LearningDelivery.CompStatus = 2
And
LearningDelivery.AchDate for the latest programme aim is not returned or NULL
And
there is no Learning Delivery record exists where at least one aim is LearningDelivery.LearnAimRef = Z0059747, Z0059748, Z0059749
Exclusions

This rule is not triggered by:
Completed programme aims where the file preparation date is six months after the Learning Actual End Date
(LearningDelivery.AimType = 1
and
LearningDelivery.CompStatus = 2
and
file preparation date > 6 months after LearningDelivery.LearnActEndDate)
Flow chart R138

Open flow chart in a new window

Flow chart details

Flowchart for 'R138' rule

1. Has a completed Skills bootcamp programme aim been returned within the last 6 months?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Has an achievement date or a event aim been returned?

  • 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

Need help understanding some of these terms?

View the validation rules glossary of terms