Student Needs (Arizona v3.6)

Tool Search: Ed-Fi

Needs are reported from the State Reporting Enrollment fields, FRAM, Flags, locked IEPs and LEP Services. This resource identifies any needs that a student may need to participate in for a program.

For the 23-24 Configuration year, this resource includes Homeless and Unaccompanied Youth logic. 

For the 24-25 Configuration year and future, this resource does NOT include Homeless and Unaccompanied Youth logic. Instead, that logic is included in the Student Homeless Program Associations Resource. 


Flags and Programs

The tables below describe the logic for triggering syncing of this object for Flags and Programs only. Expand one of the areas below to see full requirements:

Object Triggering Logic for Flags and Programs

Click here to expand...

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.

ActionTrigger
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, reports 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, reports with the following logic:
    • Reports a need from the enrollment with the earliest start date and sets 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 sets 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:

    1. District Information > State District Number
    2. 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 marked in the grade level record tied to the calendar in which the student is enrolled.
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.
PostWhen 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/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
DeleteDeletes the existing record when a need is changed on an existing flag/program.
Delete

Flag/Program 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 for 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.

Object Data Elements for Flags and Programs

Click here to expand...

Data Element LabelBusiness Requirements and RulesMandatory, Conditional or OptionalLocation
id The unique identifier of the resource.M
Education
Organization
Reference 

A reference to the related Education Organization resource.


Report the School Entity ID.

MSchool Information > School Detail > Entity ID

school.entity id
studentReference 

A reference to the related Student resource.


Reports the student reference.


The Ed-Fi ID reports from the Student State ID field.

M
studentNeed
Descriptor

The program descriptor of the student need.

  1. Report based on the mapped value indicated in the EdFi mapping tool, when it exists, tied to the attribute dictionary item selected.
  2. When a mapping does not exist, do not report.
MFlags > Need

programparticipation.need
studentNeedEntry
Date

The date the student was identified with the need.

  1. 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.
  2. 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.
  3. 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


programparticipation.StartDate



Enrollment > Start Date


enrollment.startdate

StudentNeedExit
Date

The date the student is no longer identified with the need.

  1. 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.
  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.
  4. 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


programparticipation.EndDate


Enrollment > End Date


enrollment.enddate



Days Setup

primaryStudentNeed
Indicator

Indicates when this is a primary need for the student.


Do not report, not required from Flags.

O
_etag
O

Types and Descriptors for Flags and Programs

Click here to expand...

CodeShort Description
8Immigrant
9Neglected
10Delinquent
16Refugee
26Chronic Health Problem, A.R.S. § 15-346
20Evacuee


Gifted

The tables below describe the logic for triggering syncing of this object for Gifted only. Expand one of the areas below to see full requirements

Object Triggering Logic for Gifted

Click here to expand...

ActionTrigger
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/PostWhen 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.
PostWhen 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/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
DeleteDelete the existing need when a need is changed on an existing Gifted record.
DeleteGifted record 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.
Delete/PostWhen 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).
DeleteGifted 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.

Scope Year Logic for 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.

Object Data Elements for Gifted

Click here to expand...

Data Element LabelBusiness Requirement and RulesMandatory, Conditional, or OptionalLocation
id The unique identifier of the resource.M
EducationOrganizationReference 

A reference to the related Education Organization resource.


Report the School Entity ID.


MSchool Information > School Detail > 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 Codes value from the Gifted Need dropdown.

MGifted > Gifted Need
studentNeedEntryDate

The date the student was identified with the need.

  1. Reports 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.
  2. 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.
  3. 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


gifted.startDate


Enrollment > Start Date


enrollment.startdate

StudentNeedExitDate

The date the student is no longer identified with the need.

  1. 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.
  2. Report Enrollment End Date:

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

  3. Else, report the last instructional date from the calendar where the student is enrolled.
  4. 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


gifted.endDate


Enrollment > End Date


enrollment.enddate


Day Setup

primaryStudentNeedIndicator

Indicate when this is a primary need for the student.


Do not report, not required from Gifted record.

O
_etag
O


Homebound

Object Trigger Logic for Homebound

Click here to expand...

ActionTrigger
Post

