Student Language Instruction Program Associations (Kansas v3.6)
Last Modified on 08/25/2025 8:47 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. Use today's date to determine their status.
Use the Program Exit date as the start date and the First Year Monitoring date as the end date to determine the student's status.
Use 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 the student's Second Year Monitoring date is before the configured year.
Does not send a record when the enrollment is in a calendar marked as Exclude.
Does not send a record when the enrollment is in a school marked as Exclude.
Does not send a record when the enrollment is marked as No Show or State Exclude.
Delete/Post
When any field part of the natural key is changed:
Identified Date
Put
When any field not part of the natural key is changed:
End Date
englishLanguageProficiencyAssessments
languageInstructionProgramServices
Delete
All enrollments are deleted for a student.
Delete
When the student's enrollment is marked as No Show or State Exclude.
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 is sent.
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 is needed 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 is expected and this change would 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
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 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 Requirements and Rules
Mandatory, Conditional or Optional
Location
beginDate
The month, day, and year on which the Student first received services.
Reports the latest of the Identified Date of the EL record being reported and the student's Enrollment Start Date in the configuration year.
When multiple enrollments exist for the student in the current configuration year, reports the Start Date of the Primary enrollment record.
M
English Learners (EL) > Identified Date
lep.startDate
educationOrganizationReference
The education organization where the student is participating in or receiving the program services.
Report the Ed-Fi School ID of the Accountability School for the educationOrganizationId
Logic for determining Accountability School:
Reports from Enrollment Override location.
When the Override location is NULL, report State School Number.
M
Enrollments > State Reporting Fields > AYP Override 1
EnrollmentKS.schoolAYP1
School Information > School > Ed-Fi School ID
School.entityID
programReference
A reference to the Program Resource.
Report the Natural Key from the Programs resource.
educationOrganizationId = Ed Fi School ID of the Accountability School
Reports from Enrollment Override location.
When the Override location is NULL, reports the State School Number.
programName = English as a Second Language (ESL)
programTypeDescriptor = English as a Second Language (ESL)
M
Enrollments > State Reporting Fields > AYP Override 1
EnrollmentKS.schoolAYP1
School Information > School > Ed-Fi School ID
School.entityID
English Learners (EL)
studentReference
A unique alpha-numeric code assigned to a student.
Reports the Natural Key for the Student resource
studentUniqueID reports from the Student State ID field.
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.
C
EL > Program Exit Date
lep.exitdate
englishLanguageProficiencyAssessments
Results of yearly English language assessment.
See the Array section for details.
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.
Reports True when the student has an EL Services record that overlaps the configured year.
Reports False when the student has a service and the Parent Declined checkbox is marked.
Reports False when the student does not have a service or the service record does not overlap the configured year.
O
EL > EL Services
lepservice.name
EL > Parent Declined
languageInstructionProgramServices
Indicates the service(s) being provided to the Student by the Language Instruction Program.
See the Array section for details.
O
reasonExitedDescriptor
This descriptor defines the reason a student exited a program.
This is optional and does not report.
O
servedOutsideRegularSession
Indicates whether the Student received services during the summer session or between sessions.
This is optional and does not report.
O
dosage
The duration of time in minutes for which the student was assigned to participate in the program.
When ESOL/Bilingual Program Participation Code = 1, 2, 3, or 7.
Reportsthe value from the ESOL Contact Minutes Per Day.
Otherwise, does not report.
O
Student Information >Program Participation > English Learners (EL)> EL Services > ESOL Contact Minutes Per Day
LEpSErvice.SerivceMinutes
usInitialSchoolEntryDate
First Entry Date into a School in the United States
Reports the entered date.
O
Demographics > Date Entered US School
Identity.dateEnteredUSSchool
fundingSourceDescriptor
The source of funding for ESOL/bilingual program in which the student participates in.
Reports the Ed-Fi Code mapped to the service the student is assigned to that overlaps the configured year.
When the service is not mapped, does not report.
O
English Learners (EL)> EL Services > Service Type
languageInstructionProgramTypeDescriptor
The language instruction program type the student participates in.
O
Arrays
English Language Proficiency Assessments
Data Element Label
Business Requirements and Rules
Mandatory, Conditional or Optional
Location
monitoredDescriptor
Student is monitored on content achievement who are no longer receiving services.
Reports the following when the student has an LEP Program Status of Exited LEP and the LEP Exit Date falls in the monitoring period and the Monitoring option is mapped in the preferences:
Reports the code mapped to First Year Monitoring when today's date is on or between the EL Exit Date and the First Year Monitoring date.
Reports the code mapped to Second Year Monitoring when today's date is after the First Year Monitoring date and on or before the Second Year Monitoring date.
Otherwise, does not report.
O
EL > First Year Monitoring, Second Year Monitoring
lep.firstyearMonitoring
lep.secondYearMonitoring
participationDescriptor
Field indicating the participation in the yearly English language assessment.
Reports the mapped descriptor from the Reason Code selected on the student's assessment record.
Uses the assessment logic in the Proficiency Descriptor field logic below to determine which test result to use.
O
Assessments > Reason Code
testscore.reasonCode
proficiencyDescriptor
The proficiency level for the yearly English language assessment.
Reports the mapped descriptor based on the mapped results on the student's assessment record.
Looks at the assessments that have a type mapped in the English Language Proficiency Assessmentsmapping.
The student's assessment date must overlap the configured year.
The student must have a result on the test.
When the result is blank or the student does not have an eligible test, reports blank.
When the student has more than one eligible test that overlaps the configured year, uses the test with the most recent test date.
When the dates are the same, the last test to send displays in the ODS.
O
test.assessmentType
testlistitem.passed
testscore.result
progressDescriptor
The yearly progress or growth from last year's assessment.
This is optional, does not report.
O
schoolYearTypeReference
The key for School Year.
Reports the end year of the configured year.
O
school Year
Language Instruction Program Services
Data Element Label
Business Requirements and Rules
Mandatory, Conditional or Optional
Location
languageInstructionProgram ServiceDescriptor
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.
When the service is not mapped, does not report.
M
EL Services > Name
lepservice.services
primaryIndicator
True when 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.
This is optional, does not report.
O
serviceEndDate
Last date the Student was in this option for the current school year.
Optional Transitional year, for a student scoring 3/Proficient on last year's KELPA, but services are still needed for EL support.
When EL services are not provided, select monitored status. Minutes must be provided and entered in field D44: ESOL/Bilingual Student Contact Minutes and the program ending date must be entered in D43: ESOL/Bilingual Program Ending Date.
A transitional student isl either placed on monitored status the following year and remains for two years or becomes eligible to re-enter the ESOL program, receive services and testing requirements.
Monitored, for a student scoring proficient on last year's KELPA and is not receiving EL support minutes(transitional year not chosen) OR is in second year monitored status. For EOYA, D43: ESOL/Bilingual Program Ending Date is required and D44: ESOL/Bilingual Student Contact Minutes must be blank.
Transitional Bilingual Education or Early-Exit Bilingual Education
This program, also known as early-exit bilingual education, utilizes a student's primary language in instruction. The program maintains and develops skills in the primary language and culture while introducing, maintaining, and developing skills in English. The primary purpose of a TBE program is to facilitate the EL student's transition to an all English instructional program while receiving academic subject instruction in the native language to the extent necessary.
TTransitional Bilingual Education or Early-Exit Bilingual Education
Dual Language or Two-way Immersion
Also known as two-way or developmental, the goal of these bilingual programs is for students to develop language proficiency in two languages by receiving instruction in English and another language in a classroom that is usually comprised of half native English speakers and half native speakers of the other language.
A program of techniques, methodology and special curriculum designed to teach EL students English language skills, which may include listening, speaking, reading, writing, study skills, content vocabulary, and cultural orientation. ESL instruction is usually in English with little use of native language.
This approach makes use of instructional materials, learning tasks, and classroom techniques from academic content areas as the vehicle for developing language, content, cognitive and study skills. English is used as the medium of instruction.
Newcomer programs are separate, relatively self-contained educational interventions designed to meet the academic and transitional needs of newly arrived immigrants. Typically, students attend these programs before they enter more traditional interventions (e.g., English language development programs or mainstream classrooms with supplemental ESL instruction).
Also referred to as late-exit bilingual education, is a program that uses two languages, the student's primary language and English, as a means of instruction. The instruction builds upon the student's primary language skills and develops and expands the English language skills of each student to enable him or her to achieve proficiency in both languages, while providing access to the content areas.
SAn instructional approach used to make academic instruction in English understandable to EL students. In the sheltered classroom, teachers use physical activities, visual aids, and the environment to teach vocabulary for concept development in mathematics, science, social studies, and other subjects.
A submersion program places EL students in a regular English-only program with little or no support services on the theory that they will pick up English naturally. This program should not be confused with a structured English immersion program.