Montana AIM Student Enrollment

Contents

Introduction

This report includes a record for each student enrolled in the school between the first day of school and the count date of the report.

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 records from the [Students] and [ReEnrollments] tables based on the school where the student was enrolled during the report date range. The report compares the student’s entry date and exit date for their school enrollments to the report dates. The student must have been enrolled in the school on the count date entered at report run time.

Report Input

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

Field	Description
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.
Snapshot 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.
Submission Type*	Choose the submission type from the pop-up menu. Valid values: June On Demand Notes: When running the June submission, the Exit Date and Exit Code are reported. When running the On Demand submission, the Exit Date and Exit Code are suppressed.

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
1	Record Type	The file type abbreviation. Set to “EN”	Always set to “EN”	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.	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	Start Comment	Entry comments entered for this this enrollment record	[Students]TransferComment	String
22	End Comment	Exit comments entered when the student exited this enrollment.	[Students]ExitComment	String
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