Montana AIM Teacher Class - Roster

Introduction

This report extracts data from Courses/Sections into a Teacher Class Roster Export for State Reporting. The report selects courses/sections that have at least one student enrolled in active courses in the current school year.

Selection Criteria

The report selects sections that have at least one student enrolled in active courses in current school year.

Includes all sections that have students in active courses for the selected year.
Includes Course, Section, Student, and School NOT excluded from state reporting.
Includes students enrolled in active courses
Includes remote classes
Includes dropped classes
Does not include records for remote class enrollments having school excluded from reporting.

Report Input

Navigation: Start Page, Reports, Reports (State Reports), Teacher Class - Roster.

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.
Calendar Number(###)	Enter a three digit calendar number. Note: If this field is blank, the student track will be used.

Report Output

Data Element	Description	Table[FieldName]	Data Type	Length
File Type	Indicates the file type (Hardcoded)	RU
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.	[Prefs]Value where [Prefs]Name=districtnumber	Alphanumeric	40
School Number	The unique school number assigned by the OPI. This is the OPI School Number in PowerSchool on the Edit School page.	[Schools]School_Number	Numeric	10
Calendar Number	The school calendar number. If the school has more than one calendar, this value indicates which calendar is used for this report. Student Track Code Mapping: Blank or A = 1 B = 2 C = 3 D = 4 E = 5 F = 6	Calendar UI Parameter If not null Else [Students]Track	Numeric	3
Course Number	The unique course number.	[Courses]Course_Number	Alphanumeric	11
Section Number	The section number.	[Sections]Section_Number	Numeric	20
Student’s State ID	The unique student state ID.	[Student]State_StudentNumber	String	13
Student Last Name	The student’s last name.	[Student]Last_Name	String	50
Student First Name	The student’s first name.	[Student]First_Name	String	50
Start Date	The student’s course enrollment date.	[CC]DateEnrolled	mm/dd/yyyy	10
End Date	The student’s course exit date.	[CC]DateLeft	mm/dd/yyyy	10
Year	Selected year.	Selected year, if it is 2024-2025, then 2025	Numeric	4