Tool Search: Migrant_Student
The Migrant Student Template reports one record per enrolled student per Migrant Program Participation record that is active at least one day on or between the reporting range selected on the extract editor.
Migrant Student Template Editor
Report Logic
- Reports one record per reportable student's Migrant Program Participation record that is active at least one day on or between the reporting range selected on the extract editor.
- Migrant Participation is considered Active starting on the Last Qualifying Arrival Date up to and including the Eligibility Expiration Date.
- To report, student MUST have a Student State ID that is not null.
- To report, student's Migrant Program Participation MUST have an MSIX ID that is not null.
Report Editor
| Field | Description |
|---|---|
| Submission Schedule | The collection period for the extract. |
| Start Date | The first day in the date range from which data will report. |
| End Date | The last day in the date range from which data will report. |
| Which students would you like to include in the report? | This option allows you to narrow your search results by using one of the following options.
|
Format | The format in which the report will generate. Options include HTML or Comma Separated (CSV). |
| Select Calendars | The calendar(s) from which data is pulled for the report. |
Generate Report/ | Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
Report Layout
| Element Name | Logic | Type, Format and Length | Campus Database | Campus Location |
|---|---|---|---|---|
| District Code | The state district number. | Alphanumeric, 20 characters | District.number | System Administration > Resources > District Information > State District Number |
| School Year Date | The end year of the Year selected on the Campus tool bar plus the date 06-30. For example, 2018-06-30. | Date field, 10 characters YYYY-MM-DD | N/A | N/A |
| Student ID | Reports the state-assigned identifier for the student. | Numeric, 9 digits | Person.stateID | Census > People > Demographics > State ID |
| Reporting Date | The reporting date of the collection.This element reports the end year plus a specific value for the selected Submission Schedule. Valid Values
| Date field, 10 characters YYYY-MM-DD | N/A | N/A |
| MSIX Student ID | Reports the MSIX ID from the student's Migrant Program Participation record. | Numeric, 12 digits | Migrant.msixID | Student Information > Program Participation > Migrant > Migrant Editor > Student Migrant Detail > MSIX ID |
| Last Qualifying Arrival Date | Reports the Last Qualifying Arrival Date from the student's Migrant Program Participation record. | Date field, 10 characters YYYY-MM-DD | Migrant.lastQualifyingArrivalDate | Student Information > Program Participation > Migrant > Migrant Editor > Student Migrant Detail > Last Qualifying Arrival Date |
| Filler 7 | N/A | N/A | N/A | N/A |
| Qualifying Move From State Code | Reports the "From State" from the student's Migrant Program Participation record. | Alphanumeric, 3 characters | Migrant.fromState | Student Information > Program Participation > Migrant > Migrant Editor > Student Migrant Detail |
| Filler 9 | N/A | N/A | N/A | N/A |
| Filler 10 | N/A | N/A | N/A | N/A |
| Qualifying Move To State Code | Reports the "To State" from the student's Migrant Program Participation record. | Alphanumeric, 3 characters | Migrant.toState | Student Information > Program Participation > Migrant > Migrant Editor > Student Migrant Detail |
| Eligibility Expiration Date | Reports the Eligibility Expiration Date from the student's Migrant Program Participation record. | Date field, 10 characters YYYY-MM-DD | Migrant.eligibilityExpirationDate | Student Information > Program Participation > Migrant > Migrant Editor > Student Migrant Detail |
| Filler 13 | N/A | N/A | N/A | N/A |
| Migrant COE Status Indicator | Reports the Migrant COE Status Indicator is marked on the student's Migrant Program Participation record. | Alphanumeric, 1 character Y or N | Migrant.migrantCOEStatusIndicator | Student Information > Program Participation > Migrant > Migrant Editor > Student Migrant Detail |
| Last Qualifying Move Date | Reports the Last Qualifying Move Date from the student's Migrant Program Participation record. | Date field, 10 characters YYYY-MM-DD | Migrant.lastQualifyingMoveDate | Student Information > Program Participation > Migrant > Migrant Editor > Student Migrant Detail |
