MySQL Operations

Copy Existing Fiscal Year

It is critical to make a copy of any existing fiscal data for the year being uploaded. You must copy the Annual Data record and the related Financial Data Detail records. For the Annual Data record export "SELECT m_annualdata.* FROM m_annualdata JOIN m_municipalities ON MunID = AndMunID WHERE MunModID = 1 AND MunState = 'MI' AND MunType = 'County' AND AndYear = 2014 AND AndIndicatorScore IS NOT NULL" and then import back in with a Scenario "D" and Data Status "Workbook" (saved as "MU List Counties to Duplicate Annual Data Records").