MySQL Steps

 

1.  Import the downloaded file into the temp table: aa_mi_f65_batch.

2.  Run the scripts in: MU MI F65 Batch Import. This prepares the data and inserts it into: ztblfinancialdatadetail.

3.  Run the script: Test Import F65 Data. This deletes any existing data and then inserts the data into the m_financialdatadetail table.

4.  Run the script: MU Update Indicator Score Data New Algorithm. This copies General Fund data from the m_financialdatadetail into the m_annualdata table for the fiscal score calculation.

5.  Run the script: MU Process Municipal Scores. This recalculates the fiscal scores for a specific state and fiscal year.

6.  Rebuild the Municipal Directory in Dirty Laundry