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

Tool Search: Ed-Fi Configuration

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.

ActionTrigger
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 or State Exclude.
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
DeleteAll enrollments are deleted for a student.
DeleteIf the student's enrollment is marked as No Show or State Exclude.
DeleteIf the Eligibility record is deleted.
DeleteIf 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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
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.
DeleteCascading 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

POSEligibilityschoolFoodServiceProgramServiceDescriptor

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
POSEligibilityPost/Put/DeleteThe 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 LabelBusiness RequirementLogicM, C or O

Data Source GUI Path

Database Field
id The unique identifier of the resource.
M

beginDateThe month, day, and year on which the Student first received services.

Reports the start date of the Eligibility record 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.

Report the State District Number.

M

System Administration> Resources> District Information> State District Number

district.number

programReferenceA reference to the Program Resource.

Reports the Natural Key for the Program resource.

M

studentReferenceA 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

endDateThe 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
reasonExitedDescriptorThis descriptor defines the reason a student exited a program.

This is optional, does not report.

O

schoolFoodServiceProgram
Services
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 LabelBusiness RequirementLogicM, C or O

Data Source GUI Path

Database Field
schoolFoodServiceProgramServiceDescriptor

Indicates the service being provided to the student by the School Food Service Program.

Reports the mapped Ed-Fi Code from the Eligibility Type selected for the student.

MFRAM> Eligibility> Eligibilityposeligibility.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

Click here to expand...

School Food Service Program Service Descriptor

codeValuedescriptionnamespaceshortDescription
Free BreakfastFree Breakfasturi://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorFree Breakfast
Free LunchFree Lunchuri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorFree Lunch
Free MilkFree Milkuri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorFree Milk
Free SnackFree Snackuri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorFree Snack
Free SupperFree Supperuri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorFree Supper
Full Price BreakfastFull Price Breakfasturi://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorFull Price Breakfast
Full Price LunchFull Price Lunchuri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorFull Price Lunch
Full Price MilkFull Price Milkuri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorFull Price Milk
Full Price SnackFull Price Snackuri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorFull Price Snack
Full Price SupperFull Price Supperuri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorFull Price Supper
OtherOtheruri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorOther
Reduced Price BreakfastReduced Price Breakfasturi://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorReduced Price Breakfast
Reduced Price LunchReduced Price Lunchuri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorReduced Price Lunch
Reduced Price SnackReduced Price Snackuri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorReduced Price Snack
Reduced Price SupperReduced Price Supperuri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptorReduced Price Supper