1. Home
  2. Validation rules
  3. LearningDeliveryHE_08
HE Rules

LearningDeliveryHE_08

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name LearningDeliveryHE_08
Version 1
Status Active
Category HE Rules
Severity Warning
Error message

A Learning Delivery HE record must be returned for this learning aim

Intent

To ensure that a Learning Delivery HE record is returned, where necessary

Guidance

Ensure that, where the learning aim is prescribed HE in the LARS database, and not being delivered by a college or grant funded provider and the UKPRN is a valid lookup on the Office for Students register, the Learning Delivery HE record should be returned; unless the aim record is generated by HESA or where the organisation is an UHEO

Description

If the learning aim is prescribed HE in the LARS database, and not being delivered by a college or grant funded provider and the UKPRN is a valid lookup on the Office for Students register then the Learning Delivery HE record should be returned

Detailed error condition
Detailed description

If the learning aim is prescribed HE in the LARS database (LARS_EnglPrscID = 1 or 2 (where LearningDelivery.LearnAimRef = LARS_LearnAimRef)), and not being delivered by a college or grant funded provider (DD27 = N) and the UKPRN is a valid lookup on the Office for Students register ( LearningProvider.UKPRN = UKPRN.OfSProviders) then the Learning Delivery HE record should be returned

(error where LearningDelivery.LearningDeliveryHE is unknown)

Exclusions

This rule is not triggered by records generated by HESA ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 352), or by records where LearningProvider.UKPRN = ORG_UKPRNS and LegalOrgType = UHEO

Flow chart LearningDeliveryHE_08

Open flow chart in a new window

Flow chart details

Flowchart for 'LearningDeliveryHE_08' rule

1. Is the record generated by HESA or is the organisation an UHEO?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is the learning aim prescribed HE in the LARS database?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. Is the aim delivered by a college or grant funded provider?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

4. Is the college UKPRN is a valid lookup on the Office for Students register?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

5. Is a Learning Delivery HE record returned?

  • If 'No' then the rule is triggered

  • If 'Yes' then the rule is not triggered

Change summary

Version 1

The rule has been rolled over from the previous year

Status summary

Current SLD severity

Warning
Current FIS severity

Warning
Is this rule in FIS?

Yes
Field values

LearningDelivery.LearnAimRef

LearningProvider.UKPRN

Need help understanding some of these terms?

View the validation rules glossary of terms