Michigan School Annual Data Load

The data for 2019 was in 2 ZIP files producing 4 MS Excel files.

 

Use this to delete any existing records for the Year: SELECT SfdID FROM s_financialdatadetail JOIN m_schoolannualdata ON SadID = SfdSadID JOIN m_municipalities ON MunID = SadScdID WHERE MunModID = 2 AND MunState = 'MI' AND SadYear = 2019 AND SadScenario = 'Baseline'

 

Otherwise use the following steps to save the data under a different Scenario for the same year.