{"id":628,"date":"2013-07-10T14:06:08","date_gmt":"2013-07-10T14:06:08","guid":{"rendered":"http:\/\/psws.glenbard.org\/index.php\/2013\/07\/10\/business-searches\/"},"modified":"2022-08-02T10:27:43","modified_gmt":"2022-08-02T15:27:43","slug":"business-searches","status":"publish","type":"post","link":"https:\/\/docs.glenbard.org\/index.php\/ps-2\/admin-ps\/general-admin-ps\/business-searches\/","title":{"rendered":"Business Searches"},"content":{"rendered":"<div class=\"nolwrap\"><p>This article will cover all the business screen values and the common searches to help find the information with ease.<\/p>\n<p>Below are many of the pertinent fields on the business screen and the possible values.<\/p>\n<table border=\"0\">\n<tbody>\n<tr>\n<th>Location<\/th>\n<th>Field Name<\/th>\n<th>Possible values<\/th>\n<th>Search Example<\/th>\n<\/tr>\n<tr class=\"evenrow\">\n<td><\/td>\n<td>IL_LII<\/td>\n<td align=\"left\">Checked=1<\/p>\n<p>Not Checked=0 or blank<\/td>\n<td align=\"left\">IL_LII=1<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>lunch_status<\/td>\n<td align=\"left\">Pending<\/p>\n<p>Declined<\/p>\n<p>Free<\/p>\n<p>Reduced<\/p>\n<p>Blank (no application)<\/td>\n<td align=\"left\">Free Students<\/p>\n<p>lunch_status=Free<\/p>\n<p>Reduced Students<\/p>\n<p>lunch_status=reduced<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>lunch_date<\/td>\n<td align=\"left\">yyyymmdd<\/td>\n<td align=\"left\">Lunch status change on 1\/03\/2013<\/p>\n<p>lunch_date=20130103<\/p>\n<p>Lunch Status Change after 10\/12\/2013<\/p>\n<p>Lunch_date&gt;=20131012<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>reason<\/td>\n<td align=\"left\">Directly Certified=D<\/p>\n<p>Income=I<\/p>\n<p>Foster Child=F<\/p>\n<p>Homeless=H<\/p>\n<p>SNAP=S<\/p>\n<p>TANF=T<\/td>\n<td align=\"left\">Directly Certified Students<\/p>\n<p>reason=D<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>medicaid<\/td>\n<td align=\"left\">Checked=1<\/p>\n<p>Unchecked=0,blank<\/td>\n<td align=\"left\">Students directly Certified via medicaid<\/p>\n<p>medicaid=1<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Snap<\/td>\n<td align=\"left\">Checked=1<\/p>\n<p>Unchecked=0,blank<\/td>\n<td align=\"left\">Students directly Certified via SNAP<\/p>\n<p>snap=1<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>Tanf<\/td>\n<td align=\"left\">Checked=1<\/p>\n<p>Unchecked=0,blank<\/td>\n<td align=\"left\">Students directly Certified via TANF<\/p>\n<p>tanf=1<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>lunch_notes<\/td>\n<td align=\"left\">Any Text<\/td>\n<td align=\"left\">Contact IT<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>lunch_notes_private<\/td>\n<td align=\"left\">Any Text<\/td>\n<td align=\"left\">Contact IT<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>fee_status<\/td>\n<td align=\"left\">Fee application declined: declined<\/p>\n<p>Waived (&lt;=130% poverty guidelines): waived<\/p>\n<p>Waived (131-185% poverty guidelines): 185<\/p>\n<p>Regular Fees:\u00a0blank<\/td>\n<td align=\"left\">Student Waived<\/p>\n<p>fee_status in waived,185<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>fee_date<\/td>\n<td align=\"left\">yyyymmdd<\/td>\n<td align=\"left\">Fee status change on 1\/03\/2013<\/p>\n<p>fee_date=20130103<\/p>\n<p>Fee Status Change after 10\/12\/2013<\/p>\n<p>fee_date&gt;=20131012<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>fee_notes<\/td>\n<td align=\"left\">Any Text<\/td>\n<td align=\"left\">Contact IT<\/td>\n<\/tr>\n<tr>\n<td><\/td>\n<td>fee_notes_private<\/td>\n<td align=\"left\">Any Text<\/td>\n<td align=\"left\">Contact IT<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h1 id=\"common-searches\">Common Searches<\/h1>\n<table border=\"0\">\n<tbody>\n<tr>\n<th>What I am looking for<\/th>\n<th>Search Query<\/th>\n<\/tr>\n<tr class=\"evenrow\">\n<td align=\"left\">Students marked free after 08\/24\/2013<\/td>\n<td align=\"left\">lunch_date=20130824;lunch_status=free<\/td>\n<\/tr>\n<tr>\n<td align=\"left\">Students marked direct certified \u00a0after 12\/13\/2014<\/td>\n<td align=\"left\">lunch_status&gt;=20141213;reason=D<\/td>\n<\/tr>\n<tr>\n<td align=\"left\">All students Directly Certified by TANF after 11\/12\/2013<\/td>\n<td align=\"left\">lunch_date&gt;=20131112;tanf=1<\/td>\n<\/tr>\n<tr>\n<td align=\"left\">All students Directly Certified by SNAP after 11\/12\/2013<\/td>\n<td align=\"left\">lunch_date&gt;=20131112;snap=1<\/td>\n<\/tr>\n<tr>\n<td align=\"left\">All students Driectly Certified by Medicad only<\/td>\n<td align=\"left\">medicaid=1;tanf#1;snap#1<\/td>\n<\/tr>\n<tr>\n<td align=\"left\">All students Directly Certified by medicaid after 11\/12\/2013<\/td>\n<td align=\"left\">lunch_date&gt;=20131112;medicaid=1<\/td>\n<\/tr>\n<tr>\n<td align=\"left\">All students with their lunch status changed before 09\/01\/2013<\/td>\n<td align=\"left\">lunch_date&lt;=20130901;<\/td>\n<\/tr>\n<tr>\n<td align=\"left\">Students that were waived after 8\/02\/2013<\/td>\n<td align=\"left\">fee_date&gt;=20130802;fee_status in waived,185<\/td>\n<\/tr>\n<tr>\n<td align=\"left\">Students that had there fee status change before 9\/10\/2013<\/td>\n<td align=\"left\">fee_date&lt;=20130910<\/td>\n<\/tr>\n<tr>\n<td align=\"left\">Students that are Free Lunch but not directly certified<\/td>\n<td align=\"left\">lunch_status=free;reason#D;reason#F<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>This article will cover all the business screen values and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[100],"tags":[],"class_list":["post-628","post","type-post","status-publish","format-standard","hentry","category-general-admin-ps"],"acf":[],"_links":{"self":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/628","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/comments?post=628"}],"version-history":[{"count":8,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/628\/revisions"}],"predecessor-version":[{"id":6211,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/628\/revisions\/6211"}],"wp:attachment":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/media?parent=628"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/categories?post=628"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/tags?post=628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}