Classic View: System Administration > Ed-Fi

Search Terms: 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 is saved for a student, and there are one or more FRAM records saved that overlap the enrollment record, with an eligibility of 'Free' or 'Reduced'. Or When a new FRAM record is saved that overlaps one or more enrollment records . When a student has two enrollments in the same School, Calendar & Schedule Structure with the same start date, report from the enrollment service type in the following order: P: Primary Enrollment S: Partial/Ancillary N: Special Ed Services When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record. Do not send records if the Calendar Exclude checkbox is checked in the calendar the student is enrolled. Do not send records if the School Exclude checkbox is checked in the calendar the student is enrolled. Do not send a record if the No Show checkbox is checked. When a new FRAM record is saved for a student, and there is a reportable enrollment record that overlaps the FRAM record. When the FRAM record's Start Date or End Date are updated so that they newly overlap a reportable enrollment record. When the Enrollment record's Start Date or End Date are updated so that they newly longer overlap a FRAM record. Do not send a record with an Eligibility of 'Paid'. Do not send a record if the enrolling school site classification on the corresponding SSA is 45: Targeted Services or 51: SpEd ESY (Object Triggering requirement R1.BR6).
Put	When the start date for an enrollment is changed. When an enrollment with a lower priority is changed, data will not send. When an enrollment is updated for a student. When the FRAM record is updated for a student. When the Certified Type of the FRAM record is updated.
Delete	When an enrollment is deleted. When a student has two enrollments in the same school for the same start date, records with lower priority will not trigger a delete. When the No Show checkbox is checked. When the FRAM record is deleted. When the FRAM record's Start Date or End Date are updated so that they no longer overlap a reportable enrollment record. When the FRAM record's eligibility is changed from either 'Free' or 'Reduced' to 'Paid'.

Action

Trigger

Post

When a new enrollment is saved for a student, and there are one or more FRAM records saved that overlap the enrollment record, with an eligibility of 'Free' or 'Reduced'.

When a new FRAM record is saved that overlaps one or more enrollment records .

When a student has two enrollments in the same School, Calendar & Schedule Structure with the same start date, report from the enrollment service type in the following order:
1. P: Primary Enrollment
2. S: Partial/Ancillary
3. N: Special Ed Services
When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record.
Do not send records if the Calendar Exclude checkbox is checked in the calendar the student is enrolled.
Do not send records if the School Exclude checkbox is checked in the calendar the student is enrolled.
Do not send a record if the No Show checkbox is checked.
When a new FRAM record is saved for a student, and there is a reportable enrollment record that overlaps the FRAM record.
When the FRAM record's Start Date or End Date are updated so that they newly overlap a reportable enrollment record.
When the Enrollment record's Start Date or End Date are updated so that they newly longer overlap a FRAM record.
Do not send a record with an Eligibility of 'Paid'.
Do not send a record if the enrolling school site classification on the corresponding SSA is 45: Targeted Services or 51: SpEd ESY (Object Triggering requirement R1.BR6).

Put

When the start date for an enrollment is changed.

When an enrollment with a lower priority is changed, data will not send.
When an enrollment is updated for a student.
When the FRAM record is updated for a student.
When the Certified Type of the FRAM record is updated.

Delete

When an enrollment is deleted.

