cleaning up database conversion from state and not_atteding