Research issue: Come up with a way of proactively assuring data quality of high profile committees after filing deadlines

[jwchumley]

This is a research task to create a plan for checking high-profile reports as they come in. Can we set this up as a new relic test? What should we test? This will be an ongoing process we build on, so our results don't need to be comprehensive.

1. Entirely in FECP - checking for issues after nightly load such as:

• Amended report has vastly different number of transactions compared to previous report
• Ops log pass3 entry date is done but number of transactions obviously disagrees with number of pages
• etc

2. Between FECP and PG (I think this is already in place making sure data transfer has no issues)
3. Entirely in PG
   • Using Operations log pass 3 entry done date to know when to test for transactions added to API
   • Comparing base tables with API output
   • Check count of filings each day

Completion criteria:

• In FECP: Figure out what to check?
• Between FECP and PG is it already being checked or do we need more checks there?
• In PG Figure out what to check and how to check it