Student School Food Service Program Associations (Georiga v3.6.1)

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

Report a record when a student has an enrollment that overlaps the configured school year.

  • Do not report a record if the any of the following exclusions are present:
    • Enrollment State Exclude
    • Enrollment No Show
    • Enrollment Grade Exclude from State Reporting
    • Calendar Exclude
    • School Exclude
  • The Programs record must exist in the ODS prior to sending a Student School Food Service Program Associations record.
    • If the Programs record does not already exist in the ODS, the Programs record is sent prior to the Student School Food Service Program Associations.
  • If there are multiple enrollments, use the following priority list to determine which one should report:
    • Primary > Partial > SPED
    • Earliest Start Date
    • Latest Enrollment ID
  • A record is reported for each FRAM record that overlaps the current configured year (if the student has multiple FRAM records).
    • If the student has no FRAM records that overlap the current configured year, a single Student School Food Service Program Associations record reports.
Delete/Post/Put

A DELETE/POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

  • When the following information is changed on a FRAM record:

    • FRAM Program ID (New FRAM Record)
    • Start Date
    • End Date
    • State Eligibility Code
    • Source
  • When the following information is changed on an Enrollment:

    • Enrollment ID (New Enrollment)
    • State Exclude
    • No Show
Delete
  • When the enrollment being reported off of is deleted.
  • When the enrollment is changed to no longer overlap the configured year or excluded.
  • When the student is excluded through their enrollment, calendar, grade level, or school.
  • When the FRAM record being reported off of is deleted.
  • When the FRAM record is changed to no longer overlap 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.
  •  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.


Resource Preferences

Data Element Label

Mapping Needed

School Food Service Program Service Descriptor POS Eligibility

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 Requirement and Business Rules
M, C or O

Data Source GUI Path

Database Field
beginDate The month, day, and year on which the Student first received services.

  • Reports the Start Date of the FRAM record being reported.
  • For students that do NOT have a FRAM record, report as 07/01/startYear.
    • Start Year is the start year for the configured year being reported.
M

FRAM > Eligibility > Start Date

POSEligibility.startDate
educationOrganization
Reference
The education organization where the student is participating in or receiving the program services.

Reports the fields that are part of the Natural Key for the Schools resource.

  • educationOrganizationId = Ed-Fi School ID
M

System Administration > Resources > School > Ed-Fi School ID

School.entityID

programReferenceA reference to the Program Resource.

Reports the fields that are part of the Natural Key for the Programs resource.

  • educationOrganizationId = Ed-Fi School ID
  • programName = Student School Food Service (Hard-Coded)
  • programTypeDescriptor = Student School Food Service (Hard-Coded)
MSystem Administration > Resources > School > Ed-Fi School ID
School.entityID
studentReferenceA unique alpha-numeric code assigned to a student.

Reports the fields that are part of the Natural Key for the Students resource.

MN/A
N/A
directCertification

Indicates that the student’s National School Lunch Program (NSLP) eligibility has been determined through direct certification.


  • Reports TRUE if Source is set to "Direct".
  • Reports FALSE in all other situations.
CFRAM > Eligibility > SourcePOSEligibility.directType IS NOT NULL
endDateThe month, day, and year on which the student exited the program or stopped receiving services.

  • Reports the End Date of the FRAM record being reported.
  • For students that do NOT have a FRAM record, report 06/30/endYear.
    • End Year is the end year for the configured year being reported for.
C

FRAM> Eligibility> End Date

POSEligibility.endDate
schoolFoodServiceProgramServicesIndicates the service(s) being provided to the Student by the School Food Service Program.

Reports the below data elements in an array:

  • schoolFoodServiceProgramServiceDescriptor
    • Reports the Ed-Fi Code mapped to the State Eligibility Code calculated on the FRAM record being reported off of.
    • Reports N if the student does not have a FRAM record in the current configured year or their FRAM record does not have a State Eligibility Code that is mapped to an Ed-Fi Code.
MFRAM > Eligibility > State Eligibility CodePOSEligibility.eligibility

Type/Descriptors

Click here to expand...

programTypeDescriptor

Ed-Fi Code Value

Namespace

Ed-Fi Short Description

Ed-Fi Description
Student School Food Serviceuri://gadoe.org/ProgramTypeDescriptorStudent School Food ServiceStudent School Food Service

schoolFoodServiceProgramServiceDescriptor

Code Value

DescriptionNamespace

Short Description

FStudent is eligible for free meal programuri://gadoe.org/SchoolFoodServiceProgramServiceDescriptorStudent is eligible for free meal program
RStudent is eligible for reduced price meal programuri://gadoe.org/SchoolFoodServiceProgramServiceDescriptorStudent is eligible for reduced price meal program
NStudent is not eligible for free or reduced-price meal programuri://gadoe.org/SchoolFoodServiceProgramServiceDescriptorStudent is not eligible for free or reduced-price meal program