I got it. The INSERT INTO was missing the draft status id field and also the name in the new table was still DRAFT_STATUS_ID but labeled Draft Status Id.

Once it passes those validations, no more errors are expected and you can pump it over in one statement (well, could be an insert, a delete and maybe even a delete) to the final table. Since no more ...