Migrant Education Parent Form | PowerSchool SIS Compliance

Introduction

Use this report to identify potential migrants and their eligibility to receive supplemental services from the State Migrant Program. The details of each student are printed on a separate page. The forms can be sent to the district's migrant liaison staff for referral to the State of Iowa Migrant Education office.

Output File Name Format:

[DistrictNum][CampusID]_MigrantInfo[Timestamp].csv or.pdf

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

Students are reported based on the following criteria:

The "Date Submitted" value on the Migrant Questionnaire must fall within the report's date range (S_IA_STU_X.Mig_Submit_Date).
The family's arrival date must be within the three years of the current system date (S_IA_STU_X.Mig_Arrive_Date is within the last 3 years).
The questionnaire indicates that the family moved in order to work (S_IA_STU_X.Mig_Moved_to_Work set to Y) and a value is entered for one or more types of employment.

Report Input

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

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meets the 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. The All Schools option is only available when running the report from the District Office.
Select Students	Choose one of the following: The Selected [x] 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.
Start Date	Enter the start date for the report.
End Date	Enter the end date for the report's date range.
Completion Date	Enter the date to display as the "Date completed" on the form.
Output Format	Select PDF or CSV as the output file format.

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Length
1	District Name	The district name.	prefs.value	NA
2	School ID	The school number assigned by the district.	schools.school_number	4
3	School Name	The student's school of enrollment.	Schools.Name	20
4	Student ID	The locally assigned student number.	Students.Student_Number	20
5	First Name	The first name of the student entered on the Demographics page.	Students.First_Name	60
6	Middle Name	The middle name of the student entered on the Demographics page.	Students.Middle_Name	60
7	Last Name	The last name of the student entered on the Demographics page.	Students.Last_Name	60
8	Grade Level	The student’s grade level entered on the Transfer Info page.	Students.Grade_Level	2
9	Date Submitted	The submission date entered in the Migrant tab.	s_ia_stu_x.Mig_Submit_Date	10
10	Date Completed	The completion date entered to run the report.	Calculated based on the report parameters	10
11	Parent/Guardian First Name	The last name of the parent or guardian.	person.first_name	30
12	Parent/Guardian Middle Name	The middle name of the parent or guardian.	person.middle_name	30
13	Parent/Guardian Last Name	The first name of the parent or guardian.	person.last_name	30
14	Parent/Guardian Suffix	The suffix of the parent or guardian.	person.suffixcodesetid
15	Relationship	The student's relationship with the primary contact (parent or guardian).	studentcontactdetail.relationshiptypecodesetid	30
16	Address - Street	The street address of the student.	personaddress.substr(street, linetwo,1,40) first 40 characters for the combination of street and linetwo columns students.mailing_street If the contact's address is blank, reports the student address by default	30
17	Address - City	The student's city of residence.	personaddress.city students.mailing_city If the contact's address is blank, reports the student address by default	20
18	Address - State	The student's state of residence.	personaddress.statescodesetid students.mailing_state If the contact's address is blank, reports the student address by default	2
19	Address - Zip	The student's zip code of residence.	personaddress.postalcode students.maling_zip If the contact's address is blank, reports the student address by default	5
20	Phone Number	The student's home phone number.	phonenumber students.home_phone	12
21	Migrant Moved To Work	This field should have Yes (Y) for the student to be selected.	s_ia_stu_x.Mig_Moved_to_Work	1
22	Migrant Arrival Date	The date the student or family arrived in the city or town.	s_ia_stu_x.Mig_Arrive_Date	10
23	Migrant Employment	Select the parent's or guardian's area of work. Valid options: (AG) Agriculture; planting/picking fruits and vegetables (DP) Dairy/Poultry/Egg/Livestocks (FS) Fishing or fish farms (MT)Meatpacking/Meat processing (PL) Planting, Growing, Detasseling or Farm labor (PR) Processing/packing agricultural products (OT) Other	s_ia_stu_x.Mig_Employment, other_employ If Mig_Employment = OT(Other), the Other Employment details are included	NA