S_MI_SCH_TSDL_X (ver 15.8.0)
This table is an extension of the [Schools] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SchoolsDCID | 15.8.0 | Number(10,0) | Primary key that relates the extended table back to the [Schools] table. |
AdminUnit | 15.8.0 | Varchar2(12) | School or Facility number. Migrated from [Schools.MI_SRSD_AdminUnit]. |
| CyberSchool | 15.8.0 | Number(1,0) | Used to denote if the school is a cyber school. |
| ExcludeEarlyChild | 15.8.0 | Number(1,0) | Used to exclude school from the Early Childhood submission. |
| ExcludeTSDL | 15.8.0 | Varchar2(1) | Used to exclude school from the TSDL submission. As of version 18.8.0, this field changed from Number(1,0) to Varchar2(1). |
FTEHoursPerWeek | 15.8.0 | Number(25,10) | Total hours per week in school. Migrated from [Schools.MI_TotalHoursPerWeek]. |
SchoolType | 15.8.0 | Varchar2(4) | The school type. |