• Home
  • State Specific Information
  • Wisconsin
  • Wisconsin Ed-Fi v3.1 Resources

Wisconsin 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.

ActionTrigger
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 = 'EL'.
  • The student has a EL Program Status = '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.
  • Do not send a record if the student's Second Year Monitoring date is before the configured year.
  • Do not send records if the Calendar Exclude or Summer School Exclude check box is checked in the calendar the student is enrolled or the calendar is in a School marked Exclude.
  • Do not send records if the Grade Level Exclude check box is checked on the grade the student is enrolled.
  • Do not send a record if enrollment is marked as No Show, State Exclude, or WISE Exclude.
  • Do not report if State Enrollment Type = Coursework Only or PPP: Parentally Placed Private.
  • If Ed-Fi Configuration Profile = Choice + Private Opt In or Ed-Fi Configuration Profile = Choice ONLY, do not report a record
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
DeleteAll enrollments are deleted for a student.
DeleteWhen an enrollment is deleted or one of the check boxes for No Show, State Exclude, or WISE Exclude are checked.
DeleteIf the student's EL record is no longer eligible to report based on Identified Date, Exit Date or EL Status.
DeleteWhen a resync is completed for all schools if a student has multiple enrollments that meet the requirements. Any existing SLIPA records for each enrollment in the reported year will remain.


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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
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.
DeleteCascading 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.


Identity Mapping Object Key

Campus Object TypeObject Key Data Source
LEPlepID


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

lepPutEnd Date
lepPutMonitored Descriptor

test

testlistitem

testscore

PutProficiency Descriptor
lepservicePutEnglish Learner Participation

lepservicetype

lepservice

PutLanguage Instruction Program Service Descriptor


Object Data Elements

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

Data Element LabelBusiness RequirementLogicM, C or O

Data Source GUI Path

Database Field
id The unique identifier of the resource.
M

beginDateThe enrollment date for continuing ELs or the date of identification for new ELs.
  1. If the EL Date Identified is prior to the current school year, report the start date of the triggering enrollment.
  2. If EL Date is in the current year, report the latest of:
    • the EL Date Identified.
    • the Enrollment Start Date.
M

Student Information > General > Enrollment > Start Date


Student Information > Program Participation > EL > EL Date Identified

enrollment.startdate

OR

lep.startdate

educationOrganizationReferenceA reference to the related school.
  1. If there is a school override on the Enrollment, report first from the override.

  2. Otherwise, report the School Ed-Fi Number from the school of Enrollment triggering the record.

M

Student information > General > enrollment > School Override


Student > Information > General > Enrollment > School Calendar


System Administration > Resources > School > Ed-Fi Number


programReferenceA reference to the Program Resource.
  1. Report "Language Instruction Education" for Program Name.

  2. Report '48856' for educationOrganizationid.

M

studentReferenceA unique alpha-numeric code assigned to a student.
  1. Reports the Natural Key for the Student resource
M

endDateThe enrollment end date.
  1. Report the earliest of:
    • The enrollment end date.
    • The EL Program Exit Date.
  2. If the enrollment is not ended and the EL program is not exited, report blank.

 -  Note: For 1st and 2nd year monitoring students who exited EL but do not have an enrollment end date in the current year, report blank.

O

Student Information > General > Enrollment > End Date


Student Information > Program Participation > EL > Exit Date

enrollment.enddate

or

lep.exitdate

englishLanguageProficiencyAssessments

Results of yearly English language assessment.
  1. This is optional, does not report.
O

englishLearnerParticipationAn indication that an English Learner student is served by an English language instruction educational program supported with Title III of ESEA funds.
  1. This is optional, does not report.
O

languageInstructionProgramServices

Indicates the service(s) being provided to the Student by the Language Instruction Program.

  1. See Array section for details.
O

reasonExitedDescriptorThis descriptor defines the reason a student exited a program.
  1. This is optional, does not report.
O

servedOutsideRegularSession

Indicates whether the Student received services during the summer session or between sessions.

  1. This is optional, does not report.
O

Arrays

Click here to expand...

Appendix A: Additional Logic

Click here to expand...


Type/Descriptor

Click here to expand...