Blog | Level Data

How to Generate Lunch Exception Report in PowerSchool

Written by Tom Lang | March 15, 2022 at 2:00 PM

Funding is always a major concern for schools and making sure they're getting all the funding available is especially important.

One area of particular concern is funding based on a student's poverty status. In many instances, this information is based on a student's lunch status field.

Making sure that data is accurate is of significant importance as it not only affects reimbursement for meals but can also impact funding areas such as title and e-rate reimbursement.

Unfortunately for schools, this data is often stored in multiple places, so making sure the data is accurate is even more complicated. 

However, with the use of Level Data’s use of lunch status analysis and lunch exception report, reviewing the data for accuracy just got easier.

The lunch expectation report provides a quick and easy way for schools to identify households where not all students share the same lunch status value.

By identifying all students associated with a specific home address and then comparing the lunch status values for all students the report returns a record for each address where a mismatch exists, making it easy for schools to identify, review, and correct those issues.

The lunch status report is a district-based report and incorporates field-level security on the lunch status field, as a result, the user must be in the district office and must have permission to view the lunch status field to be able to run this report. 

 

How to run the report:

Once in the district office, from the start page, click on the link for RealTime Reports and then select the Lunch Exception Report. When the report loads, you'll see a row for each address where a mismatch excites.

To view the associated student records, click on the arrow at the left of the record or to view all records at once, click the expand all at the top of the page. Users can then filter as needed based on the returned address, the student's login ID, and/or his student enrollment status. 

Once filtered, you can either make this group the current student selection for use on the PowerSchool side or you can export the records to a CSV file to be shared with other appropriate personnel.

Please note that this report is not meant to be the final determining factor as to whether the data contained is correct. It's merely meant to identify when students within the same household do not share the same lunch status value.

It is the responsibility of the districts to determine if the data is accurate and to make any necessary corrections.

Getting to your data has never been easier.