Reporting on corrected reject/decline motives in OBI

Summary

Is it possible to grab the most recent reject/decline motive value for a submission when multiple exist?

Content

In OBI, I'm having problems grabbing ONLY the max reject date and most recent reject/decline motive.  We have multiple situations where a user has recorded the wrong reject reason and has to go back and correct it in Recruiting after the fact.  The reject date and reject/decline motive fields do not seem to be consistently linked in my analysis.  My analysis returns two rows for any submissions I've rejected twice (we revert the submission in Recruiting and then move the submission back to a rejected status to pick a corrected reject motive).  I see both reject reason #1 and #2, though I do not