Student School Food Service Program Associations (New Mexico v3.5)

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 a FRAM record that overlaps the enrollment and 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. Enrollment Start Date
Put	When any field not part of the natural key is changed. When any of the following fields are changed on the FRAM record being reported: Start Date End Date Eligibility Certified Type
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. Natural Key changes: 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.
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	Logic	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
beginDate	The earliest date the student is involved with the program. Typically, this is the date the student becomes eligible for the program.	Report the Start Date of the student's enrollment. If multiple enrollments exist for the student in the current config year, report the Start Date of the earliest enrollment record.	M	Student Information > General > Enrollment > Start Date	enrollment.startDate
educationOrganization Reference	The education organization where the student is participating in or receiving the program services.	Report the Ed-Fi School ID for education Organization ID.	M	System Administration > Resources > School > Ed-Fi School ID
programReference	A reference to the Program Resource.	Report the Natural Key from the Programs resource. Report the Ed-Fi District Number for educationOrganizationId. Report Student School Food Service for programName. Report Student School Food Service for ProgramTypeDescriptor.	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.	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 below.	M
directCertificationStatusDescriptor	Identifies the Direct Certification Status of a student. This does not apply to all students in the district. Valid values: 1 = SNAP Direct Cert as identified in the direct certification report and certified by the district. 2 = Other Direct Cert Eligible (Homeless, FDPIR, Foster, Migrant, and Head Start) 3 = Family Members of SNAP identified students that were not found in the Direct Certification report.	If 'Eligibility' on the FRAM record being sent is F: Free or R: Reduced: Report 1 if Certified Type is SP (SNAP) on the FRAM record being sent. Report 2 if Certified Type is H (Homeless), FD (FDPIR), F (Foster), M (Migrant), or HS (Head Start). Note: Logic for reporting Code 3 (Family Members of SNAP identified students that were not found in Direct Certification report) is not present at this time. It is NOT currently needed for this year's reporting, but may need to be added in the future. Otherwise, do not report.	C	FRAM > Eligibility > Eligibility Editor > Eligibility Detail: Direct Certified Type
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.	Report the Ed-Fi Code that is mapped to the value selected for 'Eligibility' on the FRAM record being sent.	M	FRAM> Eligibility > Eligibility Editor > Eligibility Detail: School Year Start Date End Date EligibilityType	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.	Report the Start Date of the FRAM record being sent.	M	FRAM> Eligibility > Eligibility Editor > Eligibility Detail > Start Date
serviceEndDate	Last date the Student was in this option for the current school year.	Reports the End Date of the FRAM record being sent.	C	FRAM> Eligibility > Eligibility Editor > Eligibility Detail > End Date

Type/Descriptors