Arizona Ed-Fi Data v3.5 - Student Needs
Last Modified on 11/18/2024 10:43 am CST
Needs are reported from the Enrollment > State Reporting fields, FRAM, Flags, locked IEPs and LEP Services. This resource identifies any needs that a student may need to participate in for a program.
Object Triggering Logic
The tables below describe the logic for triggering syncing of this object. Expand one of the areas below to see full requirements:
Flags and Programs
This reports from BOTH Programs and Flags. Districts should choose only ONE method and stay consistent. When a need is created in both areas, two records are sent.
Click here to expand...
Action | Trigger |
---|
Post | Report a record based on the students enrollment record: Service Type = P. |
Post | When a Flag/Program is created and saved for a student that is mapped to a state program code. - The Flag/Program start date must be on or after enrollment start date.
|
Post | When a Need is changed on an existing Flag/Program for a student with a need populated. |
Post | When a new enrollment is created for a student that has an active Flag/Program mapped to a state program code. - Enrollment start date must be after Flag/Program start date.
- Flag/Program end date must be NULL or after enrollment start date.
- When the enrollment overlaps an existing enrollment within the same school, follows the post requirements based on the student's enrollment record, otherwise a new record is posted.
|
Delete/Post | When a start or end date is entered or changed for an existing record. - When a Need is posted from the Flag/Program, updates when the start or end date changes.
- When a Need is posted from Enrollment, updates when the start or end date changes.
- When the student has two of the same flags/programs with the same start date and one record is deleted, the remaining record's data posts.
|
Delete/Post | When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13. |
Delete | Deletes the existing record when a need is changed on an existing flag/program. |
Delete | Flag/Program is deleted for a student. |
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 - When 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.
- When 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:
- Reports 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.
- Reports 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. When an enrollment end date is blank, sets end date to the calendar end date.
- Only sends a record for enrollments that have a Local Service Type other than P:Primary when 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.
- Does 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
- When the Enrollment Resident District does not match the District Information > State District Number, all credentials are reviewed and compared to the District Number.
- Does not send a record for an enrollment that is marked as State Exclude or No Show.
- Does not send a record when an enrollment is in a calendar marked as State Exclude.
- Does not send a record when the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
- Does not send records when 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 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.
|
Delete/Post | When the Gifted Need dropdown is changed on an existing Gifted record for a student. |
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.
- When 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.
|
Post | When a start or end date is entered or changed for an existing record:- When a Need was posted from a Gifted record, updates when the start or end date was changed.
- When a Need was posted from Enrollment updates when the start or end date was changed.
- When the student has two of the same Gifted records (ie. the Gifted Need dropdown is the same between the records) with the same start date and one record is deleted, the remaining record's data posts.
|
Delete/Post | When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13. |
Delete | Delete the existing need when a need is changed on an existing Gifted record. |
Delete | Gifted record is deleted for a student. |
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/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'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. |
Homebound
Click here to expand...
Action | Trigger |
---|
Post | Reports a record based on the students enrollment record: Service Type = P |
Post | When a Homebound record is created and saved for a student: - Homebound start date must be on or after enrollment start date.
|
Post | When a new enrollment is created for a student that has an active Homebound record:- Enrollment start date must be after Homebound start date.
- Homebound end date must be NULL or after enrollment start date.
- When an enrollment overlaps an existing enrollment within the same school, follows the Post rules above, otherwise posts new record.
|
Post | When a start or end date is entered or changed for an existing record:- When a Need was posted from a Homebound record, updates when the start or end date was changed.
- When a Need was posted from Enrollment, updates when the start or end date was changed.
|
Delete/Post | When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13. |
Delete | Homebound record is deleted for a student. |
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/Post | When the enrollment tied to the Homebound 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 | Homebound 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. |
Homeless
Click here to expand...
Action | Trigger |
---|
Post | When a Homeless record is created and tied to a valid Enrollment record. |
Post | When a Homeless record overlaps the student's Enrollment record for that school. - The Homeless record start date is on or after enrollment start date.
- The Homeless record start date is before enrollment start date, and the Homeless record end date is either null or after the enrollment start date.
- When 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.
|
Post | When a new enrollment for the same school indicated in a pre-existing Homeless 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 for an existing Homeless 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 Homeless program is changed on an existing record. |
Delete/Post | When the enrollment tied to the Homeless 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/Post | Homeless record is deleted. - When the student has two or more Homeless records with the same Homeless Residence and Start Date, do not delete the record unless all programs or needs associated with the primary keys are deleted.
|
Delete | Homeless 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. |
Unaccompanied Youth
Click here to expand...
Action | Trigger |
---|
Post | When a Homeless record is created and tied to a valid Enrollment record and the Unaccompanied Youth dropdown is set to 'Yes'. |
Post | When a Homeless record with the Unaccompanied Youth dropdown is set to Yes overlaps the student's Enrollment record for that school.- The Homeless record start date is on or after enrollment start date.
- The Homeless record start date is before enrollment start date, and the Homeless record end date is either null or after the enrollment start date.
- When an enrollment overlaps an existing enrollment within the same school, follows rules within requirement R1, otherwise post new record.
|
Post | When a new enrollment for the same school indicated in a pre-existing Homeless record where the Unaccompanied Youth dropdown is set to Yes 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 Homeless record where the Unaccompanied Youth dropdown is set to Yes. |
Delete/Post | When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13. |
Delete/Post | When the Homeless program where the Unaccompanied Youth dropdown is set to Yes is changed on an existing record. |
Delete/Post | When the enrollment tied to the Homeless record where the Unaccompanied Youth dropdown is set to 'Yes' 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/Post | Homeless record where the Unaccompanied Youth dropdown is set to 'Yes' is deleted.- When the student has two or more Homeless records with the same Homeless Residence and Start Date and both have the Unaccompanied Youth dropdown set to Yes, does not delete the record unless all programs or needs associated with the primary keys are deleted.
|
Delete | The start date or end date is changed on a homeless record where the Unaccompanied Youth dropdown is set to 'Yes', 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. - When 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.
- When 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 need 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 need 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. When enrollment end date is blank, set end date to the calendar end date.
- Only send a need for enrollments that have a Local Service Type other than P:Primary when 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.
- Does not send a record for enrollments that have a Local Service Type OTHER than P:Primary OR T:AO AND the enrollment Resident District does not match the following:
- District Information > State District Number
- When the Enrollment Resident District does not match the District Information > State District Number, all of the credentials are viewed and compared to the District Number.
- Does not send a student record for an enrollment that is marked as State Exclude or No Show.
- Does not send a record when the enrollment is in a calendar marked as State Exclude.
- Does not send a record when the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
- Does not send records when 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. - When 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. |
Eligibility (FRAM)
Click here to expand...
Action | Trigger |
---|
Post | Report a record based on the students enrollment record: Service Type = P. - When 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.
- When 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:
- Reports a need 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.
- Reports a second need 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. When an enrollment end date is blank, sets end date to the calendar end date.
- Only sends a need for enrollments that have a Local Service Type other than P:Primary when 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.
- Does 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
- When enrollment Resident District does not match the District Information > State District Number, all credentials are reviewed and compare to the District Number.
- Does not send a record for an enrollment that is marked as State Exclude or No Show.
- Does not send a record when an enrollment is in a calendar marked as State Exclude.
- Does not send a record when the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
- Does not send records when the Grade Level Exclude check box is checked in the grade level record tied to the calendar the student is enrolled in.
|
Post | When an Eligibility is created and saved for a student that is mapped to a state program code of 4 or 5 - Eligibility start date must be on or after enrollment start date.
|
Post | When an Eligibility is changed on an existing Eligibility record for a student mapped to a state program code of 4 or 5. |
Post | When a new enrollment is created for a student that has an active Eligibility. - Enrollment start date must be after Eligibility start date.
- Eligibility end date must be after enrollment start date.
- When 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. - When a Need was posted from Eligibility, updates when the start or end date was changed.
- When a Need was posted from Enrollment, updates when the start or end date was changed.
|
Delete/Post | When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13. |
Delete | Deletes the existing need when the Eligibility status is changed to a status not mapped to a state program code of 4 or 5. |
Delete | Eligibility is deleted for a student. |
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. |
Special Ed - IEP
Click here to expand...
Action | Trigger |
---|
Post | Report one record for each Primary/Secondary SPED Services School with a student having a new IEP created and saved for a student and locked in a given scope year. When a student has multiple overlapping enrollments within the primary/secondary school, report from the enrollment with a Local Service Type of 'P: Primary'. When a student has multiple overlapping enrollments within the primary/secondary school, but no 'P: Primary' enrollment, report the 'T: AOI' enrollment. When a student has multiple overlapping enrollments within the primary/secondary school, but no 'P: Primary' or 'T: AOI' enrollment, report the most recent 'A: Ancillary' enrollment. When a student has multiple overlapping enrollments within the primary/secondary school, but no 'P: Primary', 'T: AOI', or 'A: Ancillary' enrollment, report the most recent 'O: Program Only' enrollment. When Primary/Secondary Services dropdowns are not populated, report from the enrollment that overlaps the IEP dates that has a IC Service Type of 'P: Primary'. - Do not send a record for an enrollment that is marked as State Exclude or No Show.
- Do not send a record when enrollment is in a calendar marked as State Exclude.
- Do not send a record when the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
|
Post | When a new IEP is created and saved for a student and locked in a given scope year. - IEP start date must be on or after enrollment start date and on or before enrollment end date.
- The following fields must be <>NULL: Sped Status, Disability.
|
Post | When a new enrollment is created for a student that has an existing IEP. - Enrollment start date must be after IEP start date.
- IEP end date must be NULL or after Enrollment start date.
- When the student has more than 1 IEP started in previous schools years, only report the most recent IEP.
- When 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.
|
Post | When a Disability is changed in an existing IEP |
Delete/Post | When a start or end date is entered or changed for an existing record. - When Need was posted from IEP, update when start or end date was changed.
- When Need was posted from Enrollment, update when start or end date was changed.
|
Delete/Post | When the student has two locked IEPs with the same start date and 1 record is deleted or unlocked, the remaining IEP posts. |
Delete/Post | When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13. |
Delete/Post | When an Exit Eval is entered for a student, update the end date of the active IEP. |
Delete | IEP is deleted for a student. |
Delete | A disability is changed for a student. |
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 | When the IEP Start or End Dates OR the Enrollment Start or End Dates have been updated so the IEP and Enrollment no longer overlap, delete the record when one was created. |
Delete | When a plan is unlocked. |
EL Services
Click here to expand...
Action | Trigger |
---|
Post | Report a record based on the students enrollment record: Service Type = P. - When 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.
- When 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 need 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 need 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. When enrollment end date is blank, set end date to the calendar end date.
- Only send a need for enrollments that have a Local Service Type other than 'P:Primary' when 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 when the enrollment Resident District does not match the following:
- District Information > State District Number
- When 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 when enrollment is in a calendar marked as State Exclude.
- Do not send a record when the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
- Do not send records when the Grade Level Exclude check box is checked in the grade level record tied to the calendar the student is enrolled in.
|
Post | When an EL Service is created and saved for a student that is mapped to a state program code and overlaps the student's Enrollment record for that school. - The EL Service record start date is on or after enrollment start date.
- The EL Service record start date is before enrollment start date, and the EL Service record end date is either null or after the enrollment start date.
|
Post | When an EL 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 EL Service. - Enrollment start date must be after EL Service start date.
- The enrollment start date is before the EL Service start date, and the enrollment end date is either null or after the EL Service start date.
- When 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. - When Need was posted from EL Service, update when start or end date was changed.
- When Need was posted from Enrollment update when start or end date was changed.
|
Delete/Post | When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13. |
Delete | Delete the existing need when an EL Service is changed to a status not mapped to a state program code. |
Delete | An EL Service is deleted for a student. |
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. |
Scope Year Logic
The tables below describe scope year logic of this object. Expand one of the areas below to see full requirements:
Flags and Programs
Click here to expand...
Logic |
---|
When a new Flag/Program is created, the record reports in the Scope Year that the record start date overlaps with. - The start date must be on or before the School Year End Date. When School Year End Date is NULL, 6/30/XXXX is used as the default date.
- Data only sends for the years that have valid configuration.
|
When the record is triggered from enrollments, the record sends to the scope year for the school year the enrollment is associated with. - Data only sends for the years that have valid configuration.
|
Gifted
Click here to expand...
Logic |
---|
When a new Gifted record is created, the record reports in the Scope Year that the record start date overlaps with. - The start date must be on or before the School Year End Date. When School Year End Date is NULL, 6/30/XXXX is used as the default date.
- Data only sends for the years that have valid configuration.
|
When the record is triggered from enrollments, the record sends to the scope year for the school year the enrollment is associated with. - Data only sends for the years that have valid configuration.
|
Homebound
Click here to expand...
Logic |
---|
When a new Homebound record is created, the record reports in the Scope Year that the record start date overlaps with. - The start date must be on or before the School Year End Date. When School Year End Date is NULL, 6/30/XXXX is used as the default date.
- Data only sends for the years that have valid configuration.
|
When the record is triggered from enrollments, the record only sends to the scope year for the school year the enrollment is associated with. - Data only sends for the years that have valid configuration.
|
Homeless
Click here to expand...
Logic |
---|
The record sends to the scope year for the school year the enrollment is associated with. - Data only sends for the years that have valid configuration.
|
Unaccompanied Youth
Click here to expand...
Logic |
---|
The record sends to the scope year for the school year the enrollment is associated with. - Data only sends for the years that have valid configuration.
|
Title 1
Click here to expand...
Logic |
---|
The record sends to the scope year for the school year the enrollment is associated with. - Data only send for the years that have valid configuration.
|
Eligibility (FRAM)
Click here to expand...
Logic |
---|
A record reports when an Eligibility is created and saved that is aligned to a scoped year. - Data only sends for the years that have valid configuration.
|
When using data in Campus that have start and end dates, the following logic is applied to determine the scope year(s) to report the data to. - Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date.
- Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. When blank, the default date of 6/30/xxxx is used.
- Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. When blank, the default date of 7/01/xxxx is used.
|
Special Ed - IEP
Click here to expand...
Logic |
---|
When a new IEP is created, the record reports in the Scope Year that the IEP Start Date overlaps with. - The start date must be on or before the School Year End Date. When School Year End Date is NULL, 6/30/XXXX is used as the default date.
- Data only sends for the years that have valid configuration.
|
When the record is triggered from enrollments, the record sends to the scope year for the school year the enrollment is associated with. - Data only sends for the years that have valid configuration
|
EL Services
Click here to expand...
Logic |
---|
When a new EL Service is created, the record reports in the Scope Year that the IEP Start Date overlaps with. - The start date must be on or before the School Year End Date. When School Year End Date is NULL, 6/30/XXXX is used as the default date.
- Data only sends for the years that have valid configuration.
|
When the record is triggered from enrollments, the record sends to the scope year for the school year the enrollment is associated with. - 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 |
---|
Homeless Primary Nighttime Residence Descriptors | Homeless Primary Night Time Residence |
Student Needs Descriptors | Enrollment Primary Disability |
POSEligibility Eligibility |
ProgramParticipation Need |
Title1 Instructional Services |
Gifted Need |
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. Expand one of the areas below to see full requirements:
Flags and Programs
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
---|
id | The unique identifier of the resource. |
| M |
|
|
Education Organization Reference | A reference to the related Education Organization resource. | Report the School Entity ID. | M | School Information > Entity ID | school.entity id |
studentReference | A reference to the related Student resource. | Report the student reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
studentNeed Descriptor | The program descriptor of the student need. | - Report based on the mapped value indicated in the EdFi mapping tool, when it exists, tied to the attribute dictionary item selected.
- When a mapping does not exist, do not report.
| M | Flags > Need | programparticipation. need |
studentNeedEntry Date | The date the student was identified with the need. | - Report the start date from the Flag when:
- 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 when:
- Enrollment Start Date is after the Flag Start Date.
- Flag End Date is NULL or after Enrollment Start Date.
- When 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 | Flags > Start Date
OR Enrollment Start Date | programparticipation. StartDate or enrollment.startdate |
StudentNeedExit Date | The date the student is no longer identified with the need. | - Report the end date from Flag when populated.
- Flag End Date must be before Enrollment End Date or before last instructional day of the calendar.
Report Enrollment End Date. - Else, report the last instructional date from the calendar where the student is enrolled.
- When 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 | Flags > End Date
OR Enrollments > Enrollment End Date
OR Day Setup | programparticipation. EndDate or enrollment.enddate |
primaryStudentNeed Indicator | Indicates when this is a primary need for the student. | Do not report, not required from Flags. | O |
|
|
_etag |
|
| O |
|
|
Gifted
Click here to expand...
Data Element Label | Business Requirement | Localized Logic | M, C or O | Data Source GUI Path | Database Field |
---|
id | The unique identifier of the resource. |
| M |
|
|
EducationOrganizationReference | A reference to the related Education Organization resource. | - Report the School Entity ID.
| M | School Information > Entity ID | school.entity id |
studentReference | A reference to the related Student resource. | Report the student reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
studentNeedDescriptor | The program descriptor of the student need. | - Report Code value from the Gifted Need dropdown.
| M | Gifted > Gifted Need |
|
studentNeedEntryDate | The date the student was identified with the need. | - Report the start date from the Gifted record when:
- 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 when:
- Enrollment Start Date is after the Gifted Start Date.
- Gifted End Date is NULL or after Enrollment Start Date.
- When 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 | Gifted > Start Date
OR
Enrollment Start Date |
enrollment.startdate |
StudentNeedExitDate | The date the student is no longer identified with the need. | - Report the end date from the Gifted record when populated:
- Gifted End Date must be before Enrollment End Date or before last instructional day of the calendar.
Report Enrollment End Date: - Else, report the last instructional date from the calendar where the student is enrolled.
- When 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 | Gifted > End Date OR Enrollment End Date OR Day Setup |
enrollment.enddate |
primaryStudentNeedIndicator | Indicate when this is a primary need for the student. | - Do not report, not required from Gifted record.
| O |
|
|
_etag |
|
| O |
|
|
Homebound
Click here to expand...
Data Element Label | Business Requirement | Localized Logic | M, C or O | Data Source GUI Path | Database Field |
---|
id | The unique identifier of the resource. |
| M |
|
|
EducationOrganization Reference | A reference to the related Education Organization resource. | Report the School Entity ID.
| M | School Information > Entity ID | school.entity id |
studentReference | A reference to the related Student resource. | Report the student reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
studentNeedDescriptor | The program descriptor of the student need. | Report the code '11' for Homebound when a Needs record stems from a Homebound Tab record. | M | Homebound |
|
studentNeedEntryDate | The date the student was identified with the need. | - Report the start date from the Homebound record when:
- Homebound Start Date must be after enrollment Start Date.
- Enrollment End Date must be NULL or after Homebound start date.
- Report the Enrollment Start Date when:
- Enrollment Start Date is after the Homebound Start Date.
- Homebound End Date is NULL or after Enrollment Start Date.
- When 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 | Homebound > Start Date
OR Enrollment Start Date | enrollment.startdate |
StudentNeedExitDate | The date the student is no longer identified with the need. | - Report the end date from the Homebound record when populated.
- Homebound End Date must be before Enrollment End Date or before last instructional day of the calendar.
Report Enrollment End Date. - Else, report the last instructional date from the calendar where the student is enrolled.
- When 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 | Homebound > End Date
OR Enrollment End Date
OR
Day Setup | enrollment.enddate |
primaryStudentNeedIndicator | Indicate when this is a primary need for the student. | - Do not report, not required from Homebound record.
| O |
|
|
_etag |
|
| O |
|
|
Homeless
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
---|
id | The unique identifier of the resource. |
| M |
|
|
EducationOrganization Reference | A reference to the related Education Organization resource. | Report the School Entity ID. | M | School Information > Entity ID | school.entityid |
studentReference | A reference to the related Student resource. | Report the student reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
studentNeed Descriptor | The program descriptor of the student need. | Report the code '6' for Homeless when a Needs record stems from a Homeless record. | M | Homeless | n/a |
studentNeedEntry Date | The date the student was identified with the need. | - Report the latest date of the following date fields:
- Homeless Start Date.
- Enrollment Start Date (for enrollment tied to Homeless record).
- When 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 | Homeless > Start Date
OR Enrollments > Start Date | ic_Homeless.startDate enrollment.startdate |
StudentNeedExitDate | The date the student is no longer identified with the need. | - Report the earliest date of the following date fields:
- Homeless End Date.
- Enrollment End Date (for enrollment tied to Homeless record).
- The last instructional day of the calendar the student is enrolled.
- When 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 | Homeless > End Date
Enrollments > End Date | ic_Homeless.endDate
enrollment.enddate |
primaryStudentNeed Indicator | Indicates when this is a primary need for the student. | Do not report, not required for Homeless. | O |
|
|
primaryNightTime ResidenceDescriptor | Reports the student's Primary Night Time Residence. | - Report from the Homeless Residence field on student's Homeless record.
- When blank, do not report.
- Report the Ed-Fi code value.
| C | Homeless > Homeless Residence | enrollmentaz.homeless Residence |
_etag | A unique system-generated value that identifies the version of the resource. |
| O | N/A | N/A |
Unaccompanied Youth
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
---|
id | The unique identifier of the resource. |
| M |
|
|
EducationOrganization Reference | A reference to the related EducationOrganization resource. | Report the School Entity ID. | M | School Information > Entity ID | school.entityid |
studentReference | A reference to the related Student resource. | Report the student reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
studentNeed Descriptor | The program descriptor of the student need. | Report the code '21' for Unaccompanied Youth when a Needs record stems from a Homeless Tab record where the 'Unaccompanied Youth' dropdown is set to 'Y'. | M | Homeless > Unaccompanied Youth |
|
studentNeedEntry Date | The date the student was identified with the need | Reports the latest date of the following date fields: - Homeless Start Date.
- Enrollment Start Date (for enrollment tied to Homeless record).
- When 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 | Homeless > Start Date
OR Enrollments > Start Date
| ic_Homeless.startDate enrollment.startdate
|
StudentNeedExitDate | The date the student is no longer identified with the need. | Report the earliest date of the following date fields: - Homeless End Date
- Enrollment End Date (for enrollment tied to Homeless record)
- The last instructional day of the calendar the student is enrolled.
- When 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 | Homeless > End Date
OR Enrollments > End Date
| ic_Homeless.endDate enrollment.enddate
|
primaryStudentNeed Indicator | Indicates when this is a primary need for the student. | Do not report, not required for Homeless. | O |
|
|
primaryNightTime ResidenceDescriptor | Reports the student's Primary Night Time Residence. | Report from the Homeless Residence field on student's Homeless record- When blank, do not report.
- Report the Ed-Fi code value.
| C | Homeless > Homeless Residence | enrollmentaz.homeless Residence |
_etag | A unique system-generated value that identifies the version of the resource. |
| O | N/A | N/A |
Title 1
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
---|
id | The unique identifier of the resource. |
| M |
|
|
Education Organization Reference | A reference to the related Education Organization resource. | Report the School Entity ID. | M | School Information > Entity ID | school.entityid |
studentReference | A reference to the related Student resource. | Report the student reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
studentNeed Descriptor | The program descriptor of the student need. | Report based on the mapped value indicated in the EdFi mapping tool, when it exists, tied to the attribute dictionary item selected. - When a mapping does not exist, do not report.
Note, this is likely how this should be set up: Title 1 Program Droplist (code: name) | studentNeed Descriptor | code |
---|
28: Title I Math | Math | 13 | 29: Title I Other | Other Academic Services | 19 | 30: Title I Reading | Language Arts (reading and/or writing) | 14 | 31: Title I Science | Science | 15 | 32: Title I Social Studies | Social Studies | 18 |
| M | Title 1 > Title 1 Service | ic_Title1.title1 Services |
studentNeedEntry Date | The date the student was identified with the need | - Report the latest date of the following date fields:
- Title 1 Start Date
- Enrollment Start Date (for enrollment tied to Title 1 record)
- When 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 | Title 1 > Start Date
OR Enrollments > Start Date | Title1.startDate enrollment.startdate |
StudentNeedExit Date | The date the student is no longer identified with the need. | - Report the earliest date of the following date fields:
- Title 1 End Date.
- Enrollment End Date (for enrollment tied to Title 1 record).
- The last instructional day of the calendar the student is enrolled.
- When 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 | Title 1 > End Date
OR Enrollments > End Date | Title1.endDate
enrollment. enddate |
primaryStudentNeed Indicator | Indicates whether this is a primary need for the student. | Do not report, not required for Title 1. | O |
|
|
primaryNightTime ResidenceDescriptor | Reports the student's Primary Night Time Residence. | Do not report, not required for Title 1. | C |
|
|
_etag | A unique system-generated value that identifies the version of the resource. |
| O | N/A | N/A |
Eligibility (FRAM)
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
---|
id | The unique identifier of the resource |
| M |
|
|
EducationOrganization Reference | A reference to the related Education Organization resource. | Report the School Entity ID. | M | School Information > Entity ID | school.entity id |
studentReference | A reference to the related Student resource. | Report the student reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
studentNeed Descriptor | The program descriptor of the student need. | Reports based on the mapped value indicated in the EdFi mapping tool, when it exists, tied to the attribute dictionary item selected. - When a mapping does not exist, does not report.
Note this is likely how this should be set up: State Eligibility Code | Post-Amble 2019 (and future) | Post-Amble 2018 (and older) |
---|
'5' (Free) | '28' (Income Eligibility 1) | '5' (NCLB Indicator 1) | '4' (Reduced) | '29' (Income Eligibility 2) | '4' (NCLB Indicator 2) | Anything else | Do not report. | Do not report. |
| M | Eligibility > eligibility record > State Eligibility Code |
|
studentNeedEntry Date | The date the student was identified with the need. | - Reports the start date from the Eligibility when:
- Eligibility Start Date is after enrollment Start Date.
- Enrollment End Date must be NULL or after Eligibility start date.
- Reports the Enrollment Start Date when:
- Enrollment Start Date is after the Eligibility Start Date.
- Eligibility End Date is after the Enrollment Start Date.
- When 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 |
|
|
StudentNeedExit Date | The date the student is no longer identified with the need. | - Reports the end date from Eligibility when populated.
- Eligibility End Date must be before Enrollment End Date or before last instructional day of the calendar.
Report Enrollment End Date. - Else, report the last instructional date from the calendar where the student is enrolled.
- When 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 |
|
|
primaryStudent NeedIndicator | Indicates whether this is a primary need for the student. | Do not report, not required for Eligibility. | O |
|
|
_etag |
|
| O |
|
|
Special Ed - IEP
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
---|
id | The unique identifier of the resource. |
| M |
|
|
EducationOrganization Reference | A reference to the related Education Organization resource. | - When the Primary SPED Services School is populated on the locked IEP, report the School Entity ID from the school selected.
- When the Secondary SPED Services School is populated on the locked IEP, report the School Entity ID from the school selected.
- Report the School Entity ID.
| M | Documents > AZ locked Plan > Enrollment Status > Primary SPED Services School
Documents > AZ locked Plan > Enrollment Status > Secondary SPED Services School System Administration> Resources> School editor> Entity ID
| school.entity id |
studentReference | A reference to the related Student resource. | Report the student reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
studentNeedDescriptor | The program descriptor of the student need. | Report the value from the Ed-Fi mapping field on the Disability selected on the locked IEP.
When the student has more than 1 Disability, 1 need record for each distinct Disability selected. | M | Documents > AZ locked Plan>Enrollment Status>Primary Disability | PlanState.disability1 OR PlanState.disability2 PlanState.disability3 PlanState.disability4 PlanState.disability5 |
studentNeedEntry Date | The date the student was identified with the need. | - Report the start date from the IEP when:
- IEP Start Date is after enrollment Start Date.
- Enrollment End Date must be NULL or after IEP start date.
- Report the Enrollment Start Date when:
- Enrollment Start Date is after the IEP Start Date.
- IEP End Date is after the Enrollment Start Date.
Notes: - When 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.
- Note, 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.
- Use the enrollment that is tied to the primary/secondary services school when populated, otherwise use the enrollment that has an IC Service Type of P: Primary.
| M | Documents > AZ locked Plan>Education Plan>IEP Start Date
OR
Enrollments> Start Date | Plan.startDate OR enrollment. startdate |
StudentNeedExit Date | The date the student is no longer identified with the need. | - When Enrollment End Date is NOT null
- Report the earliest of the following dates:
- Exit Date from the most recent Evaluation of the type 'Exit'.
Enrollment End Date - IEP End Date
- When Enrollment End Date IS null:
- When an IEP exists starting immediately after an existing plan or an IEP has an end date that is prior to the last instructional day of the school year or the most recent Evaluation of type 'Exit' has an exit reason of SPED01 or SPED09, report the earliest of the IEP end date and Evaluation Exit Date.
- When an IEP does not have an end date and a new IEP is created, report the last instructional day that occurs right before the start date of the new IEP.
- Otherwise, report blank.
Notes: - Whatever end date is sending (minimum of plan end, exit eval or enrollment end date), when it is not an instructional date, take the most previous instructional date and send that.
- When 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.
- Note, 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.
- Use the enrollment that is tied to the primary/secondary services school when populated, otherwise use the enrollment that has an IC Service Type of P: Primary.
| C | Documents > AZ locked Evaluation>Exit Evaluation> Exit Date
OR Enrollments> End Date
| Evaluation. exitDate OR
enrollment.
enddate |
primaryStudent NeedIndicator | Indicates when this is a primary need for the student. | - Report 'True' when the need reported is the Primary Disability.
- Report 'False' when the need reported is not the Primary Disability.
| O | Documents > AZ locked Plan > Enrollment Status > Primary, Secondary, Tertiary, |
|
_etag |
|
| O |
|
|
EL Services
Click here to expand...
Data Element Label | Business Requirement | Business Rules | M, C or O | Data Source GUI Path | Database Field |
---|
id | The unique identifier of the resource. |
| M |
|
|
EducationOrganization Reference | A reference to the related Education Organization resource. | Report the School Entity ID. | M | School Information > Entity ID | school.entity id |
studentReference | A reference to the related Student resource. | Report the student reference.
Note: The Ed-Fi ID reports from the Student State ID field. | M |
|
|
studentNeed Descriptor | The program descriptor of the student need. | Report the code value 'LEPS' for a LEP Service that is mapped to a state code- Only report 1 need for the student regardless of the number of services.
| M |
|
|
studentNeedEntry Date | The date the student was identified with the need. | - Report the start date from the LEP Service when:
- LEP Service Start Date is after enrollment Start Date.
- Enrollment End Date must be NULL or after LEP Service start date.
- Report the Enrollment Start Date when:
- Enrollment Start Date is after the LEP Service Start Date.
- LEP Service End Date is after the Enrollment Start Date.
- When 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 | LEP Services > Start Date
OR Enrollments> Start Date | lepservice. StartDate or enrollment. startdate |
StudentNeedExit Date | The date the student is no longer identified with the need. | - Report the end date from LEP Service when populated.
- LEP Service End Date must be before Enrollment End Date or before last .instructional day of the calendar.
Report Enrollment End Date. - Else, report the last instructional date from the calendar where the student is enrolled.
- When 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 | LEP Services > End Date
OR Enrollments > End Date | lepservice. EndDate or enrollment. EndDate |
primaryStudent NeedIndicator | Indicates when this is a primary need for the student. | Do not report, not required for LEP. | O |
|
|
_etag |
|
| O |
|
|
Type/Descriptors
Eligibility (FRAM)
Click here to expand...
School Food Services Eligibility Descriptor
State Eligibility Code | Post-Amble 2019 (and future) | Post-Amble 2018 (and older) |
---|
'5' (Free) | '28' (Income Eligibility 1) | '5' (NCLB Indicator 1) |
'4' Reduced | '29' (Income Eligibility 2) | '4' (NCLB Indicator 2) |
Anything Else | Do not report. | Do not report. |
Flags and Programs
Click here to expand...
Code
| Short Description
|
---|
8
| Immigrant
|
9
| Neglected
|
10
| Delinquent
|
16
| Refugee
|
26
| Chronic Health Problem, A.R.S. § 15-346
|
20
| Evacuee
|