...
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 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:
...