Economic Status Report
The Economic Status Report provides economic status data for all students who have a valid enrollment for at least one day within the specified reporting period dates.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student selection
The student must be enrolled at least one day between the Report Start Date and the Report End Date.
The student must not be excluded from state reporting.
The student must have a value for School Lunch Eligibility.
The student must have a value for Eligibility Start Date between the Report Start Date and the Report End Date.
The student must not have a blank value for Lunch Status.
School selection
The student's school must not be excluded from state reporting.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Schools to Include* | Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled:
If sub-districts are enabled:
|
Students to Include* | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running the report. |
Report Start Date* | Select the Start Date for the report. |
Report End Date* | Select the End Date for the report. |
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.
Note: The following data elements are required for the report submission except when listed as "blank is allowed".
Data Element | Description | [Table]Fieldname | Data Type | Field Length |
---|---|---|---|---|
SAUID | The NEO Organization ID for the attending School Administrative Unit (SAU). This is the ID used for uploading and entering the student's data. Note: The district number on import must match the district number tied to the student’s enrollment. If district numbers don't match, the following error appears: “Student does not have an enrollment in this SAU Id, School ID, and school year.” | [Prefs]Name = ME_SAUID [Prefs]Value If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number | Int | 4 |
StateStudentID | The student's state-assigned ID number. | [Students]State_StudentNumber | Char | 9 |
School ID | The ID number of the school the student attends. | [S_ME_SCH_X]StateSchoolNumber If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number | Int | 4 |
Year Code | The school year designation. | Derived | Varchar | 9 |
Action | Indicates if this is an Add/Update of a student record or a delete. Blank is allowed Note: A blank value indicates an insert or update to an existing record in Synergy. A value of D indicates deletion of the FRAM record for the given State Student ID, Start Date, Eligibility value. | N/A | N/A | N/A |
Eligibility | The student's economic eligibility status. | [S_ME_STU_X]SchoolLunchEligibility [S_ME_REN_X]SchoolLunchEligibility | Varchar | 15 |
StartDate | The start date of the student's eligibility from the lunch status. | [S_ME_STU_X]EconmicStatusEligibStartDate [S_ME_REN_X]EconmicStatusEligibStartDate | Date | 8 |
EndDate | The end date of the student's eligibility. If there is an EndDate, it must be within the school year of the upload. Blank is allowed. | [S_ME_STU_X]EconmicStatusEligibEndDate [S_ME_REN_X]EconmicStatusEligibEndDate | Date | 8 |