1. Home
  2. Validation rules
  3. ULN_07
Learner

ULN_07

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name ULN_07
Version 3
Status Changed
Category Learner
Severity Error
Error message

This Unique learner number must not be used

Intent

To ensure that, for funded aims, the learners Unique learner number (ULN) is not 999999999

Guidance

Ensure that, where the file preparation date is on or after 1 January of the current teaching year, and the aim is a funded aim and and is more than 5 days long, and the aim start is more than 60 days before the file preparation date, the Unique learner number (ULN) must not be 999999999

Description

If the file preparation date is on or after 1 January of the current teaching year, and the aim is a funded aim and and is more than 5 days long, and the aim start is more than 60 days before the file preparation date, the Unique learner number (ULN) must not be 999999999

Detailed error condition
Detailed description

If the file preparation date is on or after 1 January of the current teaching year (file preparation date >= 1 January), and the aim is agency funded ( LearningDelivery.FundModel = 25, 82, 35, 37, 38, 36, 81, 70 or (99 and LearningDelivery.LearnDelFAMType = ADL and LearningDelivery.LearnDelFAMCode = 1)), and the aim has a planned or actual duration of >= 5 days and the Learning start date is > 60 days before the file preparation date (( LearningDelivery.LearnPlanEndDate - LearningDelivery.LearnStartDate >= 5 OR LearningDelivery.LearnActEndDate - LearningDelivery.LearnStartDate >= 5) and file preparation date - LearningDelivery.LearnStartDate > 60 days), the Unique learner number (ULN) must not be 9999999999

(error where Learner.ULN = 9999999999)

Exclusions

This rule is not triggered on OLASS learning aims ( LearningDelivery.LearnDelFAMType = LDM and LearningDelivery.LearnDelFAMCode = 034), or for levy funded apprenticeships (LearnDelFAMType = ACT and LearnDelFAMCode = 1)

Flow chart ULN_07 Flowchart

Open flow chart in a new window

Flow chart details

Flowchart for 'ULN_07' rule

1. Is the learner record OLASS or a levy funded apprenticeship (ACT = 1)?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is the file preparation date after 1st January of the current year?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. Is the learning aim funded?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

4. Is the planned or actual duration of the aim five or more days?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

5. Is the Learning start date more than 60 days before the file preparation date?

  • If 'Yes' then the rule is triggered

  • If 'No' then the rule is not triggered

Change summary

Version 3

Removal of FM 70 from the rule

Version 1

Addition of FM 37, 38 (highlighted)

Status summary

Current SLD severity

Error
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

Learner.ULN

LearningDelivery.LearnStartDate

LearningDelivery.LearnPlanEndDate

LearningDelivery.FundModel

LearningDelivery.LearnActEndDate

LearningDeliveryFAM.LearnDelFAMType

LearningDeliveryFAM.LearnDelFAMCode

Need help understanding some of these terms?

View the validation rules glossary of terms