Student Language Instruction Program Associations (Georgia v3.6.1)

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	Report a record when a student has an EL record with a Program Status of: EL, Exited EL, or Not EL (Must have a corresponding EL Service of type "EL-I: Student incorrectly reported as EL" to report Not EL) AND an enrollment that overlaps the current configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude The Programs record must exist in the ODS prior to sending a Student Language Instruction Program Associations record. If the Programs record does not already exist in the ODS, the Programs record will be sent prior to the Student Language Instruction Program Associations record. If there are multiple enrollments, use the following priority list to determine which one should report: Primary > Partial > SPED Earliest Start Date Latest Enrollment ID Only reports the most recent EL record. No historical EL records will report.
Delete/Post/Put	A DELETE/POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following EL Program information changes: Program Status Identified Date Program Exit Date Exit Reason First Year Monitoring Second Year Monitoring Third Year Monitoring Fourth Year Monitoring When the following EL Services information changes: EL Services ID (New EL Service) Service Type Start Date End Date When the following Enrollment information changes: Enrollment ID (New Enrollment) Start Date End Date No Show State Exclude
Delete	When the enrollment being reported off of is deleted. When the enrollment is changed to no longer overlap the configured year. When the student is excluded through their enrollment, calendar, grade level, or school. When the EL record being reported off of is deleted. When the EL record is changed to no longer overlap the configured year.

Action

Trigger

Post

Report a record when a student has an EL record with a Program Status of: EL, Exited EL, or Not EL (Must have a corresponding EL Service of type "EL-I: Student incorrectly reported as EL" to report Not EL) AND an enrollment that overlaps the current configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
The Programs record must exist in the ODS prior to sending a Student Language Instruction Program Associations record.
- If the Programs record does not already exist in the ODS, the Programs record will be sent prior to the Student Language Instruction Program Associations record.
If there are multiple enrollments, use the following priority list to determine which one should report:
- Primary > Partial > SPED
- Earliest Start Date
- Latest Enrollment ID
Only reports the most recent EL record. No historical EL records will report.

Delete/Post/Put

A DELETE/POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following EL Program information changes:
- Program Status
- Identified Date
- Program Exit Date
- Exit Reason
- First Year Monitoring
- Second Year Monitoring
- Third Year Monitoring
- Fourth Year Monitoring
When the following EL Services information changes:
- EL Services ID (New EL Service)
- Service Type
- Start Date
- End Date
When the following Enrollment information changes:
- Enrollment ID (New Enrollment)
- Start Date
- End Date
- No Show
- State Exclude

Delete

When the enrollment being reported off of is deleted.
When the enrollment is changed to no longer overlap the configured year.
When the student is excluded through their enrollment, calendar, grade level, or school.
When the EL record being reported off of is deleted.
When the EL record is changed to no longer overlap the configured 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.

