1. Home
  2. Validation rules
  3. FworkCode_05
Learning delivery

FworkCode_05

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name FworkCode_05
Version 1
Status Deleted
Category Learning delivery
Severity Error
Error message

The Framework code, Pathway code and Programme type combination is not valid in the LARS database for this Learning aim reference

Intent

This rule ensures that the framework and pathway code matches the LARS database for a valid framework

Guidance

Check that the combination of framework and pathway code is valid and matches the LARS database

Description

If the learning aim is part of an apprenticeship framework, component aim then the Framework code must be a valid lookup in the Framework aims table in the LARS database for this Programme type and Pathway code

Detailed error condition
Detailed description

If the learning aim is part of an apprenticeship framework (DD07 = Y) , component aim ( LearningDelivery.AimType = 3), then the Framework code must be a valid lookup in the Framework aims table in the LARS database for this Programme type and Pathway code

(error where is no matching record in the LARS_FrameworkAims table where ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LearningDelivery.ProgType = LARS_ProgType and LearningDelivery.FworkCode = LARS_FworkCode and LearningDelivery.PwayCode = LARS_PwayCode) and there is no matching record in the LARS_FrameworkCmnComponents table where (LearningDelivery.Progtype = LARS_ProgType and LearningDelivery.FworkCode = LARS_FworkCode and LearningDelivery.PwayCode = LARS_PwayCode and LARS_FrameworkComponentType = LARS_FrameworkCommonComponent for this learning aim (where LearningDelivery.LearnAimRef = LARS_LearnAimRef))

Exclusions

This rule is not triggered by apprenticeship standards (LearningDelivery.ProgType = 25)

Flow chart FworkCode_05

Open flow chart in a new window

Flow chart details

Flowchart for 'FworkCode_05' rule

1. Has the learner been recorded on an apprenticeship framework?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the framework and Pathway match a valid framework in LARS?

  • If 'Yes' then the rule is not triggered

  • If 'No' then he rule is triggered

Change summary

Version 1

This rule has been deleted

Status summary

Is this rule in FIS?

No

Need help understanding some of these terms?

View the validation rules glossary of terms