Arizona Ed-Fi Data v3.3 - Student Needs

Classic View: System Administration > Ed-Fi 

Search Terms: Ed-Fi

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

ActionTrigger
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 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. If 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' 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:

    1. District Information > State District Number
    2. 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.
PostWhen a Need is changed on an existing Flag for a student with a need populated.
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.

  • If Need was posted from Flag, update if start or end date was changed.
  • If Need was posted from Enrollment update if start or end date was changed.
  • When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
DeleteDelete the existing record if a Program is changed on an existing flag.
Delete

Flag is deleted for a student.

DeleteWhen a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
DeleteWhen an existing enrollment is marked as State Exclude or No Show.

Homeless

ActionTrigger
Post

When a Homeless record is created and tied to a valid Enrollment record.

  • 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 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. If 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' 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:

    1. District Information > State District Number
    2. 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 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.
  • 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.
PostWhen 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/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
Delete/PostWhen the Homeless program is changed on an existing record.
Delete/PostWhen 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.

  • If 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.
DeleteHomeless 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

ActionTrigger
PostWhen a Homeless record is created and tied to a valid Enrollment record and the Unaccompanied Youth dropdown is set to 'Yes'.
  • 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 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. If 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' 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:

    1. District Information > State District Number
    2. 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 student 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 Student has an 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.
PostWhen 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.
  • If enrollment overlaps an existing enrollment within the same school, follow rules within requirement R1, otherwise post new record.
 PostWhen 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/PostWhen a start or end date is entered or changed on an existing Homeless record where the Unaccompanied Youth dropdown is set to 'Yes'.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status:  W1-W13.
Delete/PostWhen the Homeless program where the Unaccompanied Youth dropdown is set to 'Yes' is changed on an existing record.
Delete/PostWhen 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/PostHomeless record where the Unaccompanied Youth dropdown is set to 'Yes' is deleted.
  • If 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', do not delete the record unless all programs or needs associated with the primary keys are deleted.
DeleteThe 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.
DeleteWhen there is a delete/edit to the eligible enrollment reporting is based on, such that there are no longer any eligible enrollments.

Title 1

ActionTrigger
Post

When a Title 1 record is created and tied to a valid Enrollment record.

  • 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 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. If 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' 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:
    1. District Information > State District Number
    2. 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 student 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.

  • Title 1 record start date is on or after enrollment start date.

  • Title 1 record start date is before enrollment start date, and the Title 1 record end date is either null or after the enrollment start date.
PostWhen 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/PostWhen a start or end date is entered or changed on an existing Title 1 record.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status:  W1-W13.
Delete/PostWhen the Title 1 service is changed on an existing record.
Delete/PostWhen 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.
DeleteTitle 1 record's start date or end date is changed, such that it no longer overlaps an eligible enrollment.
DeleteWhen there is a delete/edit to the eligible enrollment reporting is based on, such that there are no longer any eligible enrollments.

Eligibility (FRAM)

ActionTrigger
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 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. If 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' 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:
    1. District Information > State District Number
    2. 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 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.
PostWhen 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.
  • 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.

  • If Need was posted from Eligibility, update if start or end date was changed.
  • If Need was posted from Enrollment update if start or end date was changed.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
DeleteDelete the existing need if 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.

DeleteWhen a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
DeleteWhen an existing enrollment is marked as State Exclude or No Show.

Special Ed - IEP

ActionTrigger
Post

Report a record based on the students enrollment record:  Service Type = P.

  • If a student has multiple overlapping enrollments within the same school, report from the most recent enrollment with a Service Type of 'P: Primary'.
  • If the student has multiple overlapping enrollments within the same school, but no 'P: Primary' enrollment, report the most recent 'T: AOI' enrollment.
  • If the student has multiple overlapping enrollments within the same school, but no 'P: Primary' or 'T: AOI' enrollment, report the most recent 'A: Ancillary' enrollment.
  • If the student has multiple overlapping enrollments within the same school, but no 'P: Primary', 'T: AOI', or 'A: Ancillary' enrollment, report the most recent 'O: Program Only' enrollment.

  • If a student has multiple overlapping enrollments from any school with different start dates, report with the following logic for end date:

    • 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. If enrollment end date is blank, set end date to the calendar end date.
  • 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 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:
    1. District Information > State District Number
    2. 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.
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.
  • 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.
  • If the student has more than 1 IEP started in previous schools years, only report the most recent IEP.
  • 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.
PostWhen a Disability is changed in an existing IEP
Delete/Post

When a start or end date is entered or changed for an existing record.

  • If Need was posted from IEP, update if start or end date was changed.
  • If Need was posted from Enrollment, update if start or end date was changed.
Delete/PostWhen the student has two locked IEPs with the same start date and 1 record is deleted or unlocked, the remaining IEP will post.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
DeleteIEP is deleted for a student.
Delete

