Business Searches

This article will cover all the business screen values and the common searches to help find the information with ease.

Below are many of the pertinent fields on the business screen and the possible values.

Location Field Name Possible values Search Example
IL_LII Checked=1

Not Checked=0 or blank

IL_LII=1
lunch_status Pending

Declined

Free

Reduced

Blank (no application)

Free Students

lunch_status=Free

Reduced Students

lunch_status=reduced

lunch_date yyyymmdd Lunch status change on 1/03/2013

lunch_date=20130103

Lunch Status Change after 10/12/2013

Lunch_date>=20131012

reason Directly Certified=D

Income=I

Foster Child=F

Homeless=H

SNAP=S

TANF=T

Directly Certified Students

reason=D

medicaid Checked=1

Unchecked=0,blank

Students directly Certified via medicaid

medicaid=1

Snap Checked=1

Unchecked=0,blank

Students directly Certified via SNAP

snap=1

Tanf Checked=1

Unchecked=0,blank

Students directly Certified via TANF

tanf=1

lunch_notes Any Text Contact IT
lunch_notes_private Any Text Contact IT
fee_status Fee application declined: declined

Waived (<=130% poverty guidelines): waived

Waived (131-185% poverty guidelines): 185

Waived (186-260% poverty guidelines): 260

Regular Fees: blank

Student Waived

fee_status in waived,185,260

fee_date yyyymmdd Fee status change on 1/03/2013

fee_date=20130103

Fee Status Change after 10/12/2013

fee_date>=20131012

fee_notes Any Text Contact IT
fee_notes_private Any Text Contact IT

Common Searches

What I am looking for Search Query
Students marked free after 08/24/2013 lunch_date=20130824;lunch_status=free
Students marked direct certified  after 12/13/2014 lunch_status>=20141213;reason=D
All students Directly Certified by TANF after 11/12/2013 lunch_date>=20131112;tanf=1
All students Directly Certified by SNAP after 11/12/2013 lunch_date>=20131112;snap=1
All students Driectly Certified by Medicad only medicaid=1;tanf#1;snap#1
All students Directly Certified by medicaid after 11/12/2013 lunch_date>=20131112;medicaid=1
All students with their lunch status changed before 09/01/2013 lunch_date<=20130901;
Students that were waived after 8/02/2013 fee_date>=20130802;fee_status in waived,185,260
Students that had there fee status change before 9/10/2013 fee_date<=20130910
Students that are Free Lunch but not directly certified lunch_status=free;reason#D;reason#F