Impact Aid Enrollment Count (Montana)

Classic Path: MT State Reporting > Impact Aid Enrollment Count

Search Terms: Impact Aid Enrollment Count

The Impact Aid Enrollment Count searches within a selected date range to report the date with the highest number of enrollments per school for use in Federal Impact Aid reporting.

Screenshot of the Impact Aid Enrollment Count Extract Editor.Impact Aid Enrollment Count Extract Editor

Reporting Population and Business Rules 

  • The Impact Aid Enrollment Count report will return the date with the highest enrollment count per school.
    • Users are required to select an enrollment type(s) to be included in the query.
    • The query will not include enrollments that are marked exclude, or in excluded calendars and grade levels UNLESS the Include Excluded Enrollments box is checked.
    • The query will find the date with the highest number of enrolled students within the selected date range for each school selected.
    • The query will count distinct enrollments within a school.
      • If a student has overlapping enrollments within the same school they will only be counted 1 time.
      • Students with the checkbox Extracurricular Activities Only marked on their enrollment are excluded from attendance calculations used within the report.

Generate the Report

  1. Enter the Start Date and End Date. Only enrollment records within this date range are considered for reporting.
  2. Select the Enrollment Service Type. Only enrollment records with this Service Type are considered for reporting. You must select a value in order for data to report in the extract.
  3. To have excluded enrollments included in the report, mark the Include Excluded Enrollments checkbox.
    Marking this checkbox does NOT change the reporting logic for extracurricular students. Students who have the Extracurricular Activities Only checkbox marked on their enrollment are still excluded from the report.
  4. Select the report Format
  5. Select the School Year
  6. Select which School(s) will report data. 
  7. Select how the data is generated/sent:
    • Generate Report - Select this option to generate the report immediately. 
    • Submit to Batch - Select this option to schedule when the report will be generated. The report will appear in the Batch Queue List.

Screenshot of an HTML example.HTML Example

Data Elements

Data Element

Description

UI Path and Database Field

District Name

The name of the Montana district.

Student Information > General > Enrollment


District.name

School Number

The unique school number assigned by the OPI.


Must be 4 characters long.

Student Information > General > Enrollment


School.number

School Name

Name of the School where enrollments were counted.

Student Information > General > Enrollment

School.name
Highest Enrollment DateDate where the most students were enrolled in the school.

If there are multiple dates where the number of enrollments for the school was at its highest point display the first instructional date where the number was reached.

Instructional Day is determined by the date being checked as a School Day and Instruction Day in at least one calendar for the school.

If the school does not have Days set up in any calendars report the highest enrollment date within the Date Range.


Calculated
Total Enrollment CountReport the total number of distinct students enrolled in the school on the Highest Enrollment Date.Calculated
Enrollment Service TypeReport the Enrollment Service Type(s) included in the query.

List the enrollment service types selected in the UI, separated by a comma.

  • P for Primary
  • S for Secondary
  • N for Special Ed

Eg., 'P, S, N' when all Enrollment Service Types are selected.

MT State Reporting > Impact Aid Enrollment Count > Enrollment Service Type
Include Excluded EnrollmentsReport if the Count included enrollments marked as 'Exclude' or enrollments from excluded calendars and grade levels.

Report 'Y' when the Include Excluded Enrollments is checked, else report 'N'
MT State Reporting > Impact Aid Enrollment Count > Include Excluded Enrollments
Date RangeReport the Date Range selected in the extract editorMT State Reporting > Impact Aid Enrollment Count > Date Range
4th School DayReport the 4th day of school for the year.

Report the 4th day of school for the year.

  • 4th School Day can be outside of the Date Range but must be within the same school year.
  • If the school has multiple calendars, report the earliest Day #4 out of all the calendars
  • If the school does not have any calendars with Days set up, leave blank.
Calendar > Days > Day Detail > Day #

Calculated