update recentvisits view to include id and status