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

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.

ActionTrigger
Post

When a new enrollment with a distinct start date and State Enrollment Type of Primary is created.

  • Do not send a record if enrollment is in a grade level marked Exclude.
  • Do not send a record if enrollment is in a school marked Summer School.
  • Do not send a record if enrollment has State Enrollment Type of Coursework Only, PPP, or Programs Only.
  • If the student has more than one enrollment record, only one record will report.
  • 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.
  • 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 1 State Enrollment Type = Primary, the student will get a record for each enrollment.
  • If Ed-Fi Configuration Profile = Choice + Opt in report a record for all eligible students if Choice = Yes or No on the student's enrollment.
  • If Ed-Fi Configuration Profile = Choice AND Choice = No on the student's enrollment, do not report a record.
  • When a resync is completed for all schools, if a student has multiple enrollments that meet the requirements, any existing FRAM records for each enrollment in the reported year must remain.
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 State Exclude, No Show, or WISE 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.


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

beginDateStudent 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.
  1. Report the start of eligibility record.
  2. If the eligibility start date is prior to the start of the enrollment, report the enrollment start date.
  3. If there is no FRAM Eligibility record, report the enrollment start date.
  4. 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

educationOrganizationReferenceThe education organization where the student is participating in or receiving the program services.
  1. Report the Ed-Fi ID from the school the student's enrollment is tied to.
M



programReferenceA reference to the Program Resource.
  1. For Program Name report: "School Food Service Eligibility".
  2. For ProgramType Descriptor, report 'SFS'.
  3. for edOrgID: report '48856'.



studentReferenceA unique alpha-numeric code assigned to a student.
  1. 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.

  1. This is optional, does not report.
O

endDateStudent 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. 
  1. 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.
  2. 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


reasonExitedDescriptorThis descriptor defines the reason a student exited a program.
  1. This is optional, does not report.
O

schoolFoodServiceProgramServiceDescriptorIndicates the service(s) being provided to the Student by the School Food Service Program.
  1. If the student's enrollment school has a school history record where the Provision status is CEP AND the enrollment record is within the CEP Provision Base Year and Provision End Year window, report "Free Lunch".
  2. 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.
  3. Otherwise, If the student has no Eligibility record, report the values for "Full Price Lunch".
C


servedOutsideRegularSession

Indicates whether the Student received services during the summer session or between sessions.

  1. This is optional, does not report.
O


Type/Descriptors

Click here to expand...

School Food Service Descriptor

CodeDescription
F: FreeFree
N Full PriceFull Price
R: Reduced PriceReduced Price
U: UnknownUnknown