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

R_122

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

The achievement date is not known, therefore the Date applies to record must be the same as the Learning actual end date

Intent

This rule ensures that if the learner has been recorded as completed or withdrawn the latest ACT to date matches the actual end date if the achievement date has not been entered into the ILR

Guidance

If the achievement date has not been entered and the learner has withdrawn or been recorded as completed then the ACT to date must match the actual end date.

Description

For apprenticeship standards if the Completion status is not continuing and there is record of an Apprenticeship Contract Type that has been returned and the achievement date has not been returned then the Date applies to for the latest ACT record must be the same as the Learning Actual End Date
Detailed error condition
Detailed description

For apprenticeship standards (FundModel =36, ProgType = 25) if the Completion status <>1 ( LearningDelivery.CompStatus <> 1) and there is record of an Apprenticeship Contract Type that has been returned ( LearningDeliveryFAM.LearnDelFAMTyp e =ACT), and the achievement date has not been returned ( LearningDelivery.AchDate is unknown) then the Date applies to for the latest ACT record must be the same as the Learning Actual End Date


(error where LearningDeliveryFAM.LearnDelFAMDateTo of the latest ACT record <> LearningDelivery.LearnActualEndDate )

Exclusions


Flow chart R122

Open flow chart in a new window

Flow chart details

Flowchart for 'R122' rule

1. Has an apprenticeship standard been recorded as completed?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Has the achievement date been recorded?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

3. Does the ACT to date match the actual end date?

  • 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.AchDate

LearningDeliveryFAM.LearnDelFAMType

LearningDeliveryFAM.LearnDelFAMDateTo

LearningDelivery.CompStatus

Need help understanding some of these terms?

View the validation rules glossary of terms