MN v3.3 - Student School Food Service Program Associations

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 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:

    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.

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

If the student's enrollment has an End Date before the config year End Date, report the enrollment End Date.

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

Location

id The unique identifier of the resource.
M
beginDateThe 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 > Application Processing > 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

School & District Settings > Schools > School Information > School Record > Ed-Fi School ID


tt: School & District Settings > District > District Information > district record > Type


dddd: School & District Settings > District > District Information > district record > State District Number


SSS: School & District Settings > Schools > School Information > 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

School & District Settings > District > District Information > District Record > Ed-Fi District Number


tt: School & District Settings > District > District Information > District Record > Type


dddd: School & District Settings > District > District Information > District Record> State District Number


District.entityID

District.type

District.number

directCertificationIndicates 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".
CFRAM > Application Processing > Eligibility > Eligibility >Eligibility Detail > Source > Certified Type

poseligibility.elgType

POSEligibility.directType

endDateA unique system-generated value that identifies the version of the resource.
  1. 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.
  2. If no FRAM record End Date exists, do not report.
C

FRAM > Application Processing > 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 LabelBusiness RequirementLogicM, 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 
  1. If 'Free' is selected, report '2'
  2. If 'Reduced' is selected, report '1'
  3. Otherwise, do not report


MFRAM > Application Processing > 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.
  1. 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 LocationFRAM > Application Processing > Eligibility > Eligibility
    Attribute DictionarySystem Settings > Custom Data and Links > CORE Attribute Dictionary > POS Eligibility

  2. Click Save.