Reports 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 an 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:AOI AND the enrollment Resident District does not match the following:

    1. District Information > State District Number
    2. When the Enrollment Resident District does not match the District Information > State District Number, loop through all of the credentials 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 in which the student is enrolled.
Post

When a Homebound record is created and saved for a student:

  • Homebound start date must be on or after enrollment start date.
PostWhen 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.
PostWhen 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/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
DeleteHomebound record 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.
Delete

When an existing enrollment is marked as State Exclude or No Show.

Delete/PostWhen 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)
DeleteHomebound 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.

Scope Year Logic for 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.

Object Data Elements for Homebound

Click here to expand...

Data Element LabelBusiness Requirement and RulesMandatory, Conditional, or OptionalLocation
id The unique identifier of the resource.M
EducationOrganization
Reference 
A reference to the related Education Organization resource.

Reports the School Entity ID.

MSchool Information > School Detail > Entity ID

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

Reports the student reference.


The Ed-Fi ID reports from the Student State ID field


M
studentNeedDescriptorThe program descriptor of the student need.

Reports the code '11' for Homebound when a Needs record stems from a Homebound Tab record.
MHomebound
studentNeedEntryDateThe date the student was identified with the need.

  • Reports 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


Enrollment > Start Date


enrollment.startdate

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

  1. 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.
  2. Report Enrollment End Date.

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

  3. Else, report the last instructional date from the calendar where the student is enrolled.
  4. 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


enrollment.enddate


Day Setup

primaryStudentNeedIndicatorIndicate when this is a primary need for the student.

  • Does not report, not required from Homebound record.

O
_etag
O


Homeless

Object Trigger Logic for Homeless

Click here to expand...

ActionTrigger
Post

When a Homeless 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:
    • Reports a need from the enrollment with the earliest start date and sets 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, 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 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. When the Enrollment Resident District does not match the District Information > State District Number, loop through all of the credentials 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 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 marked 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.
  • 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.
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.

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

Scope Year Logic for 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.

Object Data Elements for Homeless

Click here to expand...

Data Element LabelBusiness Requirements and RulesMandatory, Conditional or OptionalLocation
id 

The unique identifier of the resource.

M
EducationOrganization
Reference 

A reference to the related Education Organization resource.


Reports the School Entity ID.

MSchool Information > School Detail > Entity ID

school.entityid
studentReference 

A reference to the related Student resource.


Reports the student reference.


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

studentNeedEntry
Date

The date the student was identified with the need.

  1. Reports the latest date of the following date fields:
    • Homeless Start Date.
    • Enrollment Start Date (for enrollment tied to Homeless record).
  2. 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


Homeless.startDate


Enrollments > Start Date


enrollment.startdate

StudentNeedExitDate

The date the student is no longer identified with the need.

  1. Reports 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.
  2. 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


Homeless.endDate


Enrollments > End Date


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.

  1. Report from the Homeless Residence field on student's Homeless record.
    • When blank, do not report.
    • Report the Ed-Fi code value.
CHomeless > Homeless Residence

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


Unaccompanied Youth

Object Trigger Logic for Unaccompanied Youth

Click here to expand...

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

    1. District Information > State District Number
    2. When the Enrollment Resident District does not match the District Information > State District Number, loop through all of the credentials and compare 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 an enrollment is in a calendar marked as State Exclude.
  • Does not send a record when the Student has an 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.
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.
  • When an enrollment overlaps an existing enrollment within the same school, follows 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.
  • 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.
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.

Scope Year Logic for 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.

Object Data Elements for Unaccompanied Youth

Click here to expand...

Data Element LabelBusiness Requirements and RulesMandatory, Conditional or OptionalLocation
id 

The unique identifier of the resource.

M
EducationOrganization
Reference 

A reference to the related EducationOrganization resource.


Reports the School Entity ID.

MSchool Information > School Detail > Entity ID

school.entityid
studentReference 

A reference to the related Student resource.


Reports the student reference.


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

MHomeless > 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).
  3. 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


Homeless.startDate


Enrollments > Start Date


enrollment.startdate


StudentNeedExitDate

The date the student is no 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.
  4. 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


Homeless.endDate


Enrollments > End Date


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
  1. When blank, do not report.
  2. Report the Ed-Fi code value.
CHomeless > Homeless Residence

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


Title 1

