Migrant Student Extract

Introduction

This template is used to track detailed information specific to Migrant Students. This is a district level report that will have 1 record per active student as of the snapshot date.

Selection Criteria

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

Student Selection

Students are reported based on the following criteria:

The student must be enrolled on the snapshot date.
The student must have a Title IC Programs Fact record that is active on the user defined snapshot date.
The student must not be excluded from state reporting.

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 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.
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.
Reporting Period	Select the desired reporting period.
Snapshot Date	Enter the snapshot date you wish to run the report for.

Back to Top

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	Begin / End Position
1	DistrictCode	The district’s 3 digit PED defined code.	[Prefs]Value Where [Prefs]Name = DistrictNumber	N/A
2	SchoolYearDate	The reporting year. Valid Value: YYYY-06-30	[Terms]LastDay	N/A
3	StudentID	The student's state ID number.	[Students]State_StudentNumber	N/A
4	ReportDate	The date representative of the user selected reporting period. Valid values: YYYY-10-01 = 40D YYYY-12-15 = 80D YYYY-03-01 = 120D YYYY-06-01 = EOY	N/A	N/A
5	MSIXID	The student’s MSIX ID from the MSIX system.	[S_NM_STU_X]MSIXID
6	LastQualArrDate	The date that is on the Certificate of Eligibility (COE). If the COE is in process this should be the date the student arrived in the district.	[S_NM_STU_X]ArrivalDate	N/A
7	Not Collected	Not Collected	N/A	N/A
8	QualFromState	The postal abbreviation of the state the student moved from.	[S_NM_STU_X]MoveFromState	N/A
9	Not Collected	Not Collected	N/A	N/A
10	Not Collected	Not Collected	N/A	N/A
11	QualToState	The postal abbreviation of the state the student moved to.	[S_NM_STU_X]MoveToState	N/A
12	EligExpDate	The date that is on the Certificate of Eligibility (COE). If the COE is in process This should be a date that is 36 months from the Arrival date.	[S_NM_STU_X]EligExpDate	N/A
13	Not Collected	Not Collected	N/A	N/A
14	COEStatusInd	Indicates the approval status of the Certificate of Eligibility (COE). Valid Values: Y or N	[S_NM_STU_X]COEStatus	N/A
15	LastQualMoveDate	The Last Qualifying Move Date as Approved in the Certificate of Eligibility (COE). If the COE is in process this should be the date the student arrived in the district.	[S_NM_STU_X]LastMoveDate	N/A

Back to Top