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

R_147

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_147
Version 5
Status Changed
Category Cross Record
Severity Error
Error message

The Technical Qualification and the Occupational Specialism must match on Programme Type, Framework code and Pathway in the LARS Framework Aims table

Intent

This rule ensures that the T level technical qualification and occupational specialism mates in the LARS database

Guidance

Ensure that both the T level technical qualification and occupational specialism match in LARS database, update the ILR accordingly to ensure that the correct T level is recorded

Description

If there is an open T Level Technical Qualification and there is an open Occupational Specialism have been returned, these must have the same matching record of Framework code and Pathway in the Framework Aims table in LARS.

Detailed error condition
Detailed description

If there is an open T Level Technical Qualification (LARS_LearnAimRefType = 1468 and LearningDelivery.LearnActEndDate is not returned) and there is an open Occupational Specialism (LearningDelivery. LearnAimRef = ZTLOSxxx and LearningDelivery.LearnActEndDate is not returned) have been returned, these must have the same matching record of Framework code and Pathway in the Framework Aims table in LARS.

Error where
Learning Delivery record contains (
LearningDelivery.LearnAimRef = LARS_LearnAimRef where LARS_LearnAimRefType = 1468,
LearningDelivery.LearnAimRef = LARS_LearnAimRef = ZTLOSxxx and where LearningDelivery.LearnActEndDate is not returned or NULL for these learning aims
) and there is no matching record of LARS_FworkCode and LARS_PwayCode in the Framework Aims table in LARS for these Learning aims.

Flow chart R147

Open flow chart in a new window

Flow chart details

Flowchart for 'R147' rule

1. Has a T level programme been recorded?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Does the Technical Qualification and Occupational Specialism have the same Pathway code?

  • If 'Yes' then the rule is not triggered

  • If 'No' then the rule is triggered

Change summary

Version 5

Amendments to the rule to ensure the rule looks at the occupational specialism where there is not an actual end date recorded

Version 1

New Rule 24/25

Status summary

Current SLD severity

Error
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

LearningDelivery.LearnAimRef

Need help understanding some of these terms?

View the validation rules glossary of terms