Title 1 Schoolwide logic reports based on the most recent School History record for the school. One record for each reportable student in the school reports for each of the marked Title 1 programs (for example, when Title 1 Match and Title 1 Reading are marked, two records report for each reportable student).

Object Trigger Logic for Title 1

Click here to expand...
ActionTrigger
Post

When a school's School History has Title 1 set to Schoolwide Program OR 


When a student has an individual Title 1 record that overlaps an Enrollment that overlaps the configured year. 

  • When a student has an individual Title 1 record in a school that has a Title 1 Schoolwide Program, reports only the individual Title 1 record.
  • When a student has multiple enrollments with a Local Service Type of P: Primary in the same school and start date, reports 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, reports with the following logic:
    • Reports a need from the enrollment with the earliest start date and sets 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 sets the start date to the enrollment start date and the end date to the enrollment end date. When enrollment end date is blank, sets the end date to the calendar end date.
  • 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, loops through all of the credentials and compares to the District Number.
  • Does not send a record when any of the exclusions apply:
    • Enrollment State Exclude
    • Enrollment No Show
    • Grade Level Exclude
    • Calendar State Exclude
    • School Exclude
    • Enrollment Start Status is E: NON-SAIS DISTRICT USE ONLY!
Delete/Post/PutA Delete/Post is performed when the natural key is changed. Otherwise, a Put is performed.
When the following information on an individual Title 1 record is changed:
  • Title 1 Record ID (New Title 1 Record)
  • School
  • Start Date
  • End Date
  • Instructional Services

When the following information on an Enrollment is changed:

  • State Exclude
  • No Show
  • Start Status
  • Start Date
  • End Date
Delete

When the Title 1 individual record is deleted.

DeleteWhen the associated enrollment is deleted. 
DeleteWhen the Title 1 individual record dates are changed so they no longer overlap the associated enrollment. 
DeleteWhen the enrollment dates are changed so they no longer overlap the configured year. 

Scope Year Logic for 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 sends for the years that have valid configuration.

Object Data Elements for Title 1

Click here to expand...

Data Element LabelBusiness Requirements and RulesMandatory, Conditional or OptionalLocation
Education
Organization
Reference 

A reference to the related Education Organization resource.


Reports the fields that are part of the Natural Key for the Local Education Agency resource:


  • educationPrganizationID = School Entity ID
MSchool Information > School Detail > Entity ID

School.entityID
studentReference 

A reference to the related Student resource.


Reports the fields that are part of the Natural Key for the Students resource:


  • studentUniqueID = Student State ID
MDemographics > Student State ID

Person.stateID
studentNeedDescriptor

The program descriptor of the student need.


Individual:

Reports the EdFi Code mapped to the value(s) selected on Instructional Services. 


When a mapping does not exist, does not report.


The suggested setup for the mappings are: 


Instructional ServicestudentNeed Descriptor
28: Title I Math13: Math
29: Title I Other19: Other Academic Services
30: Title I Reading14: Language Arts (reading and/or writing)
31: Title I Science15: Science
32: Title I Social Studies18: Social Studies

Schoolwide:
Reports as 19: Other Academic Services (hard-coded). 
MTitle 1 > Title 1 Service

Title1.title1Services
studentNeedEntryDate

The date the student was identified with the need.


Individual:
Reports the latest date of the following date fields:
  • Title 1 Start Date
  • Enrollment Start Date (for enrollment tied to Title 1 record)

Reports the future nearest instructional date when the calendared date is not an instructional day. 

  • Example:
    • 10/13/2023 is the calculated date. This is not an instructional day.
    • 10/14/2023 is not an instructional day.
    • 10/15/2023 IS an instructional day.
    • 10/15/2023 reports.

Schoolwide:

  • Reports the Enrollment Start Date.
  • Reports the future nearest instructional date when the calculated date is not an instructional day.
    • Example:
      • 10/13/2023 is the calculated date. This is not an instructional day.
      • 10/14/2023 is not an instructional day.
      • 10/15/2023 IS an instructional day.
      • 10/15/2023 reports. 

Notes:

When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, the enrollments are combined 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


Title1.startDate

enrollment.startdate


Enrollments > Start Date

StudentNeedExitDate

The date the student is no longer identified with the need.


Individual:

