PowerSchool SIS Illinois

S_IL_STU_ELL_X (ver 16.6.2)

This table is an extension of the Students table.

Column Name

Version

Data Type

Description

StudentsDCID

16.6.2

Number(10,0)

Primary key that relates the extended table to the [Students] table.

Class_Period_Per_Week

16.6.2

Varchar2(2)

Migrated from [Students]IL_Class_Period_Per_Week

Content_Based_ESL

16.6.2

Varchar2(1)

Migrated from [Students]IL_Content_Based_ESL

Date_Test_Taken

16.6.2

Date

Migrated from [Students]IL_Date_Test_Taken

Development_Bilingual_Edu

16.6.2

Varchar2(1)

Migrated from [Students]IL_Development_Bilingual_Edu

Dual_Language_2_Way_Imm

16.6.2

Varchar2(1)

Migrated from [Students]IL_Dual_Language_2_Way_Imm

ELL_Entry_Status

16.6.2

Varchar2(10)

Migrated from [Students]IL_ELL_Entry_Status

EL_Services_Provided

16.9.0

Varchar2(2)

Extended field for EL Services Provided

End_Date

16.6.2

Date

Migrated from [Students]IL_End_Date

Enrolled_Reenrolled_ELL_Date

16.6.2

Date

Migrated from [Students]IL_Enrolled_Reenrolled_ELL_Date

Grade_Level

16.6.2

Varchar2(2)

Migrated from [Students]IL_Grade_Level

LEP_Final

16.6.2

Varchar2(2)

Migrated from [Students]IL_LEP_Final

Listening_Prof_level

16.6.2

Varchar2(3)

Migrated from [Students]IL_Listening_Prof_level

Literacy_Prof_Level

16.6.2

Varchar2(3)

Migrated from [Students]IL_Literacy_Prof_Level

New_to_US

16.6.2

Varchar2(2)

Migrated from [Students]IL_New_to_US

Oral_Prof_Level

16.6.2

Varchar2(3)

Migrated from [Students]IL_Oral_Prof_Level

Overall_Prof_Level

16.6.2

Varchar2(3)

Migrated from [Students]IL_Overall_Prof_Level

Pull_Out_Individualized_Sup

16.6.2

Varchar2(1)

Migrated from [Students]IL_Pull_Out_Individualized_Sup

Reading_Prof_Level

16.6.2

Varchar2(3)

Migrated from [Students]IL_Reading_Prof_Level

Reason_For_ELL_Ending

16.6.2

Varchar2(2)

Migrated from [Students]IL_Reason_for_ELL_Ending

Screener_Test

16.6.2

Varchar2(2)

Migrated from [Students]IL_Screener_Test

Self_Contained

16.6.2

Varchar2(1)

Migrated from [Students]IL_Self_Contained

Semester

16.6.2

Varchar2(2)

Migrated from [Students]IL_Semester

Sheltered_Language_Instruct

16.6.2

Varchar2(1)

Migrated from [Students]IL_Sheltered_Language_Instruct

Speaking_Raw_Prof_Level

16.6.2

Varchar2(3)

Migrated from [Students]IL_Speaking_Raw_Prof_Level

Structured_English_Immersion

16.6.2

Varchar2(1)

Migrated from [Students]IL_Structured_English_Immersion

Title_III_Status

16.6.2

Varchar2(1)

Migrated from [Students]IL_Title_III_Status

Transitional_Bilingual_Inst

16.6.2

Varchar2(1)

Migrated from [Students]IL_Transitional_Bilingual_Inst

WAPT_Listening_Raw_Score

16.6.2

Varchar2(2)

Migrated from [Students]IL_WAPT_Listening_Raw_Score

WAPT_Reading_Raw_Score

16.6.2

Varchar2(2)

Migrated from [Students]IL_WAPT_Reading_Raw_Score

WAPT_Speaking_Raw_Score

16.6.2

Varchar2(2)

Migrated from [Students]IL_WAPT_Speaking_Raw_Score

WAPT_Writing_Raw_Score

16.6.2

Varchar2(2)

Migrated from [Students]IL_WAPT_Writing_Raw_Score

Writing_Prof_Level

16.6.2

Varchar2(3)

Migrated from [Students]IL_Writing_Prof_Level