Student School Food Service Program Associations (Wisconsin v3.6)

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 a new enrollment with a distinct start date and State Enrollment Type of Primary is created. If the student has a FRAM record that overlaps the enrollment, the record will post using that records data. If the student does not have a FRAM record that overlaps the enrollment, the record will post using the enrollment Start and End Dates. If the student has more than one State Enrollment Type that is Primary, the student getf a record for each enrollment in each school. Do not send a record if enrollment is in a calendar marked as Exclude. Do not send a student record for an enrollment that is marked as State Exclude, No Show, or WISE 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
Delete	All enrollments are deleted for a student.
Delete	If the student's enrollment is marked as State Exclude, No Show, or WISE Exclude.
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.

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	Student enrollment entry date OR The month, day, and year on which the Student began receiving services in the school year the data is being submitted. it should be within the enrollment period. If the student receives program services over multiple school years, there should be a new record submitted each school year.	Report the start of eligibility record. If the eligibility start date is prior to the start of the enrollment, report the enrollment start date. If there is no FRAM Eligibility record, report the enrollment start date. If a FRAM Eligibility has ended and there is no new FRAM record, but still an active enrollment, report the day after the FRAM record.	M	Student Information > General > Enrollment > Start Date or FRAM> Eligibility > Start Date	enrollment.startDate poseligibility.startDate
educationOrganization Reference	The education organization where the student is participating in or receiving the program services.	Report the Ed-Fi ID from the school the student's enrollment is tied to.	M
programReference	A reference to the Program Resource.	For Program Name report: "School Food Service Eligibility". For ProgramType Descriptor, report 'SFS'. for edOrgID: report '48856'.
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	Student enrollment exit date or the month, day, and year on which the Student exited the Program or stopped receiving services., It should be within the enrollment period.	Report the end date of the FRAM Eligibility record. If the eligibility end date is prior to the end of the enrollment, report the enrollment end date. If the enrollment end date is after the last instructional day for the calendar of the enrollment, report the last instructional day. If the student has more than 1 enrollment, report the date from the Primary enrollment. If the end date is after the last instructional day of the calendar, report the last instructional day. If there is no eligibility record associated with the SSFSPA record, send a default record and report the earliest of: Enrollment end date if it is before the last instructional day of the calendar of enrollment. If enrollment end date is null, report the last instructional day. The day before a new FRAM record's start date if it is before the last instructional day for the calendar of enrollment.	C	Student Information > General > Enrollment > End Date or FRAM> Eligibility > End Date	enrollment.endDate poseligibility.endtDate
reasonExitedDescriptor	This descriptor defines the reason a student exited a program.	This is optional, does not report.	O
schoolFoodServiceProgram ServiceDescriptor	Indicates the service(s) being provided to the Student by the School Food Service Program.	If the student's enrollment school has any school history record where the Provision status is CEP, is within the Provision Base Year and Provision End Year window, report 'Free Lunch' when the Provision status on the current School Record is CEP . If the School is not CEP or the CEP provision window is not active during the student's enrollment, report the value mapped to the student's Eligibility record value. Otherwise, If the student has no Eligibility record, report the following: If Unknown FRAM Eligibility is checked on the student's most recent Enrollment, report "Unknown". If Unknown FRAM Eligibility is not checked on the student's most recent Enrollment, report "Full Price Lunch".	C
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
schoolFoodServiceProgram ServiceDescriptor	Indicates the service being provided to the student by the School Food Service Program.	If the student's enrollment school has a current school record where the Provision status = CEP and is active within the base year to provision year window, report 'Free Lunch' when the Provision status on the current School Record is = CEP . If the School is not CEP or the CEP provision window is not active during the student's enrollment, Report the value mapped to the student's Eligibility record value. Otherwise, If the student has no Eligibility record, report the values for "Full Price Lunch".	C	FRAM > Eligibility > Eligibility System Administration > Resources > School > School History > USDA Programs	poseligibility.elgType

Data Element Label

Business Requirement

Logic

M, C or O

Data Source GUI Path

Database Field

schoolFoodServiceProgram
ServiceDescriptor

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

If the student's enrollment school has a current school record where the Provision status = CEP and is active within the base year to provision year window, report 'Free Lunch' when the Provision status on the current School Record is = CEP .
If the School is not CEP or the CEP provision window is not active during the student's enrollment, Report the value mapped to the student's Eligibility record value.
Otherwise, If the student has no Eligibility record, report the values for "Full Price Lunch".

FRAM > Eligibility > Eligibility

System Administration > Resources > School > School History > USDA Programs

poseligibility.elgType

Type/Descriptors