Reports the earliest date of the following date fields:
  • Title 1 End Date
  • Enrollment End Date (for enrollment tied to Title 1 record)
  • Last instructional day of the calendar

Reports the past nearest instructional date when the calculated date is not an instructional day. 

  • Example:
    • 2/13/2023 is the calculated date. This is not an instructional day.
    • 2/23/2023 is not an instructional day.
    • 2/11/2023 IS an instructional day.
    • 2/11/2023 reports.

Schoolwide:

Reports the earlier of:

  • Enrollment End Date
  • Last Instructional Day of the Calenda

Reports the past nearest instructional date when the calculated date is not an instructional day:

  • Example:
    • 2/13/2023 is the calculated date. This is not an instructional day.
    • 2/23/2023 is not an instructional day.
    • 2/11/2023 IS an instructional day.
    • 2/11/2023 reports. 

Notes:

When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, the enrollments are combined 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


Title1.endDate


Enrollments > End Date


enrollment.enddate

primaryStudentNeedIndicatorIndicates whether this is a primary need for the student.

Does not report, not required for Title 1.
O
primaryNightTime
ResidenceDescriptor
Reports the student's Primary Night Time Residence.

Does not report, not required for Title 1.
O

isAncillaryIndicates if the SPED Need as an ancillary.

Does not report, not required for Title 1.
O


Eligibility (FRAM)

Object Trigger Logic for FRAM

Click here to expand...
ActionTrigger
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:
    1. District Information > State District Number
    2. 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.
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.
  • 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/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
DeleteDeletes 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.

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

Object Data Elements for FRAM

Click here to expand...

Data Element LabelBusiness Requirements and RulesMandatory, Conditional, or OptionalLocation
id The unique identifier of the resource.M
EducationOrganization
Reference 

A reference to the related Education Organization resource.


Reports the School Entity ID.

MSchool Information > School Detail > Entity ID

school.entity id
studentReference 

A reference to the related Student resource.


Reports the student reference.


The Ed-Fi ID reports from the Student State ID field.

M
studentNeed
Descriptor

The program descriptor of the student need.


  1. 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.
  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.
MEligibility > State Eligibility Code
studentNeedEntry
Date

The date the student was identified with the need.

  1. 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.
  2. Reports the Enrollment Start Date when:
    • Enrollment Start Date is after the Eligibility Start Date.
    • Eligibility End Date is after the Enrollment Start Date.
  3. 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.

  1. 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.
  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.
  4. 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.
Does not report, not required for Eligibility.
O
_etag
O

Types and Descriptors for FRAM

Click here to expand...

School Food Services Eligibility Descriptor 

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.



Special Ed IEP

Object Trigger Logic for Special Ed IEP

Click here to expand...
ActionTrigger
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 Special Ed Status and Disability fields must be populated.
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 one 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.
PostWhen a Disability is changed in an existing IEP
PostWhen reporting from an amendment, only post when one of the following editors are updated:
  • Education Plan
  • Enrollment Status
    • When this editor was updated, compare the disability list from the current IEP document to the amended document.
      • When the disability is on both documents, changes are not made to the Student Needs resource for that disability.
      • When the disability is only on the old document, but not the amended document, the Student Needs resource for that disability is end dated with the old IEP end date.
      • When the disability is only on the amended document, but not the old document, a new Student Needs resource for that disability with the amended IEP start date is sent.
  • Placement
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/PostWhen the student has two locked IEPs with the same start date and 1 record is deleted or unlocked, the remaining IEP posts.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
Delete/PostWhen an Exit Eval is entered for a student, update the end date of the active IEP.
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.
DeleteWhen 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.
DeleteWhen a plan is unlocked.

Scope Year Logic for 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

Object Data Elements for Special Ed IEP

Click here to expand...

Data Element LabelBusiness Requirements and RulesMandatory, Conditonal, or OptionalLocation
id The unique identifier of the resource.M
EducationOrganization
Reference 

A reference to the related Education Organization resource.

  1. When the SPED Services School is populated with a SPED Concurrency Type of Primary or the Primary SPED Services School is populated on the locked IEP, the School Entity ID reports from the selected school.
  2. When the SPED Services School is populated with a SPED Concurrency Type of Secondary or the Secondary SPED Services School is populated on the locked IEP, the School Entity ID reports from the selected school.
  3. Reports the School Entity ID.
