Student School Food Service Program Associations (Kansas v3.6)
Last Modified on 03/08/2024 10:14 am CST
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. |
| 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.startDate
Student 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
Click here to expand...
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.
This is optional, does not report. | O |
|
Type/Descriptors
Click here to expand...
Program Type Descriptor
School Food Service Program Service Descriptor
| Code Value | Description | namespace | Short Description |
|---|
| Reduced Price Lunch - Direct Certification | Eligible for Reduced Price Lunch as determined by the National School Lunch Program Application or Direct Certification with Medicaid (Reduced) | uri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptor | 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) | uri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptor | 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. | uri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptor | Eligible for Reduced Price Lunch as determined by the KSDE Household Economic Survey. |
| Free Lunch - Household Economic Survey | Eligible for Free Lunch as determined by the KSDE Household Economic Survey. | uri://ed-fi.org/SchoolFoodServiceProgramServiceDescriptor | Eligible for Free Lunch as determined by the KSDE Household Economic Survey. |
