1.  Run “MI F65 Prep” to truncate 3 temp tables: tmp_f65_imp_rev, tmp_f65_imp_exp, tmp_f65_imp_sop

2.  Import the three Revenue, Expense and SOP Excel files prepared from the Michigan F65 Portal into the 3 temp tables.

3.  MI F65 Run Normalize à MI F65 Normalize Utilities

4.  Run the Stored Procedure Test Import F65 Data which repeatedly processes the records in ztblfinancialdatadetails by calling the stored procedure importF65Data.

5.  Need to update General Fund numbers on the home pages by running MU Update Indicator Data New Algorithm make sure to replace the Fiscal Year and State Code in the Where filters before running.

Need to recalc by running Test MU Process Municipal Scores; make sure to process years in ascedning order

Need to rebuild the Directory by running Test Build Municipal Directory