1. Home
  2. Validation rules
  3. UKPRN_28
Learner

UKPRN_28

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name UKPRN_28
Version 1
Status Changed
Category Learner
Severity Error
Error message

This learning aim cannot be started after the Stop New Starts date for this funding relationship

Intent

To ensure that there are no new starts under the delivery contract once a 'Stop New Starts' order has been placed on it.

Guidance

Where a 'Stop New Starts' order has been placed on the contract for delivery, no new starts can be returned until this order has been removed from the contract.

Description

If the learning aim is identified as Adult skills (FM = 35 and SOF = 105 and LDM = 388) where there is a funding relationship for this UKPRN in FCT, it cannot be started on or after the Stop New Starts date of the latest contract start date

Detailed error condition
Detailed description

If the learning aim is identified as procured Adult Education Budget 2023 (AEB), ( LearningDelivery.LearnDelFAMType = LDM and LearningDelivery.LearnDelFAMCode = 388) and the learning aim is Adult skills funded ( LearningDelivery.FundModel = 35 or 38 and LearningDelivery.LearnDelFAMType = SOF and LearningDelivery.LearnDelFAMCode = 105) and there is a funding relationship in FCT for this UKPRN ( LearningProvider.UKPRN = ContractAllocation.DeliveryUKPRN and ContractAllocation.FundingStreamPeriodCode = ASF2023-AS2526, ASF2023-FCFJ2526, ASF2023-STFI2526) , it cannot be started on or after the Stop New Starts date of the latest contract start date in FCT (ContractAllocation.StartDate)

(error where ContractAllocation.StopNewStartsFromDate is not null and LearningDelivery.LearnStartDate >= ContractAllocation.StopNewStartsFromDate of the latest ContractAllocation.StartDate in FCT)

Exclusions

This rule is not triggered by Restarts ( LearningDelivery.LearnDelFAMType = RES)

Flow chart UKPRN_28 Flowchart

Open flow chart in a new window

Flow chart details

Flowchart for 'UKPRN_28' rule

1. Is the aim a Restart?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is the aim procured Adult skills (FM = 35 or 38 and LDM = 388)?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

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

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

4. Is there a funding relationship in FCT for the UKPRN?

  • If 'No' then the rule is triggered

  • If 'Yes' then:

5. Is the aim start after the ‘Stop new starts’ date?

  • If 'Yes' then the rule is triggered

  • If 'No' then the rule is not triggered

Change summary

Version 1

The funding stream period code has been updated

Status summary

Current SLD severity

Error
Is this rule in FIS?

No
Field values

LearningDelivery.LearnStartDate

LearningDelivery.FundModel

LearningDelivery.ProgType

LearningDeliveryFAM.LearnDelFAMType

LearningDeliveryFAM.LearnDelFAMCode

Need help understanding some of these terms?

View the validation rules glossary of terms