Monthly assignments

Currently, Courtney and Jieun produce a two-column spreadsheet with resp_id and assignments by name. [Dan is not sure exactly what is involved with this piece, please feel free to expound.]

Dan converts that name column into an "assignment" column with the numbers for assignments. (These numbers were brought over from the old, horrifying MySQL database and are a bit strange.)

As of right now, we are assigning all respondents being assigned to Madison Biomarker (42) who finish Cognitive at M4 to Bio/Neuro (425) OR who are longitudinal. Dan is doing this semi-manually currently using a report, with plans to automate.

Once that final two-column spreadsheet is ready, the automation script create_assignments.py is ran:

./create_assignments.py m4 path_to_assignments.csv

And then the update_current_assignment.py script should also be kicked:

./update_current_assignment.py m4 core

Changes

2026-05-18: Dan created a flag on the flat reporting instrument that identifies neuro longitudinal participants (yes/no) and added that to the assignment checking report

2026-04-22: Dan added "do not contact" prevention that queries the DB for any assigned people who are marked do not contact or deceased

2026-04-12: All respondents to Madison Bio who finish Cognitive at M4 get assigned to Bio/Neuro (currently manual)