Report 21033 Food Services - Master Eligibility List (Form 128)

Modified on Tue, May 2, 2023 at 10:13 AM

21033 Food Services- Master Eligibility List (Form 128)

Sample Output

Parameters

Report Parameter	Notes
Students with lunch tracking records that are active on
Run for School (Blank = all)
Run for Resident District (Blank = all)
In District Schools Only	NO, Yes
Sort by	Student Name, Application Number, Grade

Report Totals Question

If you are wondering why all of your totals do not perfectly add to the number of students, there is a perfectly reasonable explanation. Depending on the lunch code, a student can qualify for Free multiple times. This will obviously count a student twice towards you free totals which will make your lunch count greater than your student count.

Source of Data

Database Table	Genesis Object	Notes
ATTENDANCE_DAILIES2	AttendanceDaily2
ATTENDANCE_RECORDS2	AttendanceRecord2
DISTRICTS	District
LUNCH_APPL_STUDENTS	LunchApplicationStudent
LUNCH_CODES	LunchCode
LUNCH_TRACKING	LunchTrackingRecord
RESIDENT_DISTRICT_TRACKING
SCHOOLS	School
STUDENTS	Student

PLEASE NOTE

This report must be run for a valid day of school.

Notes

Food Services: Master Eligibility List (Form 128) - Data for this report comes from the Lunch Tracking Records and the Food Services Applications.
If the Date Of Application is after the report date, then the application is not be reported.
When running the report for a Resident School District:
- The list shows only districts that students in your district reside in.
- The report determines a student is in that district by looking at the Resident District Tracking record for that student as of the date of the report.
Report only pulls students who have an active Lunch Tracking Record as of the date selected. All other students are removed.
The Withdrawn column represents the student's current Exit/Withdrawal Date.
- The withdrawal date only populates if it is on or before the date selected when running the report.