A disability is changed for a student.

DeleteWhen a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
DeleteWhen an existing enrollment is marked as State Exclude or No Show.
Delete

When a Exit Evaluation is added for a student and a future record was already created.

  • The Exit Date on the Evaluation must be on or before the start date of the future record.
DeleteIf 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 if one was created.
DeleteIf a plan is unlocked.

EL Services

ActionTrigger
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 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. If 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' 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:
    1. District Information > State District Number
    2. 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 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.
PostWhen 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.
  • 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.

  • If Need was posted from EL Service, update if start or end date was changed.
  • If Need was posted from Enrollment update if start or end date was changed.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status:  W1-W13.
DeleteDelete the existing need if an EL Service is changed to a status not mapped to a state program code.
Delete

An EL Service is deleted for a student.

DeleteWhen a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
DeleteWhen 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

Logic

When a new Flag is created, the record will report in the Scope Year that the record start date overlaps with.

  • The start date must be on or before the School Year End Date.  If School Year End Date is NULL, 6/30/XXXX will be used as the default date.
  • Data will only send for the years that have valid configuration.

When the record is triggered from enrollments, the record will send to the scope year for the school year the enrollment is associated with.

  • Data will only send for the years that have valid configuration.

Homeless

Logic

The record will send to the scope year for the school year the enrollment is associated with.

  • Data will only send for the years that have valid configuration.

Unaccompanied Youth

Logic

The record will send to the scope year for the school year the enrollment is associated with.

  • Data will only send for the years that have valid configuration.

Title 1

Logic

The record will send to the scope year for the school year the enrollment is associated with.

  • Data will only send for the years that have valid configuration.

Eligibility (FRAM)

Logic

A record will report when an Eligibility is created and saved that is aligned to a scoped year.

  • Data will only send for the years that have valid configuration.

When using data in Campus that have start and end dates, the following logic will be 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. If 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. If blank, the default date of 7/01/xxxx is used.

Special Ed - IEP

Logic

When a new IEP is created, the record will report in the Scope Year that the IEP Start Date overlaps with.

  • The start date must be on or before the School Year End Date.  If School Year End Date is NULL, 6/30/XXXX will be used as the default date.
  • Data will only send for the years that have valid configuration.

When the record is triggered from enrollments, the record will send to the scope year for the school year the enrollment is associated with.

  • Data will only send for the years that have valid configuration

EL Services

Logic

When a new EL Service is created, the record will report in the Scope Year that the IEP Start Date overlaps with.

  • The start date must be on or before the School Year End Date.  If School Year End Date is NULL, 6/30/XXXX will be used as the default date.
  • Data will only send for the years that have valid configuration.

When the record is triggered from enrollments, the record will send to the scope year for the school year the enrollment 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

Homeless Primary Nighttime Residence DescriptorsHomeless Primary Night Time Residence
Student Needs DescriptorsEnrollment Primary Disability
POSEligibility Eligibility
ProgramParticipation Need
Title1 Instructional Services


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

Data Element LabelBusiness RequirementBusiness RulesM, 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 EducationOrganization resource.

Report the School Entity ID.

M

System Administration> Resources > School editor > Entity ID

school.entity id
studentReference A reference to the related Student resource.

Report the student reference.

M



studentNeed
Descriptor
The program descriptor of the student need.
  1. Report based on the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected.
  2. If a mapping does not exist, do not report.
MStudent Information > General > Flags > Needprogramparticipation.
need
studentNeedEntry
Date
The date the student was identified with the need.
  1. 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.
  2. 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.
M

Student Information > General > Flags > Start Date


OR


Student Information > General > Enrollment Start Date

programparticipation.

StartDate

or

enrollment.startdate

StudentNeedExit
Date
The date the student is not longer identified with the need.
  1. 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.
  2. Report Enrollment End Date.

    • Enrollment End date must be after Flag Start Date and before Flag End Date and before last instructional day.

  3. Else, report the last instructional date from the calendar where the student is enrolled.
C

Student Information > General > Flags > End Date


OR


Student Information > General > Enrollment End Date


OR


System Administration > Calendar > Calendar > Days

programparticipation.

EndDate

or

enrollment.enddate

primaryStudentNeed
Indicator
Indicates if this is a primary need for the student.

Do not report, not required from Flags.

O

_etag

O

Homeless

Data Element LabelBusiness RequirementBusiness RulesM, 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.
  1. Report the School Entity ID.
M

System Administration > Resources > School editor > Entity ID

school.entityid
studentReference A reference to the related Student resource.

Report the student reference.

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.

MStudent Information > Program Participation > Homeless

n/a

