Montana AIM EOY Attendance

Contents

Introduction

This report pulls end-of-year attendance data and produces a tab delimited file for upload 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 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	When running at the District level: Select All Schools to run the extract for all schools not excluded from state reporting. Select Multiple Schools allows the user to use the Ctrl or SHIFT key on your keyboard to click each school you want to run the extract. When running at the School level: Select All Schools to run the extract for all schools not excluded from state reporting. Select Current School Only to run the extract just for the current school.
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.

Back to Top

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 "HD"	Fixed value	String	2
2	Date	The date the file is created in MM/DD/YYYY format.	System date	Date	10
3	Time	The time the file is 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. Always "AA”	Fixed value	String	2
2	District Number	The unique system number assigned by the OPI. Note: This is not the Legal Entity (LE) Number. This is the district number in PowerSchool. See the AIM website to identify your state-assigned District Number, Reporting Entity Number, and School Number: http://opi.mt.gov/Leadership/Data-Reporting/AIM-Achievement-in-Montana	[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: P – Primary S – Partial N – Special Ed Services only	[S_MT_STU_Programs_X]ServiceType	String	1
10	Start Date	The student's enrollment entry date in mm/dd/yyyy format.	[Students]EnrtyDate	Date	10
11	End Date	The student's enrollment exit date in mm/dd/yyyy format.	[Students]ExitDate	Date	10
12	Grade Level	The student’s grade level for this enrollment.	[Students]Grade_Level	String	2
13	# Days Present	The total number of days the student was present during the enrollment reporting period.	Calculated from attendance data	String	7
14	# Days Enrolled	The total number 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
15	ESSA # Days Absent	The total number of days the student was absent during the enrollment reporting period. If the Student has zero days absent, then the report will extract 0.	Calculated from attendance data	String	3
16	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