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

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. Do not send a record if enrollment is in a calendar marked as Exclude. Do not send a record if enrollment is in a school marked as Exclude. Do not send a record if 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. End Date Eligibility
Delete	All enrollments are deleted for a student.
Delete	If the student's enrollment is marked as No Show.
Delete	If the Eligibility record is deleted.
Delete	If 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	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.

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	Logic	M, C or O	Data Source GUI Path	Database Field
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. Report within the fiscal calendar 07/01-06/30.	M	FRAM> Eligibility > Start Date	poseligibility.startDate
educationOrganizationReference	The education organization where the student is participating in or receiving the program services.	Report the State District Number.	M	System Administration> Resources> District Information> State District Number	district.number
programReference	A reference to the Program Resource.	Reports the Natural Key for the Program resource.	M
studentReference	A unique alpha-numeric code assigned to a student.	Reports the Natural Key for the Student resource.	M
directCertification	Indicates that the student’s National School Lunch Program (NSLP) eligibility has been determined through direct certification.	This is optional, does not report.	O
endDate	The month, day, and year on which the student exited the program or stopped receiving services.	Reports the end date of the Eligibility record being reported. Report within the fiscal calendar 07/01-06/30.	O	FRAM> Eligibility> End Date	poseligibiliy.enddate
reasonExitedDescriptor	This descriptor defines the reason a student exited a program.	This is optional, does not report	O
schoolFoodServiceProgramServices	Indicates the service(s) being provided to the Student by the School Food Service Program.	See Array section for details.	O
servedOutsideRegularSession	Indicates whether the Student received services during the summer session or between sessions.	This is optional, does not report.	O

Arrays

Click here to expand...

School Food Service Program Services

Data Element Label	Business Requirement	Logic	M, C or O	Data Source GUI Path	Database Field
schoolFoodServiceProgramServiceDescriptor	Indicates the service being provided to the student by the School Food Service Program.	This descriptor defines indications of a student's level of eligibility for breakfast, lunch, snack, supper and milk programs. If a student has a FRAM record with a type of FREE report that student as a Free Eligible student. If a student has a FRAM record with a type of Reduced report that student as a Reduced Eligible student. If a student has a Campus FRAM record, but it is marked as not eligible, report this student as 0. If the Hot Lunch Facility = ‘Yes’, report the following values: If no eligibility record exists OR their Eligibility = Paid, report ‘0’ If there is an active eligibility record and Free status, and Special Milk Checkbox is off (unchecked), report code of ‘1’ If there is an active eligibility record and Reduced status, and Special Milk checkbox is off (unchecked), report ‘2’. If there is an active eligibility record and Free or Reduced status, and Special Milk checkbox is on (checked), report ‘3’. If the Hot Lunch Facility = ‘No’, report the following values: If there is an active eligibility record and Free or Reduced Status, report as 3, ignoring the special milk checkbox. If the Provision field on the School editor is set to CEP, report a 4 for all students. CEP will keep all individual FRAM records form reporting - it is an override for all students in the school. If the student has more than one enrollment, report from the Primary Enrollment. If the student does not have a Primary enrollment, then report from the enrollments with Service Types in the the following order: S: Ancillary Enrollment N: Special Education If the student has multiple enrollments with the same service type, report from earliest enrollment ID. Use the highest enrollmentID if multiple of same serviceTypes and startDates.	M	FRAM> Eligibility> Eligibility System Administration > Resources > School > USDA Programs	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

Type/Descriptors