Cross Record

R_07

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	R_07
Version	1
Status	Active
Category	Cross Record
Severity	Error
Error message	There must not be more than one Learning Delivery record with the same Learner reference number and Aim sequence number combination
Intent	This rule ensures that there is not more than one learning delivery record with the same learner reference using the same aim sequence.
Guidance	Check the ILR file to ensure that there is not more than one learning delivery record with the same learning aim reference recorded on the same aim sequence.
Description	A learner must not have more then one Learning Delivery record with the same Aim sequence number.

Detailed error condition

Detailed description	A learner must not have more then one Learning Delivery record with the same Aim sequence number (error where there is more than one Learning Delivery record with the same combination of Learner.LearnRefNumbe r and LearningDelivery.AimSeqNumber )
Flow chart	Open flow chart in a new window Flow chart details Flowchart for 'R07' rule 1. Is there a duplicate learning delivery record with the same learning aim reference and aim sequence? If 'No' then the rule is not triggered If 'Yes' 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.LearnRefNumber LearningDelivery.AimSeqNumber

Need help understanding some of these terms?

View the validation rules glossary of terms