The Missouri Reports Setup screen is used to set options used in various state reporting processes.
The Missouri Reports Setup module contains three calendar-related tabs that supply required data for the Missouri calendar submissions:
- School Calendar Header Setup - stores metadata about each attendance calendar (grade range, instructional time, four-day week status, etc.).
- School Calendar Days Setup - stores a standard day length per school/calendar and per-date exception rows for days that are already in the attendance calendar but need special reporting values.
- School Calendar Non-Session Days Setup - defines dates that are not in the attendance calendar but must still appear in the Days extract.
All three tabs feed data used by the SchoolCalendarHeader and SchoolCalendarDays extracts. Schools flagged as "Exclude from State Reporting" (CUSTOM_200000200 = 'Y') are hidden in all tabs and excluded from all output.
Recommended Setup Workflow:
1. Complete School Calendar Header Setup first.
- For each calendar: enter Begin Grade and End Grade, fill in Minutes Per Week / Periods Each Day / Minutes Each Period, set Four Day School Week fields if applicable, and select Exclude from State Reporting on any non-reporting calendars.
2. Set the Standard Day Length in School Calendar Days Setup.
- If hours calculated from calendars and bell schedules are correct, you do not need to do this step. Start with All Schools / All Calendars if most schools share the same day length (enter in hours). Then switch to a specific school or calendar to enter any overrides.
3. Add per-date exception rows for every non-standard day.
- Weather cancellations, AMI days, planned make-up days, and emergency closures all require an Event Code row. Use the narrowest scope that applies: calendar-specific for single-calendar events, school-level for events affecting all calendars at one school, district-level for district-wide closures.
4. Save after each scope change.
- The save button applies to whichever school/calendar is currently selected in the pull-downs. After changing the scope, click Save Hours/Records before switching away.
The District Setup tab is used to set the district default for the MAP administration date. If a school does not have a date set in the School MAP Administration Dates tab, the district default date will be used.
1. In the Missouri Reports menu, click Missouri Reports Setup.
The District Setup tab is opened by default.
2. Update the Date of MAP Administration, as needed.
3. Select Report Second School Attendance in SEA Extract, if desired. When selected, all ADA reportable attendance from a student's enrollment marked as Second School will be added to their primary enrollment in the Student Enrollment and Attendance extract.
4. Select Do Not Create MAP Precode Records Unless Student is Scheduled in State Testing Course, if desired. When selected, the MAP extract will only report students scheduled into MAP courses.
5. Select Calculate Summer Course Assignment Caseload, if desired. If selected, the summer course assignment file will report the number of students scheduled in the section on the extract effective date if the section has a state course code of 192000. If the option is not selected, no caseload will be reported.
6. Click Save Records when finished.
The School Calendar Days Setup tab is used to set default standard day length hours and specify special case dates for the district, school, and calendar levels.
The School Calendar Days extract calculates hours for each school day from the attendance calendar and bell schedules. Standard day length entries override that calculation: the most specific non-zero value applies calendar-level, then school-level, then district-level. Specific date entries override the standard day length.
This tab stores two types of data: a standard day length for a school/calendar combination, and per-date exception rows for days that deviate from the normal schedule. The data is stored in MO_CALENDAR_ENTRIES (standard day length) and MO_CALENDAR_DATES (per-date rows).
1. In the Missouri Reports menu, click Missouri Reports Setup.
2. Click the School Calendar Days Setup tab.
3. Select the School and Calendar. This controls which scope the data is saved at.
The system supports three scope levels, applied in priority order when resolving values for the extract.
| School | Calendar | Scope | Priority |
|---|---|---|---|
A specific school | A specific calendar | Calendar-level (most specific) | 1 — Highest |
|
A specific school |
All Calendars |
School-level |
2 |
|
All Schools |
All Calendars |
District-level (broadest) |
3 — Lowest |
For every date in the Days extract, the system checks for a matching exception row at the calendar level first, then the school level, then the district level. The first match found is used. This applies to all four per-date fields: Day Length, Event Code, Event Hours, and Comments. If no exceptions exist for a particular day, the extract will calculate the hours from school calendars and bell schedules.
Select All Schools and All Calendars for district-wide closures or a uniform default day length. Use school-level for events that affect all calendars at one school. Use calendar-level only when the exception applies to a single calendar.
4. Set the Standard Day Length (hours).
This sets the default reported hours for every day in the selected scope. The extract resolves StandardDayLength for each date using this priority order:
Priority 1 (highest): Per-date Day Length override (from the exception rows below)
Priority 2: Standard Day Length entered here
Priority 3 (lowest): Calculated from bell schedule period times (total minutes ÷ 60)
In practice: Enter a Standard Day Length here if the bell schedule calculation produces incorrect hours for a school or calendar. Add a per-date exception row (Priority 1) only when a single day differs from the rest.
Note: Entering 0 for Standard Day Length is treated the same as leaving it blank — the system skips it and falls through to the next priority level.
UI note: When a school or calendar is selected, the parent-scope Standard Day Length fields are shown as read-only for context. Only the field matching the current scope selection is editable.
5. In the table, enter any special reporting values.
Each row represents a specific school date that needs special reporting values. Rows can be added, edited, and deleted. The Date field must match a date that exists in the system’s ATTENDANCE_CALENDAR for the selected calendar.
| Field | Extract Column | Notes |
|---|---|---|
Date | Date | The specific school date this exception applies to. |
Day Length in Hours | StandardDayLength | Overrides the Standard Day Length for this one date. Subject to the scope cascade — a calendar-level row overrides school-level and district-level rows for the same date. |
Event Code | EventCode | Missouri-defined code classifying the type of event. See the Event Code Reference table below. Leave blank (N/A) for normal school days. |
Event Hours | EventHours | Hours associated with the event. Numeric. For Event Codes 2 and 3 only: if left blank, the extract automatically uses the day’s resolved Standard Day Length as the Event Hours value (applying the same priority chain: per-date Day Length → calendar STD → school STD → district STD → bell schedule). For all other event codes, Event Hours is only what is explicitly entered; blank stays blank in the extract. |
Comments | Comments | Free-text description. Maximum 200 characters. |
Event Code Reference:
| Code | Description |
|---|---|
| 1 |
School Not in Session |
| 2 |
Planned Weather Make-up (Conditional) |
| 3 |
Planned Weather Make-up (Built-in) |
| 4 |
Actual Weather Make-up |
| 5 |
School in Session — AMI |
| 6 |
School Not in Session — Snow/Ice |
| 7 |
School Not in Session — Excessive Heat / Extreme Cold |
| 8 |
School Not in Session — Tornado |
| 9 |
School Not in Session — Flooding |
| 10 |
School Not in Session — Utility Outage |
| 11 |
School Not in Session — Contagious Disease |
| 12 |
School Not in Session — Other Exceptional or Emergency Circumstance |
| 13 |
School Not in Session — Inclement Weather Other |
| 14 |
Make-up — Other |
6. Click Save Hours/Records.
The School Calendar Header Setup tab allows users to set additional information for Focus attendance calendars.
This tab displays one row per school/calendar combination for the current school year. Changes are saved to the MO_CALENDAR_INFO table. Every field maps directly to a column in the SchoolCalendarHeader extract.
1. In the Missouri Reports menu, click Missouri Reports Setup.
2. Click the School Calendar Header Setup tab.
3. For each school and calendar, set the following fields, as needed.
| Field | Extract Column | Notes |
|---|---|---|
| School | N/A | Identifies which school the row belongs to. Read-only. |
| Calendar | N/A | Identifies the attendance calendar. Read-only. |
| Date Calendar Adopted | dateCalendarAdopted | Output formatted m/d/Y. Blank if not entered. |
| Begin Grade | beginGrade | The lowest grade level served by this calendar. Appears in both the Header and on every date row in the Days extract. Select from the standard Missouri grade list (PK through 12, including AM/PM splits). |
| End Grade | endGrade | The highest grade level served. Same usage as Begin Grade. |
| Minutes Per Week | minPerWeek | Total instructional minutes scheduled per week. Up to 6 digits. |
Periods Each Day | periodsEachDay | Number of instructional periods per day. Up to 7 characters. |
Minutes Each Period | minutesEachPeriod | Length of each period in minutes. Up to 9 characters. |
Exclude from State Reporting | Suppresses all output | When checked, this calendar is completely removed from both the Header and Days extracts. No records will appear for it in either report. Use for non-reporting calendars. |
Four Day School Week | FourDaySchoolWeek | Check if this calendar operates on an approved four-day school week schedule. Outputs Y or blank. |
Date Four Day Week Approved | dateVotersApproved4DayWeek | First school year the four-day approval is effective. 4-digit year. |
|
Four Day Week End Year |
FourDayVoterAppEndYear |
Last school year the four-day approval is effective. 4-digit year. |
The Exclude from State Reporting check box controls whether the calendar appears in any Missouri calendar extract.
Selecting this option hides the calendar from both SchoolCalendarHeader and SchoolCalendarDays. Verify this setting carefully before running extracts.
4. Click Save Records.
Use the Mass Update function to update multiple records at once. When filtering the table, only the visible rows will be updated when using Mass Update. After using Mass Update, click Save Records to commit the changes. See Mass Update for more information on using this function.
The School Calendar Non-Session Days Setup tab is used to define non-session dates at the district, school, or calendar level. These dates appear in the School Calendar Days extract for dates not already present in the attendance calendar.
This tab defines dates that are not present in the attendance calendar but must appear as rows in the SchoolCalendarDays extract. Typical uses include planned holidays (e.g., Christmas), emergency district closures, and any other non-session day that needs state reporting. Data is stored in the MO_CALENDAR_NONSESSION table.
If a date entered here is also present in ATTENDANCE_CALENDAR for a given school/calendar, the session day always takes precedence and the non-session entry is silently ignored for that combination. Use School Calendar Days Setup to annotate dates that are already in the calendar.
1. In the Missouri Reports menu, click Missouri Reports Setup.
2. Click the School Calendar Non-Session Days Setup tab.
3. Select the School and Calendar.
The same three scope levels apply as in School Calendar Days Setup, but here the scope controls which schools and calendars a non-session date is expanded to in the extract rather than which annotation values to use. Each entry is expanded outward to all applicable combinations:
| School | Calendar | Scope | Expands To |
|---|---|---|---|
|
All Schools |
All Calendars |
District-level |
Every school and calendar in the extract |
|
A specific school |
All Calendars |
School-level |
Every calendar at that school |
|
A specific school |
A specific calendar |
Calendar-level |
That school/calendar only |
If the same date is entered at more than one scope level, the most specific entry wins for any given school/calendar combination (calendar-level > school-level > district-level). Calendars with Exclude from State Reporting checked are never included in the expansion.
Enter district-wide holidays (Christmas, Thanksgiving, etc.) once using All Schools / All Calendars and they will appear for every school and calendar automatically. Only drop to a narrower scope when the date applies to a subset of the district.
4. In the table, enter any special reporting values.
| Field | Extract Column | Notes |
|---|---|---|
Date | Date | The non-session date to report. Must not already exist in the attendance calendar for the selected scope — if it does, the session day takes precedence and this entry is ignored for that school/calendar. |
Event Code | EventCode | All 14 Missouri event codes are available. Defaults to 1 —School Not in Session. See the Event Code Reference table in School Calendar Days Setup. |
|
Standard Day Length | StandardDayLength | Hours the school was in session. Optional; leave blank for a true non-session day. No bell schedule fallback applies — the value here is used as-is. |
|
Event Hours |
EventHours |
Hours associated with the event. Optional. |
|
Comments |
Comments |
Free-text description. Optional. |
School Calendar Days Setup annotates dates that already exist in the attendance calendar. School Calendar Non-Session Days Setup creates reporting rows for dates that do not exist in the attendance calendar. The two tabs serve complementary purposes and together cover all dates that need special treatment in the extract.
5. Click Save Records.
SchoolCalendarHeader Extract
- Produces one record per calendar (not per date, not per student).
- All fields come exclusively from School Calendar Header Setup (MO_CALENDAR_INFO).
- Calendars with Exclude from State Reporting checked are not included.
- beginDate and endDate are always sourced directly from the earliest and latest dates in ATTENDANCE_CALENDAR — they are not stored in setup and cannot be overridden.
- Date fields are output formatted as m/d/Y.
SchoolCalendarDays Extract
- Produces one record per school date per calendar, including both attendance calendar dates and non-session dates.
- beginGrade and endGrade come from School Calendar Header Setup and repeat on every date row.
- For attendance calendar dates: StandardDayLength uses the three-level priority chain (per-date override → standard day length → bell schedule calculation). ). Event Code, Comments, and Day Length all use the three-scope cascade (calendar-specific → school-wide → district-wide). Event Hours also uses the cascade, with one exception: for Event Codes 2 (Planned Weather Make-up Conditional) and 3 (Built-in), if Event Hours is blank after the cascade, the extract falls back to the resolved Standard Day Length for that day.
- For non-session dates: values come directly from School Calendar Non-Session Days Setup. There is no bell schedule fallback — Standard Day Length and Event Hours are exactly what was entered (or blank). Session days always take precedence over non-session entries for the same date and school/calendar.
- Calendars with Exclude from State Reporting checked are not included, and non-session date expansion skips excluded calendars.
- For August, only blank event codes and codes 1, 2, and 3 are reported.
- For June, event codes 2 and 3 are not reported.
The School MAP Administration Dates tab is used to set the date of MAP administration by school. If a school does not have a date set in this tab, the district default set in the District Setup tab will be used.
1. In the Missouri Reports menu, click Missouri Reports Setup.
2. Click the School MAP Administration Dates tab.
3. Update the Date of MAP Administration for a school, as needed.
4. Click Save Records when finished.