When a student has two enrollments in the same school for the same start date, records with lower priority will not trigger a delete.
When the No Show checkbox is checked.
When the FRAM record is deleted.
When the FRAM record's Start Date or End Date are updated so that they no longer overlap a reportable enrollment record.
When the FRAM record's eligibility is changed from either 'Free' or 'Reduced' to 'Paid'.

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. Natural Key changes: 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.
Natural Key changes: 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.
The FRAM eligibility end year must be the same as the Ed-Fi config year.

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	Location
id	The unique identifier of the resource.		M
beginDate	The month, day, and year on which the Student first received services.	Report the Start Date from the FRAM record. If the Enrollment Start Date takes place after the FRAM record Start Date, report the Enrollment Start Date.	M	FRAM > Eligibility > eligibility record > Start Date Student Information > General > Enrollments > Start Date POSEligibility.startDate Enrollment.startDate
education Organization Reference	educationOrganizationId The identifier assigned to an education organization.	Report the Ed-Fi School ID. If Ed-Fi School ID is NULL, report: ttddddsss where: tt = district type dddd = district number, left zero filled sss = school number, left zero filled	M	System Administration > Resources > School > School Record > Ed-Fi School ID tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number SSS: System Administration > Resources > School > school record > State School Number School.entityID District.type District.number School.number
program Reference	educationOrganizationId The identifier assigned to an education organization. programName The formal name of the Program of instruction, training, services, or benefits available through Federal, state, or local agencies. programTypeDescriptor The type of program.	Report the following values within the program educationOrganizationId: Report the Ed-Fi District Number, if it exists If Ed-Fi District Number is NULL, report: ttddddsss where: tt = district type dddd = district number, left zero filled sss = 000 programName: 'School Food Service' programTypeDescriptor: 'School Food Service' uri://education.mn.gov/ProgramTypeDescriptor#School Food Service	M	System Administration > Resources > District Information > District Record > Ed-Fi District Number tt: System Administration > Resources > District Information > District Record > Type dddd: System Administration > Resources > District Information > District Record> State District Number District.entityID District.type District.number
directCertification	Indicates that the student’s National School Lunch Program (NSLP) eligibility has been determined through direct certification.	Report true if the student's associated Eligibility Status is 'F' or 'R'. AND POS Direct Certified Type is not NULL = Eligibility Source in UI is "Direct".	C	FRAM > Eligibility > Eligibility >Eligibility Detail > Source > Certified Type poseligibility.elgType POSEligibility.directType
endDate	A unique system-generated value that identifies the version of the resource.	Report the End Date from the FRAM record, if it exists. If the Enrollment End Date takes place before the FRAM record End Date, report the Enrollment End Date. If no FRAM record End Date exists, do not report.	C	FRAM > Eligibility > Eligibility Record > End Date Student Information > General > Enrollments > Enrollment End Date POSEligibility.endDate Enrollment.endDate
schoolFoodService ProgramServices	Indicates the service(s) being provided to the student by the School Food Service Program.	See Array section for details.	O

Arrays

School Food Service Program Services

Data Element Label	Business Requirement	Logic	M, C or O	Location
schoolFoodServiceProgram ServiceDescriptor	Indicates the service being provided to the student by the School Food Service Program.	Reports based on the Eligibility Type selected for the student's FRAM record. Reports the full name of the Descriptor followed by the Descriptor Code Example: "schoolFoodServiceProgramServiceDescriptor": uri://education.mn.gov/SchoolFoodServiceProgramServiceDescriptor#1 Report if POS Eligibility Type = M: Meal If 'Free' is selected, report '2' If 'Reduced' is selected, report '1' Otherwise, do not report	M	FRAM > Eligibility > Eligibility POSEligibility.elgType POSEligibility.eligibility POSEligibility.stateCode
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

Resource Preferences

The Ed-Fi Configuration tool is used to establish Ed-Fi data resources.

The following describes how to set the resource preferences for the Student School Food Service Program Association resource. If the Configure or Edit buttons do not display, then the resource does not need to be mapped and the toggle button can be used to turn the resource on or off.

If a mapping is changed, a resync must be performed on the resource in order for the new mappings to send correctly.

Select the appropriate Ed-Fi Code for the Student School Food Service Descriptors.
Any item not mapped will not report to Ed-Fi.
POS Eligibility
UI Location FRAM > Eligibility > Eligibility
Attribute Dictionary System Administration > Custom > Attribute Dictionary > POS Eligibility
Click Save.

POS Eligibility
UI Location	FRAM > Eligibility > Eligibility
Attribute Dictionary	System Administration > Custom > Attribute Dictionary > POS Eligibility

MN v3.3 - Student School Food Service Program Associations