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 for Calendars 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 | CalendarEventType | [Calendar_Day]Type | Setup is required to match the values expected by MDE. See code mapping below:
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 | 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 | 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 | 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 |