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 [Schools]MailingCity or [S_SCH_X]SchoolCity [S_SCH_X]MailingCity | |
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 [Schools]Mailing_Count or [S_SCH_X]CountyName [S_SCH_X]Mailing_Count | |
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 [Schools]Mailing_ZIP or [S_SCH_X]SchoolZIP [S_SCH_X]Mailing_ZIP | |
Address Street Number and Name | Yes | The street number and street name or post office box number of an address. | None | AddressStreetNumberAndName | [Schools]SchoolAddress [Schools]Mailing_Street or [S_SCH_X]SchoolAddress [S_SCH_X]Mailing_Stree | |
Address Type for Organization | Yes | The type of address listed for an organization. Note: Both Mailing and physical address use the same data type and properties as the current address fields. When publishing the address section, we shall publish the Physical Address fields are published as “Physical” and Mailing Address fields as “Mailing”. The default is set to “Physical”. | 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 [Schools]Mailing_State or [S_SCH_X]SchoolState [S_SCH_X]Mailing_State | |
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 | The system will publish Yes or No (S_SCH_CRDC_X.CharterSchool_YN). Default is No. | |
Charter School Type | Yes | The category of charter school. | School - School Charter | CharterSchoolType | NA | If Charter school (S_SCH_CRDC_X.CharterSchool_YN) is Yes, then the system will publish “School”. |
Grades Offered | Yes | The specific grade or combination of grades offered by an education institution. | Refer to Grades Offered. | SchoolOperationalStatus | [GradesOffered]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 | If the user selects “Yes” for the Magnet or Special Program Emphasis School (S_SCH_CRDC_X.MagnetSchoolOrProgram_YN) field under the Start page, District Information, Compliance tab, the system will publish “Some”. However, the system will publish “None” if the user does not select “Yes”. If the user selects “Yes” for the All Magnet Only (S_SCH_CRDC_X.AllMagnetOnly_YN) field, the system will publish “All”. However, the system will publish “Some” if the user selects “No”. | |
Operational Status Effective Date | Yes | The effective date for a change in operational status. | None | OperationalStatusEffectiveDate | Only published when the school operational status changes. Format: YYYY-MM-DD | |
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 is Open if status is blank. 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 | The system will publish Yes or No. Default is No. | |
Web Site Address | Yes | The Uniform Resource Locator (URL) for the unique address of a Web page. | WebSiteAddress | [S_SCH_X]Website_URL | The same data type and properties as the current field on the Sub-District page. | |
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.Name="DistrictNumber" | This value is the same for all schools in the district. |
InstructionalMintuesPerDay | Yes | The number of instructional minutes in the day in which the school is normally in session. | InstructionalMintuesPerDay | [S_SCH_X]InstrMintuesPerDay | ||
LunchMinutesPerDay | Yes | The number of lunch minutes in the day in which the school is normally in session. | LunchMinutesPerDay | [S_SCH_X]LunchMinutesPerDay | ||
RecessMinutesPerDay | Yes | The number of recess minutes in the day in which the school is normally in session. | RecessMinutesPerDay | [S_SCH_X]RecessMinutesPerDay | ||
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 |