Ed-Fi Data v3.X - Student Migrant Education Program Associations

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

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. Do not send a record if enrollment is in a calendar marked as Exclude. Do not send a record if enrollment is in a school marked as Exclude. Do not send a record if enrollment is marked as No Show. Use the Last Qualifying Arrival Date for Start Date and the Eligibility Expiration Date for the End Date to determine overlapping logic.
Delete/Post	When any field part of the natural key is changed: Begin Date
Put	When any field not part of the natural key is changed. End Date Last Qualifying Move Priority For Services Qualifying Arrival Date State Residency Date US Initial Entry US Initial School Entry US Most Recent Entry
Delete	All enrollments are deleted for a student.
Delete	If the student's enrollment is marked as No Show.
Delete	If the Migrant record is deleted.
Delete	If the Last Qualifying Arrival Date or Eligibility Expiration Date on the Migrant record are 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	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Resync	If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
Resync	If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
Resync	If a mapping is changed in Resource Preferences, a resync will need 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: LEA Reference - District Numbers cannot change after data has been sent. If a district number changes, we would expect an Ed-Fi error and this change would not be supported. If an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers. If the Program Name or Program Type Descriptor mapping changes and a resync is completed. If the Start Date of the Migrant program record changes.
Delete	Cascading Deletes: N/A - no dependent resources.

Action

Trigger

Post/Delete

Natural Key changes:

LEA Reference - District Numbers cannot change after data has been sent. If a district number changes, we would expect an Ed-Fi error and this change would not be supported.
If an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers.
If the Program Name or Program Type Descriptor mapping changes and a resync is completed.
If the Start Date of the Migrant program record changes.

Delete

Cascading Deletes: N/A - no dependent resources.

Scope Year Logic

This table describes scope year logic of this object.

Logic
The record will send to any year the Migrant record overlaps with if the student has an enrollment in that year.
Data will only send 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	Business Requirement	Logic	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
beginDate	The month, day, and year on which the Student first received services.	Reports the Services Start Date from the Migrant record being reported.	M	Student Information> Program Participation> Services Start Date	migrant.servicesstartdate
educationOrganizationReference	The education organization where the student is participating in or receiving the program services.	Report the State District Number.	M	System Administration> Resources> District Information> State District Number	district.number
programReference	A reference to the Program Resource.	Reports the Natural Key for the Program.	M
studentReference	A unique alpha-numeric code assigned to a student.	Reports the Natural Key for the Student resource.	M
continuationOfServicesReasonDescriptor	The “continuation of services” provision found in Section 1304(e) of the statute provides that (1) a child who ceases to be a migratory child during a school term shall be eligible for services until the end of such term; (2) a child who is no longer a migratory child may continue to receive services for one additional school year, but only if comparable services are not available through other programs; and (3) secondary school students who were eligible for services in secondary school may continue to be served through credit accrual programs until graduation. Only students who received services at any time during their 36 month eligibility period may continue to receive services (not necessarily the same service).	This is optional, does not report.	O
eligibilityExpirationDate	The Eligibility Expiration Date is used to determine end of eligibility and to account for a child’s eligibility expiring earlier than 36 months from the child’s QAD. A child’s eligibility would end earlier than 36 months from the child’s QAD, if the child is no longer entitled to a free public education (e.g., graduated with a high school diploma, obtained a high school equivalency diploma (HSED), or for other reasons as determined by States’ requirements), or if the child passes away.	This is optional, does not report.	O
endDate	The month, day, and year on which the student exited the program or stopped receiving services.	Reports the Eligibility Expiration Date.	O	Student Information> Program Participation> Migrant> Eligibility Expiration Date	migrant.eligibilityExpirationDate
lastQualifyingMove	Date the last qualifying move occurred; used to compute MEP status.	Reports the Last Qualifying Move Date.	M	Student Information> Program Participation> Migrant> Last Qualifying Move Date	migrant.lastQualifyingMoveDate
migrantEducationProgramServices	Indicates the Service(s) being provided to the Student by the Migrant Education Program.	This is optional, does not report.	O
priorityForServices	Report 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 if Priority for Service is checked. Else, report False.	M	Student Information> Program Participation> Migrant> Priority for Service	migrant.priorityForService
qualifyingArrivalDate	The Qualifying Arrival Date (QAD) is the date the child joins the worker who has already moved, or the date when the worker joins the child who has already moved. The QAD is the date that the child’s eligibility for the MEP begins. The QAD is not affected by subsequent non-qualifying moves.	Reports the Last Qualifying Arrival Date.	O	Student Information> Program Participation> Migrant> Last Qualifying Arrival Date	migrant.lastQualifyingArrivalDate
reasonExitedDescriptor	The reason the child left the Program within a school or district.	This is optional, does not report.	O
servedOutsideOfRegularSession	Indicates whether the Student received services during the summer session or between sessions.	This is optional, does not report.	O
stateResidencyDate	The verified State residency for the student.	Reports the Date Entered State School.	O	Census> People> Demographics> Date Entered State School	identity.dateEnteredState
usInitialEntry	The month, day, and year on which the Student first entered the U.S.	Reports the Date Entered US.	O	Census> People> Demographics> Date Entered US	identity.dateEnteredUS
usInitialSchoolEntry	The month, day, and year on which the Student first entered a U.S. school.	Reports the Date Entered US School.	O	Census> People> Demographics> Date Entered US School	identity.dateEnteredUSSchool
usMostRecentEntry	The month, day, and year of the Student’s most recent entry into the U.S.	Reports the Last Qualifying Arrival Date.	O	Student Information> Program Participation> Migrant> Last Qualifying Arrival Date	migrant.lastQualifyingArrivalDate

Arrays

Migrant Education Program Services

Data Element Label	Business Requirement	M, C or O
migrantEducationProgramServiceDescriptor	Indicates the Service being provided to the student by the Migrant Education Program.	M
primaryIndicator	Field indicating the participation in the yearly English language assessment.	O
serviceBeginDate	First date the Student was in this option for the current school year.	O
serviceEndDate	Last date the Student was in this option for the current school year.	O

Type/Descriptors

Continuation of Services Reason Descriptor

Code Value	Description	Namespace	Short Description
Ceased to be migratory during previous term	Ceased to be migratory during previous school term and no comparable services are available	uri://ed-fi.org/ContinuationofServicesReasonDescriptor	Ceased to be migratory in previous term - comparable services not available.
Ceased to be migratory during school term	Ceased to be migratory during school term	uri://ed-fi.org/ContinuationofServicesReasonDescriptor	Ceased to be migratory during school term.
Previously migratory secondary student	Previously migratory secondary student continuing secondary school credit accrual	uri://ed-fi.org/ContinuationofServicesReasonDescriptor	Previously migratory secondary student continuing credit accrual.