It would also be worth looking at authentication methods, in particular the database method, which allows you to link directly to an external source. You can also map fields from the source table to user profile fields in Moodle if you wanted to flag that someone has been confirmed.
https://docs.moodle.org/400/en/Authentication
https://docs.moodle.org/400/en/Authentication