I have been having issues with trying to pull the most up to date learning assignments for people for a report.

I have been using WLF_ASSIGNMENT_RECORDS_F and it is all date effective. I'm trying to find completed courses but always find duplicates in report because there is too many factors that deems an assignment record "completed". Ex; withdrawn, reassigned, auto completed, etc.

Is there a table/view or a even a simple way to add to my query conditions to find the most recent learning assignment?