PowerSchool SIS Illinois

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