finalized the view migration

general cleanup after migration