Migrant Course History Report

Introduction

This report contains course and grade data for migrant students in grades 9 through 12. This report is submitted twice a year, once in January and again in June. This is a district level report.

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.

Selection Criteria

Student must be in grades 9-12.
Student must not be excluded from state reporting.
Student must have been enrolled at some point during the report date range.
Student must be flagged as Migrant (Migrant = Y)
The student must not have opted out of the AMYA report ([S_AK_STU_X]OptOutAMYA cannot equal 1)

Note: The student SHSEQ numbers must be entered for each necessary student prior to running this report.

Report Input

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

Field	Description
School(s) to report	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Students to Include	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 that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Start Date	Enter the start date for the reporting period.
End Date	Enter the end date for the reporting period.
Submission Period	Select the appropriate submission period: Fall Spring
Store Codes	Select at least one store code to include on the report. To select multiple store codes, hold down the SHIFT or the CTRL key and click the desired codes.

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.

File 1

Item #	Data Element	Description	[Table]FieldName	Length
1	SESEQ	A state assigned student identification number. Note: This number may change every semester and must be entered for each applicable student.	[S_AK_STU_X]SHSEQ	N/A
2	DistrictCode	The state assigned district number.	[Prefs]Value where [Prefs]Name = districtnumber	N/A
3	Facility	The alternate school number if one exists.	[CC]SchoolID [Schools]School_Name	N/A
4	StudentID	The student’s state assigned ID number.	[Students]State_StudentNumber	N/A
5	LastName	The student’s last name.	[Students]Last_Name	N/A
6	FirstName	The student’s first name.	[Students]First_Name	N/A
7	MiddleName	The student’s middle name.	[Students]Midddle_Name	N/A
8	Subject	The course subject description based on a list of standardized options.	[S_AK_CRS_X]Subject	N/A
9	CourseTitle	The locally defined course title.	[Courses]Course_Name	N/A
10	CourseType	The type of course the student is taking. Note: This is derived based on the selected reporting period.	[S_AK_CRS_X]Course_Type	N/A
11	CourseSection	The prescribed duration of course taken.	Derived based on the user selected reporting period: Fall – 1^st Semester Spring – 2^nd Semester	N/A
12	TermTypeCode	The prescribed span of time that a course is provided and in which the students are under the direction and guidance of teachers and/or an educational institution.	[S_AK_CRS_X]TermType_Override [S_AK_SEC_X]TermType_Override [Sections]TermID	N/A
13	ClockHours	For courses that were NOT been completed (or credit granted), the number of clock hours to date the student completed. Note: This is only reported for courses that were not completed or classes where no credit was awarded. If the student completed the course, regardless of credit being awarded, this will be blank.	Derived using the following: [CC]DateEnrolled [CC]DateLeft [CC]TermID [Calendar_Day]Date [Calendar_Day]Cycle_Day_ID [Calendar_Day]Bell_Schedule_ID [Calendar_Day]InSession [Calendar_Day]SchoolID [Cycle_Day]ID [Cycle_Day]Letter [Bell_Schedule_Items]Bell_Schedule_ID [Bell_Schedule_Items]Period_ID [Bell_Schedule_Items]Minutes_Attended [Section_Meeting]Cycle_Day_Letter [Section_Meeting]Period_Number [Section_Meeting]YearID [Section_Meeting]SchoolID	N/A
14	GradeToDate	For courses that were NOT been completed (or credit granted), a numerical grade (percentage) of student performance for the grade-to-date that the student has completed at the time of withdrawal. Note: This is only report for courses that were not completed or classes where no credit was awarded. If the student completed the course, regardless of credit being awarded, this will be blank. Example: .25 = 25%	[PGFinalGrades]Percent	N/A
15	CreditsGranted	The credits granted to the student in Carnegie Units for completing a given course, or a section of a course. Note: This will be blank if the student did not complete the course, or if no credit was awarded.	[Courses]Credit_Hours	N/A
16	FinalSubjectGrade	For courses that have had credit granted, a final indicator of student performance in a class at the time of withdrawal as submitted by the instructor. Note: This will be blank if the student did not complete the course, or if no credit was awarded.	[StoredGrades]Grade	N/A
17	Notes	For notes included in the student’s record.	[S_AK_STU_X]Record_Notes	N/A