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

R_113

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

The Learning actual end date is not known, therefore the Date applies to record must not be returned.

Intent

This rule ensures that the ACT to date is not added when an apprentice is continuing their programme of study

Description

For apprenticeships frameworks if there is record of an Apprenticeship Contract Type that has been returned and the Learning actual end date has 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 apprenticeships frameworks ( LearningDelivery.FundModel = 36), if there is record of an Apprenticeship Contract Type that has been returned ( LearningDeliveryFAM.LearnDelFAMType =ACT), and the Learning actual end date has not been returned ( LearningDelivery.LearnActEndDate is unknown), then the Date applies to for the latest ACT record must not be returned.

(error where LearningDeliveryFAM.LearnDelFAMDateTo of the latest ACT record is known)

Exclusions

Excluding: Apprenticeship standards (FundModel =36, ProgType =25)

Flow chart R113

Open flow chart in a new window

Flow chart details

Flowchart for 'R113' rule

1. Has an apprenticeship framework been recorded?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Has the actual end date been returned?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. Has the ACT to date been returned?

  • If 'No' then the rule is not triggered

  • If 'Yes' 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.FundModel

LearningDeliveryFAM.LearnDelFAMDateFrom

LearningDeliveryFAM.LearnDelFAMDateTo

LearningDeliveryFAM.LearnDelFAMType

LearningDelivery.LearnActEndDate

Need help understanding some of these terms?

View the validation rules glossary of terms