Student Language Instruction Program Associations (Missouri v3.6)
Last Modified on 07/28/2025 8:52 am CDT
In This Article
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
The student must have a Student School Association record in the configured year and meet the following EL record criteria:
The student has a EL Program Status of EL.
The student has a EL Program Status of Exited EL and the First Year Monitoring or Second Year Monitoring dates overlap a configured year. Uses today's date to determine status.
Uses the Program Exit date as the start date and the First Year Monitoring date as the end date to determine the student's status.
Uses the day after the First Year Monitoring date as the start date and the Second Year Monitoring date as the end date to determine the student's status.
Does not send a record when enrollment is in a calendar marked as Exclude.
Does not send a record when enrollment is in a school marked as Exclude.
Does not send a record when enrollment is marked as No Show.
Delete/Post
When any field part of the natural key is changed:
Identified Date
District Number
Put
When any field not part of the natural key is changed:
languageInstructionProgramServices
Delete
All enrollments are deleted for a student.
Delete
When the student's enrollment is marked as No Show.
Delete
When the student's EL record is no longer eligible to report based on Identified Date, Exit Date or EL Status.
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:
LEA Reference - District Numbers cannot change after data has been sent. When a district number changes, an Ed-Fi error occurs and is not be supported.
When an Ed-Fi ID changes, a delete/post occurs with the cascading deletes from the Ed-Fi ID Change triggers.
When the Program Name or Program Type Descriptor mapping changes and a resync is completed.
When the Identified Date of the EL program record changes.
Delete
There are no dependent resources.
Scope Year Logic
This table describes scope year logic of this object.
Business Rules
The record sends to any year the EL record overlaps with when the student has an enrollment in that year.
Data only sends 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
M, C or O
Data Source GUI Path
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
Program Participation > English Learners (EL) > Identified Date
lep.startDate
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
System Administration > Resources > 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.
educationOrganizationId = Reporting District Code
programName = Language Instruction
programTypeDescriptor = Language Instruction
M
Program Participation> EL > EL Services
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
languageInstructionProgramServices
Indicates the service(s) being provided to the Student by the Language Instruction Program.
An unordered collection of studentLanguageInstructionProgramAssociation englishLanguageProficiencyAssessments. Results of yearly English language assessment.
Status of Title III funding for an immigrant student.
When State Reporting Fields > Immigrant field is set to Y, reports selected code in State Reporting Fields > Title III Immigrant drop list. Otherwise, reports as NE.
O
Enrollments > State Reporting Fields > Immigrant
Enrollments > State Reporting Fields > Title III Immigrant
titleIIILEPFundingDescriptor
Status of Title III funding for an LEP student.
When Student Information > Program Participation > EL > EL = RCV, reports code from State Reporting Fields > Title III EL. Otherwise, reports as NE.
O
Program Participation > EL > EL
Enrollment s> State Reporting Fields > Title III EL
Arrays
Language Instruction Program Services
Data Element Label
Description
M, C, or O
Database Location
languageInstructionProgramServiceDescriptor
Indicates the service being provided to the student by the Language Instruction Program.
When at least one LEP record exists for a student, the following logic is used to determine which LEP record to use:
Select the LEP record where the Second Year Monitoring Date is greater than or equal to the end date of the current year; OR whenno such record exists, select the LEP record where the Second Year Monitoring Date is NULL.
Use the selected EL record to determine the code to return as follows:
When the Program Status is EL, reports as RCV.
When the current date is after the exit date and up to or on the First Year Monitoring date, reports as MY1.
When the current date is after the First Year Monitoring date and up to or on the Second Year Monitoring date, reports as MY2.
When the current date is after the Second Year Monitoring date and up to or on the Third Year Monitoring date, reports as AY3.
When the current date is after the Third Year Monitoring date and up to or on the Fourth Year Monitoring date, reports as AY4.
Otherwise, reports as NLP.
C
Student Information > Program Participation > EL > EL
lepService
English Language Proficiency Assessments
Data Element Label
Description
M, C, or O
Database Location
monitoredDescriptor
Student is monitored on content achievement who are no longer receiving services.
When languageInstructionProgramServiceDescriptor is MY2, AY3, or AY4; reports the mapped state code from EL Exit Reason from the reporting year as follows:
IFA = IFA
STG = STG
TCI = TCI
When languageInstructionProgramServiceDescriptor reports as MY1 or NLP; does not report.
O
Student Information > Program Participation > EL > EL Exit
participationDescriptor
Field indicating the participation in the yearly English language assessment.
When languageInstructionProgramServiceDescriptor reports as RCV; reports NOE. Otherwise, reports the mapped EL Exit Reason from the reporting year as follows:
NOE = NOE
POR = POR
ACS = ACS
O
Student Information > Program Participation > EL > EL Exit
