Identify best way to show all new FAC submissions

[danielnaab]

User story

As a user, I want to search by FAC submission date so that I can see newly submitted audits even if they correspond to prior audit years.

Acceptance criteria

• [ ] Follow-up work on how to implement imports of prior audit years.
• [ ] Optionally, implementation.

Outstanding questions

• The FAC data dumps are by audit year, and prior audit years are in different formats than current audit years.
• The ideal solution would involve mirroring the entire database, but level-of-effort to import all the tables with the inconsistencies in the dumps may be a poor use of time.
• There may be a proxy table we can load to indicate that new audits were filed, which we can use to direct the user to the FAC interface to get more detail information when it corresponds to a prior audit year.