1. Home
  2. Validation rules
  3. UKPRN_23
Learner

UKPRN_23

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name UKPRN_23
Version 1
Status Active
Category Learner
Severity Error
Error message

There is no Adult skills funding relationship for this UKPRN

Intent

To ensure that there is a live contract for delivery of the Adult skills provision associated with the file upload.

Guidance

Please ensure that, to avoid this rule is triggering, you have an active and signed Adult skills contract in your MyESF service. This rule may also trigger an error where the contract is signed and a file uploaded on the same day; in this case please resubmit your file upload on the following day.

Description

If the learning aim is identified as Adult skills (FM = 35 and SOF = 105 and LDM = 379) starting on or after 1st August 2021 there must be a funding relationship in FCT for this UKPRN

Detailed error condition
Detailed description

If the learning aim starting on or after 1st August 2021 ( LearningDelivery.LearnStartDate >= 2021-08-01) and is identified as procured Adult Education Budget 2021 (AEB), ( LearningDelivery.LearnDelFAMType = LDM and LearningDelivery.LearnDelFAMCode = 379) and the learning aim is Adult skills funded ( LearningDelivery.FundModel = 35 and LearningDelivery.LearnDelFAMType = SOF and LearningDelivery.LearnDelFAMCode = 105) there must be a funding relationship in FCT for this UKPRN ( LearningProvider.UKPRN = ContractAllocation.DeliveryUKPRN)

(error where there is no funding relationship in FCT ContractAllocation.FundingStreamPeriodCode = AEB-AS2324, AEB-NSF2324)

Exclusions

This rule is not triggered when LearningDelivery.LearnActEndDate is not null and in the previous teaching year

Flow chart UKPRN_23 Flowchart

Open flow chart in a new window

Flow chart details

Flowchart for 'UKPRN_23' rule

1. Is the Learning actual end date completed for a previous year?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is the aim start date after 1st August 2021?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

3. Is the aim procured Adult education budget funded (FM = 35 and LDM - 379)?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

4 . Is the aim Adult skills funded (SoF = 105)?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

5 . Is there a funding relationship in FCT for this UKPRN?

  • 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

Error
Is this rule in FIS?

No
Field values

LearningDelivery.LearnStartDate

LearningProvider.UKPRN

LearningDelivery.FundModel

LearningDeliveryFAM.LearnDelFAMType

LearningDeliveryFAM.LearnDelFAMCode

Need help understanding some of these terms?

View the validation rules glossary of terms