Skip to main content
Skip table of contents

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.

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
Physical - Physical

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
No

CharterSchoolIndicator

This field is optional. To be added later.

Charter School Type

Yes

The category of charter school.

School - School Charter
CollegeUniversity - College/University Charter
NA - Not a Charter School

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
[Schools]High_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
None - No students participate
Some - Some, but not 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
Closed - Closed
New - New
Added - Added
ChangedAgency - Changed Agency
Inactive - Inactive
FutureSchool - Future school
Reopened - Reopened

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
Special - Special Education School
CareerAndTechnical - Career and Technical Education School
Alternative - Alternative Education School
Reportable - Reportable Program

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
No

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
SEA - State Education Agency assigned number
NCES - National Center for Education Statistics assigned number

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
[Schools]School_Number

Format: School ID (0000-000)

4 character district number
+ - +
3 character school 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.

Refer to Local Education Agency Identification System.

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
No

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
Intersession - Intersession
LongSession - Long Session
MiniTerm - Mini Term
Quarter - Quarter
Quinmester - Quinmester
Semester - Semester
SummerTerm - Summer Term
Trimester - Trimester
TwelveMonth - Twelve Month
Other - Other

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
No

TechnicalAssistanceApprovedIndicator

NA

Not Applicable

Technical Assistance Delivery Type

No

The method of delivery of technical assistance received/provided

Onsite - Onsite
Virtual - Virtual classroom
Off-Site - Off-site classroom
Conference - Conference

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
Fax - Fax number

InstitutionTelephoneNumberType

Main or Fax depending on the field being extracted.

  • If SchoolPhone then Main

  • If SchoolFax then Fax

Telephone Number

Yes

The telephone number including the area code, and extension, if applicable.

None

TelephoneNumber

[Schools]SchoolPhone
[Schools]SchoolFax

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.