M

AZ locked Plan > Enrollment Status > Primary SPED Services School


AZ locked Plan > Enrollment Status > Secondary SPED Services School


AZ locked Plan > Placement  > SPED Concurrency Type


AZ locked Plan > Placement > SPED Services School


System Administration > Resources > School editor > Entity ID


school.entity id
studentReference 

A reference to the related Student resource.


Reports the student reference.


Note: The Ed-Fi ID reports from the Student State ID field.

M
studentNeedDescriptor

The program descriptor of the student need.


Reports the value from the Ed-Fi mapping field on the Disability selected on the locked IEP.


When the student has more than one Disability, one need record for each distinct Disability selected.


When the Disability is ED/EDP (an inactive code), reports as follows: 

  • When the disability is reporting for a school where Separate Facility or Private School is marked, reports as EDP. 
  • Otherwise, a value of ED reports.

A manual resync is required to properly report the needs if ED/EDP is still selected as the disability. It is highly recommended to update the disability to ED or EDP respectively for proper reporting via automatic triggers. 

M

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.

  1. Reports 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.
  2. Reports the Enrollment Start Date when:
    • Enrollment Start Date is after the IEP Start Date.
    • IEP End Date is after the Enrollment Start Date.

Notes:

  1. 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.
  2. 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

AZ locked Plan>Education Plan>IEP Start Date



Student Information> General> Enrollments> Start Date


Plan.startDate

enrollment.

startdate

StudentNeedExit
Date

The month, day and year on which the student exited the program or stopped receiving services.


  1. When Enrollment End Date is NOT null:
    • Reports the earliest of the following dates:
      • Exit Date for the Evaluation of the type Exit. The Exit Date must be within the IEP Start Date and the IEP End Date to be considered.
      • Enrollment End Date

      • IEP End Date 
  2. When Enrollment End Date IS null:
    • One of the following is true: 
      • 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 with a type of Exit has an exit reason of SPED01 or SPED09.
    • Reports the earliest of the following:
      • IEP End Date
      • Exit Date for the Evaluation of the type Exit. The Exit Date must be within the IEP Start Date and the IEP End Date to be considered.
      • Last instructional day of the school year. 
ZZZ Calculation
When there are enrollments connected with an end status of ZZZ AND a subsequent enrollment with a start status of ZZZ, the enrollments are combined into a reportable enrollment. 
  • The latest end date of the combined enrollments reports 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.

Notes

The end date being sent must be an instructional day. When the calculated date (using the logic above) is not an instructional day, the previous instructional day reports. Example: 

  • 4/15/23 is the calculated end date, but is not an instructional day.
  • 4/14/23 is not an instructional day.
  • 4/13/23 is an instructional day.
  • 4/13/23 reports.
When there are multiple enrollments that all start before the IEP starts, use the following logic to determine which enrollment to use to calculate the Enrollment End Date:
  • When reporting from the Primary SPED Services School, always uses the enrollment tied to the Primary SPED Services School.
  • When reporting from the Secondary SPED Services School, always uses the enrollment tied to the Secondary SPED Services School.
  • Otherwise, reports from the enrollment that has a Service Type of P: Primary.

When the LRE (SPED Setting) is D: Public or Private Separate Day School for greater than 50% of the school day, the End Date does NOT report until the associated enrollment has an end date. This logic also applies to amended IEPs.

C

AZ locked Evaluation>Exit Evaluation> Exit Date


OR


Student Information> General> Enrollments> End Date


Evaluation.

exitDate


OR


enrollment.

enddate

primaryStudent
NeedIndicator

Indicates when 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
primaryNightTime ResidenceDescriptorReports the student's Primary Night Time Residence.

Not required for SPED
C
isAncillaryIndicates the SPED NEED as an Ancillary.

Reports a value of True when the Ancillary checkbox is marked for the reported disability.

Otherwise, reports False.
CAZ locked Plan > Enrollment Status > Ancillary Disability 1-7
_etag
O


EL Services

Object Trigger Logic for EL Services

Click here to expand...
ActionTrigger
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:
    1. District Information > State District Number
    2. 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.
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.
  • 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/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
DeleteDelete 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.

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 for 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 for EL Services

