Download the Entity Master from the state’s website: https://cepi.state.mi.us/eem/PublicDatasets.aspx
Save the file by adding the school year as a prefix to the name and store it in BOX at Clients à aaMichigan à Schools à Entity.
In the Excel file remove the spaces from the column names.
Import the Excel file into: “aa_mi_se_eem”.
Run the SQL utilities in: “SE MI Import Entity”.
The EEM is used for both districts (m_municipalities) and Buidlings (c_buildings). There are scripts for both.