School
This resource publishes School-level information that includes the school's address, directory, identification, session, and phone.
Note: The schools that are published must NOT be excluded from state reporting.
This resource is updated to support sub-district capabilities in MS MSIS 2.0 for charter schools and includes publishing of the correct District and School references across the system. For more information, refer to the Additional Setup for Charter Schools section.
Element Name | Submission | Definition | Code Set, if applicable | Technical Name | [Table]Field Mapping | Business Rules or Comments |
|---|---|---|---|---|---|---|
Category - Address | ||||||
Address Apartment Room or Suite Number | Yes | The apartment, room, or suite number of an address. | None | AddressApartmentRoomOrSuiteNumber | This field is optional. To be added later. | |
Address City | Yes | The name of the city in which an address is located. | None | AddressCity | [Schools]SchoolCity | |
Address County Name | Yes | The name of the county, parish, borough, or comparable unit (within a state) in which an address is located. | None | AddressCountyName | [Schools]CountyName | |
Address Postal Code | Yes | A number that identifies each postal delivery area in the United States used as a portion of an address. | None | AddressPostalCode | [Schools]SchoolZIP | |
Address Street Number and Name | Yes | The street number and street name or post office box number of an address. | None | AddressStreetNumberAndName | [Schools]SchoolAddress | |
Address Type for Organization | Yes | The type of address listed for an organization. | MDE Option Set Mailing - Mailing | AddressTypeForOrganization | Default to "Mailing" Other addresses to be added later. | |
State Abbreviation | Yes | The abbreviation for the state (within the United States) or outlying area in which an address is located. | Refer to State Abbreviation. | StateAbbreviation | [Schools]SchoolState | |
Category - Directory | ||||||
Charter School Indicator | Yes | An indication that a public school provides free public elementary and/or secondary education to eligible students under a specific charter executed, pursuant to a state charter school law, by an authorized chartering agency/authority and that is designated by such authority to be a public charter school. | Yes | CharterSchoolIndicator | This field is optional. To be added later. | |
Charter School Type | Yes | The category of charter school. | School - School Charter | CharterSchoolType | NA | Not Applicable |
Grades Offered | Yes | The specific grade or combination of grades offered by an education institution. | Refer to Grades Offered. | SchoolOperationalStatus | [Schools]Low_Grade | A list of grades between Low_Grade and High_Grade. |
Magnet or Special Program Emphasis School | Yes | A school that has been designed: 1) to attract students of different racial/ethnic backgrounds for the purpose of reducing, preventing, or eliminating racial isolation; and/or 2)to provide an academic or social focus on a particular theme (e.g., science/math, performing arts, gifted/talented, career academy or foreign language). | All - All students participate | MagnetOrSpecialProgramEmphasisSchool | This field is optional. To be added later. | |
Operational Status Effective Date | Yes | The effective date for a change in operational status. | None | OperationalStatusEffectiveDate | This field is optional. To be added later. | |
School Operational Status | Yes | The current status of the school operations, exclusive of scheduled breaks, holidays, or other temporary interruptions. | Open - Open | SchoolOperationalStatus | [Schools]State_ExcludeFromReporting | Default to Open. We will be sending only schools that are not excluded from reporting. |
School Type | Yes | The type of education institution as classified by its primary focus. | Regular - Regular School | SchoolType | Default to Regular | |
Virtual Indicator | Yes | An indication that a childcare, early education, or early learning program, school, institution, program, or course section focuses primarily on instruction in which children and teachers are separated by time and/or location and interact through the use of computers and/or telecommunications technology. | Yes | VirtualIndicator | Default to No | |
Category - Identification | ||||||
Name of Institution | Yes | The full legally accepted name of the institution. | None | NameOfInstitution | [Schools]Name | |
Organization Type | Yes | The type of educational organization or entity. | MDE Option Set K12School - K12 School | OrganizationType | Default to K12School | |
School Identification System | Yes | A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to an institution. | MDE Option Set ACT - College Board/ACT program code set of PK-grade 12 institutions | SchoolIdentificationSystem | Default to SEA | |
School Identifier | Yes | A unique number or alphanumeric code assigned to an institution by a school, school system, a state, or other agency or entity. | None | SchoolIdentifier | [Prefs]Value where [Prefs]Name="DistrictNumber" concatenated with | Format: School ID (0000-000) 4 character district number |
Short Name of Institution | Yes | The name of the organization, which could be abbreviated form of the full legally accepted name. | None | ShortNameOfInstitution | [Schools]Abbreviation | |
Local Education Agency Identification System | Yes | A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a local education agency. | LEAIdentificationSystem | Default to SEA | ||
Local Education Agency Identifier | Yes | A unique number or alphanumeric code assigned to a local education agency by a school system, a state, or other agency or entity. | None | LocalEducationAgencyIdentifier | [Prefs]Value where [Prefs]Name="DistrictNumber" | This value is the same for all schools in the district. |
Category - Session | ||||||
School Year | Yes | The year for a reported school session. | None | SchoolYear | [Terms]Name Where isyearrec=1 | Calculated as the spring part of the school year. For example, for 2023-2024 school year, it shall extract as 2024. |
Session Begin Date | Yes | The year, month and day on which a session begins. | None | SessionBeginDate | [Terms]FirstDay | |
Session End Date | Yes | The year, month and day on which a session ends. | None | SessionEndDate | [Terms]LastDay | |
Session Scheduling Term Indicator | No | Indicates that the session is a scheduling term. | Yes | SessionSchedulingTermIndicator | NA | Not Applicable |
Session Type | Yes | A prescribed span of time when an education institution is open, instruction is provided, and students are under the direction and guidance of teachers and/or education institution administration. A session may be interrupted by one or more vacations. | FullSchoolYear - Full School Year | SessionType | [Terms]Portion | 1=FullSchoolYear 2=Semester 3=Trimester 4=Quarter 5=Quinmester 6=MiniTerm |
Category - Technical Assistance | ||||||
Technical Assistance Approved Indicator | No | Indicates whether or not the technical assistance was approved. | Yes | TechnicalAssistanceApprovedIndicator | NA | Not Applicable |
Technical Assistance Delivery Type | No | The method of delivery of technical assistance received/provided | Onsite - Onsite | TechnicalAssistanceDeliveryType | NA | Not Applicable |
Technical Assistance Type | No | The type of technical assistance provided. | Refer to Technical Assistance Type. | TechnicalAssistanceType | NA | Not Applicable |
Category - Telephone | ||||||
Institution Telephone Number Type | Yes | The type of communication number listed for an organization. | MDE Option Set Main - Main phone number | InstitutionTelephoneNumberType | Main or Fax depending on the field being extracted.
| |
Telephone Number | Yes | The telephone number including the area code, and extension, if applicable. | None | TelephoneNumber | [Schools]SchoolPhone | |