...
On my list of items to revisit in future sessions:
-Finding potential twins (people where there exist other people with the same address, birthdate, and last name)
-NOT EXISTS/IN vs. EXISTS/NOT IN
8/21/2024
We touched on subquery joins vs. joins inside subqueries, took a detour into independent subqueries and system bases for lookup.activity, and then discussed various combinations of EXISTS, NOT EXISTS, IN, NOT IN, and NOT.
On that last front, Hannah, I think I misunderstood what you were asking at one point—you were correct that EXISTS a decision NOT IN Admit:
...
Is equivalent to EXISTS a decision IN all of the codes other than Admit:
...
Both of those would return applications that have at least one decision other than admit, but neither would exclude applications that also have an admit code. That was why we needed to add the second filter for NOT EXISTS code IN Admit.
9/11/2024 Reporting Demo
The reports we started on events and mailings can be found here:
https://tusmgp.admissions.tufts.edu/manage/report/render?id=271c0756-a2a2-4ecf-9c66-1b329699a06b
https://tusmgp.admissions.tufts.edu/manage/report/render?id=db5914b7-af9a-4cf0-ac4e-15b1340fd5c7
Once we've wrapped up the full rebuild of the other reports, I'll share those links as well.
The four legacy reports we identified for rebuilding have all been completed, along with the two demo reports for events and mailings that we mocked up for Alessa and Hannah on the call:
Demos:
Rebuilt:
[CJs Migration] 2023 MPH Application Funnel (legacy version here)
[CJs Migration] Fall 2023 - Tallies by Status - MBS (legacy version here)
[CJs Migration] PHPD 2023 - Tallies Report (MBS) (legacy version here)
[CJs Migration] Su 2023 DPT-PHX Application Funnel (legacy version here)