Tool Search: Ed-Fi

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.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When the student has an Eligibility Type that is mapped to an Ed-Fi code. Does not send a record when enrollment is in a calendar marked as Exclude. Does not send a record when enrollment is in a school marked as Exclude. Does not send a record when enrollment is marked as No Show.
Delete/Post	When any field part of the natural key is changed. Student Ed-Fi ID Start Date
Put	When any field not part of the natural key is changed. Eligibility
Delete	All enrollments are deleted for a student.
Delete	When the student's enrollment is marked as No Show.
Delete	When the Eligibility record is deleted.
Delete	When the start/end dates on the Eligibility record are updated so the record no longer overlaps the 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	When a resource is toggled to off after data has sent, all sent data will remain in the ODS but no new data sends.
Resync	When a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table.
Resync	When a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS.
Resync	When a mapping is changed in Resource Preferences, a resync needs 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. When a district number changes, an Ed-Fi error occurs and this change is not supported. When an Ed-Fi ID changes, a delete/post occurs with the cascading deletes from the Ed-Fi ID Change triggers. When the Program Name or Program Type Descriptor mapping changes and a resync is completed. When the Eligibility record Start Date changes the resource deletes/reposts.
Delete	Cascading Deletes: N/A - no dependent resources.

Action

Trigger

Post/Delete

Natural Key changes:

LEA Reference - District Numbers cannot change after data has been sent. When a district number changes, an Ed-Fi error occurs and this change is not supported.
When an Ed-Fi ID changes, a delete/post occurs with the cascading deletes from the Ed-Fi ID Change triggers.
When the Program Name or Program Type Descriptor mapping changes and a resync is completed.
When the Eligibility record Start Date changes the resource deletes/reposts.

Delete

Cascading Deletes: N/A - no dependent resources.

Scope Year Logic

This table describes scope year logic of this object.

Logic
The record sends to the configured year that the School Year from the Eligibility record aligns to when the student has an enrollment in that year.
Data only sends 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	M, C or O	Data Source GUI Path
id	The unique identifier of the resource.	M
beginDate	The month, day, and year on which the Student first received services. Reports the start date of the Eligibility record being reported.	M	FRAM> Eligibility > Start Date poseligibility.startDate
educationOrganizationReference	The education organization where the student is participating in or receiving the program services. Reports the State District Number.	M	District Information > State District Number district.number
programReference	A reference to the Program Resource. Reports the Natural Key for the Program resource. educationOrganizationId = Reporting District Code programName = Student School Food Service programTypeDescriptor = Student School Food Service	M
studentReference	A unique alpha-numeric code assigned to a student. Reports the Natural Key for the Student resource where the studentUniqueID is the Student State ID.	M
schoolFoodServiceProgramServices	Indicates the service(s) being provided to the Student by the School Food Service Program. See the Arrays section for details.	M

Arrays

Click here to expand...

School Food Service Program Services

Data Element Label	Description	M, C, or O	Database Location
schoolFoodServiceProgramServiceDescriptor	Indicates the service being provided to the student by the School Food Service Program. Looks at the school's 'USDA Programs' "Provision" status When the current value selected is "5: CEP", then reports all students with the value mapped to "F" in resource preferences. When FRAM eligibility record exists, returns state code. When "Free", reports the value mapped to "F" in resource preferences. When "Reduced", reports the value mapped to "R" in resource preferences. When "Paid" or "Non-reimbursable", reports the value mapped to "U" in resource preferences Else, reports the value mapped to "U" in resource preferences. Only considers FRAM records within the active school year.	M	FRAM > Eligibility > State Code OR School Information > School > USDA Programs

Data Element Label

Description

M, C, or O

Database Location

schoolFoodServiceProgramServiceDescriptor

Indicates the service being provided to the student by the School Food Service Program.

Looks at the school's 'USDA Programs' "Provision" status

When the current value selected is "5: CEP", then reports all students with the value mapped to "F" in resource preferences.
When FRAM eligibility record exists, returns state code.
- When "Free", reports the value mapped to "F" in resource preferences.
- When "Reduced", reports the value mapped to "R" in resource preferences.
- When "Paid" or "Non-reimbursable", reports the value mapped to "U" in resource preferences
Else, reports the value mapped to "U" in resource preferences.

Only considers FRAM records within the active school year.

FRAM > Eligibility > State Code

School Information > School > USDA Programs

Type/Descriptors