Update Misc Tables

_oat.math_communication_requirements

Sam St. Amand generates new versions of tables encoding Math Communications requirements and anti-requisites. This typically happens in late August. She’ll open a git issue or send the CSV files. They need to be loaded into the appropriate tables.

It’s expected that the contents of the CSV will simply replace the existing data.

Workflow

  1. Save the math communications CSV to /oat3/sql/operations/math_comm_requirements/math_communication_requirements_YYYY_YY.csv where the Ys are filled in with the appropriate academic year (eg 2025-26).
  2. Run ./load_math_comm_requirements.scala math_communication_requirements_YYYY_YY.csv. Note that the script takes a --service argument (that defaults to oat-prod).

_oat.uw_ug_antireqs

Pretty much the same as _oat.math_communication_requirements but in the /oat3/sql/operations/ug_antireqs/ directory.