S_SCH_X (ver 18.8.0)
This table is an extension of the [Schools] table. This table is available for all states/provinces and may or may not be utilized for your state/province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SchoolsDCID | 18.8.0 | Number(10,0) | Primary Key |
CEP_School | 20.1.2.0 | Number(1,0) | Indicates if the building is a CEP school. |
Exclude_Attendance | 19.7.1.0 | Number(1,0) | To exclude attendance from IL attendance reporting at the school level |
NSLP_Exclusion | 18.8.0 | Varchar2(1) | Indicates that the building does NOT participate in the National School Lunch Program. |
RestraintSeclusionURL | 18.9.0 | Varchar2(2000) | Text field for Restraint/Seclusion URL. |
SchoolStatus | 20.1.2.0 | Varchar2(2) | Indicates if a school is active or inactive. |
SchoolType | 19.5.1.0 | Varchar2(2) | Indicates whether the school is a private or public school. |
SteamStem | 19.8.2.0 | Varchar2(1) | Indicates if the school is a STEAM/STEM School. |
LearningPreference | 22.6.3.0 | Varchar2(30) | The desired method of learning for the school. |
NSLP_Participation | 23.12.3.0 | Varchar2(15) | This field tracks the number of students participating in the National School Lunch Program at the school level. |