Montana AIM Average Daily Attendance

Contents

Introduction

This report includes student ADA/ADM for the end of year average daily attendance collection. ADA/ADM is calculated from the student’s enrollment date to the count date or to the last day of the school year, whichever is earlier. The report produces a tab delimited text file that can be uploaded to the Achievement In Montana (AIM) reporting system.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects student records from the [Students] and [ReEnrollments] tables based on the following criteria:

The student must have been enrolled in the school at some time during the current school year.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Current Selection Students*	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district who meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Count Date*	Enter the count date for the report.
Calendar Number (###)*	Enter the school calendar number. If the school has more than one calendar, this value indicates which calendar is used for this report.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
Header Record
1	Record Type	The record type identifier	Always set to HD	String	2
2	Date	The date the file was created in mm/dd/yyyy format.	System date	Date	10
3	Time	The time the file was created in hh:mm:ss format	System time	Time	8
4	Version	The version of the file format	Always output as MT9.1	String	5
Detail Record
1	Record Type	The file type abbreviation. Set to “AA”	Always set to “AA”	String	2
2	District Number	The unique system number assigned by the OPI. This is not the Legal Entity (LE) Number. This is the district number in PowerSchool. See the AIM website to identify your District Number, Reporting Entity Number, and School Number: http://opi.mt.gov/Reports-Data/AIM/	[Prefs]Value where [Prefs]Name=districtnumber	String	4
3	School Number	The unique school number assigned by the OPI. This is the OPI School Number in PowerSchool on the Edit School page.	[S_MT_SCH_X]OPISchoolNumber	String	4
4	Calendar Number	The school calendar number. If the school has more than one calendar, this value indicates which calendar is used for this report.	Value entered at report runtime.	Number	3
5	Student’s State ID	The unique nine-digit state assigned student ID.	[Students]State_StudentNumber	String	9
6	Student’s Local ID	The locally assigned student number. This field is not required.	[Students]Student_Number	String	15
7	Last Name	The student’s legal last name. This field is not required.	[Students]Last_Name	String	50
8	First Name	The student’s legal first name. This field is not required.	[Students]First_Name	String	50
9	Service Type	The type of services received by the student in the district. Valid values are: P – Primary S – Partial N – Special Ed Services only	[S_MT_STU_Programs_X]ServiceType	String	1
10	Start Date	Student enrollment entry date in mm/dd/yyyy format	[Students]EnrtyDate	Date	10
11	Start Status	Student enrollment entry status	[Students]EnrtyCode	String	3
12	End Date	Student enrollment exit date in mm/dd/yyyy format	[Students]ExitDate	Date	10
13	End Status	Student enrollment exit status	[Students]ExitCode	String	3
14	Dropout Reason	The reason the student dropped out of school if applicable	[S_MT_STU_Academics_X]DropOut	String	2
15	Filler	Filler	N/A	N/A	1
16	Sort By Field	Used for designating how test booklets should be sorted for the student. Filler for this report	N/A	N/A	15
17	Grade Level	Student’s grade level for this enrollment	[Students]Grade_Level	String	2
18	Diploma Date	Date the student graduated in mm/dd/yyyy format	[Terms]LastDay where [Terms]IsYear = 1 or [Students]Exit date whichever is earlier if [Students]ExitCode = 400	Date	10
19	Diploma Type	The type of Diploma the student earned if the student has graduated. Valid values are: 01 – Regular Diploma 04 – Certificate of Completion	[S_MT_STU_Academics_X]DiplomaType	String	2
20	Diploma Period	The period of time the student took to earn the diploma. Valid values are: 01 – Early Graduate less than 7 Semesters 02 – Early Graduate 7 Semesters 03 – 4 Years or with IEP Allowing for Longer 04 – Graduated in More than 4 Years	[S_MT_STU_Academics_X]DiplomaPeriod	String	2
21	# Days Present	Number of days the student was present during the enrollment reporting period	Calculated from attendance data.	String	7
22	# Days Enrolled	Total numbers of days the student was enrolled during the enrollment reporting period	Calculated based on the calendar, student enrollment dates, student schedule and bell schedule	String	7
23	Year	The school calendar year. This value is reported from the last day of the full year term on the Years & Terms page.	Year portion of [Terms]LastDay where [Terms]IsYear = 1	String	4

Back to Top