rebuilt using normed codes and PIVOT
frozen in last year for testing
had to change a data type
only for previous year
added field for uniform
moved innermost subquery to CTE
fixed ambiguous student_number
combined promo status views
new view for MS lit tracker
will drop and recreate actualy procedure
python scripts for syncing google docs and naviance with the db
combined GPA views