1. Home
  2. Validation rules
  3. R_59
Cross Record

R_59

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_59
Version 1
Status Active
Category Cross Record
Severity Error
Error message

The ILR file should not have more than one record with the same ULN

Intent

This rule ensures that only ULN in the ILR file per learner and there are no duplicate records

Guidance

Check that there are no duplicate ULNs in the ILR file, if a learner has undertook a new episode of study within the same academic year, these learning aims should be added to the existing record under the original ULN and learner reference.

Description

There should not be more than one Learner record with the same ULN, except where the ULN is 9999999999

Detailed error condition
Detailed description

There should not be more than one Learner record with the same ULN, except where the ULN is 9999999999

(error where Learner.ULN is not 9999999999
and there is more than one occurance in the file with the same ULN)

Flow chart R59

Open flow chart in a new window

Flow chart details

Flowchart for 'R59' rule

1. Has more than one of the same ULN been returned?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the ULN 9999999999?

  • 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
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

Learner.ULN

Need help understanding some of these terms?

View the validation rules glossary of terms