The Total Debt value is found in a separate download from the state’s portal (https://apps.fldfs.com/LocalGov/Reports/default.aspx) titled “Totals Revenues, Expenditures and Debt”. The report includes Total Revenues, Expenditures, Debt and the date the AFR was filed.

For each fiscal year, download the report, copy and paste the rawdata into the master totals Excel file “FL MU Annual Totals Report”. There is a tab in this file for each fiscal year.

Insert one column to the left of Column B and name it ImpMunID. The final column names will be: ImpMunID, UnitID, LocalName, GoverningAuthority, Revenues, Expenditures, Debt, AFRReceived

Truncate the MySQL table: aa_fl_annual_debt

import the raw data into MySQL and append to the table: aa_fl_annual_debt.

Update the FiscalYeart field to the year being imported: UPDATE aa_fl_annual_debt SET FiscalYear = YYYY Make sure to change the Fiscal Year Value

Updated the MunID from the m_municipalities table: UPDATE aa_fl_annual_debt JOIN m_municipalities ON MunLocalCode = UnitID SET ImpMunID = MunID WHERE MunModID = 1 AND MunState = 'FL'.

NOTE: double check in case some municiplaities did not get an ID: SELECT ImpMunID, UnitID, LocalName, LENGTH(LocalName) FROM aa_fl_annual_debt WHERE ImpMunID is NULL ORDER BY LENGTH(LocalName)

Update m_annualdata table with the total debt: UPDATE m_annualdata JOIN aa_fl_annual_debt ON ImpMunID = AndMunID SET AndGeneralLongTermDebt = Debt WHERE AndYear = YYYY Make sure to change the Fiscal Year Value