added missing NOLOCK
assessments view is static now
redirected to static assessments table