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 Regular Fees: blank |
Student Waived
fee_status in waived,185 |
|
| 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 |
| 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 |