This association represents the migrant education program(s) that a student participates in or receives services from. The association is an extension of the StudentProgramAssociation with added elements particular to migrant education programs.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a student has a Migrant record that overlaps the configured year and has an enrollment in the configured year.
|
| Delete/Post | When any field part of the natural key is changed:
|
| Put | When any field not part of the natural key is changed.
|
| Delete | All enrollments are deleted for a student. |
| Delete | When the student's enrollment is marked as No Show. |
| Delete | When the Migrant record is deleted. |
| Delete | When the Last Qualifying Arrival Date on the Migrant record is updated so the record no longer overlaps the configured year. |
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.
| Action | Trigger |
|---|---|
| None | When a resource is toggled to off after data has sent, all sent data remains in the ODS but no new data sends. |
| Resync | When a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table. |
| Resync | When a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS. |
| Resync | When a mapping is changed in Resource Preferences, a resync needs to be done to reflect the changes. |
Natural Key Changes, Cascading Updates, and Deletes Logic
This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.
| Action | Trigger |
|---|---|
| Post/Delete | Natural Key changes:
|
| Delete | Cascading Deletes: N/A - no dependent resources. |
Scope Year Logic
This table describes scope year logic of this object.
| Logic |
|---|
The record sends to any year the Migrant record overlaps when the student has an enrollment in that year. |
| Data only sends for the years that have valid configuration. |
Resource Preferences
Data Element Label | Mapping Needed |
|---|---|
| Select the Program Type Descriptor associated with this Program | Program Type Descriptor |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| migrant | Post/Put/Delete | The primary table for sending data for this resource. |
| identity | Put | Reports US Initial Entry, US Initial School of Entry, State Residency Date. |
Error Log
Error | Possible Causes/How to Fix |
|---|---|
| Error code return from Ed-Fi. 400: [message:Validation of 'StudentMigrantEducationProgramAssociation' failed. LastQualifyingMove : '1/1/0001 12:00:00 AM' must be within SQL datetime range ('1/1/1753 12:00:00 AM' to '12/31/9999 11:59:59 PM') LastQualifyingMove is required. ]. | LastQualifyingMove is required. Add date to Last Qualifying Move Date field on Migrant record. |
| Error code return from Ed-Fi. 400: [message:Validation of 'StudentMigrantEducationProgramAssociation' failed. BeginDate is required. ]. | BeginDate is required. Add date to servicesStartDate field on Migrant record. |
Object Data Elements
Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.
| Data Element Label | Description | M, C, O | Database Location |
|---|---|---|---|
| id | The unique identifier of the resource | M | |
| beginDate | The month, day, and year on which the Student first received services. Reports the start date of the enrollment. | M | Enrollments > Start Date migrant.servicesstartdate |
| educationOrganizationReference | The education organization where the student is participating in or receiving the program services. Reports the fields that are part of the Natural Key for the Local Education Agency resource where the educationOrganizationId is the State District Number. | M | District Information> State District Number district.number |
| programReference | A reference to the Program Resource. Reports the fields that are part of the Natural Key for the Programs resource.
| M | Enrollments > State Reporting Fields > Migrant Indicator |
| studentReference | A unique alpha-numeric code assigned to a student. Reports the fields that are part of the Natural Key for the Students resource where the studentUniqueId is the Student State ID. | M | |
| lastQualifyingMove | Date the last qualifying move occurred; used to compute MEP status. Pass date of when the last qualifying move occurred. | M | Program Participation > Migrant > Last Qualifying Move Date migrant.lastQualifyingMoveDate |
| priorityForServices | Reports migratory children who are classified as having “priority for services” because they are failing, or most at risk of failing to meet the State’s challenging State academic content standards and challenging State student academic achievement standards, and their education has been interrupted during the regular school year. Reports True when the Priority for Service is marked. Otherwise, reports as False. | M | Program Participation > Migrant > Priority for Service migrant.priorityForService |
| programParticipationStatuses | An unordered collection of generalStudentProgramAssociation ProgramParticipationStatuses. The status of the student's program participation. See the Arrays section. | M | |
| migrantDescriptor | The migrant status of the student. Reports the Migrant Indicator. | O | Program Participation > Migrant > Migrant Indicator |
Arrays
Type/Descriptors
