Known Anamolies

m_municipalities – this table was named when we were only doing Municipalities but it actually holds School Districts, Public School Academies and Service Providers as well.

m_schoolannualdata – by definition this table should begin with an “s” but was named before the prefix was standardized. More importantly, is the field SadScdID. By definition this should be SadMunID since this foreign key points to the m_municipalities table. However, too many objects refer to the current field name to change this.