S_STU_LUNCH_C (ver 19.8.2.0)
This table is a child table of Students and is used to store lunch status changes. This table is available for all states and provinces and might or might not be utilized for your state or province.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 19.8.2.0 | Number(10,0) | Primary Key |
| End_Date | 19.8.2.0 | Date | The end date for a lunch status. |
| EconomicDisadvantage | 20.7.2.0 | Varchar2(3) | Indicates if the student is Economically Disadvantaged. The values for the EconomicDisadvantage field are seeded for each state or province. |
| LunchEligibility | 20.7.2.0 | Varchar2(2) | Indicates the criteria used to determine the student's lunch eligibility. The values for the LunchEligibility field are seeded for each state or province. |
| LunchStatus | 19.8.2.0 | Varchar2(3) | The changed lunch status value of the core field. |
| Notes | 19.8.2.0 | Varchar2(4000) | The comments from the user. |
| ReportedValue | 19.8.2.0 | Varchar2(40) | The reported value. The values for the ReportedValue field are seeded for each state or province. |
| SchoolID | 19.8.2.0 | Number(10,0) | The school number. |
| Start_Date | 19.8.2.0 | Date | The start date for a lunch status. |