Learner

UKPRN_26

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

There is no Skills Bootcamp funding relationship for this UKPRN

Intent

To ensure that there is a live contract for delivery of the skills bootcamp provision associated with the UKPRN.

Guidance

Please ensure that, to avoid this rule is triggering, you have an active and signed Skills bootcamps contract contract in your MyESF service or a matching Contract Reference Number in the Skills Bootcamps Contracts database. 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 Skills Bootcamps (programme type = 32) there must be either; a valid contract reference number and deliverable code in FCT for this UKPRN, or a matching Contract Reference Number in the Skills Bootcamps Contracts database

Detailed error condition
Detailed description

If the learning aim is identified as Skills Bootcamps ( LearningDelivery.ProgType = 32) there must be either a funding relationship, a valid contract reference number and deliverable code in FCT for this UKPRN or a matching Contract Reference Number in the Skills Bootcamps Contracts database.

(error where LearningDelivery.ProgType = 32 and (there is no matching record in FCS where
LearningProvider.UKPRN = ContractAllocation.DeliveryUKPRN) and ContractAllocation.FundingStreamPeriodCode = SB2022, SB-PAA2022 or SB2023 and the first part of LearningDelivery.ConRefNumber (up to the second hyphen) matches a ContractAllocation.ContractAllocationNumber) and the second part of LearningDelivery.ConRefNumber (after the second hyphen) matches a ContractDeliverable.DeliverableCode for the contract allocation) or there is no matching record in Skills Bootcamp Contract database where LearningDelivery.ConRefNumber = SkillsBootcampContracts.ILRContractRefNumber))

Flow chart UKPRN_26 Flowchart

Open flow chart in a new window

Flow chart details

Flowchart for 'UKPRN_26' rule

1. Is the aim Skills bootcamp funded?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is there a valid contract reference number and deliverable code in FCT for this UKPRN?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

3. Is there a matching Contract Reference in the Skills Bootcamps contracts database for this programme?

  • 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

Current FIS severity

N/A

Is this rule in FIS?

No

Field values

LearningDelivery.ProgType

LearningDelivery.ConRefNumber

LearningProvider.UKPRN

Need help understanding some of these terms?

View the validation rules glossary of terms