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)

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	Student Grade Level	The grade of the student.		N/A
5	Enroll Date	The date on which the student enrolled for the course.		N/A
6	StudentID	The student’s state assigned ID number.	[Students]State_StudentNumber	N/A
7	LastName	The student’s last name.	[Students]Last_Name	N/A
8	FirstName	The student’s first name.	[Students]First_Name	N/A
9	MiddleName	The student’s middle name.	[Students]Midddle_Name	N/A
10	Subject	The course subject description based on a list of standardized options.	[S_AK_CRS_X]Subject	N/A
11	CourseTitle	The locally defined course title.	[Courses]Course_Name	N/A
12	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
13	CourseSection	The value is taken from the Course Section field under the Migrant Course History Information on the courses page if specified. Valid values: Full Yr (01) Section A (02) Section B (03) If no value is specified for the Course Section field on the courses page, the report will derive the value based on Term Type and, where applicable, the reporting time parameter (RTP). If the value of the Term Type Override field on the section page is Full Year, then the reporting time parameter Submission Period will be considered. The value reported will be: 02 for Fall 03 for Spring If the value of the Term Type Override field on the section page is not Full Year, then the reporting time parameter Submission Period will not be considered. The value reported will be Full Yr (01). If the value of the Term Type Override field on the section page is not selected, then the value reported will be Blank.	[S_AK_CRS_X]Course_Section	N/A
14	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
15	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
16	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
17	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
18	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
19	Notes	For notes included in the student’s record.	[S_AK_STU_X]Record_Notes	N/A