Action	Trigger
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Resync	If 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.
Resync	If 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.
Resync	If 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.

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

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 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
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 Requirement and Business Rules	M, C or O	Data Source GUI Path	Database Field
beginDate	The month, day, and year on which the Student first received services. Normal Logic: Reports the Identified Date of the EL record being reported. IF the student has an EL Status of "Not EL" and an EL Service with Service Type "EL-I: Student incorrectly reported as EL": Report the Enrollment Start Date	M	Student Information> Program Participation> English Learners (EL)> Identified Date Student Information > General > Enrollment > Start Date	LEP.startDate Enrollment.startDate
educationOrganization Reference	The identifier assigned to an education organization. Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = Ed-Fi School ID	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
programReference	A reference to the Program Resource. Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationId = Ed-Fi School ID programName = English Learner (EL) (Hard-Coded) programTypeDescriptor = English Learner (EL) (Hard-Coded)	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
studentReference	A unique alpha-numeric code assigned to a student. Reports the fields that are part of the Natural Key for the Students resource. studentUniqueId = Student State ID	M	Census > People > Demographics > Student State ID	Student.stateID
endDate	The month, day, and year on which the student exited the program or stopped receiving services. Normal Logic: Reports the Program Exit Date of the record being reported. If the student has an EL Status of "Not EL" and an EL Service with Service Type "EL-I: Student incorrectly reported as EL": Does not report.	O	Student Information> Program Participation> EL> Program Exit Date	LEP.exitdate
englishLanguage ProficiencyAssessments	Results of yearly English language assessment. Use the below logic to determine what to report for *proficiencyDescriptor: Report the override code selected in EL Services if present. EL Services Start Date must be within the current configured year. Available overrides: Report 1 if Service Type = 'ESOL-M1O' Report 2 if Service Type = 'ESOL-M2O' Report 3 if Service Type = 'ESOL-M3O' Report 4 if Service Type = 'ESOL-M4O' Report F if Service Type = 'ESOL-FO' Report I if Service Type = 'EL-I' If there is more than one EL Service that meets these conditions, report the EL Service Type based on the following: EL Service with the newest Start Date EL Service with a blank End Date EL Service with the newest End Date EL Service with the highest ID Report Y if EL Program Status = 'EL'. Report 1 if First Year Monitoring Date is within or after the current configured year. Report 2 if the Second Year Monitoring Date is within the current configured year. Report 3 if the Third Year Monitoring Date is within the current configured year. Report 4 if the Fourth Year Monitoring Date is within the current configured year. Report F if the Fourth Year Monitoring Date is before the start of the current configured year. Report N if EL Program Status = 'Not EL' Do not report the englishLanguageProficiencyAssessments* array if the proficiencyDescriptor cannot be determined using the above logic. Use the below logic to determine what to report for schoolYearTypeReference: Send the End Year of the current configured year.	M	Student Information > Program Participation > English Learners (EL)	LEPService.lepServiceTypeID LEP.firstYearMonitoring LEP.secondYearMonitoring LEP.thirdYearMonitoring LEP.fourthYearMonitoring
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. Report TRUE if student has an EL Service with Service Type = 'ESOL' within the current configured year. Report FALSE in all other situations.	M	Student Information > Program Participation > English Learners (EL) > EL Services	LEPService.lepServiceTypeID
languageInstruction ProgramServices	Indicates the service(s) being provided to the Student by the Language Instruction Program. This is optional, do not report.	O
reasonExitedDescriptor	This descriptor defines the reason a student exited a program. Report the Ed-Fi Code mapped to the value selected for Exit Reason on the EL Program.	C	Student Information > Program Participation > English Learners (EL)	LEP.exitReason

Type/Descriptor

reasonExitedDescriptor

Code Value	Description	Namespace	Short Description
1	ACCESS for EL proficiency	uri://gadoe.org/ReasonExitedDescriptor	ACCESS for EL proficiency
2	Exited out of state or from a non public school	uri://gadoe.org/ReasonExitedDescriptor	Exited out of state or from a non public school
3	Reclassification Team Decision	uri://gadoe.org/ReasonExitedDescriptor	Reclassification Team Decision

programTypeDescriptor

Code Value	Description	Namespace	Short Description
English Learner (EL)	English Learner (EL)	uri://gadoe.org/ProgramTypeDescriptor	English Learner (EL)

Proficiency Descriptor

Code Value	Description	Namespace	Short Description
N	Student is not EL	uri://gadoe.org/ProficiencyDescriptor	Not Proficient
Y	Yes - student is EL.	uri://gadoe.org/ProficiencyDescriptor	Yes - student is EL.
1	1st year out of EL Program; monitored year one.	uri://gadoe.org/ProficiencyDescriptor	1st year out of EL Program; monitored year one.
2	2nd year out of EL Program; monitored year two.	uri://gadoe.org/ProficiencyDescriptor	2nd year out of EL Program; monitored year two.
3	No longer EL; no longer monitored; tested out of EL 3 years ago.	uri://gadoe.org/ProficiencyDescriptor	No longer EL; no longer monitored; tested out of EL 3 years ago.
4	No longer EL; no longer monitored; tested out of EL 4 years ago.	uri://gadoe.org/ProficiencyDescriptor	No longer EL; no longer monitored; tested out of EL 4 years ago.
F	Former EL Student; tested out of EL 5 or more years ago.	uri://gadoe.org/ProficiencyDescriptor	Former EL Student; tested out of EL 5 or more years ago.
I	Student incorrectly reported as 'EL'.	uri://gadoe.org/ProficiencyDescriptor	Student incorrectly reported as 'EL'.