Arizona Ed-Fi Data v3.5 - Student Program Associations [.2227 - .2303]
Last Modified on 02/09/2023 9:20 am CST
Classic View: System Administration > Ed-Fi
Search Terms: Ed-FI
This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.
Object Triggering Logic
This tables below describe the logic for triggering syncing of this object.
Flags
Click here to expand...
| Action | Trigger |
|---|
| Post | Report a record based on the students enrollment record: Service Type = P. - If a student has multiple enrollments with a Local Service Type of ‘P:Primary” in the same school and start date, report from the earliest created enrollment.
- If a student has multiple enrollments with a Local Service Type of 'P:Primary" in the same school with different start dates, report with the following logic:
- Report a record from the enrollment with the earliest start date and set the end date to one day prior to the start date of the next enrollment.
- Report a second record from the enrollment with the later start date and set the start date to the enrollment start date and the end date to the enrollment end date. If enrollment end date is blank, set end date to the calendar end date.
- Only send a record for enrollments that have a Local Service Type other than 'P:Primary' if they are the only enrollment in a given timeframe. This means the enrollment does not overlap with any other enrollment from the same school or any other school.
- Do not send a record for enrollments that have a Local Service Type OTHER than 'P:Primary" OR 'T:AOI" AND the enrollment Resident District does not match the following:
- District Information > State District Number
- If enrollment Resident District does not match the District Information > State District Number, loop through all of the credentials and compare to the District Number.
- Do not send a record for an enrollment that is marked as State Exclude or No Show.
- Do not send a record if enrollment is in a calendar marked as State Exclude.
- Do not send a record if the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
- Do not send records if the Grade Level Exclude check box is checked in the grade level record tied to the calendar the student is enrolled in.
|
| Post | When a Flag is created and saved for a student that is mapped to a state program code. - Flag start date must be on or after enrollment start date.
|
| Post | When a new enrollment is created for a student that has an active Flag mapped to a state program code. - Enrollment start date must be after Flag start date.
- Flag end date must be NULL or after enrollment start date.
- If the enrollment overlaps an existing enrollment within the same school, follow the post requirements based on the student's enrollment record, otherwise post a new record.
|
| Delete/Post | When a start or end date is entered or changed for an existing record. |
| Delete/Post | When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13. |
| Delete | Delete the existing record if a Program is changed on an existing flag. |
| Delete | Flag is deleted for a student. - If the student has two flags with the same Program Name and Start Date, do not delete this record unless all programs or needs associated with the record are deleted.
|
| Delete | When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved. |
| Delete | When an existing enrollment is marked as State Exclude or No Show. |
Gifted
Click here to expand...
| Action | Trigger |
|---|
| Post | Report a record based on a Gifted record being saved and overlapping the students enrollment record: Service Type = P - If a student has multiple enrollments with a Local Service Type of ‘P:Primary” in the same school and start date, report from the earliest created enrollment.
- If a student has multiple enrollments with a Local Service Type of 'P:Primary" in the same school with different start dates, report with the following logic:
- Report a record from the enrollment with the earliest start date and set the end date to one day prior to the start date of the next enrollment.
- Report a second record from the enrollment with the later start date and set the start date to the enrollment start date and the end date to the enrollment end date. If enrollment end date is blank, set end date to the calendar end date.
- Only send a record for enrollments that have a Local Service Type other than 'P:Primary' if they are the only enrollment in a given timeframe. This means the enrollment does not overlap with any other enrollment from the same school or any other school.
- Do not send a record for enrollments that have a Local Service Type OTHER than 'P:Primary" OR 'T:AOI" AND the enrollment Resident District does not match the following:
- District Information > State District Number
- If enrollment Resident District does not match the District Information > State District Number, loop through all of the credentials and compare to the District Number.
- Do not send a record for an enrollment that is marked as State Exclude or No Show.
- Do not send a record if enrollment is in a calendar marked as State Exclude.
- Do not send a record if the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
- Do not send records if the Grade Level Exclude check box is checked in the grade level record tied to the calendar the student is enrolled in.
- If a student has multiple overlapping gifted records, only report one program association with the following logic:
- Report the start date based on the record with the earliest start date.
- Report the end date based on the record with the latest end date. If one record has an end date and the second record does not, the null end date is considered the latest end date.
- Do not send a record if the 'No Gifted Program' checkbox is marked.
|
| Post | When a Gifted record is created and saved for a student. - Gifted start date must be on or after enrollment start date and the Gifted record end date is either null or after the enrollment start date.
|
| Post | When a new enrollment is created for a student that has an active Gifted record: - Enrollment start date must be after Gifted start date.
- Gifted end date must be NULL or after enrollment start date.
- If the enrollment overlaps an existing enrollment within the same school, follow the post requirements based on the student's enrollment record, otherwise post a new record.
|
| Delete/Post | When a start or end date is entered or changed for an existing record. |
| Delete/Post | When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13. |
| Delete/Post | When the enrollment tied to the Gifted record is deleted or made ineligible, and there is another eligible enrollment in the student's record (another overlapping one with perhaps a lower ranked Status value, non-excluded). |
| Delete | Gifted record is deleted for a student. - If the student has two Gifted records with the same Start Date, do not delete this record unless all Gifted records associated with the record are deleted.
|
| Delete | When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved. |
| Delete | When an existing enrollment is marked as State Exclude or No Show. |
| Delete | Gifted record's start date or end date is changed, such that it no longer overlaps an eligible enrollment |
| Delete | When there is a delete/edit to the eligible enrollment reporting is based on, such that there are no longer any eligible enrollments. |
| Delete | When the 'No Gifted Program' checkbox is checked. |
21CCLC
Click here to expand...
| Action | Trigger |
|---|
| Post | Report a record based on a 21st CCLC record being saved and overlapping the students enrollment record: Local Service Type = O: Program Only - If a student has multiple enrollments with a Local Service Type of ‘O: Program Only' in the same school and start date, report from the earliest created enrollment.
- If a student has multiple enrollments with a Local Service Type of 'O: Program Only' in the same school with different start dates that both overlap the 21st CCLC record, report from the enrollment with the oldest end date (a null end date is the oldest end date).
- Only report if the Resident District matches one of the following:
- District Info > State District Number
- If enrollment Resident District does not match the District Info > State District Number, loop through all of the credentials and compare to the District Number.
- Do not send a record if enrollment is in a calendar marked as State Exclude.
- Do not send records if the Grade Level Exclude check box is checked in the grade level record tied to the calendar the student is enrolled in.
|
| Post | When a 21st CCLC record is created and saved for a student. - 21st CCLC start date must be on or after enrollment start date and the 21st CCLC record end date is either null or after the enrollment start date.
|
| Put | When a Program is changed on the 21st CCLC record for a student mapped to a program code.- If the program code is changed from one mapped code to another, post the updated code.
|
| Post | When a new enrollment is created for a student that has an active 21st CCLC record. - Enrollment start date must be after 21st CCLC start date.
- 21st CCLC end date must be NULL or after enrollment start date.
- If the enrollment overlaps an existing enrollment within the same school, follow the post requirements based on the student's enrollment record, otherwise post a new record.
|
| Delete/Post | When a start or end date is entered or changed for an existing record. |
| Delete/Post | When an enrollment end date is entered for a student with a valid enrollment end status: W1-W51. |
| Delete/Post | When the enrollment tied to the 21st CCLC record is deleted or made ineligible, and there is another eligible enrollment in the student's record (another overlapping one). |
| Delete | Delete the existing record if a Program is changed on an existing 21st CCLC record. |
| Delete | 21st CCLC record is deleted for a student. - If the student has two 21st CCLC records with the same Program Name and Start Date, do not delete this record unless all programs associated with the record are deleted.
|
| Delete | 21st CCLC record's start date or end date is changed, such that it no longer overlaps an eligible enrollment. |
| Delete | When there is a delete/edit to the eligible enrollment reporting is based on, such that there are no longer any eligible enrollments. |
Title 1
Click here to expand...
| Action | Trigger |
|---|
| Post | When a Title 1 record is created and tied to a valid Enrollment record where the location of the Title 1 record equals the school on the enrollment. - If a student has multiple enrollments with a Local Service Type of ‘P:Primary” in the same school and start date, report from the earliest created enrollment.
- If a student has multiple enrollments with a Local Service Type of 'P:Primary" in the same school with different start dates, report with the following logic:
- Report a record from the enrollment with the earliest start date and set the end date to one day prior to the start date of the next enrollment.
- Report a second record from the enrollment with the later start date and set the start date to the enrollment start date and the end date to the enrollment end date. If enrollment end date is blank, set end date to the calendar end date.
- Only send a record for enrollments that have a Local Service Type other than 'P:Primary' if they are the only enrollment in a given timeframe. This means the enrollment does not overlap with any other enrollment from the same school or any other school.
- Do not send a record for enrollments that have a Local Service Type OTHER than 'P:Primary" OR 'T:AOI" AND the enrollment Resident District does not match the following:
- District Information > State District Number
- If enrollment Resident District does not match the District Information > State District Number, loop through all of the credentials and compare to the District Number.
- Do not send a record for an enrollment that is marked as State Exclude or No Show.
- Do not send a record if enrollment is in a calendar marked as State Exclude.
- Do not send a record if the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
- Do not send records if the Grade Level Exclude check box is checked in the grade level record tied to the calendar the student is enrolled in.
|
| Post | When Title 1 record overlaps the student's Enrollment record for that school. |
| Post | When a new enrollment for the same school indicated in a pre-existing Title 1 record is created for a student, which had not previously had an eligible enrollment record (either didn't have one in that school, didn't have one that overlapped, or didn't have one that wasn't excluded). |
| Delete/Post | When a start or end date is entered or changed on an existing Title 1 record. |
| Delete/Post | When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13. |
| Delete/Post | When the Title 1 service is changed on an existing record. |
| Delete/Post | When the enrollment tied to the Title 1 record is deleted or made ineligible, and there is another eligible enrollment in the student's record (another overlapping one with perhaps a lower ranked Status value, non-excluded). |
| Delete | Title 1 record is deleted. - If the student has two or more Title 1 records with the same Title 1 program value and Start Date, do not delete the record unless all programs or needs associated with the primary keys are deleted.
|
| Delete | Title 1 record's start date or end date is changed, such that it no longer overlaps an eligible enrollment. |
| Delete | When there is a delete/edit to the eligible enrollment reporting is based on, such that there are no longer any eligible enrollments. |
EL
Click here to expand...
| Action | Trigger |
|---|
| Post | Report a record based on the students enrollment record: Service Type = P. - If a student has multiple enrollments with a Local Service Type of ‘P:Primary” in the same school and start date, report from the earliest created enrollment.
- If a student has multiple enrollments with a Local Service Type of 'P:Primary" in the same school with different start dates, report with the following logic:
- Report a record from the enrollment with the earliest start date and set the end date to one day prior to the start date of the next enrollment.
- Report a second record from the enrollment with the later start date and set the start date to the enrollment start date and the end date to the enrollment end date. If enrollment end date is blank, set end date to the calendar end date.
- Only send a record for enrollments that have a Local Service Type other than 'P:Primary' if they are the only enrollment in a given timeframe. This means the enrollment does not overlap with any other enrollment from the same school or any other school.
- Do not send a record for enrollments that have a Local Service Type OTHER than 'P:Primary" OR 'T:AOI" AND the enrollment Resident District does not match the following:
- District Information > State District Number
- If enrollment Resident District does not match the District Information > State District Number, loop through all of the credentials and compare to the District Number.
- Do not send a record for an enrollment that is marked as State Exclude or No Show.
- Do not send a record if enrollment is in a calendar marked as State Exclude.
- Do not send a record if the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
|
| Post | When a LEP Service is created and saved for a student that is mapped to a state program code. |
| Post | When a Service is changed on an existing Service for a student with a state program code. |
| Post | When a new enrollment is created for a student that has an active Service. - Enrollment start date must be after Service start date.
- Service end date must be NULL or after enrollment start date.
- If the enrollment overlaps an existing enrollment within the same school, follow the post requirements based on the student's enrollment record, otherwise post a new record.
|
| Put | When a start or end date is entered or changed for an existing record. - When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
- When an EL Service Type is updated.
|
| Delete | Delete the existing Service if the Service is changed. |
| Delete | A Service is Deleted. - If the student has two services with the same start date, do not delete this record unless all services with the same start date are deleted.
|
| Delete | When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved. |
| Delete | When an existing enrollment is marked as State Exclude or No Show. |
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:
- If the Flag Start Date or Flag Name changes, all Student Program Associations will be deleted and then re-posted.
|
| Delete | Cascading Deletes: N/A - No resources exist under this resource. |
Scope Year Logic
This table describes scope year logic of this object.
| Logic |
|---|
The record will send to the scope year for the school year the program association record is associated with.
|
| 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 |
|---|
| Program Type Descriptors - Flags | Program State Program Code |
| Reason Exited Descriptors | Program Participation Exit Reason |
| Lep Service Exit Reason |
| Twenty First CCLC Exit Reason |
Identity Mapping Object Key
This table describes the Identity Mapping Object Key of this object.
| campusObjectType | Object Key Data Source |
|---|
| ProgramParticipation | participationID |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|
| programs | Put | The primary table used for sending data for this resource. |
| programparticipation | Put | The primary table used for sending data for this resource. |
Object Data Elements
Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.
Flags
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M, C, or O | Data Source GUI Path | Database Field |
|---|
educationOrganization
Reference | The identifier assigned to an education organization. | Report the School Entity ID. | M | System Administration > Resources > School editor > Entity ID | school.entityid |
| programReference | The identifier assigned to an education organization. | - Program Type:
- Report 'Support Program' when the Ed-Fi Code of the mapped dictionary value is any of the following (program ID =60):
- 28,
- 29,
- 30,
- 31,
- 32,
- 33,
- 35,
- 36,
- 38,
- 40,
- 41,
- Report 'Grand Canyon Diploma' when the Ed-Fi code of the mapped dictionary value is 'Grand Canyon Diploma'.
- Report 'Dropout Recovery Program' when the Ed-FI code of the mapped dictionary value is = Dropout Recovery Program.
- Program Education Organization Id: Report the District Entity ID from the School Editor if populated.
- If NULL, report the District Entity ID.
- Program Name: Reports the Program Code + Program Name.
| M | Programs > Flags > State Program Code
System Administration > Resources > Resources > School Editor > District Entity ID
OR
System Administration > Resources > Resources > District Information > Entity ID
| program.code customschool. districtentityid
or
customdistrict.entityid |
| studentReference | A reference to the related Student resource. | Reports the Student Reference
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
| beginDate | The month, day, and year on which the Student first received services. | - Report the start date from the Flag if:
- Flag Start Date must be after enrollment Start Date.
- Enrollment End Date must be NULL or after Flag start date.
- Report the Enrollment Start Date if:
- Enrollment Start Date is after the Flag Start Date.
- Flag End Date is NULL or after Enrollment Start Date.
- If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date.
- The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
| M | Student Information > General > Flags > Start Date
OR
Enrollment Start Date | programparticipation.
StartDate |
| endDate | The month, day, and year on which the Student exited the Program or stopped receiving services. | - Report the end date from Flag if populated.
- Flag End Date must be before Enrollment End Date or before last instructional day of the calendar.
Report Enrollment End Date if populated. - Else, report the last instructional date from the calendar where the student is enrolled.
- If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date.
- The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
| C | Student Information > General > Program Participation
Student Information > General > Enrollments > End Date | programparticipation.
EndDate
enrollment.endDate |
reasonExitedDescriptor | The reason the child left the Program within a school or district. | - Report from Flags > Exit Reason if <> NULL, and dictionary value is mapped in the Ed-Fi Resource Preferences area.
- Otherwise, do not report.
|
| Programs > Flags > Exit Reason |
|
Gifted
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|
educationOrganization
Reference | The identifier assigned to an education organization. | Report the School Entity ID. | M | System Administration > Resources > School editor > Entity ID | school.entityid |
| programReference | The identifier assigned to an education organization. | - Program Type:
- Report 'Gifted and Talented'.
- Program Education Organization Id: Report the District Entity ID from the School Editor if populated
- If NULL, report the District Entity ID.
- Program Name: Reports '35 Gifted Program'.
| M | System Administration > Resources > Resources > School Editor > District Entity ID
OR
System Administration > Resources > Resources > District Information > Entity ID
|
customschool. districtentityid or customdistrict.entityid |
| studentReference | A reference to the related Student resource. | Reports the Student Reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
| beginDate | The month, day, and year on which the Student first received services. | - Report the start date from the Gifted record if:
- Gifted Start Date must be after enrollment Start Date.
- Enrollment End Date must be NULL or after Gifted start date.
- Report the Enrollment Start Date if:
- Enrollment Start Date is after the Gifted Start Date.
- Gifted End Date is NULL or after Enrollment Start Date.
Note:- If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date.
- The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status. - If there are multiple gifted records, combine the records and report the earliest start date for the Gifted Start Date.
| M | Student Information > Program Participation > Gifted > Start Date |
|
| endDate | The month, day, and year on which the Student exited the Program or stopped receiving services. | - Report the end date from Gifted record if populated:
- Gifted record End Date must be before Enrollment End Date or before last instructional day of the calendar.
Report Enrollment End Date if populated: - Else, report the last instructional date from the calendar where the student is enrolled.
Noes: - If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date.
- The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
- If there are multiple gifted records, combine the gifted records and report the latest end date for the Gifted End Date.
| C | Student Information > Program Participation > Gifted > End Date |
|
| reasonExitedDescriptor | The reason the child left the Program within a school or district. | Do Not Report. |
|
|
|
21 CCLC
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|
educationOrganization
Reference | The identifier assigned to an education organization. | Report the School Entity ID. | M | System Administration > Resources > School editor > Entity ID | school.entityid |
| programReference | The identifier assigned to an education organization. | - Program Type:
- Report 'Support Program'.
- Program Education Organization Id: Report the District Entity ID from the School Editor if populated.
- If NULL, report the District Entity ID.
- Program Name: Reports '21st CCLC'.
| M | System Administration > Resources > Resources > School Editor > District Entity ID
OR
System Administration > Resources > Resources > District Information > Entity ID
|
customschool. districtentityid or customdistrict.entityid |
| studentReference | A reference to the related Student resource. | Reports the Student Reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
| beginDate | The month, day, and year on which the Student first received services. | - Report the start date from the 21st CCLC record.
| M | Student Information > Program Participation > State Programs > 21st CCLC > Start Date |
|
| endDate | The month, day, and year on which the Student exited the Program or stopped receiving services. | - Report the lesser of the 3 following dates:
- 21st CCLC program record end date
- 21st CCLC enrollment end date
- Identified by an enrollment with a Local Service type of 'O: Program Only' that overlaps the 21st CCLC program record.
- Last Instructional Date from the calendar where the student's 21st CCLC enrollment is.
| C | Student Information > Program Participation > State Programs > 21st CCLC > End Date |
|
| reasonExitedDescriptor | The reason the child left the Program within a school or district. | - Report from Exit Reason if <> NULL, and dictionary value is mapped in the EdFi Resource Preferences area.
- Otherwise, do not report.
|
| Student Information > Program Participation > State Programs > 21st CCLC > Exit Reason |
|
Title 1
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|
educationOrganization
Reference | The identifier assigned to an education organization. | Report the School Entity ID. | M | System Administration > Resources > School editor > Entity ID | school.entityid |
| programReference | The identifier assigned to an education organization. | - Program Type:
- Report 'Support Program' when the mapped Ed-Fi Code is one of the following: 28, 29, 30, 31, 32, 38, 39, 40, 41, IM.
- Program Education Organization Id: Report the District Entity ID from the School Editor if populated.
- If NULL, report the District Entity ID.
- Program Name: Reports the Program Code + Program Name
| M | Programs Participation > Title 1 > Title 1 record > Title 1 Service
System Administration > Resources > Resources > School Editor > District Entity ID
OR
System Administration > Resources > Resources > District Information > Entity ID
| program.code customschool. districtentityid
or customdistrict. entityid |
| studentReference |
| Reports the Student Reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
| beginDate | The month, day, and year on which the Student first received services. | - Report the start date from the Title 1 record.
- If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date.
- The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
| M | Programs Participation > Title 1 > Title 1 record > Start Date | programparticipation.
StartDate |
| endDate | The month, day, and year on which the Student exited the Program or stopped receiving services. | - Report the end date from the Title 1 record if populated.
- If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date.
- The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
| C | Programs Participation > Title 1 > Title 1 record > End Date | programparticipation.
EndDate |
| reasonExitedDescriptor | The reason the child left the Program within a school or district. | Do not report. |
|
|
|
EL
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M,C, or O | Data Source GUI Path | Database Field |
|---|
educationOrganization
Reference | The identifier assigned to an education organization. | Report the School Entity ID. | M | System Administration > Resources > School editor > Entity ID | school.entityid |
| programReference | The identifier assigned to an education organization. | - The Program Type = 'ELL'
- Program Type ID = 1
- Program Education Organization Id: Report the District Entity ID from the School Editor if populated.
- If NULL, report the District Entity ID.
- Program Name: Reports the Program Code + Program Name
|
|
|
|
| studentReference |
| Reports the Student Reference.
Note: The Ed-Fi ID reports from the Student State ID field. |
|
|
|
| beginDate | The month, day, and year on which the Student first received services. | - Report the start date from the EL Service if:
- EL Service Start Date is after enrollment Start Date.
- Enrollment End Date must be NULL or after EL Service start date.
- Report the Enrollment Start Date if:
- Enrollment Start Date is after the EL Service Start Date.
- EL Service End Date is after the Enrollment Start Date.
- If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date.
- The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
| M | Student Information > General> Program Participation > EL > EL Services > Start Date
or
Student Information > General > Enrollments > Start Date | lepservice. StartDate or enrollment. startdate |
| endDate | The month, day, and year on which the Student exited the Program or stopped receiving services. | - Report the end date from EL Service if populated
- EL Service End Date must be before Enrollment End Date or before last instructional day of the calendar.
- Report Enrollment End Date if populated.
- Else, report the last instructional date from the calendar where the student is enrolled.
- If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date.
- The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
| C | Student Information > General > Program Participation > EL > EL Services > End Date
or
Student Information > General > Enrollments > End Date | lepservice. EndDate or enrollment. EndDate |
| reasonExitedDescriptor | The reason the child left the Program within a school or district. | - Report the mapped Ed-Fi Code from the Exit Reason selected on the EL Service if populated.
- Report ELL02 if Enrollment End Date is populated and End Status is W1-13, W21-22, W41, or W51.
- Program End Date must be null or on or after the Enrollment End Date.
- Report ELL08 if Enrollment End Date is populated and End Status is 'WK'.
- Program End Date must be null or on or after the Enrollment End Date.
- Else, report ELL06.
|
| Student Information > General > Program Participation > EL > EL Services > Exit Reason |
|
