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 | Report a record when a student has an enrollment that overlaps the configured school year.
|
| Delete/Post/Put | A DELETE/POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.
|
| Delete |
|
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:
|
| 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 |
|---|---|
| School Food Service Program Service Descriptor | POS Eligibility |
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 and Business Rules | M, C or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| beginDate | The month, day, and year on which the Student first received services.
| M | FRAM > Eligibility > Start Date | POSEligibility.startDate |
| educationOrganization
Reference | The education organization where the student is participating in or receiving the program services. Reports the fields that are part of the Natural Key for the Schools resource.
| M | System Administration > Resources > School > Ed-Fi School ID | School.entityID |
| programReference | A reference to the Program Resource. Reports the fields that are part of the Natural Key for the Programs resource.
| M | System Administration > Resources > School > Ed-Fi School ID | School.entityID |
| studentReference | A unique alpha-numeric code assigned to a student. Reports the fields that are part of the Natural Key for the Students resource. | M | N/A | N/A |
| directCertification | Indicates that the student’s National School Lunch Program (NSLP) eligibility has been determined through direct certification.
| C | FRAM > Eligibility > Source | POSEligibility.directType IS NOT NULL |
| endDate | The month, day, and year on which the student exited the program or stopped receiving services.
| C | FRAM> Eligibility> End Date | POSEligibility.endDate |
| schoolFoodServiceProgramServices | Indicates the service(s) being provided to the Student by the School Food Service Program. Reports the below data elements in an array:
| M | FRAM > Eligibility > State Eligibility Code | POSEligibility.eligibility |
