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 |