Skip to main content
Skip table of contents

S_IL_STU_X (ver 14.9.3)

This table is an extension of the Students table.

Column Name

Version

Data Type

Description

StudentsDCID14.9.3Number (10,0)Primary key that relates the extended table to the [Students] table.
Century_2116.6.2Number(1,0)Migrated from [Students]IL_Century21
Content_Area_Tutoring17.2.0Varchar2(2)Migrated from [Students]IL_Content_Area_Tutoring
Country_Of_Birth14.9.3Varchar2(4)The student's country of birth.
Date_WAPT_Taken17.2.0DateMigrated from [Students]IL_Date_WAPT_Taken
Disability16.6.2Varchar2(2)Migrated from [Students]IL_Disability
Displaced_Homemaker16.6.2Number(1,0)Migrated from [Students]IL_Displaced_Homemaker
Dropout_TF17.2.0Number(1,0)Migrated from [Students]IL_Dropout
Elig_Immig_Edu_Program17.2.0Varchar2(2)Migrated from [Students]IL_Elig_Immig_Edu_Prog
Enrollment_Entry_Type_Code16.6.2Varchar2(2)Migrated from [Students]IL_Enrollment_Type_Code
Enrollment_Exit_Status16.6.2Varchar2(2)Migrated from [Students]IL_Enrollment_Exit_Status
Enrollment_Exit_Type_Code16.6.2Varchar2(2)Migrated from [Students]IL_Enrollment_Exit_Type_Code
First_Date_Into_US_School14.9.3DateThe date of the first entry into a US School.
FTE16.6.2Number(25,10)Migrated from [Students]IL_FTE
Graduate_TF17.2.0Number(1,0)Migrated from [Students]IL_Graduate
Heritage_Language_Instruct17.2.0 Varchar2(2)Migrated from [Students]IL_Heritage_Language_Instruct
IEP16.6.2Number(1,0)Migrated from [Students]IL_IEP
IEP_Accommodate_TF17.2.0Number(1,0)Migrated from [Students]IL_IEP_Accommodate
Immigrant_Education_Program17.2.0Varchar2(2)Migrated from [Students]IL_Immigrant_Education_Program
Inclusionary_Support17.2.0Varchar2(2)Migrated from [Students]IL_Inclusionary_Support
Kday17.2.0Varchar2(1)Migrated from [Students]IL_Kday
Language_Activities17.2.0Varchar2(2)Migrated from [Students]IL_Language_Activities
LEP16.6.2Number(1,0)Migrated from [Students]IL_LEP
LII16.6.2Number(1,0)Migrated from [Students]IL_LII
Math_Activities17.2.0Varchar2(2)Migrated from [Students]IL_Math_Activities
Migrant16.6.2Number(1,0)Migrated from [Students]IL_Migrant
PARCC_ELA_Accom_50415.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Accom_ELL15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Accom_IEP15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Alt_Rep_Paper_Test15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Answer_Masking15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Answer_Recorded15.2.0 Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_ASL_Video15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Braille_Display15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Braille_Graphics_216.12.3Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Braille_Graphics_216.12.3Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Braille_Response15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Class_Name15.2.0Varchar2(38)Reported on IL PARCC Report.
PARCC_ELA_Closed_Caption15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Color_Contrast15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Constructed_Response15.2.0 Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Dictionary15.2.0 Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_DirClfy_StuNtLng20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_DirRead_StuNtLng20.10.2.0Varchar2(3)Reported on IL PARCC Report.
PARCC_ELA_Frequent_Breaks20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Emergency_Accomm20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Extended_Time15.2.0 Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Human_Reader15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Large_Print15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Monitor_Response15.2.0 Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Screen_Reader_App15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Selected_Response15.2.0 Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Separate_Alt_Loc20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Session_Location15.2.0Varchar2(45)Reported on IL PARCC Report.
PARCC_ELA_Specifd_Area_Set20.10.2.0Varchar2(45)Reported on IL PARCC Report.
PARCC_ELA_Spl_Equip_Furn20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Small_Grp_Testing20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Stu_Rd_Assmt_Ald20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Tactile_Graphics15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Test_Code15.2.0Varchar2(5)Reported on IL PARCC Report.
PARCC_ELA_Test_Format15.2.0Varchar2(1)Reported on IL PARCC Report.
PARCC_ELA_Text_To_Speech15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Time_of_Day20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Unique_Accomm20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_Word_Prediction15.2.0 Varchar2(2)Reported on IL PARCC Report.
PARCC_ELA_TestDirections20.12.1.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Accom_50415.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Accom_ELL15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Accom_IEP15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Alt_Rep_Paper_Test15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Answer_Masking15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Answer_Recorded15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_ASL_Video15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Braille_Response15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Calc_Device_216.12.3Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Class_Name15.2.0Varchar2(38)Reported on IL PARCC Report.
PARCC_Math_Color_Contrast15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Dictionary15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_DirClfy_StuNtLng20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_DirRead_StuNtLng20.10.2.0Varchar2(3)Reported on IL PARCC Report.
PARCC_Math_Emergency_Accomm20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Extended_Time15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Frequent_Breaks20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Human_Reader15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Large_Print15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Monitor_Response15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Response15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Response_EL15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Screen_Reader_App15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Session_Location15.2.0Varchar2(45)Reported on IL PARCC Report.
PARCC_Math_Separate_Alt_Loc20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Small_Grp_Testng20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Specifd_Area_Set20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Spl_Equip_Furn20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Stu_Rd_Assmt_Ald20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Tactile_Graphics15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Test_Code15.2.0Varchar2(5)Reported on IL PARCC Report.
PARCC_Math_Test_Format15.2.0Varchar2(1)Reported on IL PARCC Report.
PARCC_Math_Text_To_Speech15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Time_of_Day20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Translate_Spanish15.2.0Varchar2(3)Reported on IL PARCC Report.
PARCC_Math_Unique_Accomm20.10.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_Word_Prediction15.2.0Varchar2(2)Reported on IL PARCC Report.
PARCC_Math_TestDirections20.12.1.0Varchar2(2)Reported on IL PARCC Report.
Parent_Contact16.6.2Number(1,0)Migrated from [Students]IL_ParentContact
PreK17.2.0Varchar2(1)Migrated from [Students]IL_PreK
PreK_Followup17.2.0Varchar2(1)Migrated from [Students]IL_PreK_Followup
Private_School_Student16.6.2Number(1,0)Migrated from [Students]IL_Private_School_Student
Pull_Out_ESL17.2.0Varchar2(2)Migrated from [Students]IL_Pull_Out_ESL
RCDTS_Home_School16.6.2Varchar2(15)Migrated from [Students]IL_RCDTS_Home_School
RCDTS_Service_Provider15.11.0Varchar2(15)Reported on the the IL Service Provider report.
RCDTS_Serving_School16.6.2Varchar2(15)Migrated from [Students]IL_RCDTS_Serving_School
RCDTS_Testing_School16.6.2Varchar2(15)Migrated from [Students]IL_RCDTS_Testing_School
Reading_Activities17.2.0Varchar2(2)Migrated from [Students]IL_Reading_Activities
Reading_First16.6.2Varchar2(2)Migrated from [Students]IL_Reading_First
Reading_Improve16.6.2Varchar2(2)Migrated from [Students]IL_Reading_Improve
SES16.6.2Number(1,0)Migrated from [Students]IL_SES
Single_Pregnant_Woman16.6.2Number(1,0)Migrated from [Students]IL_Single_Pregnant_Woman
State_ExcludeEnrollment16.6.2Number(1,0)Migrated from [Students]state_excludeenrollment
Testing_Grade_Level16.6.2Varchar2(2)Migrated from [Students]IL_Testing_Grade_Level
Title116.6.2Varchar2(2)Migrated from [Students]IL_Title1
Truancy16.6.2Varchar2(1)Migrated from [Students]IL_Truancy
WAPT_Composite_Level17.2.0Varchar2(3)

Migrated from [Students]IL_WAPT_Composite_Level

Military_Connected17.5.0BooleanIndicator for family military connection.
First_Year_Ninth_Grade18.7.0IntegerYear for 9th Grade to support any overrides that cannot be derived from the enrollment history
Dual_Language18.8.0Varchar2(2)Indicator for participation in the dual language program.
Language_Of_Instruction18.8.0Varchar2(3)Language of instruction for the dual language program
Tuition_In_Indicator18.8.0Varchar2(2)Students residing in a school district who choose to attend another school district and their parents pay that school district tuition.
Gifted_Test20.4.3.0Varchar2(2)The student's value for their gifted test.
Accelerated_Placement20.4.3.0Varchar2(2)Indicator for participation in the accelerated program.
Alt_Assessment_Indicator20.8.2.0Varchar2(2)Alternate Assessment Indicator




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close