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.

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

Click here to expand...

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		O

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. This is optional, does not report.	O

Type/Descriptor

Click here to expand...

Program Type Descriptor

Code Value	Description	Namespace	Short Description
English as a Second Language (ESL)	English as a Second Language (ESL)	uri://ed-fi.org/ProgramTypeDescriptor	English as a Second Language (ESL)
Homeless	Homeless	uri://ed-fi.org/ProgramTypeDescriptor	Homeless
Student School Food Service	Student School Food Service	uri://ed-fi.org/ProgramTypeDescriptor	Student School Food Service
Title I Part A	Title I Part A	uri://ed-fi.org/ProgramTypeDescriptor	Title I Part A
Kansas Parents as Teachers Program	Kansas Parents as Teachers Program	uri://ed-fi.org/ProgramTypeDescriptor	Kansas Parents as Teachers Program
Kansas Pre-K Pilot Program	Kansas Pre-K Pilot Program	uri://ed-fi.org/ProgramTypeDescriptor	Kansas Pre-K Pilot Program

Funding Source Descriptor

Code Value	Description	Namespace	Short Description
Not an ESOL eligible student	Not an ESOL eligible student and not an ESOL monitored student.	uri://ksde.org/FundingSourceDescriptor	Not an ESOL eligible student
Title III Funded	Title III Funded	uri://ksde.org/FundingSourceDescriptor	Title III Funded
State ESOL/Bilingual Funded	State ESOL/Bilingual Funded	uri://ksde.org/FundingSourceDescriptor	State ESOL/Bilingual Funded
Both Title III and State ESOL/Bilingual Funded	Both Title III and State ESOL/Bilingual Funded	uri://ksde.org/FundingSourceDescriptor	Both Title III and State ESOL/Bilingual Funded
ESOL program eligible	ESOL program eligible, based on an English language proficiency test, but not currently receiving ESOL program services. Example: Parents who have waived their child out of ESOL services, but the district is still obligated to provide ESOL support and tested with KELPA.	uri://ksde.org/FundingSourceDescriptor	ESOL program eligible
Receives ESOL services and not funded	Receives ESOL services and not funded	uri://ksde.org/FundingSourceDescriptor	Receives ESOL services and not funded
Optional Transitional 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.	uri://ksde.org/FundingSourceDescriptor	Optional Transitional year
Monitored	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.	uri://ksde.org/FundingSourceDescriptor	Monitored

Monitored Descriptor

Code Value	Description	Namespace	Short Description
Year 1	Year 1	uri://ed-fi.org/MonitoredDescriptor	Year 1
Year 2	Year 2	uri://ed-fi.org/MonitoredDescriptor	Year 2
Not Monitored	Not Monitored	uri://ed-fi.org/MonitoredDescriptor	Not Monitored

Participation Descriptor

Code Value	Description	Namespace	Short Description
Completed	Completed	uri://ed-fi.org/ParticipationDescriptor	Completed
Attempted	Attempted	uri://ed-fi.org/ParticipationDescriptor	Attempted
Did Not Take	Did Not Take	uri://ed-fi.org/ParticipationDescriptor	Did Not Take
Unable Due To Medical Emergency	Unable Due To Medical Emergency	uri://ed-fi.org/ParticipationDescriptor	Unable Due To Medical Emergency

Proficiency Descriptor

Code Value	Description	Namespace	Short Description
Not Proficient	Not Proficient	uri://ed-fi.org/ProficiencyDescriptor	Not Proficient
Proficient	Proficient	uri://ed-fi.org/ProficiencyDescriptor	Proficient

Progress Descriptor

Code Value	Description	Namespace	Short Description
No Progress	No Progress	uri://ed-fi.org/ProgressDescriptor	No Progress
Proficient	Proficient	uri://ed-fi.org/ProgressDescriptor	Proficient
Progress	Progress	uri://ed-fi.org/ProgressDescriptor	Progress

Language Instruction Program Service Descriptor

Code Value	Description	Namespace	Short Description
Not an ESOL Student	Not an ESOL Student	uri://ksde.org/LanguageInstructionProgramTypeDescriptor	Not an ESOL Student
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.	uri://ksde.org/LanguageInstructionProgramTypeDescriptor	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.	uri://ksde.org/LanguageInstructionProgramTypeDescriptor	Dual Language or Two-way Immersion
ESL or ELD	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.	uri://ksde.org/LanguageInstructionProgramTypeDescriptor	ESL or ELD
Content Classes with integrated ESL support	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.	uri://ksde.org/LanguageInstructionProgramTypeDescriptor	Content Classes with integrated ESL support
Newcomer programs	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).	uri://ksde.org/LanguageInstructionProgramTypeDescriptor	Newcomer programs
Maintenance Bilingual Education (MBE)	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.	uri://ksde.org/LanguageInstructionProgramTypeDescriptor	Maintenance Bilingual Education (MBE)
Sheltered English Instruction	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.	uri://ksde.org/LanguageInstructionProgramTypeDescriptor	Sheltered English Instruction
Submersion Program	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.	uri://ksde.org/LanguageInstructionProgramTypeDescriptor	Submersion Program

Student Language Instruction Program Associations (Kansas v3.6)