S_IL_STU_X (ver 14.9.3)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
---|---|---|---|
StudentsDCID | 14.9.3 | Number (10,0) | Primary key that relates the extended table to the [Students] table. |
Century_21 | 16.6.2 | Number(1,0) | Migrated from [Students]IL_Century21 |
Content_Area_Tutoring | 17.2.0 | Varchar2(2) | Migrated from [Students]IL_Content_Area_Tutoring |
Country_Of_Birth | 14.9.3 | Varchar2(4) | The student's country of birth. |
Date_WAPT_Taken | 17.2.0 | Date | Migrated from [Students]IL_Date_WAPT_Taken |
Disability | 16.6.2 | Varchar2(2) | Migrated from [Students]IL_Disability |
Displaced_Homemaker | 16.6.2 | Number(1,0) | Migrated from [Students]IL_Displaced_Homemaker |
Dropout_TF | 17.2.0 | Number(1,0) | Migrated from [Students]IL_Dropout |
Elig_Immig_Edu_Program | 17.2.0 | Varchar2(2) | Migrated from [Students]IL_Elig_Immig_Edu_Prog |
Enrollment_Entry_Type_Code | 16.6.2 | Varchar2(2) | Migrated from [Students]IL_Enrollment_Type_Code |
Enrollment_Exit_Status | 16.6.2 | Varchar2(2) | Migrated from [Students]IL_Enrollment_Exit_Status |
Enrollment_Exit_Type_Code | 16.6.2 | Varchar2(2) | Migrated from [Students]IL_Enrollment_Exit_Type_Code |
First_Date_Into_US_School | 14.9.3 | Date | The date of the first entry into a US School. |
FTE | 16.6.2 | Number(25,10) | Migrated from [Students]IL_FTE |
Graduate_TF | 17.2.0 | Number(1,0) | Migrated from [Students]IL_Graduate |
Heritage_Language_Instruct | 17.2.0 | Varchar2(2) | Migrated from [Students]IL_Heritage_Language_Instruct |
IEP | 16.6.2 | Number(1,0) | Migrated from [Students]IL_IEP |
IEP_Accommodate_TF | 17.2.0 | Number(1,0) | Migrated from [Students]IL_IEP_Accommodate |
Immigrant_Education_Program | 17.2.0 | Varchar2(2) | Migrated from [Students]IL_Immigrant_Education_Program |
Inclusionary_Support | 17.2.0 | Varchar2(2) | Migrated from [Students]IL_Inclusionary_Support |
Kday | 17.2.0 | Varchar2(1) | Migrated from [Students]IL_Kday |
Language_Activities | 17.2.0 | Varchar2(2) | Migrated from [Students]IL_Language_Activities |
LEP | 16.6.2 | Number(1,0) | Migrated from [Students]IL_LEP |
LII | 16.6.2 | Number(1,0) | Migrated from [Students]IL_LII |
Math_Activities | 17.2.0 | Varchar2(2) | Migrated from [Students]IL_Math_Activities |
Migrant | 16.6.2 | Number(1,0) | Migrated from [Students]IL_Migrant |
PARCC_ELA_Accom_504 | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Accom_ELL | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Accom_IEP | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Alt_Rep_Paper_Test | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Answer_Masking | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Answer_Recorded | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_ASL_Video | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Braille_Display | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Braille_Graphics_2 | 16.12.3 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Braille_Graphics_2 | 16.12.3 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Braille_Response | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Class_Name | 15.2.0 | Varchar2(38) | Reported on IL PARCC Report. |
PARCC_ELA_Closed_Caption | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Color_Contrast | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Constructed_Response | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Dictionary | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_DirClfy_StuNtLng | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_DirRead_StuNtLng | 20.10.2.0 | Varchar2(3) | Reported on IL PARCC Report. |
PARCC_ELA_Frequent_Breaks | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Emergency_Accomm | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Extended_Time | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Human_Reader | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Large_Print | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Monitor_Response | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Screen_Reader_App | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Selected_Response | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Separate_Alt_Loc | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Session_Location | 15.2.0 | Varchar2(45) | Reported on IL PARCC Report. |
PARCC_ELA_Specifd_Area_Set | 20.10.2.0 | Varchar2(45) | Reported on IL PARCC Report. |
PARCC_ELA_Spl_Equip_Furn | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Small_Grp_Testing | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Stu_Rd_Assmt_Ald | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Tactile_Graphics | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Test_Code | 15.2.0 | Varchar2(5) | Reported on IL PARCC Report. |
PARCC_ELA_Test_Format | 15.2.0 | Varchar2(1) | Reported on IL PARCC Report. |
PARCC_ELA_Text_To_Speech | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Time_of_Day | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Unique_Accomm | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_Word_Prediction | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_ELA_TestDirections | 20.12.1.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Accom_504 | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Accom_ELL | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Accom_IEP | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Alt_Rep_Paper_Test | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Answer_Masking | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Answer_Recorded | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_ASL_Video | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Braille_Response | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Calc_Device_2 | 16.12.3 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Class_Name | 15.2.0 | Varchar2(38) | Reported on IL PARCC Report. |
PARCC_Math_Color_Contrast | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Dictionary | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_DirClfy_StuNtLng | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_DirRead_StuNtLng | 20.10.2.0 | Varchar2(3) | Reported on IL PARCC Report. |
PARCC_Math_Emergency_Accomm | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Extended_Time | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Frequent_Breaks | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Human_Reader | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Large_Print | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Monitor_Response | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Response | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Response_EL | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Screen_Reader_App | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Session_Location | 15.2.0 | Varchar2(45) | Reported on IL PARCC Report. |
PARCC_Math_Separate_Alt_Loc | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Small_Grp_Testng | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Specifd_Area_Set | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Spl_Equip_Furn | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Stu_Rd_Assmt_Ald | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Tactile_Graphics | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Test_Code | 15.2.0 | Varchar2(5) | Reported on IL PARCC Report. |
PARCC_Math_Test_Format | 15.2.0 | Varchar2(1) | Reported on IL PARCC Report. |
PARCC_Math_Text_To_Speech | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Time_of_Day | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Translate_Spanish | 15.2.0 | Varchar2(3) | Reported on IL PARCC Report. |
PARCC_Math_Unique_Accomm | 20.10.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_Word_Prediction | 15.2.0 | Varchar2(2) | Reported on IL PARCC Report. |
PARCC_Math_TestDirections | 20.12.1.0 | Varchar2(2) | Reported on IL PARCC Report. |
Parent_Contact | 16.6.2 | Number(1,0) | Migrated from [Students]IL_ParentContact |
PreK | 17.2.0 | Varchar2(1) | Migrated from [Students]IL_PreK |
PreK_Followup | 17.2.0 | Varchar2(1) | Migrated from [Students]IL_PreK_Followup |
Private_School_Student | 16.6.2 | Number(1,0) | Migrated from [Students]IL_Private_School_Student |
Pull_Out_ESL | 17.2.0 | Varchar2(2) | Migrated from [Students]IL_Pull_Out_ESL |
RCDTS_Home_School | 16.6.2 | Varchar2(15) | Migrated from [Students]IL_RCDTS_Home_School |
RCDTS_Service_Provider | 15.11.0 | Varchar2(15) | Reported on the the IL Service Provider report. |
RCDTS_Serving_School | 16.6.2 | Varchar2(15) | Migrated from [Students]IL_RCDTS_Serving_School |
RCDTS_Testing_School | 16.6.2 | Varchar2(15) | Migrated from [Students]IL_RCDTS_Testing_School |
Reading_Activities | 17.2.0 | Varchar2(2) | Migrated from [Students]IL_Reading_Activities |
Reading_First | 16.6.2 | Varchar2(2) | Migrated from [Students]IL_Reading_First |
Reading_Improve | 16.6.2 | Varchar2(2) | Migrated from [Students]IL_Reading_Improve |
SES | 16.6.2 | Number(1,0) | Migrated from [Students]IL_SES |
Single_Pregnant_Woman | 16.6.2 | Number(1,0) | Migrated from [Students]IL_Single_Pregnant_Woman |
State_ExcludeEnrollment | 16.6.2 | Number(1,0) | Migrated from [Students]state_excludeenrollment |
Testing_Grade_Level | 16.6.2 | Varchar2(2) | Migrated from [Students]IL_Testing_Grade_Level |
Title1 | 16.6.2 | Varchar2(2) | Migrated from [Students]IL_Title1 |
Truancy | 16.6.2 | Varchar2(1) | Migrated from [Students]IL_Truancy |
WAPT_Composite_Level | 17.2.0 | Varchar2(3) | Migrated from [Students]IL_WAPT_Composite_Level |
Military_Connected | 17.5.0 | Boolean | Indicator for family military connection. |
First_Year_Ninth_Grade | 18.7.0 | Integer | Year for 9th Grade to support any overrides that cannot be derived from the enrollment history |
Dual_Language | 18.8.0 | Varchar2(2) | Indicator for participation in the dual language program. |
Language_Of_Instruction | 18.8.0 | Varchar2(3) | Language of instruction for the dual language program |
Tuition_In_Indicator | 18.8.0 | Varchar2(2) | Students residing in a school district who choose to attend another school district and their parents pay that school district tuition. |
Gifted_Test | 20.4.3.0 | Varchar2(2) | The student's value for their gifted test. |
Accelerated_Placement | 20.4.3.0 | Varchar2(2) | Indicator for participation in the accelerated program. |
Alt_Assessment_Indicator | 20.8.2.0 | Varchar2(2) | Alternate Assessment Indicator |