Skip to main content
Skip table of contents

Calendar

This resource publishes the school calendars that include events, organization identification, and session information.

Additional setup is required to publish the K12 Organization > Calendar resource. Refer to the Additional District Setup section.

Note: The school calendars are published for schools NOT excluded from state reporting.

Element Name

Submission

Definition

Code Set, if applicable

Technical Name

[Table]Field Mapping

Business Rules or Comments

Category - Event

Calendar Event Date

Yes

The date of the scheduled or unscheduled calendar event.

None

CalendarEventDate

[Calendar_Day]Date_Value

NA

Calendar Event Day Name

Yes

A name used for the day of the calendar event.

None

CalendarEventDayName

[Calendar_Day]Notes

Truncate to 30 characters maximum length.

Calendar Event Type

Yes

A type of scheduled or unscheduled calendar event.

MDE Option Set

EmergencyDay - Emergency day
Holiday - Holiday
InstructionalDay - Instructional day
Other - Other
Strike - Strike
LateArrivalEarlyDismissal - Student late arrival/early dismissal
TeacherOnlyDay - Teacher only day
ProfessionalDevelopmentDay - Professional Development Day 

CalendarEventType

[Calendar_Day]Type

Setup is required to match the values expected by MDE. See code mapping below:

  • ED - EmergencyDay

  • H - Holiday

  • IN - InstructionalDay

  • O - Other

  • ST - Strike

  • LAED - LateArrivalEarlyDismissal

  • TD - TeacherOnlyDay

  • PD - ProfessionalDevelopmentDay

Anything outside this list will be defaulted to "Other"

Category - Organization Identification

Organization Identification System

Yes (Optional for School)

A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to an organization.

MDE Option Set

ACT - College Board/ACT program code set of PK-grade 12 institutions
NCES - National Center for Education Statistics assigned number
SEA - State Education Agency assigned number

OrganizationIdentificationSystem

Default to "SEA"

Organization Identifier

Yes (Optional for School)

A unique number or alphanumeric code assigned to an organization by a school, school system, a state, or other agency or entity.

None

OrganizationIdentifier

[Prefs]Value where Prefs.Name="DistrictNumber" concatenated with
[Schools]School_Number

Format: School ID (0000-000) 4 character district number + - + 3 character school number.

Organization Type

Yes (Optional for School)

The type of educational organization or entity.

MDE Option Set

K12School - K12 School
LEA - Local Education Agency (LEA)
SEA - State Education Agency (SEA)

OrganizationType

Set to K12School

Category - Session

Alternate Day Name

Yes (optional)

An alternate name used for the school day, typically used for the bell schedule (e.g., Blue day, Red day).

None

AlternateDayName

NA

NA

Calendar Description

Yes (optional)

A description or identification of the calendar.

None

CalendarDescription

NA

NA

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

NA

Session Code

Yes (optional)

A local code given to the session, usually for a session that represents a term within the school year such as a marking term.

None

SessionCode

[Terms]Abbreviation

NA

Session Description

Yes (optional)

A short description of the Session.

None

SessionDescription

[Terms]Name

NA

Session End Date

Yes

The year, month and day on which a session ends.

None

SessionEndDate

[Terms]LastDay

NA

JavaScript errors detected

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

If this problem persists, please contact our support.