1. Home
  2. Validation rules
  3. ULN_05
Learner

ULN_05

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

The Unique learner number is not valid

Intent

To ensure that the Unique learner number is valid and in the Learner Register table

Guidance

Please ensure that the learners Unique learner number is valid

Description

The Unique learner number must be a valid lookup on the Learner Register table

Detailed error condition
Detailed description

The Unique learner number ( Learner.ULN ), must be a valid lookup on the Learner Register table

(error where Learner.ULN <> a valid lookup on the Learner Register table

Exclusions

This rule is not triggered where Learner.ULN = 9999999999

Flow chart ULN_05 Flowchart

Open flow chart in a new window

Flow chart details

Flowchart for 'ULN_05' rule

1. Is there a recorded ULN?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is the ULN a valid lookup on the Learner Register table?

  • If 'Yes' then the rule is not triggered

  • If 'No' then the rule is 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

Learner.ULN

Need help understanding some of these terms?

View the validation rules glossary of terms