We were doing some auditing on assignment data and were reminded about a long-standing issue with older assignments — that the
passed_at field for those aren’t filled in, since we weren’t tracking that data when the records were created. We’ve left it alone for a long time, tracking the ‘passed’ status with the aptly name
passed boolean field (that’s how we did it before the timestamp).
We’re cleaning up the inconsistency today, filling in those missing timestamps. This only affects assignments that were passed before May 1, 2017 (when we started using the timestamp logic).
How are we filling it in, you ask? Well, we don’t have any review logs for those assignments to calculate the real passing date, so we’re assuming that every person is an absolute machine and does their reviews perfectly at exact moment that they’re available. From the top of the hour when the lesson was finished, we’ll add 37 hours for the accelerated levels (1 and 2), 82 hours for the rest.
We’ll kick off the backfill in a few. We thought everyone should know why you’ll see a bunch of old assignments show up in your ‘recently updated’ API calls.