Classic View: System Administration > Ed-Fi

Search Terms: 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 a new enrollment is saved for a student, and there are one or more FRAM records saved that overlap the enrollment record, with an eligibility of 'Free' or 'Reduced', and has a Start Date on or after July 1st of the start of the Scope Year. Or When a new FRAM record is saved that overlaps one or more enrollment records . When a student has two enrollments in the same School, Calendar & Schedule Structure with the same start date, report from the enrollment service type in the following order: P: Primary Enrollment S: Partial/Ancillary N: Special Ed Services When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record. Do not send records if the Calendar Exclude checkbox is checked in the calendar the student is enrolled. Do not send records if the School Exclude checkbox is checked in the calendar the student is enrolled. Do not send a record if the No Show checkbox is checked. When a new FRAM record is saved for a student, and there is a reportable enrollment record that overlaps the FRAM record. When the FRAM record's Start Date or End Date are updated so that they newly overlap a reportable enrollment record. When the Enrollment record's Start Date or End Date are updated so that they newly longer overlap a FRAM record. Do not send records if the Calendar Grade Level "Exclude from State Reporting" checkbox is selected for the grade level that the student's enrollment is tied to.
Put	When the start date for an enrollment is changed. When an enrollment with a lower priority is changed, data will not send.
Put	When an enrollment is updated for a student. When the FRAM record is updated for a student.
Delete	When an enrollment is deleted. When a student has two enrollments in the same school for the same start date, records with lower priority will not trigger a delete. When the No Show checkbox is checked. When the FRAM record is deleted. When the FRAM record's Start Date or End Date are updated so that they no longer overlap a reportable enrollment record. When the FRAM record's eligibility is changed from either 'Free' or 'Reduced' to something else.

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.

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.

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	Logic	M, C, or O	Location
id	The unique identifier of the resource.		M
beginDate	The month, day, and year on which the Student first received services.	Report the Start Date from the FRAM record. If the Enrollment Start Date takes place after the FRAM record Start Date, report the Enrollment Start Date.	M	FRAM > Eligibility > eligibility record > Start Date Student Information > General > Enrollments > Start Date POSEligibility.startDate Enrollment.startDate
education Organization Reference	educationOrganizationId The identifier assigned to an education organization.	Report the Ed-Fi School ID. If Ed-Fi School ID is NULL, report: ttddddsss where: tt = district type dddd = district number, left zero filled sss = school number, left zero filled	M	System Administration > Resources > School > School Record > Ed-Fi School ID tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number SSS: System Administration > Resources > School > school record > State School Number School.entityID District.type District.number School.number
program Reference	educationOrganizationId The identifier assigned to an education organization. programName The formal name of the Program of instruction, training, services, or benefits available through Federal, state, or local agencies. programTypeDescriptor The type of program.	Report the following values within the program educationOrganizationId: Report the Ed-Fi District Number, if it exists If Ed-Fi District Number is NULL, report: ttddddsss where: tt = district type dddd = district number, left zero filled sss = 000 programName: 'School Food Service' programTypeDescriptor: 'School Food Service' uri://education.mn.gov/ProgramTypeDescriptor#School Food Service	M	System Administration > Resources > District Information > District Record > Ed-Fi District Number tt: System Administration > Resources > District Information > District Record > Type dddd: System Administration > Resources > District Information > District Record> State District Number District.entityID District.type District.number
endDate	A unique system-generated value that identifies the version of the resource.	Report the End Date from the FRAM record, if it exists. If the Enrollment End Date takes place before the FRAM record End Date, report the Enrollment End Date If no FRAM record End Date exists, do not report.	C	FRAM > Eligibility > Eligibility Record > End Date POSEligibility.endDate Student Information > General > Enrollments > Enrollment End Date Enrollment.endDate
schoolFoodService ProgramServices	Indicates the service(s) being provided to the student by the School Food Service Program.	See Array section for details.	O

Arrays

School Food Service Program Services

Data Element Label	Business Requirement	Logic	M, C or O	Location
schoolFoodService ProgramService Descriptor	Indicates the service being provided to the student by the School Food Service Program.	Reports based on the Eligibility Type selected for the student's FRAM record. Reports the full name of the Descriptor followed by the Descriptor Code, Example: "schoolFoodServiceProgramServiceDescriptor": uri://education.mn.gov/SchoolFoodServiceProgramServiceDescriptor#1 Report if POS Eligibility Type = M: Meal If 'Free' is selected, report '2' If 'Reduced' is selected, report '1' Otherwise, do not report	M	FRAM > Eligibility > Eligibility poseligibility.elgType
primaryIndicator	True if service is a primary service.	This is optional, does not report.	O
serviceBeginDate	First date the Student was in this option for the current school year.	This is optional, does not report.	O
serviceEndDate	Last date the Student was in this option for the current school year.	This is optional, does not report.	O
directCertification	Indicates that the student’s National School Lunch Program (NSLP) eligibility has been determined through direct certification.	Reports ‘True’ when a student's associated Eligibility Status is F (Free) or R (Reduced) and the POS Eligibility Source is 'Direct'.

Minnesota Ed-Fi Data v3.1 - Student School Food Service Program Associations