Student School Food Service Program Associations (Arizona 7.1)
Last Modified on 07/25/2024 2:52 pm CDT
This association represents the school food services program(s), such as the Free or Reduced Lunch Program, that a student participates in or from which the Student receives services.
This resource only sends with 24-25 configurations and future year configurations.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
Action | Trigger |
---|
Post | Report a record when a student has a FRAM record that overlaps an enrollment in the current configured year. - Do not report a record if any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
- To report a Student Food Service Program Association record, the FRAM record must meet one of the following criteria:
- Originated from an application (POSEligibility.applicationID IS NOT NULL)
- Source = Direct
- Certification Type = Categorical, Homeless, Migrant, Runaway, Head Start, or Foster
- If there are multiple enrollments, use the following priority list to determine which one should report:
- Primary > Partial > SPED
- Earliest Start Date
- Latest Enrollment ID
|
Delete/Post/Put | A DELETE / POST will be performed if the data element being altered is part of the resource's natural key. A PUT will be performed otherwise. |
Delete | - When the enrollment being reported off of is deleted.
- When the enrollment is changed to no longer overlap the configured year.
- When the student is excluded through their enrollment, calendar, grade level, or school.
- When the FRAM record being reported off of is deleted.
- When the FRAM record is changed to no longer overlap the enrollment in the current configured year.
|
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.
Action | Trigger |
---|
None | If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send. |
Resync | If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table. |
Resync | If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS. |
Resync | If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes. |
Natural Key Changes, Cascading Updates, and Deletes Logic
This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.
Action | Trigger |
---|
Post/Delete | Natural Key changes: - LEA Reference - District Numbers cannot change after data has been sent. If a district number changes, we would expect an Ed-Fi error and this change would not be supported.
- If an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers.
- If the Program Name or Program Type Descriptor mapping changes and a resync is completed.
- If the Eligibility record Start Date changes the resource will delete/repost.
|
Delete | Cascading Deletes: N/A - no dependent resources. |
Scope Year Logic
This table describes scope year logic of this object.
Logic |
---|
The record will send to the configured year that the School Year from the Eligibility record aligns to if the student has an enrollment in that year. |
Data will only send for the years that have valid configuration. |
Resource Preferences
Data Element Label | Mapping Needed |
---|
FRAM Eligibility | schoolFoodServiceProgramServiceDescriptor |
Select the Program Type Descriptor associated with this Program | Program Type Descriptor |
Event Queue Detail
This table describes the Event Queue Detail of this object.
Campus Table | Ed-Fi Action | Fields |
---|
POSEligibility | Post/Put/Delete | The primary table for sending data for this resource. |
Object Data Elements
Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.
Data Element Label | Business Requirement | Mandatory, Conditional or Optional | Location |
---|
beginDate | Reports the latest of the following dates:- FRAM Start Date
- Enrollment Start Date
ZZZ Logic: - If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date
- The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status or be before or equal to the ZZZ end status.
| M | Eligibility > Start Date
POSeligibility.startDate |
educationOrganizationReference | Reports the fields that are part of the Natural Key for the Schools resource. - educationOrganizationId = School Entity ID
| M | School Information > Ed-Fi School ID
School.entityID
|
programReference | Reports the fields that are part of the Natural Key for the Programs resource. - educationOrganizationId = School Override District Entity ID
- If NULL, uses the District Entity ID
- programName =
National School Lunch Program (Hard-Coded) - programTypeDescriptor =
National School Lunch Program (Hard-Coded)
| M | School Information > District Entity ID
District Information > Entity ID
CustomSchool.value INNER JOIN CampusAttribute ON CustomSchool.attributeID = CampusAttribute.attributeID District.entityID
|
studentReference | Reports the fields that are part of the Natural Key for the Students resource. | M |
|
endDate | Reports the earliest of the following dates: - FRAM End Date
- Enrollment End Date
- Last Instructional Day of the Calendar
Notes: - The reported endDate must always be after the reported startDate.
ZZZ Logic: - If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date
- The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status or be before or equal to the ZZZ end status.
| C
| Eligibility > End Date
POSeligibiliy.enddate |
eligibilitySourceDescriptor
| - Reports USDA Income Application if the FRAM record being reported off of originated from an application (applicationID is NOT NULL).
- Reports Direct Certification if Source is Direct.
- Reports Other Source Categorically Eligible if Source is Non-Direct and Certified Type is one of the following values:
- Categorical
- Homeless
- Migrant
- Runaway
- Head Start
- Foster
| M | FRAM > Applications
POSEligibility.applicationID
FRAM > Eligiblity > Source
POSEligibility.directType IS NOT NULL
FRAM > Eligibility > Certified Type
POSEligibility.type = C, H, M, R, HS, F
|
eligibilityStatusDescriptor
| Reports the Ed-Fi Code mapped to the State Eligibility Code calculated on the FRAM record being reported off of. - If State Eligibility Code is NULL on a record that is otherwise eligible to report, report Full Pay.
| M
| Eligibility > State Eligibility Code
POSEligibility.eligibility
|
Arrays
Click here to expand...
Type/Descriptors
Click here to expand...
Eligibility Source Descriptor
Auto-mapping is not needed as these are hard-coded.
IC Code
| Ed-Fi Code
| Description
| Namespace
|
---|
N/A
| Direct Certification
| Direct Certification | uri://azed.gov/eligibilitySourceDescriptor
|
N/A
| USDA Income Application
| USDA Income Application
| uri://azed.gov/eligibilitySourceDescriptor
|
N/A
| Other Source Categorically Eligible
| Other Source Categorically Eligible
| uri://azed.gov/eligibilitySourceDescriptor
|
Eligibility Status Descriptor
Auto-mapping is not needed as these are hard-coded.
IC Code
| Ed-Fi Code
| Description
| Namespace
|
---|
5: NCLB1
| Free
| Free | uri://azed.gov/eligibilityStatusDescriptor
|
4: NCLB2
| Reduced-Price
| Reduced-Price | uri://azed.gov/eligibilityStatusDescriptor
|
N/A | Full Pay
| Full Pay
| uri://azed.gov/eligibilityStatusDescriptor
|
Thank you for your feedback!