Student Language Instruction Program Associations (Nebraska v3.5)

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 an EL Program Status of EL. Only one EL Services record reports per descriptor code. When there are multiple EL Services records assigned to the same descriptor code, the most recent record that is active in the configured year reports.
  • The student has an EL Program Status of Exited EL and the First Year Monitoring or Second Year Monitoring dates overlap a configured year. Today's date is used to determine their status.
  • The Program Exit date is used as the start date and the First Year Monitoring date as the end date to determine the student's status.
  • A student marked as Redesignated English reports until the student is no longer in the district.
  • The day after the First Year Monitoring date is used 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 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
Put

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

  • End Date
  • englishLanguageProficiencyAssessments
  • languageInstructionProgramServices
DeleteAll enrollments are deleted for a student.
DeleteWhen the student's enrollment is marked as No Show.
DeleteWhen 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.

ActionTrigger
NoneWhen a resource is toggled to OFF after data has sent, all sent data remains in the ODS but no new data sends.
ResyncWhen 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.
ResyncWhen 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.
ResyncWhen 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.

ActionTrigger
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.
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 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 AssessmentsAssessment Type
Proficiency Descriptor

Student's Test Result Status is Passing

Student's Test Result Status is Not Passing

Language Instruction Program Service DescriptorEL Services
Select the Program Type Descriptor associated with this ProgramProgram Type Descriptor

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.

Reports the Identified Date of the EL record being reported.

M

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

lep.startDate
educationOrganization
Reference
The education organization where the student is participating in or receiving the program services.

Reports the State District Number.

M

System Administration> Resources> District Information> State District Number

district.number

programReferenceA reference to the Program Resource.

Reports the Natural Key for the Program.

M

studentReferenceA unique alpha-numeric code assigned to a student.

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.

Reports the Program Exit Date of the record being reported.

O

Student Information> Program Participation> EL> Program Exit Date

lep.exitdate
englishLanguage
ProficiencyAssessments

Results of yearly English language assessment.

This field is optional, does not report.

O

englishLearner
Participation
An indicator that a student who is English Learner eligible is participating in the English Learner program.

Reports 'True' when the student has an EL Services record that overlaps the configured year. Report 'True' until the student graduates or leaves the district.


Reports 'False' when the student has a service and the 'Parent Refused' checkbox is checked.


Reports 'False' when the student does not have a service or the service record does not overlap the configured year.

OStudent Information> Program Participation> EL> EL Serviceslepservice
languageInstruction

Describes the methods used to provide English Language services.

See Array section for details.

O

reasonExitedDescriptorThis descriptor defines the reason a student exited a program.

This is optional, does not report.

O

servedOutside
RegularSession

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

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.


When the service is not mapped, does not report.

M

Student Information> Program Participation> EL> EL Services


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

Reports the Service Start Date.

O

Student Information> Program Participation> EL> EL Services> Start Date

lepservice.startDate
serviceEndDate

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

Reports the Service End Date.

O

Student Information> Program Participation> EL> EL Services> End Date

lepservice.endDate

Type/Descriptor

Click here to expand...

Monitored Descriptor

Code ValueDescriptionNamespaceShort Description
Year 1Year 1uri://ed-fi.org/MonitoredDescriptorYear 1
Year 2Year 2uri://ed-fi.org/MonitoredDescriptorYear 2
Not MonitoredNot Monitoreduri://ed-fi.org/MonitoredDescriptorNot Monitored

Participation Descriptor

Code ValueDescriptionNamespaceShort Description
CompletedCompleteduri://ed-fi.org/ParticipationDescriptorCompleted
AttemptedAttempteduri://ed-fi.org/ParticipationDescriptorAttempted
Did Not TakeDid Not Takeuri://ed-fi.org/ParticipationDescriptorDid Not Take
Unable Due To Medical EmergencyUnable Due To Medical Emergencyuri://ed-fi.org/ParticipationDescriptorUnable Due To Medical Emergency

Proficiency Descriptor

Code ValueDescriptionNamespaceShort Description
Not ProficientNot Proficienturi://ed-fi.org/ProficiencyDescriptor

Not Proficient

ProficientProficienturi://ed-fi.org/ProficiencyDescriptor

Proficient

Language Instruction Program Service Descriptor

Code ValueDescriptionNamespaceShort Description
Dual LanguageDual Languageuri://ed-fi.org/LanguageInstructionProgramServiceDescriptorDual Language
Two-Way ImmersionTwo-Way Immersionuri://ed-fi.org/LanguageInstructionProgramServiceDescriptorTwo-Way Immersion
Transitional BilingualTransitional Bilingualuri://ed-fi.org/LanguageInstructionProgramServiceDescriptorTransitional Bilingual
Developmental BilingualDevelopmental Bilingualuri://ed-fi.org/LanguageInstructionProgramServiceDescriptorDevelopmental Bilingual
Heritage LanguageHeritage Languageuri://ed-fi.org/LanguageInstructionProgramServiceDescriptorHeritage Language
Sheltered English InstructionSheltered English Instructionuri://ed-fi.org/LanguageInstructionProgramServiceDescriptorSheltered English Instruction
Structured English ImmersionStructured English Immersionuri://ed-fi.org/LanguageInstructionProgramServiceDescriptorStructured English Immersion
SDAIESDAIE - Specially Designed Academic Instruction Delivered In Englishuri://ed-fi.org/LanguageInstructionProgramServiceDescriptorSDAIE - Specially Designed Academic Instruction Delivered In English
Content-Based ESLContent-Based ESLuri://ed-fi.org/LanguageInstructionProgramServiceDescriptorContent-Based ESL
Pull-Out ESLPull-Out ESLuri://ed-fi.org/LanguageInstructionProgramServiceDescriptorPull-Out ESL
OtherOtheruri://ed-fi.org/LanguageInstructionProgramServiceDescriptorOther



Previous Versions

Nebraska Ed-Fi Data v3.5 - Student Language Instruction Program Associations [.2319 and previous]