If you find that your list of adoption counselors includes some that are no longer active, you can delete them from Configurations > Staffing. Deleting an adoption counselor will not affect reporting data for past adoptions they handled; you will just not see their name in the dropdown for adoption counselors going forward.