studentNeedEntry
Date
The date the student was identified with the need.
  1. Report the latest date of the following date fields:
    • Homeless Start Date.
    • Enrollment Start Date (for enrollment tied to Homeless record).
M

Student Information > Program Participation > Homeless > Start Date


OR


Student Information > General > Enrollments > Start Date

ic_Homeless.startDate

enrollment.startdate

StudentNeedExitDateThe date the student is not longer identified with the need.
  1. 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.
C

Student Information > Program Participation > Homeless > End Date


OR


Student Information > General > Enrollments > End Date

ic_Homeless.endDate


enrollment.enddate

primaryStudentNeed
Indicator
Indicates if 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.
  1. Report from the Homeless Residence field on student's Homeless record.
    • If blank, do not report.
    • Report the Ed-Fi code value.
C

Student Information > Program Participation > Homeless > Homeless Residence

enrollmentaz.homeless
Residence
_etagA unique system-generated value that identifies the version of the resource. 
ON/AN/A

Unaccompanied Youth

Data Element LabelBusiness RequirementBusiness RulesM, 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

System Administration > Resources > School editor > Entity ID

school.entityid
studentReference A reference to the related Student resource.

Report the student reference.

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


MStudent Information > Program Participation > Homeless


Student Information > Program Participation > Homeless > Unaccompanied Youth



studentNeedEntry
Date
The date the student was identified with the need

Reports the latest date of the following date fields:

  1. Homeless Start Date
  2. Enrollment Start Date (for enrollment tied to Homeless record)
M

Student Information > Program Participation > Homeless > Start Date


OR


Student Information > General > Enrollments > Start Date


ic_Homeless.startDate

enrollment.startdate


StudentNeedExitDateThe date the student is not longer identified with the need.

Report the earliest date of the following date fields:

  1. Homeless End Date
  2. Enrollment End Date (for enrollment tied to Homeless record)
  3. The last instructional day of the calendar the student is enrolled.
C

Student Information > Program Participation > Homeless > End Date


OR


Student Information > General > Enrollments > End Date


ic_Homeless.endDate

enrollment.enddate


primaryStudentNeed
Indicator
Indicates if 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
  1. If blank, do not report.
  2. Report the Ed-Fi code value.
CStudent Information > Program Participation > Homeless > Homeless Residenceenrollmentaz.homeless
Residence
_etagA unique system-generated value that identifies the version of the resource.
ON/AN/A

Title 1

Data Element LabelBusiness RequirementBusiness RulesM, 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 EducationOrganization resource.

Report the School Entity ID.

M

System Administration > Resources > School editor > Entity ID

school.entityid
studentReference A reference to the related Student resource.

Report the student reference.

M



studentNeed
Descriptor
The program descriptor of the student need.
  1. Report based on the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected.

    • If a mapping does not exist, do not report.

Note, this is likely how this should be set up:

Title 1 Program Droplist (code: name)studentNeedDescriptorcode
28: Title I MathMath13
29: Title I OtherOther Academic Services19
30: Title I ReadingLanguage Arts (reading and/or writing)14
31: Title I ScienceScience15
32: Title I Social StudiesSocial Studies18
MStudent Information > Program Participation > Title 1 > Title 1 Serviceic_Title1.title1
Services
studentNeedEntry
Date
The date the student was identified with the need
  1. Report the latest date of the following date fields:
    • Title 1 Start Date
    • Enrollment Start Date (for enrollment tied to Title 1 record)
M

Student Information > Program Participation > Title 1 > Start Date


OR


Student Information > General > Enrollments > Start Date

Title1.startDate

enrollment.startdate

StudentNeedExit
Date
The date the student is not longer identified with the need.
  1. 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.
C

Student Information > Program Participation > Title 1 > End Date


OR


Student Information > General > Enrollments > End Date

Title1.endDate


enrollment.

enddate

primaryStudentNeed
Indicator
Indicates if 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

_etagA unique system-generated value that identifies the version of the resource.
ON/AN/A

Eligibility (FRAM)

Data Element LabelBusiness RequirementBusiness RulesM, 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

System Administration > Resources > School editor > Entity ID

school.entity id
studentReference A reference to the related Student resource.

Report the student reference.

M



studentNeed
Descriptor
The program descriptor of the student need.
  1. Report based on the mapped value indicated in the EdFi mapping tool, if it exists, tied to the attribute dictionary item selected.

    • If a mapping does not exist, do not report.
  2. Note this is likely how this should be set up:

    State Eligibility CodePost-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 elseDo not report.Do not report.
MFRAM > Eligibility > eligibility record > State Eligibility Code
studentNeedEntry
Date
The date the student was identified with the need.
  1. Report the start date from the Eligibility if:
    • Eligibility Start Date is after enrollment Start Date.
    • Enrollment End Date must be NULL or after Eligibility start date.
  2. Report the Enrollment Start Date if:
    • Enrollment Start Date is after the Eligibility Start Date.
    • Eligibility End Date is after the Enrollment Start Date.
