FRAM Extract

Contents

Report Description

This extract reports Free/Reduced Meal data for currently enrolled students, to submit through the OPI Direct Certification Application (DCA) system. See the OPI’s School Nutrition Programs website for more information.

Selection Criteria

This report has no specified selection criteria.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Select Schools*

If run at the district level, choose one of the following:

Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.
All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Back to top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Student's State ID	The unique nine-digit state assigned student ID.	[Students]State_StudentNumber	String	9
2	Last Name	The student’s legal last name. This field is not required.	[Students]Last_Name	String	50
3	First Name	The student’s legal first name. This field is not required.	[Students]First_Name	String	50
4	Eligibility	The student's lunch status. Valid values: F – Free Meals R – Reduced Price Meals N – Not Eligible or Not Participating	[Students]LunchStatus	varchar2	1
5	Certification Type	Defaults to Income.	N/A	N/A	N/A
6	Eligibility Start Date	The first date of eligibility, usually the first day of school in the upcoming school year.	[Students]eligibilityStartDate	varchar2	10
7	Eligibility End Date	The last date of eligibility, usually 30 days past the first day of school in the upcoming school year. This date defaults to October 2nd of the following school year.	[Students]eligibilityEndDate	varchar2	10

Back to top