Student School Food Service Program Associations (Georiga v3.6.1)
Last Modified on 05/14/2026 7:05 am CDT
In this article
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.
Do not report a record if the any of the following exclusions are present:
Enrollment State Exclude
Enrollment No Show
Enrollment Grade Exclude from State Reporting
Calendar Exclude
School Exclude
The Programs record must exist in the ODS prior to sending a Student School Food Service Program Associations record.
If the Programs record does not already exist in the ODS, the Programs record is sent prior to the Student School Food Service Program Associations.
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
A record is reported for each FRAM record that overlaps the current configured year (if the student has multiple FRAM records).
If the student has no FRAM records that overlap the current configured year, a single Student School Food Service Program Associations record reports.
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.
When the following information is changed on a FRAM record:
FRAM Program ID (New FRAM Record)
Start Date
End Date
State Eligibility Code
Source
When the following information is changed on an Enrollment:
Enrollment ID (New Enrollment)
State Exclude
No Show
Delete
When the enrollment being reported off of is deleted.
When the enrollment is changed to no longer overlap the configured year or excluded.
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 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.
Natural Key changes: 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
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.
Reports the Start Date of the FRAM record being reported.
For students that do NOT have a FRAM record, report as 07/01/startYear.
Start Year is the start year for the configured year being reported.
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.
educationOrganizationId = Ed-Fi School ID
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.
educationOrganizationId = Ed-Fi School ID
programName = Student School Food Service (Hard-Coded)
programTypeDescriptor = Student School Food Service (Hard-Coded)
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.
Reports TRUE if Source is set to "Direct".
Reports FALSE in all other situations.
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.
Reports the End Date of the FRAM record being reported.
For students that do NOT have a FRAM record, report 06/30/endYear.
End Year is the end year for the configured year being reported for.
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:
schoolFoodServiceProgramServiceDescriptor
Reports the Ed-Fi Code mapped to the State Eligibility Code calculated on the FRAM record being reported off of.
Reports N if the student does not have a FRAM record in the current configured year or their FRAM record does not have a State Eligibility Code that is mapped to an Ed-Fi Code.
