Application Data Report

Reports > Eligibility > Application Data

The Application Data Report presents detailed information on meal applications.

1. Name - enter a report name
   Default: Application Data

2. Output - select output format
   Csv, Excel, Html, Json, or Pdf (default)

3. Template - select a report template
   Note: As of February 14, 2022, newly created districts will have the Benefit Issuance Document template available by default.

4. Reset - click to reset to default options

5. Student - filter by specific students

6. Academic Year - filter by academic year

7. Gender - filter by gender (Male, Female, Non-Binary)

8. Races - filter by races

9. Student Tags - filter by student tags

10. Ethnicities - filter by ethnicities

11. Allergies - filter by allergies

12. Include Inactive - check to include inactivated students

13. Schools - filter by enrollment school

14. Enrolled On - filter by enrollment date
    Default: Today

15. Enrollment Start Date Range - filter by enrollment start date range

16. Grade Levels - filter by enrollment grade level

17. Home Rooms - filter by enrollment home rooms

18. Enrollment End Date Range - filter by enrollment end date range

19. Application Source - filter by Application Source

20. Application Processed Date Range - filter by date of processing

21. Eligibility Start Date Range - filter by eligibility start date range

22. Application Question - filter by Meal Application Question

23. Has Application in Verification For School Year - filter for students selected for verification for the selected year

24. Eligibility Statuses - filter by application Eligibility Status

25. Eligible On - filter by eligibility date

26. Eligibility End Date Range - filter by eligibility end date range

27. Eligibility Determination Reason - filter by eligibility determination reason

28. Eligibility Benefit Type - filter by eligibility benefit type

29. Has Eligibility Change - check to narrow results to students with a change in eligibility

30. Error Prone - check to filter for students with an error prone application
    Error Prone = income-based application that is within $100/month of the income threshold

31. Verify for Just Cause - check to narrow results to students on an application marked as Verify for Just Cause

32. Search - search for available columns
    Note: Columns are defined below

33. (+) - click or drag and drop to move available sort columns to the Selected Columns field

34. Drag and Drop to rearrange Selected Columns or click the Trash Can to remove a column from the selected columns field

35. Group By - choose one of the available column types to insert pages breaks at changes in value of the selected field

36. Include Total Row - check to include a total row at the bottom of the report

37. (+) - click or drag and drop to move available sort columns to the Sort By field
    Note: Columns selected in step 33 are available for sorting.

38. Drag and Drop to arrange Sort By columns in order of sort priority or click the Trash Can to remove a field

40. Paper Format - choose a paper format
    CR80
    Legal
    Letter (default)

41. Orientation - choose orientation
    Landscape
    Portrait (default)

42. Include Header - check to display report header on PDF or header row on CSV

43. Include Footer - check to display report footer on PDF

44. Include Filter - check to display selected filters on PDF

45. Save as Template - click to save the selected filters and columns as a template
    

1. Name - enter a template name

2. Public - check to make the template available to other users

3. Security Roles - select the security roles that can access a Public template

4. Cancel - click to return to the previous screen without saving the template

5. Save - click to save the template

46. Reset - click to reset to defaults

47. Request Report - click to request report
    Note: Report will appear in the bell icon when complete

Column Definitions

Column	Definition
Application Address	Address from Meal Application
Application Academic School Year	Academic School Year of Meal Application
Application Address City	City from Meal Application
Application Address State	State from Meal Application
Application Address Street	Street Address from Meal Application
Application Address To	Address recipient from Meal Application
Application Address Zip	Zip Code from Meal Application
Application Approved Benefit Type	Eligibility benefit type from the student's meal application
Application Benefit Number	Eligibility benefit number from the students meal application
Application Email	Email address from Meal Application
Application Ethnicity	Ethnicity from Meal Application
Application Language	Language from the Meal Application
Application No SSN	HTML, PDF: Checkmark if the No SSN box is checked, blank if unchecked CSV, EXCEL, JSON: True if No SSN box is checked, false if unchecked
Application Number	Application Number from the Meal Application
Application Phone	Phone Number from the Meal Application
Application Processed By	User who processed the meal application
Application Processed Date	Date the meal application was originally processed
Application Question Answers	Answers of additional questions from the meal application
Application Race	Race from the Meal Application
Application Receipt Date	Date application was received
Application SSN	Last 4 Digits of SSN from the student's meal application
Application Source	Application Source
Automatic Extension Reason
Benefit Refusal	HTML, PDF: Checkmark if the Refused Benefits box is checked, blank if unchecked CSV, EXCEL, JSON: True if Refused Benefits box is checked, false if unchecked
Child Income	Child Income
Child Income Frequency	Child Income Frequency
Current Date	Date the report is generated
Date of Birth	Student's Date of Birth
Date Signed	Signature Date of meal application
Direct Cert Import Template	Direct Certification Import Template Name
Eligibility	Eligibility status Note: Covert Code if feature is enabled
Eligibility Benefit Type	Eligibility Benefit Type
Eligibility Determination Reason	Eligibility Determination Reason
Eligibility End Date	Eligibility End Date
Eligibility Start Date	Eligibility Start Date
Enrollment School ID	Enrollment Building Identifier
Enrollment School Name	Enrollment Building Name
Error Prone	HTML, PDF: Checkmark if the meal application is considered error prone, blank if not CSV, EXCEL, JSON: True if the meal application is considered error prone, blank if not Note: Error prone indicates that the application was within $100/mo of the eligibility threshold
Extended Benefits	HTML, PDF: Checkmark if the student is eligible because of extended benefits, blank if not CSV, EXCEL, JSON: True if the student is eligible because of extended benefits, False if not
Has Eligibility Change	HTML, PDF: Checkmark if the student's eligibility has changed, blank if not CSV, EXCEL, JSON: True if the student's eligibility has changed, False if not
Included In Verification	HTML, PDF: Checkmark if the student is included in verification, blank if not CSV, EXCEL, JSON: True if the student is included in verification, False if not
Is Directly Certified	HTML, PDF: Checkmark if the student is Directly Certified, blank if not CSV, EXCEL, JSON: True if the student is Directly Certified, False if not
Middle Name	Middle Name of Student
Previous Application Number	Application Number of previous application
Previous Application Processed Date	Processed Date of previous application
Previous Application Source	Application Source of previous application
Previous Eligibility	Eligibility of previous application
Previous Eligibility Benefit Type	Eligibility Benefit Type of previous application
Previous Eligibility Determination Reason	Eligibility Determination Reason of previous application
Previous Eligibility End Date	Eligibility End Date of previous application
Previous Eligibility Start Date	Eligibility Start Date of previous application
Previous Total Household Members	Total Household Members of previous application
Previous Total Wage	Total Wage of previous application
Previous Total Wage Frequency	Total Wage Frequency of previous application
State Code	Eligibility Benefit Type State Code
Total Household Members	Total Household Members
Total Wage	Total Wage
Total Wage Frequency	Total Wage Frequency