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 |