search

Hennepin-County / MAXIS-scripts

6 stars 1 forks source link

Audit the use of the SQL tables for Income and Elig in Ex Parte #1398

Open C-Love opened 1 year ago

C-Love commented 1 year ago

Now that we the functionality stabilized for Ex Parte, we need to review the use of the 2 data tables - Income and Elig. These tables inform details about the selection of cases and provide more simplicity and significant speed to the PREP run for Ex Parte.

We are certainly able to use these tables to a greater degree if we update them as the process continues, but we have no plans for how to do that right now and we don't have access set up for these lists to be updated by inserting information (not sure about delete).

These could be lists that change as the processing goes on, if we don't need data from it and it only supports the processing.

We also might need to make adjustments to the queries.

Most changes to these functionality requires connection with the BI team.

IlseFerris commented 1 year ago

DaNM: updates from MAXIS/MEC2 SGG meeting