S_IL_SCH_X (ver 16.6.2)
This table is an extension of the Schools table.
Column Name | Version | Data Type | Description |
---|---|---|---|
SchoolsDCID | 16.6.2 | Number(10,0) | Primary key that relates the extended table to the [Schools] table. |
Block_Schedule_44 | 16.6.2 | Varchar2(1) | Migrated from [Schools]IL_44_Block_Schedule |
Block_Schedule | 16.6.2 | Varchar2(1) | Migrated from [Schools]IL_Block_Schedule |
DropoutProgram | 16.6.2 | Number(1,0) | Migrated from [Schools]IL_DropoutProgram |
Dual_Language | 20.12.1 | Varchar2(2) | To set Dual Language at School Level |
Kday_ADAD | 16.6.2 | Varchar2(1) | Migrated from [Schools]IL_Kday_ADAD |
Kday_ADED | 16.6.2 | Varchar2(1) | Migrated from [Schools]IL_Kday_ADED |
Kday_HDED | 16.6.2 | Varchar2(1) | Migrated from [Schools]IL_Kday_HDED |
Magnet | 16.6.2 | Varchar2(1) | Migrated from [Schools]IL_Magnet |
Pregnant_Program | 16.6.2 | Varchar2(1) | Migrated from [Schools]IL_Pregnant_Program |
PreK_Bilingual | 16.6.2 | Varchar2(1) | Migrated from [Schools]IL_PreK_Bilingual |
PreK_Regular | 16.6.2 | Varchar2(1) | Migrated from [Schools]IL_PreK_Regular |
PreK_SpecEd | 16.6.2 | Varchar2(1) | Migrated from [Schools]IL_PreK_SpecEd |
Gifted_Test | 20.4.3.0 | Varchar2(2) | The name of the school's Gifted Test. |
Accelerated_Placement | 21.4.2.0 | Varchar2(2) | Accelerated Placement, school level field for reporting to DOE |