M

StudentNeedExit
Date
The date the student is not longer identified with the need.
  1. Report the end date from Eligibility if populated.
    • Eligibility End Date must be before Enrollment End Date or before last instructional day of the calendar.
  2. Report Enrollment End Date.

    • Enrollment End date must be after Eligibility Start Date and before Eligibility End Date and before last instructional day.

  3. Else, report the last instructional date from the calendar where the student is enrolled.
C

primaryStudent
NeedIndicator
Indicates if this is a primary need for the student.Do not report, not required for Eligibility.O

_etag

O

Special Ed - IEP

Data Element LabelBusiness RequirementBusiness RulesM, 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

System Administration> Resources> School editor> Entity ID

school.entity id
studentReference A reference to the related Student resource.
  1. Report the student reference.
M



studentNeedDescriptorThe program descriptor of the student need.
  1. Report the value from the Ed-Fi mapping field on the Disability selected on the locked IEP.
    • If the student has more than 1 Disability, 1 need record for each distinct Disability selected.
MAZ 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.
  1. Report the start date from the IEP if:
    • IEP Start Date is after enrollment Start Date.
    • Enrollment End Date must be NULL or after IEP start date.
  2. Report the Enrollment Start Date if:
    • Enrollment Start Date is after the IEP Start Date.
    • IEP End Date is after the Enrollment Start Date.
M

AZ locked Plan>Education Plan>IEP Start Date


OR


Student Information> General> Enrollments> Start Date

Plan.startDate
OR
enrollment.

startdate

StudentNeedExit
Date
The date the student is not longer identified with the need.
  1. Report  the Exit Date from AZ ESR yyyy Format (current) Evaluation.
    • Look for the most recent Evaluation where Evaluation Exit Date is later than the IEP start date and before enrollment end date or last instructional day.
  2. Report Enrollment End Date.

    • Enrollment End must be on or after IEP Start Date and on or before IEP End Date.

    • Enrollment End date must be on or before Exit Date from Evaluation and on or before last Instructional Day.
  3. Report the IEP End Date if the end date falls in within the school year being reported.
    • If the IEP end date is NULL or after the last instructional day of the year, report last instructional day of calendar.
  4. Report the following if an IEP does not have an end date and a new IEP is created or an IEP is amended:
    • Report the last instructional day that occurs right before the start date of the new or amended IEP.
C

AZ locked Evaluation>Exit Evaluation> Exit Date


OR


Student Information> General> Enrollments> End Date

Evaluation.

exitDate
OR
enrollment.

enddate

primaryStudent
NeedIndicator
Indicates if this is a primary need for the student.
  1. Report 'True' when the need reported is the Primary Disability.
  2. Report 'False' when the need reported is not the Primary Disability.
OAZ locked Plan > Enrollment Status > Primary, Secondary, Tertiary,
_etag

O

EL Services

Data Element LabelBusiness RequirementBusiness RulesM, 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

System Administration > Resources > School editor > Entity ID

school.entity id
studentReference A reference to the related Student resource.

Report the student reference.

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
  1. 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.
  1. Report the start date from the LEP Service if:
    • LEP Service Start Date is after enrollment Start Date.
    • Enrollment End Date must be NULL or after LEP Service start date.
  2. Report the Enrollment Start Date if:
    • Enrollment Start Date is after the LEP Service Start Date.
    • LEP Service End Date is after the Enrollment Start Date.
M

Student Information> General > Program Participation > LEP > LEP Services > Start Date


OR


Student Information> General> Enrollments> Start Date

lepservice.

StartDate

or

enrollment.

startdate

StudentNeedExit
Date
The date the student is not longer identified with the need.
  1. Report the end date from LEP Service if populated.
    • LEP Service End Date must be before Enrollment End Date or before last .instructional day of the calendar.
  2. Report Enrollment End Date.

    • Enrollment End date must be after LEP Service Start Date and before LEP Service .End Date and before last instructional day.

  3. Else, report the last instructional date from the calendar where the student is enrolled.
C

Student Information> General > Program Participation > LEP > LEP Services > End Date


OR


Student Information > General > Enrollments > End Date

lepservice.

EndDate

or

enrollment.

EndDate

primaryStudent
NeedIndicator
Indicates if this is a primary need for the student.

Do not report, not required for LEP.

O

_etag

O

Type Descriptors

Eligibility (FRAM)

School Food Services Eligibility Descriptor 

IC Code

Ed-Fi Code

Ed-Fi Short Description

Ed-Fi Description

F

01

Free

Free

S

02

Full price

Full price

A

02

Full price

Full price

R

03

Reduced price

Reduced price


04

Unknown

Unknown