frequently used roster CTE as a view, daily scaffold for all enrollments ever, lots of NOLOCKs and :lipstick: on AR views