generated provider accounts for retired users need also be retired, see changeset with id 20110825-1000-creating-providers-for-persons-from-encounter and copy those queries