Click here to expand...

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
Gifted Need

Object Data Elements for EL Services

Click here to expand...

Data Element LabelBusiness Requirements and RulesMandatory, Conditional or OptionalLocation
id The unique identifier of the resource.M
EducationOrganization
Reference 

A reference to the related Education Organization resource.


Report the School Entity ID.

MSchool Information > School Detail > Entity ID

school.entity id
studentReference 

A reference to the related Student resource.


Reports the student reference.


The Ed-Fi ID reports from the Student State ID field.

M
studentNeed
Descriptor
The program descriptor of the student need.

Reports 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. Reports 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.
  2. Reports 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.
  3. 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

EL > EL Services > Start Date


lepservice.

StartDate



Enrollments > Start Date


enrollment.

startdate

StudentNeedExit
Date

The date the student is no longer identified with the need.

  1. 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.
  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.
  4. 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

 EL > EL Services > End Date


lepservice.

EndDate


Enrollments > End Date


enrollment.

EndDate

primaryStudent
NeedIndicator

Indicates when this is a primary need for the student.


Does not report, not required for LEP.

O
_etag
O


Section 504

Object Trigger Logic for Section 504

Click here to expand...
ActionTrigger
Post

Reports one record for each disability populated in the Section 504 record that overlaps the scope year.  

  • When a student has multiple overlapping enrollments within the primary/secondary school, reports 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'
  • Does not send a record for an enrollment that is marked as State Exclude or No Show
  • Does not send a record if enrollment is in a calendar marked as State Exclude
  • Does not send a record if the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY! 
Post

When a new Section 504 record is created and saved for a student and locked in a given scope year.

  • The Section 504 start date is on or after enrollment start date.
  • The Section 504 record start date is before enrollment start date, and the EL Service record end date is either null or after the enrollment start date.
  • The Disability field must NOT be null.
Post

When a new enrollment is created for a student who has an existing Section 504 record.

  • Enrollment start date must be after the Section 504 start date.
  • Section 504 end date must be 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.
PostWhen a Disability is changed in an exisitng Section 504 record.
Delete/Post

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

  • When Need was posted from Section 504, update when start or end date was changed.
  • When Need was posted from Enrollment update when 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.
Delete

When Section 504 is deleted for a student.

DeleteWhen all disabilities are removed and Section 504 is saved.
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 .
DeleteWhen the Section 504 Start or End Dates OR the Enrollment Start or End Dates have been updated so the Section 504 and Enrollment no longer overlap, delete the record if one was creat.

Object Data Elements for Section 504

Click here to expand...

Data Element LabelBusiness Requirements and RulesMandatory, Conditional, or OptionalLocation
id The unique identifier of the resource.M
EducationOrganization
Reference 

A reference to the related Education Organization resource.


Reports the School Entity ID.

MSchool Information > School Detail > 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 the value from the Ed-Fi mappig field on the Disability selected on the Section 504 record.

When the student has more than one disability, one needs record for each distinct Disability selected. 
M
studentNeedEntry
Date

The date the student was identified with the need.

  1. Reports the start date from the Section 504 record when:
    • Section 504 start date is after enrollment Start Date.
      • Enrollment End Date must be NULL or after Section 504 start date.
  2. Reports the Enrollment Start Date when:
    • Enrollment Start Date is after the Section 504 Start Date.
      • Section 504 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

EL > EL Services > Start Date


lepservice.

StartDate



Enrollments> Start Date

enrollment.

startdate

StudentNeedExit
Date
The date the student is no longer identified with the need.

Reports the end date from Section 504 when populated.
  • Section 504 End Date must be before Enrollment End Date or before last instructional day of the calendar.
  • Reports Enrollment End Date.

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

  • Else, reports the last instructional date from the calendar where the student is enrolled.
When the date being sent is NOT an instructional date, the most previous instructional date is sent.

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

EL > EL Services > End Date


lepservice.

EndDate



Enrollments > End Date


enrollment.

EndDate

primaryStudent
NeedIndicator

Indicates when this is a primary need for the student.


Reports False.

C
primaryNightTime ResidentDescriptorReports the student's Primary Nighttime Residence.

Does not report for Section 504
C
isAncillaryIndicates the SPED Need as an Ancillary.

Reports True.
C
_etag
O