Student School Food Service Program Associations (Kansas v3.6)
Last Modified on 03/08/2024 10:14 am CST
In This Article
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
Action
Trigger
Post
When the student has a FRAM record which overlaps their Enrollment in the configured year and the student has a State Eligibility Code greater than 0 (zero).
Does not send a record when the enrollment is in a calendar marked as Exclude.
Does not send a record when the enrollment is in a school marked as Exclude.
Does not send a record when 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
Delete
All enrollments are deleted for a student.
Delete
When the student's enrollment is marked as No Show or State Exclude.
Delete
When the Eligibility record is deleted.
Delete
When 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
Action
Trigger
None
When a resource is toggled to OFF after data has sent, all sent data remains in the ODS but no new data is sent.
Resync
When a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table.
Resync
When a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS.
Resync
When a mapping is changed in Resource Preferences, a resync needs to be done to reflect the changes.
Natural Key Changes, Cascading Updates, and Deletes Logic
Action
Trigger
Post/Delete
Natural Key changes:
LEA Reference - District Numbers cannot change after data has been sent. When a district number changes, we would expect an Ed-Fi error and this change would not be supported.
When an Ed-Fi ID changes, a delete/post occurs with the cascading deletes from the Ed-Fi ID Change triggers.
When the Program Name or Program Type Descriptor mapping changes and a resync is completed.
When the Eligibility record Start Date changes the resource deletes/reposts.
Delete
Cascading Deletes: N/A - no dependent resources.
Scope Year Logic
Logic
The record sends to the configured year that the School Year from the Eligibility record aligns to when the student has an enrollment in that year.
Data only sends 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
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 and Rules
Mandatory, Conditional or Optional
Location
id
The unique identifier of the resource.
M
beginDate
The month, day, and year on which the Student first received services.
Reports the latest of the FRAM Record Start Date and the student's Enrollment Start Date in the config year
When multiple enrollments exist for the student in the current config year, reports the Start Date of the primary active enrollment record.
M
FRAM > Eligibility > Start Date
poseligibility.startDateStudent Information > General > Enrollments > Start Date
Enrollment.startDate
educationOrganizationReference
The education organization where the student is participating in or receiving the program services.
Reports the Ed-Fi School ID of the Accountability School for the educationOrganizationId
Logic for determining Accountability School:
Reports from Enrollment Override location
When the Override location is NULL, report State School Number
M
Student Information > General > Enrollments > State Reporting Fields > AYP Override 1
System Administration > Resources > School > Ed-Fi School ID
programReference
A reference to the Program Resource.
Report the Natural Key from the Programs resource.
educationOrganizationId = Ed Fi School ID of the Accountability School
Report from Enrollment Override location.
When the Override location is NULL, report State School Number
programName = Student School Food Service
programTypeDescriptor = Student School Food Service
M
FRAM > Eligibility
studentReference
A unique alpha-numeric code assigned to a student.
Reports the Natural Key for the Student resource
studentUniqueID reports from the Student State Id field.
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 (per Core logic).
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
School Food Service Program Services
Data Element Label
Business Requirement and Logic
Mandatory, Conditional, or Optional
Logic
schoolFoodServiceProgram ServiceDescriptor
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.
Logic for determining State Eligibility Code:
State Eligibility Code is a value of 1 when the following is set up:
Eligibility = 'Reduced'
AND Source = 'Direct'
OR Source = 'Non-Direct'
AND Certified Type != 'Socioeconomic Status'
State Eligibility Code is a value of 2 when the following is set up:
Eligibility = 'Free'
AND Source = 'Direct'
OR Source = 'Non-Direct'
AND Certified Type != 'Socioeconomic Status'
State Eligibility Code is a value of 3 when the following is set up:
Eligibility Type = 'SES'
AND Eligibility = 'Reduced'
AND Source = 'Non-Direct'
AND Certified Type = 'Socioeconomic Status'
State Eligibility Code is a value of 4 when the following is set up:
Eligibility Type = 'SES'
AND Eligibility = 'Free'
AND Source = 'Non-Direct'
AND Certified Type = 'Socioeconomic Status'
Reports the full name of the Descriptor followed by the Descriptor Code.
Report the Descriptor Code associated with State Eligibility Code.
State Eligibility Code
Descriptor Code
1
Reduced Price Lunch - Direct Certification
2
Free Lunch - Direct Certification
3
Reduced Price Lunch - Household Economic Survey
4
Free Lunch - Household Economic Survey
M
State Eligibility Code is calculated using the following fields:
FRAM > Eligibility > Eligibility Type
FRAM > Eligibility > Eligibility
FRAM > Eligibility > Source
FRAM > Eligibility > Certified Type
poseligibility.elgType
primaryIndicator
True when 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.
Eligible for Reduced Price Lunch as determined by the National School Lunch Program Application or Direct Certification with Medicaid (Reduced)
Free Lunch - Direct Certification
Eligible for Free Lunch as determined by the National School Lunch Application or the Direct Certification process including Direct Certification with Medicaid (Free)
Eligible for Free Lunch as determined by the National School Lunch Application or the Direct Certification process including Direct Certification with Medicaid (Free)
Reduced Price Lunch - Household Economic Survey
Eligible for Reduced Price Lunch as determined by the KSDE Household Economic Survey.