Michigan Ed-Fi Data v3.1 - Student Language Instruction Program Associations

Tool Search: Ed-Fi

This association represents the Title III Language Instruction for Limited English Proficient and Immigrant Students program(s) that a student participates in or from which the Student receives services.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	EL: Report a record for each EL record with a distinct Identified date and has state mapped services that overlap the scope year. OR A new enrollment is created for a student and they have an existing EL record that qualifies. Do not send if the student's enrollment is marked as No Show or State Exclude. Do not send if the student is in a calendar marked as Exclude. Do not send if the student's enrollment is in a school marked as Exclude. Student must have at least one actively reported enrollment in the scope year to send a record. Do not send if student does not have an EL Identified Date.
Post	When a Service with a mapped Ed-Fi Code is added within the Scope Year.
Delete/Post	When data that is part of the Natural Key is changed: If the Identified Date is changed and saved. If the highest priority enrollment is changed to a different school (ex. Primary enrollment is deleted and Partial enrollment still exists).
Put	When any field that is not part of the natural key is changed, including the following: Services
Delete	When all non-excluded enrollments in all schools and year are deleted.
Delete	When all state mapped EL services or the EL record in the scoped year is deleted.
Delete	If the student's enrollment is marked as No Show or State Exclude.
Delete	If all service records are removed or found to be inactive within the Scope 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 Identified Date of the EL program record changes.
Delete	Cascading Deletes: N/A there are 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 Identified Date of the EL program record changes.

Delete

Cascading Deletes: N/A there are no dependent resources.

Scope Year Logic

This table describes scope year logic of this object.

Business Rules
The record will send to any year the EL 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

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Monitored Descriptor	Exited, First Year Monitoring Exited, Second Year Monitoring
English Language Proficiency Assessments	Assessment Type
Proficiency Descriptor	Student's Test Result Status is = Passing Student's Test Result Status is = Not Passing
Language Instruction Program Service Descriptor	EL Services
Select the Program Type Descriptor associated with this Program	Program Type Descriptor

Identity Mapping Object Key

Campus Object Type	Object Key Data Source
LEP	lepID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
lep	Post/Put/Delete	The primary table for sending data
lep	Put	End Date
lep	Put	Monitored Descriptor
test testlistitem testscore	Put	Proficiency Descriptor
lepservice	Put	English Learner Participation
lepservicetype lepservice	Put	Language Instruction Program Service Descriptor

Object Data Elements

This table describes data elements sent within the Student Language Instruction Program Association resource.

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 Identified Date of the EL record being reported.	M	Student Information> Program Participation> English Learners (EL)> Identified Date	lep.startDate
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
endDate	The month, day, and year on which the student exited the program or stopped receiving services.	Reports the Program Exit Date of the record being reported.	O	Student Information> Program Participation> EL> Program Exit Date	lep.exitdate
englishLanguageProficiencyAssessments	Results of yearly English language assessment.	This field is optional, does not report.	O
englishLearnerParticipation	An indication that an English Learner student is served by an English language instruction educational program supported with Title III of ESEA funds.	Report 'True' if the student has an EL Services record that overlaps the configured year. Reprt 'False' if the student has a service and the 'Parent Refused' checkbox is checked. Report 'False' if the student does not have a service or the service record does not overlap the configured year.	O	Student Information> Program Participation> EL> EL Services	lepservice
languageInstructionProgramServices	Indicates the service(s) being provided to the Student by the Language Instruction Program.	See Array section for details.	M		Student Information > Program Participation > EL > EL Services
reasonExitedDescriptor	This descriptor defines the reason a student exited a program.	This is optional, does not report.	O
servedOutsideRegularSession	Indicates whether the Student received services during the summer session or between sessions.	This is optional, does not report.	O
programReEntryDate	The date (month, day and year) that the student became re-engaged in a program or service. For example, an English Learner (EL), student has transitioned out of English-language acquisition programs in the last two years, but was reclassified as EL after transitioning.	If student has a prior EL record with Program Status = Exited EL, report Identified Date of current EL record. Else do not report.	C		Student Information > Program Participation > EL
programReEntryTypeDescriptor	The type of the program the student became re-engaged in after being transitioned out of in the last two year, but was reclassified after transitioing. For example, For example, an English Learner (EL) student had transitioned out of English-language acquisition programs in the last two years, but was reclassified as EL after transitioning.	If program ReEntryDate is reported, reports 'LEP ReEntry'.	C		Student Information > Program Participation > EL

Arrays

Click here to expand...

Language Instruction Program Services

Data Element Label	Business Requirement	Logic	M, C or O	Data Source GUI Path	Database Field
languageInstructionProgramServiceDescriptor	Indicates the service being provided to the student by the Language Instruction Program.	Reports the Ed-Fi Code mapped to the service the student is assigned to that overlaps the configured year. If the service is not mapped, do not report.	M	Student Information> Program Participation> EL> EL Services	lepservice
primaryIndicator	True if service is a primary service.	This is optional, does not report.	O
serviceBeginDate	First date the Student was in this option for the current school year.	Reports the Service Start Date.	O	Student Information> Program Participation> EL> EL Services> Start Date	lepservice.startDate
serviceEndDate	Last date the Student was in this option for the current school year.	Reports the Service End Date.	O	Student Information> Program Participation> EL> EL Services> End Date	lepservice.endDate

Type/Descriptor