S_KS_STU_X (ver 14.7.2)
This table is an extension of the [Students] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.7.2 | Number(10,0) | Primary Key |
Accountability_School | 16.3.0 | Number(11,0) | Accountability School Identifier. Migrated from [Students.KS_Ayp_Sch_Id]. |
| ACT_Assessment | 18.7.0 | VarChar2(1) | An indicator of whether the student will take the American College Testing (ACT) Assessment during the current school year. |
| ACT_WorkKeys_Assessment | 18.7.0 | VarChar2(1) | An indicator of whether the student will take the American College Testing (ACT) WorkKeys Assessment during the current school year. |
Algebraic_Mastery | 16.3.0 | Number(1,0) | Mastery of Algebraic Concepts. Migrated from [Students.KS_AlgebraicMastery]. |
| Animal_Sys_Assess | 15.7.3 | VarChar2(1) | Test options for Animal Systems assessment. |
| Animal_Sys_Gr_Ind | 15.7.3 | Varchar2(50) | The method with which Animal Systems test tickets are sorted. |
| Attend_School_District | 16.3.0 | VarChar2(100) | No longer used for state reporting. Migrated from [Students.attend_school_district]. |
| Attend_School_Name | 16.3.0 | VarChar2(100) | No longer used for state reporting. Migrated from [Students.attend_school_name]. |
Attendance_Center | 16.3.0 | VarChar2(4) | Attendance Center. Migrated from [Students.AttendanceCenter]. |
Attendance_School | 16.3.0 | Number(11,0) | Attendance School Identifier. Migrated from [KS_Attend_Sch]. |
| AV_Comm_Assess | 16.7.2 | VarChar2(1) | Test options for Audio-Visual Communications. |
| AV_Comm_Grp_Ind | 16.7.2 | VarChar2(50) | The method with which Audio-Visual Communication test tickets are sorted. |
| Comp_AG_Assess | 15.7.3 | VarChar2(1) | Test options for Comprehensive Agriculture assessment. |
| Comp_As_Gr_Ind | 15.7.3 | Varchar2(50) | The method with which Comprehensive Agriculture test tickets are sorted. |
| Comp_Bus_Assess | 15.7.3 | VarChar2(1) | Test options for Comprehensive Business assessment. |
| Comp_Bus_Gr_Ind | 15.7.3 | Varchar2(50) | The method with which Comprehensive Business test tickets are sorted. |
Concurrent_School | 16.3.0 | VarChar2(1) | Concurrent High School Enrollment. Migrated from [Students.KS_Con_HS-Enr]. |
CTE_Pass_ProctorID | 14.7.2 | Number(11,0) | The number assigned to the educator by the state. |
| CTE_Pass_ProctorID_Fld | 14.9.0 | Varchar2(10) | The number assigned to the educator by the state. Data is stored in this field. |
CTE_Pass_ProctorName | 14.7.2 | Varchar2(100) | The name of the educator that should have access to the student's assessment data. |
| Design_Precon_Assess | 15.7.3 | VarChar2(1) | Test options for Design and Pre-Construction assessment. |
| Design_Precon_Grp_Ind | 15.7.3 | Varchar2(50) | The method with which Design and Pre-Construction test tickets are sorted. |
| District_Entry_Date | 16.3.0 | Date | District Entry Date. Migrated from [Students.KS_Dist_Ent_Dte]. |
| EL_Participant | 17.6.0 | Number(1,0) | Indicates the student participates in a district-sponsored pre-K program, other than Parents as Teachers, during the school year. |
ELA_Ind1 | 14.7.2 | Varchar2(50) | The method with which ELA test tickets are sorted. |
ELA_Ind2 | 14.7.2 | Varchar2(50) | The second method with which ELA test tickets are sorted. |
| ELPA_Grp_Ind1 | 16.3.0 | VarChar2(50) | The method with which ELPA test tickets are sorted. Migrated from [Students.KS_KELPA_Ind1]. |
| ELPA_Grp_Ind2 | 16.3.0 | VarChar2(50) | The method with which ELPA test tickets are sorted. Migrated from [Students.KS_KELPA_Ind1]. |
End_Pathways_Assess | 14.7.2 | Varchar2(1) | The subject area the student will take for CTE cPass assessment. |
End_Pathways_Grp_Ind1 | 14.7.2 | Varchar2(50) | The method with which End of Pathways test tickets are sorted. |
End_Pathways_Grp_Ind2 | 14.7.2 | Varchar2(50) | The second method with which End of Pathways test tickets are sorted. |
English_DLM_ProctorID | 14.7.2 | Number(11,0) | The number assigned to the educator by the state. |
| English_DLM_ProctorID_Fld | 14.9.0 | Varchar2(10) | The number assigned to the educator by the state. Data is stored in this field. |
English_DLM_ProctorName | 14.7.2 | Varchar2(100) | The name of the educator that should have access to the student's assessment data. |
ESOL_Billingual_Prog_EndDate | 14.7.2 | Date | Date student exits an ESOL/Bilingual program. |
| Exit_Date | 16.3.0 | Date | Exit Date. Migrated from [Students.KS_Ext_Dte]. |
| Exit_Type | 16.3.0 | VarChar2(2) | Exit Type. Migrated from [Students.KS_Ext_Typ]. |
| Fin_Lit-Grp_Ind2 | 16.7.2 | VarChar2(50) | The method with which Financial Literacy test tickets are sorted. |
| Fin_Lit_Assess | 16.7.2 | VarChar2(1) | Test options for Financial Literacy. |
| Fin_Lit_Grp_Ind1 | 16.7.2 | VarChar2(50) | The method with which Financial Literacy test tickets are sorted. |
| Finance_Assess | 15.7.3 | VarChar2(1) | Test options for Finance assessment. |
| Finance_Gr_Ind | 15.7.3 | Varchar2(50) | The method with which Finance test tickets are sorted. |
| First_Instr_Date | 19.7.1.0 | Date | The month, day, and year on which the student first receives instructional services during the current school year. |
| Funding_School | 16.3.0 | Number(11,0) | Funding School. Migrated from [Students.KS_Funding_Sch]. |
Gen_CTE_Assess | 14.7.2 | Varchar2(1) | Test options the student will take for CTE cPass. |
Gen_CTE_Grp_Ind1 | 14.7.2 | Varchar2(50) | The method with which CTE test tickets are sorted. |
Gen_CTE_Grp_Ind2 | 14.7.2 | Varchar2(50) | The second method with which CTE test tickets are sorted. |
| Gifted_Student | 16.3.0 | VarChar2(2) | Gifted Student. Migrated from [Students.KS_Sec_Except]. |
| Grade_Level | 16.3.0 | VarChar2(2) | Grade Level. Migrated from [Students.KS_Grade_Level]. |
| Hist_Assessment_Task1 | 19.7.1.0 | VarChar2(2) | The performance level the student achieved in Task 1 of the History/Government state assessment. |
| Hist_Assessment_Task2 | 19.7.1.0 | VarChar2(2) | The performance level the student achieved in Task 2 of the History/Government state assessment. |
| Hist_Assessment_Task3 | 19.7.1.0 | VarChar2(2) | The performance level the student achieved in Task 3 of the History/Government state assessment. |
Hist_Gov_Assess | 14.7.2 | Varchar2(1) | Test options for the History/Government assessment. |
| Hist_Gov_ProctorFirstName | 17.6.0 | VarChar2(100) | The first name of the educator that will score the student’s assessment through KITE. |
| Hist_Gov_ProctorID | 17.6.0 | Number(11,0) | The unique number assigned to the educator by the state in the Educator Licensure System. |
| Hist_Gov_ProctorLastName | 17.6.0 | VarChar2(100) | The last name of the educator that will score the student’s assessment through KITE. |
| History_Grp_Ind1 | 16.3.0 | VarChar2(50) | The method with which History test tickets are sorted. Migrated from [Students.KS_Hist_Gov_Group_Ind1]. |
| History_Grp_Ind2 | 16.3.0 | VarChar2(50) | The method with which History test tickets are sorted. Migrated from [Students.KS_Hist_Gov_Group_Ind2]. |
| History_US_Grp_Ind1 | 16.3.0 | VarChar2(50) | The method with which History US tickets are sorted. Migrated from [Students.KS_HS_Hist_US_Group_Ind1]. |
| History_US_Grp_Ind2 | 16.3.0 | VarChar2(50) | The method with which History US test tickets are sorted. Migrated from [Students.KS_HS_Hist_US_Group_Ind2]. |
| History_World_Grp_Ind1 | 16.3.0 | VarChar2(50) | The method with which History World test tickets are sorted. Migrated from [Students.KS_HS_Hist_Wld_Group_Ind1]. |
| History_World_Grp_Ind2 | 16.3.0 | VarChar2(50) | The method with which History World test tickets are sorted. Migrated from [Students.KS_HS_Hist_Wld_Group_Ind2]. |
| HS_Sci_Grp_Ind1 | 16.3.0 | VarChar2(1) | The method with which High School Science test tickets are sorted. Migrated from [Students.KS_HS_Sci_Group_Ind1]. |
| HS_Sci_Grp_Ind2 | 16.3.0 | VarChar2(1) | The method with which High School Science test tickets are sorted. Migrated from [Students.KS_HS_Sci_Group_Ind2]. |
| Improvement_Plan | 16.3.0 | Number(1,0) | Improvement Plan. Migrated from [Students.KS_ImprovementPlan]. |
| Life_Sci_Grp_Ind1 | 16.3.0 | VarChar2(50) | The method with which Life Science test tickets are sorted. Migrated from [Students.KS_HS_Life_Sci_Group_Ind1]. |
| Life_Sci_Grp_Ind2 | 16.3.0 | VarChar2(50) | The method with which Life Science test tickets are sorted. Migrated from [Students.KS_HS_Life_Sci_Group_Ind2]. |
Math_DLM_ProctorID | 14.7.2 | Number(11,0) | The number assigned to the educator by the state. |
| Math_DLM_ProctorID_Fld | 14.9.0 | Varchar2(10) | The number assigned to the educator by the state. Data is stored in this field. |
Math_DLM_ProctorName | 14.7.2 | Varchar2(100) | The name of the educator that should have access to the student's assessment data. |
| Math_Grp_Ind1 | 16.3.0 | VarChar2(50) | The method with which Math test tickets are sorted. Migrated from [Students.KS_Math_Group_Ind1]. |
| Math_Grp_Ind2 | 16.3.0 | VarChar2(50) | The method with which Math test tickets are sorted. Migrated from [Students.KS_Math_Group_Ind2]. |
| Mfg_Prod_Assess | 15.7.3 | VarChar2(1) | Test options for Manufacturing Systems assessment. |
| Mgf_Sys_Grp_Ind | 15.7.3 | Varchar2(50) | The method with which Manufacturing Systems test tickets are sorted. |
| Miles_Transported | 16.3.0 | Number(25,10) | Miles the student is transported. Migrated from [Students.KS_DistanceTransported]. |
| Minutes_Enrolled | 16.3.0 | Number(11,0) | Minutes Enrolled. Migrated from [Students.KS_Mts_Enr]. |
| National_School_Lunch | 16.3.0 | VarChar2(1) | Eligibility for Lunch Program. Migrated from [Students.KS_Nat_Sch_Lnh]. |
| Neglected_Student | 16.3.0 | VarChar2(1) | Neglected student. Migrated from [Students.KS_Neglected_Delinq]. |
| PAT_Participant | 17.6.0 | Number(1,0) | Indicates the child’s family participates in the Parents as Teachers program during the school year. |
| Phy_Grp_Ind1 | 16.3.0 | VarChar2(50) | The method with which Physical Science test tickets are sorted. Migrated from [Students.KS_HS_Phy_Group_Ind1]. |
| Phy_Grp_Ind2 | 16.3.0 | VarChar2(50) | The method with which Physical Science test tickets are sorted. Migrated from [Students.KS_HS_Phy_Group_Ind2]. |
| Plant_Sys_Assess | 15.7.3 | VarChar2(1) | Test options for Plant Systems assessment. |
| Plant_Sys_Grp_Ind | 15.7.3 | VarChar2(50) | The method with which Plant Systems test tickets are sorted. |
| Previous_ID | 16.3.0 | Number(11,0) | Previous Enrollment School ID. Migrated from [Students.KS_Prev_SchoolID]. |
| Primary_Disability | 16.3.0 | VarChar2(2) | Primary Disability. Migrated from [Students.KS_Prim_Except]. |
| Qualified_504 | 16.3.0 | VarChar2(1) | 504 qualified. Migrated from [Students.KS_Qal_504]. |
| Qualified_Admissions | 19.7.1.0 | VarChar2(1) | An indication of whether the student met the Kansas Qualified Admissions Pre-College Curriculum criteria. |
| Read_Grp_Ind1 | 16.3.0 | VarChar2(50) | The method with which Reading test tickets are sorted. Migrated from [Students.KS_Read_Group_Ind1]. |
| Read_Grp_Ind2 | 16.3.0 | VarChar2(50) | The method with which Reading test tickets are sorted. Migrated from [Students.KS_Read_Group_Ind2]. |
| Residence_District | 16.3.0 | VarChar2(100) | No longer used for state reporting. Migrated from [Students.residence_district] |
| School_Entry_Date | 16.3.0 | Date | School Entry Date. Migrated from [Students.KS_Sch_Ent_Dte]. |
| Sci_Grp_Ind1 | 16.3.0 | VarChar2(50) | The method Science test tickets are sorted. Migrated from [Students.KS_Sci_Group_Ind1]. |
| Sci_Grp_Ind2 | 16.3.0 | VarChar2(50) | The method with which Science test tickets are sorted. Migrated from [Students.KS_Sci_Group_Ind2]. |
Science_Assess | 14.7.2 | Varchar2(1) | Test options for the Science assessment. |
Science_DLM_ProctorID | 14.7.2 | Number(11,0) | The number assigned to the educator by the state. |
| Science_DLM_ProctorID_Fld | 14.9.0 | Varchar2(10) | The number assigned to the educator by the state. Data is stored in this field. |
Science_DLM_ProctorName | 14.7.2 | Varchar2(100) | The name of the educator that should have access to the students’ assessment data. |
SES_Indicator | 14.7.2 | Varchar2(1) | The student classifies as having an economic disadvantage. |
| Single_Parent | 17.7.0 | Number(1,0) | Indicator of whether the student is a single parent. |
| Special_Circum_Xfer | 16.3.0 | VarChar2(1) | Student's transfer related to Federal Law. Migrated from [Students.KS_Spc_Cir_Trn]. |
| State_ELPA_Assess | 16.3.0 | VarChar2(1) | Test options for ELPA assessment. Migrated from [Students.KS_State_KELPA_Assess]. |
| State_ELPA_FirstName | 16.7.2 | VarChar2(100) | The first name of the educator that should have access to the students’ assessment data. |
| State_ELPA_LastName | 16.7.2 | VarChar2(100) | The last name of the educator that should have access to the students’ assessment data. |
| State_ELPA_ProctorID | 16.7.2 | Number(11,0) | The number assigned to the educator by the state. |
| State_Entry_Date | 16.3.0 | Date | State Entry Date. Migrated from [Students.KS_St_Ent_Dte]. |
| State_His_Gov_Assess | 16.3.0 | VarChar2(1) | Test options for State History Government assessment. Migrated from [Students.KS_State_His_Gov_Assess]. |
| State_Hist_Gov_Assess_US | 16.3.0 | VarChar2(1) | Test options for State History Government US assessment. Migrated from [Students.KS_HS_State_Hist_Gov_Assess_US]. |
| State_Hist_Gov_Assess_World | 16.3.0 | VarChar2(1) | Test options for State History Government World assessment. Migrated from [Students.KS_HS_State_Hist_Gov_Assess_World]. |
| State_Life_Sci_Assess | 16.3.0 | VarChar2(1) | Test options for State Life Science assessment. Migrated from [Students.KS_HS_State_Life_Sci_Assess]. |
| State_Math_Assess | 16.3.0 | VarChar2(1) | Test options for State Math assessment. Migrated from [Students.KS_State_Math_Assess]. |
| State_Phys_Sci_Assess | 16.3.0 | VarChar2(1) | Test options for Sate Physical Science assessment. Migrated from [Students.KS_HS_State_Phys_Sci_Assess]. |
| State_Read_Assess | 16.3.0 | VarChar2(1) | Test options for State Read assessment. Migrated from [Students.KS_State_Read_Assess]. |
| State_Write_Assess | 16.3.0 | VarChar2(1) | Test options for Sate Writing assessment. Migrated from [Students.KS_State_Write_Assess]. |
| Tech_Ed_Minutes | 16.3.0 | Number(11,0) | The minutes of instruction for Career and Technical education. Migrated from [Students.KS_Tec_Ed_Min]. |
Ten_Mile_Law | 16.3.0 | Number(1,0) | Non-resident Transportation. Migrated from [Students.KS_10_Mile_Law]. |
| Title_I_Participation | 16.3.0 | VarChar2(1) | Student Received Title 1 services. Migrated from [Students.KS_Tle_I_Par]. |
| Transport_Address | 16.3.0 | VarChar2(30) | Transportation Address. Migrated from [Students.KS_Trans_Address]. |
| Transport_At_Risk | 16.3.0 | Number(1,0) | At-Risk student. Migrated from [Students.KS_IsTransportAtRisk] |
| Transport_City | 16.3.0 | VarChar2(20) | Transportation City. Migrated from [Students.KS_Trans_City]. |
| Transport_FTE | 16.3.0 | Number(25,10) | Transportation FTE. Migrated from [Students.KS_TransportFTE]. |
| Transport_SPED | 16.3.0 | Number(1,0) | SPED student transported. Migrated from [Students.KS_IsTransportSPED]. |
| Transport_Status | 16.3.0 | Number(1,0) | Student transported at district expense. Migrated from [Students.KS_IsTransported]. |
Transport_Zip | 16.3.0 | VarChar2(10) | Transportation Zip. Migrated from [Students.KS_Trans_Zip]. |
| Truant_Override | 16.3.0 | Number(1,0) | Truant Student Override. Migrated from [Students.KS_TruantOverride]. |
| USA_Entry_Date | 16.3.0 | Date | The date entered the USA. Migrated from [Students.KS_USA_Ent_Dte]. |
| Userfield_1 | 15.7.3 | VarChar2(500) | Available for data entry if needed. |
| Userfield_2 | 15.7.3 | VarChar2(500) | Available for data entry if needed. |
| Userfield_3 | 15.7.3 | VarChar2(500) | Available for data entry if needed. |
| Virtual_Education | 16.3.0 | VarChar2(1) | Virtual Ed Student. Migrated from [Students.KS_IsTransportSPED]. |
| Write_Grp_Ind1 | 16.3.0 | VarChar2(50) | The method with which Writing test tickets are sorted. Migrated from [Students.KS_Write_Group_Ind1]. |
| Write_Grp_Ind2 | 16.3.0 | VarChar2(50) | The method with which Writing test tickets are sorted. Migrated from [Students.KS_Write_Group_Ind2]. |
| LANG_INST_EDU_PRGM_TYPE | 20.7.2.0 | VarChar2(2) | Indicates which Language Instruction Education Program Type has chosen for the student. |
| DYSLEXIA_SCREENER | 20.7.2.0 | VarChar2(2) | Indicates which Dyslexia Screener has been chosen for the student. |
| DYSLEXIA_SUBTEST | 20.7.2.0 | VarChar2(2) | Indicates which Dyslexia Subtest has been chosen for the student. |
| DYSLEXIA_SPRGBMRKPERFLVL | 20.7.2.0 | VarChar2(2) | Indicates which Dyslexia Spring Benchmark Performance Level has been chosen for the student. |
| INDIVIDUAL_PLAN_STUDY | 20.7.2.0 | VarChar2(1) | Indicates whether Individual Plan of Study (IPS) is chosen for the student or not. |