Peter Hancock

R59 ILR Validation Rule

Created

None

Does anybody know EXACTLY how validation rule R59 works?  

I've checked the validation rules version 3 and I don't think it specifies exactly how the rule works.  It says:
"There should not be more than one Learner record with the same ULN, except where the ULN is 9999999999"

It does not say what is meant by "more than one learner record".  
I have previously assumed that it is looking only at the field <LearnRefNumber>, but there must be more to it than that.   

I've just noticed in our R07 ILR that we have an instance of two different LearnRefNumbers that have the same ULN, but R59 has not fired in the online validation.   

So, one of two things must be true:
1) the rule checks only <LearnRefNumber>, and it is not working properly, or
2) the definition of a learner record incorporates more fields than only <LearnRefNumber>.  

Does anybody know?

 

Replies

No one has replied to this post.


Ruth Canham-James

If you check the raw xml and filter for the offending ULN, does it appear under multiple learner records (<Learner> </Learner>)? The rule looks like it just means where the ULN is included in multiple <Learner> </Learner> occurrences.

Have you tried both the FIS error checker and the errors that you get when you submit an ILR through SLD?

Peter Hancock

Ruth Canham-James

Yes, I have two separate learner records in the xml file, each with a different <LearnRefNumber>.  

No, I have not yet tested this file in the FIS.  I don't usually bother with the FIS, as the SLD validations are reliably provided very fast.  (And the SLD validation checks sometimes find issues not found in FIS - and it is the SLD validation that really counts)

Ruth Canham-James

We don't really do error checking in FIS these days for the same reasons.

That is weird, that definitely sounds like it should be triggering R59. I don't think the learner ref matters, that's already covered by R06 (There is more than one Learner record with the same Learner reference number). I don't think R59 is matching on learner ref, it's just looking for multiple occurences of the same ULN on multiple learner entities in the same ILR file (regardless of learner ref). We definitely have had R59 errors this year, it was working at R05 for sure.

Peter Hancock

Ruth Canham-James 

I agree that R59 does work (sometimes).  But it is not working for the case I am looking at today.  

Peter Hancock

I usually only use FIS when I want to get the funding export to put into PDSAT.  

Ruth Canham-James

Peter Hancock I'd definitely raise that one with the service desk, they may have a bug they need to fix.

Our big FIS thing is the SQL table outputs that we use for various things. We'd still need that if it all went to SLD.