Lots of SQL. Refactored users table, splitting out ‘organization’ and ‘college’ into a separate table to account for multiple values. With help of Jonathon Trigeux, came up with table to map colleges to organizations. after much fiddling, arrived at this summary table:
Had to seriously modify calendar coed to account for new table structure.