Student Language Instruction Program Associations (Texas v4.0)

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 the logic for triggering the 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 = 'EL'.
  • The student has an 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 a record if the enrollment is in a calendar marked as Exclude.
  • Do not send a record if the enrollment is in a school marked as Exclude.
  • Do not send a record if the enrollment is marked as No Show.
Post

Multiple Enrollments - A new record will be created for each enrollment change found. Compare enrollment Start/End Dates against EL Identified/Program Exit Dates to produce a complete set of records.

Exception: Ignore enrollment changes if End Status is mapped to an Ed-Fi Code = SC and SchoolID did not change.

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.
DeleteIf the student's enrollment is marked as No Show.
DeleteIf 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

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

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

Business Rules
Data only sends for the years that have valid configuration.

Resource Preferences

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

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 Labels in bold are part of the Natural Key and are required for Data to be sent to Ed-Fi.

Data Element LabelBusiness RequirementLogicM, C or O

Location

id The unique identifier of the resource.
M
beginDateThe first instructional day a student is identified as eligible for language services.

Reports the latest of the following that occurs within the scope year:

  • Identified Date
  • Enrollment Start Date
M

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


lep.startDate

educationOrganization
Reference
The School Reference represents the identifier assigned to a school.

Reports the Natural Key of the School resource

M

School & District Settings >  School Information



programReferenceA reference to the Program Resource.
  1. If a student has EL Service Type = B0, report reference to the Bilingual program.
  2. If a student has EL Service Type = E0, report a reference to the ESL program.
  3. If a student has EL Service Type with mapped Ed-Fi Code = 002, 003, or 004, report reference to the ESL program.
  4. If a student has EL Service Type with mapped Ed-Fi Code = 042, 043, 044, 045, 046, report reference to the Bilingual program.
    MStudent Information> English Learners > English Learners (EL) > EL Service
    studentReferenceA unique alpha-numeric code assigned to a student.

    Reports the Natural Key for the Student resource.

    M
    endDateThe first day after the last instructional day a student was eligible to receive language services.Reports the earliest of the following within the Scope Year, + 1 additional day:
    • Program Exit Date
    • Enrollment End Date (Do not report if End Status = SC and there is no change in SchoolID)

    If no date is found report report the last instructional day of the calendar + 1 day.

    O

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


    lep.exitdate

    englishLanguageProficiency
    Assessments

    Results of yearly English language assessment.

    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.

    This is optional, does not report.

    O
    languageInstructionProgram
    Services

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

    See Array section for details.

    O
    reasonExitedDescriptorThis descriptor defines the reason a student exited a program.

    This is optional, does not report.

    O
    servedOutsideRegular
    Session

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

    This is optional, does not report.

    O
    parentalPermissionSet

    See Array section for details.




    Arrays

    Click here to expand...

    English Language Proficiency Assessments

    Data Element LabelBusiness RequirementLogicM, C or O

    Location

    monitoredDescriptor

    Student is monitored on content achievement who are no longer receiving services.

    1. Reports the following when the  student has an LEP Program Status = Exited LEP and the LEP Exit Date falls in the monitoring period and the Monitoring option is mapped in the preferences.
      • Report the code mapped to First Year Monitoring if today's date is on or between the EL Exit Date and the First Year Monitoring date.
      • Report the code mapped to Second Year Monitoring if today's date is after the First Year Monitoring date and on or before the Second Year Monitoring date.
    2. Otherwise, does not report.
    OStudent Information> English Learners > English Learners (EL)

    lep.firstyearMonitoring

    OR

    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. 
    • Use the assessment logic in the Proficiency Descriptor field logic below to determine which test result to use.
    OStudent Information> Assessments> Reason Code

    testscore.reasonCode
    proficiencyDescriptor

    The proficiency level for the yearly English language assessment.

    1. Reports the mapped descriptor based on the mapped results on the student's assessment record.
    2. Look at assessments that have a type that is mapped in the English Language Proficiency Assessments mapping.
      • The student's assessment date must overlap the configured year.
      • The student must have a result on the test.
      • If the result is blank or the student does not have an eligible test, report blank.
      • If the student has more than 1 eligible test that overlaps the configured year, use the test with the most recent test date.
        • If the dates are the same, the last test to send will appear in the ODS.
    O

    Student Information Assessment Administration > Assessment Center > Test Detail > Result / Proficiency Statues > EL


    test.assessmentType


    testlistitem.passed


    testscore.result

    progressDescriptor

    The yearly progress or growth from last year's assessment.

    This is optional, does not report.

    O
    schoolYearType
    Reference
    The key for School Year.

    Reports the end year of the configured year.

    O
    school Year

    Language Instruction Program Service Sets

    Data Element LabelBusiness RequirementLogicM, C or O

    Location

    langInstruProgramSvcSet
    Descriptor

    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.
    • If the service is not mapped, does not report.
    M

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


    lepservice


    serviceBeginDate

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

    Reports the Service Start Date.

    O

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


    lepservice.startDate

    serviceEndDate

    The first day after the last instructional day a student was assigned to the LangInstruProgramSvc descriptor.

    Reports the earliest of the following within the Scope Year, + 1 additional day:
    • EL Service End Date
    • Enrollment End Date (Do not report if End Status = SC and there is no change in SchoolID)

    If no date is found, report the last instructional day of the calendar + 1 day.

    O

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


    lepservice.endDate

    Parental Permission Sets
    Data Element LabelBusiness RequirementLogicM, C or OLocation
    parentalPermissionSet
    BeginDate
    The first instructional day a student is assigned to the  ParentalPermission descriptor.

    Reports the latest of the following that occurs within the scope year:

    • EL Service Start Date
    • Enrollment Start Date
    M

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


    parentalPermissionSet
    EndDate
    The first day after the last instructional day a student was assigned to the ParentalPermission descriptor.Reports  the earliest of the following within the Scope Year, + 1 additional day:
    1. EL Service End Date
    2. Enrollment End Date (Do not report if End Status = SC and there is no change in SchoolID)

    If no date is found, report the last instructional day of the calendar + 1 day.

    O

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


    parentalPermissionSet
    Descriptor

    Indicates whether the student's parent or legal guardian has approved placement of the student in the required bilingual or English as a Second Language (ESL) program. (See 19 TAC

    §89.1240.)

    Reports the mapped Ed-Fi Code of Parental Permission Code.


    M

    Student Information> English Learners > English Learners (EL) Services > Parental Permission Code



    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

    Progress Descriptor

    Code ValueDescriptionNamespaceShort Description
    No ProgressNo Progressuri://ed-fi.org/ProgressDescriptorNo Progress
    ProficientProficienturi://ed-fi.org/ProgressDescriptorProficient
    ProgressProgressuri://ed-fi.org/ProgressDescriptorProgress

    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