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. |