Thanks Sean, I will be sure to follow the etiquette when posting in questions in the future.

Sorry about that.

I was able to figure out the problem:

it was

ROW_NUMBER() over (partition by e.claimid,e.revcode order by c.claimid)

I originally had ROW_NUMBER() over (partition by e.claimid order by c.claimid)

I thought my logic was somewhat close, but after looking at my results, I can see that I am missing a lot of records.