MN v3.3 - Student Language Instruction Program Associations

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. The record will send to any year the El records overlaps with if the student has an enrollment in that year. Data will only send for the years that have valid configuration. 

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 no program exit date exists or the exit date is before the end date of the configured year.
  • The student's enrollment end date is null, or is after the EL identified date.
  • The EL identified date is before June 30th of the configured year (end year)
  • Do not send a record if enrollment is in a calendar marked as Exclude.
  • Do not send a record if enrollment is in a school marked as Exclude.
  • Do not send a record if enrollment is marked as No Show.
  • Do not send a record if grade level is excluded from State Reporting.
  • Do not send a record if School is excluded from State Reporting.
  • Do not send a record if State Aid Category is NULL or '46' or '51'.
Put

When any field not part of the natural key is changed.

DeleteAll enrollments are deleted for a student.
  • If the student's enrollment is marked as No Show.
  • If the student's EL record is no longer eligible to report based on Identified Date, Exit Date or EL Status.
  • Do NOT send a delete for prior scope year data when a Program Exit Date exists that is in a subsequent (future) configuration 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.

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.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label

Mapping Needed

Language Instruction Program Service DescriptorEL Service Type

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 month, day, and year on which the Student first received services.
  1. If the EL record has a Lep.ParentDeclinedDate value, report that value.
  2. If Lep.ParentDeclinedDate is NULL, check if the EL record has a related LepService.startDate.
  3. If the EL record has Lep Service.parent Refused Services checked, report the entryDate as 1901/01/01.
  4. If the EL record has a related LepService.startDate value, and that value takes place between the Student School Associations' entryDate and exitWithdrawDate, report that value.
  5. If the EL record has a related LepService.startDate value, and that value takes place before the Student School Associations' entryDate, report the entryDate value.
  6. If the EL record has a related LepService.startDate value, and that value takes place after the Student School Associations' exitWithdrawDate, check the Lep.identifiedDate.

  7. If the EL Record's Lep.identifiedDate value takes place between the Student School Associations' entryDate and exitWithdrawDate, report that value.
  8. If the EL Record's Lep.identifiedDate value takes place before the Student School Associations' entryDate, report the entryDate value.
  9. If the EL record has no service associated with the school, report 1900/01/01.
M

Student Information > English Learners > English Learners (EL) > English Learners (EL) Services > Start Date


Student Information > English Learners > English Learners (EL) > English Identified Date


Student Information > English Learners > English Learners (EL) > English Parent Declined

LepService.startDate

Lep.identifiedDate

Lep.parentDeclined


education
Organization
Reference

educationOrganizationId

The education organization where the student is participating in or receiving the program services.

  1. Report the Ed-Fi School ID.
  2. If Ed-Fi School ID is NULL, report:
    1. ttddddsssmmm

      where:

      • tt = district type
      • dddd = district number, left zero filled
      • sss = school number, left zero filled
      • mmm = 000 for all organizations reported in Ed-Fi
M

School & District Settings > Schools > School Information > school record > Ed-Fi School ID


tt: School & District Settings > District > District Information > district record > Type


dddd: School & District Settings > District > District Information > district record > State District Number


SSS: School & District Settings > Schools > School Information > school record > State School Number

School.entityID

District.type

District.number

School.number

program
Reference
educationOrganizationId

The identifier assigned to an education organization.

programName

The formal name of the Program of instruction, training, services, or benefits available through federal, state, or local agencies.

programTypeDescriptor

The type of program.

  1. Report the following values within the program.

    • educationOrganizationId:
      • Report the Ed-Fi District Number, if it exists
      • If Ed-Fi District Number is NULL, report:
        • ttddddsss

          where:

          • tt = district type
          • dddd = district number, left zero filled
          • sss = 000
    • programName: ''

    • programTypeDescriptor: ''
M

School & District Settings > District > District Information > district record > Ed-Fi District Number


tt: School & District Settings > District > District Information > district record > Type


dddd: School & District Settings > District > District Information > district record > State District Number

District.entityID

District.type

District.number

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

endDateThe month, day, and year on which the student exited the program or stopped receiving services.
  1. Reports the Program Exit Date of the  record being reported.
O

Student Information> English Learners > English Learners (EL) > Program Exit Date

lep.exitdate
englishLanguage
Proficiency
Assessments

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

englishLearner
Participation
An indication that an English Learner student is served by an English language instruction educational program supported with Title III of ESEA funds.
  1. Report 'True' if the student has an EL Services record that overlaps the configured year.
  2. Reprt 'False' if the student has a service and the 'Parent Refused' checkbox is checked.
  3. Report 'False' if the student does not have a service or the service record does not overlap the configured year.
OStudent Information> English Learners > English Learners (EL) > EL Serviceslepservice
language
Instruction
Program
Services

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

  1. See Array section for details.
C

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

servedOutside
Regular
Session

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

Language Instruction Program Services

Data Element LabelBusiness RequirementLogicM, C or O

Data Source GUI Path

Database Field
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.
  1. If the service is not mapped, do not report.
C

Student Information> English Learners > English Learners (EL) > EL Services


lepservice
primaryIndicator

True if service is a primary service.

  1. This is optional, does not report.
O

serviceBeginDate

First date the Student was in this option for the current school year.

  1. This is optional, does not report.
O



serviceEndDate

Last date the Student was in this option for the current school year.

  1. This is optional, does not report.
O



Resource Preferences Continued

The Ed-Fi Configuration tool is used to establish Ed-Fi data resources. 

The following describes how to set the resource preferences for the Student Language Instruction Program Association resource. If the Configure or Edit buttons do not display, then the resource does not need to be mapped and the toggle button can be used to turn the resource on or off.

 If a mapping is changed, a resync must be performed on the resource in order for the new mappings to send correctly. Any item not mapped will not report to Ed-Fi.
  1. The filter option at the top of the section can be used to filter by Behavior ResolutionType, State Code, and/or Owner. The various filter fields determine which information displays. The Fill options can be used to fill the Ed-Fi Code fields.

  2. Select the appropriate Ed-Fi Code for the EL Service Type Descriptors

    FieldDescription
    State CodeUsed to filter by state code.
    OwnerUsed to filter by owner.
    Fill Ed-Fi CodeThe code assigned to the EL Service Type.
    Fill EmptyThe selected option will fill all EL Service Types with the same Ed-Fi code.
    Fill AllThe selected option will fill all EL Service Types that do not have an Ed-Fi Code entered with the same Ed-Fi code.
    EL Service Type
    UI LocationStudent Information> English Learners > English Learners (EL) > EL Services



  3. Click Save.