After importing certifications into Totara v11, we discovered an issue where we had imported an incorrect source field. Luckily the imported certifications affected are imported into empty shells.

I've been working on a way to bulk clear them out manually from the database (on my development copy) and thought I had gone through the import code well enough to map out the tables. It appears I am either missing some, or the import is incorrectly flagging duplicates and still importing the records. My queries further restrict the data by the program id, and the user id of the users I'm interested in, and certifid as applicable.

It is executing the $errorsql and setting the action to skip because $sameasprevious is true and $certcompletion->timecompleted equals $lasttimecompleted found in completionimport/lib.php.

Briefly, the tables I've found are:
prog_user_assignment
prog_completion
prog_completion_history
prog_completion_log
certif_completion
certif_completion_history
totara_compl_import_cert
prog_future_user_assignment

Thanks for any assistance in advance.