NCA report card view complete
cleaned up formatting for legibility
moved most of the code out of OPENQUERY, whitespace counts against 8000 character limit FYI
test version of all discipline counts wide, including merits/demerits, too slow to be practical right now, but if we can speed it up, we may be in business
combined merits and demerits counts into one view, it's twice as fast too
brought up local_student_id from public.students, this is what we need to JOIN on
fixed JOIN and added assessment tags wide, merits a further discussion about long vs wide for these tests
cleaned up view to include relevent info only, fixed JOIN to STUDENTS, added source assessment tags, added placeholders for dates table fields