Skip to main content
Skip table of contents

S_ID_STU_X (ver 14.4.2)

This is an extension of the Students table.

Column Name

Version

Data Type

Description

StudentsDCID

14.4.2

Number(10,0)

Primary Key

Admission_Date15.7.0DateAdmission Date. Migrated from [Students.ID_Admission_Date].
Admission_Status15.7.0Varchar2(5)Admission Status. Migrated from [Students.ID_Admission_Status].
AliasName15.7.0Varchar2(100)Alias Name. Migrated from [Students.ID_AliasName].
atRiskA16.8.0Number(1,0)At-Risk Indicator A (Boolean flag)
atRiskB16.8.0Number(1,0)At-Risk Indicator B (Boolean flag)
atRiskC16.8.0Number(1,0)At-Risk Indicator C (Boolean flag)
atRiskD16.8.0Number(1,0)At-Risk Indicator D (Boolean flag)
atRiskE16.8.0Number(1,0)At-Risk Indicator E (Boolean flag)
atRiskF16.8.0Number(1,0)At-Risk Indicator F (Boolean flag)
atRiskG16.8.0Number(1,0)At-Risk Indicator G (Boolean flag)
atRiskH16.8.0Number(1,0)At-Risk Indicator H (Boolean flag)
atRiskI16.8.0Number(1,0)At-Risk Indicator I (Boolean flag)
atRiskJ16.8.0Number(1,0)At-Risk Indicator J (Boolean flag)
atRiskK16.8.0Number(1,0)At-Risk Indicator K (Boolean flag)
atRiskL16.8.0Number(1,0)At-Risk Indicator L (Boolean flag)
atRiskM16.8.0Number(1,0)At-Risk Indicator M (Boolean flag)
atRiskN16.8.0Number(1,0)At-Risk Indicator N (Boolean flag)
BaseSchoolId15.7.0Varchar2(8)Base SchoolId. Migrated from [Students.ID_BaseSchoolId].
BorderId15.7.0Varchar2(15)BorderId. Migrated from [Students.ID_BorderId].
BorderStudent15.7.0Varchar2(5)Border Student. Migrated from [Students.ID_BorderStudent].
BusRider15.7.0Varchar2(5)Bus Rider. Migrated from [Students.ID_BusRider].
CalendarID15.7.0Varchar2(30)Calendar ID. Migrated from [Students.ID_CalendarID].
Citizenship_Code15.7.0Varchar2(8)Citizenship Code. Migrated from [Students.ID_Citizenship_Code].
City_of_Birth15.7.0Varchar2(60)City of Birth. Migrated from [Students.ID_City_of_Birth].
Concentrator15.7.0Varchar2(5)Concentrator. Migrated from [Students.ID_Concentrator].
Counselor15.7.0Varchar2(18)Counselor. Migrated from [Students.ID_Counselor].
Country15.7.0Varchar2(5)Country. Migrated from [Students.ID_Country].
Country_of_Birth15.7.0Varchar2(160)Country of Birth. Migrated from [Students.ID_Country_of_Birth].
Country_of_Citizenship15.7.0Varchar2(160)Country of Citizenship. Migrated from [Students.ID_Country_of_Citizenship].
County_of_Residence15.7.0Varchar2(5)County of Residence. Migrated from [Students.ID_County_of_Residence].
DateOfEntryIntoUSA15.7.0DateDate Of Entry Into USA. Migrated from [Students.DateOfEntryIntoUSA].
Dpt15.7.0Varchar2(20)Diphtheria, Tetanus, Pertussis Immunization status (DTaP, DTP, DT). Migrated from [Students.dpt].
Dtp115.7.0Varchar2(20)Diphtheria, Tetanus, Pertussis Immunization 1 Date. Migrated from [Students.dtp1].
Dtp215.7.0Varchar2(20)Diphtheria, Tetanus, Pertussis Immunization 2 Date. Migrated from [Students.dtp2].
Dtp315.7.0Varchar2(20)Diphtheria, Tetanus, Pertussis Immunization 3 Date. Migrated from [Students.dtp3].
Dtp415.7.0Varchar2(20)Diphtheria, Tetanus, Pertussis Immunization 4 Date. Migrated from [Students.dtp4].
Dtp515.7.0Varchar2(20)Diphtheria, Tetanus, Pertussis Immunization 5 Date. Migrated from [Students.dtp5].
ECDecLate15.7.0Number(11,0)ECDecLate. Migrated from [Students.ID_ECDecLate].
ECDecTim15.7.0Varchar2(5)ECDecTim. Migrated from [Students.ID_ECDecTim].
ECEligDec15.7.0Varchar2(5)ECEligDec. Migrated from [Students.ID_ECEligDec].
ECLateRea15.7.0Varchar2(5)ECLateRea. Migrated from [Students.ID_ECLateRea].
ECLROther15.7.0Varchar2(500)ECLROther. Migrated from [Students.ID_ECLROther].
ECRefAgency15.7.0Varchar2(5)ECRefAgency. Migrated from [Students.ID_ECRefAgency].

ECTransDate

14.4.2

Date

Date for Early Childhood Transition.

Eightin615.7.0Varchar2(5)8in6 status. Migrated from [Students.ID_8in6].
Enrollment_Status15.7.0Varchar2(5)Enrollment Status. Migrated from [Students.ID_Enrollment_Status].
ErlyComp14.8.2Varchar2(1)Y/N for Early Completer status.
ExcludeStudEnrlReporting15.7.0Number(1,0)Exclude Student from Enrollment Reporting. Migrated from [Students.ID_ExcluedStudEnrlReporting].
ExitCode_Set_Date15.7.0DateExit Code Set Date. Migrated from [Students.ID_ExitCode_Set_Date].
Expulsion_Cause15.7.0Varchar2(60)Expulsion Cause. Migrated from [Students.ID_Expulsion_Cause].
Expulsion_Date15.7.0DateExpulsion Date. Migrated from [Students.ID_Expulsion_Date].
Expulsion_Rdate15.7.0DateExpulsion Rdate. Migrated from [Students.ID_Expulsion_Rdate].
Eye_data15.7.0Varchar2(150)Eye data. Migrated from [Students.eye_data].
Five0415.7.0Varchar2(5)504 Status. Migrated from [Students.ID_504].
Former_Legal_Name15.7.0Varchar2(100)Former Legal Name. Migrated from [Students.ID_Former_Legal_Name].
FYILAPart15.7.0Varchar2(5)FYILAPart. Migrated from [Students.ID_FYILAPart].
FYILAPerf15.7.0Varchar2(5)FYILAPerf. Migrated from [Students.ID_FYILAPerf].
FYIMathPerf15.7.0Varchar2(5)FYIMathPerf. Migrated from [Students.ID_FYIMathPerf].
FYISciPerf15.7.0Varchar2(5)FYISciPerf. Migrated from [Students.ID_FYISciPerf].
Gearup15.7.0Varchar2(5)Gearup. Migrated from [Students.ID_Gearup].
Gifted15.7.0Varchar2(5)Gifted. Migrated from [Students.ID_Gifted].
GradeEC15.12.0Number(10,0)Early Childhood.
GraduationDate15.7.0DateGraduation Date. Migrated from [Students.ID_GraduationDate].
Hearing_data15.7.0Varchar2(150)Hearing data. Migrated from [Students.hearing_data].
Height_data15.7.0Varchar2(150)Height data. Migrated from [Students.height_data].
Hepatitis15.7.0Varchar2(20)Hepatitis B Status. Migrated from [Students.hepatitis].
Hepatitis115.7.0Varchar2(20)Hepatitis B 1 Date. Migrated from [Students.hepatitis1].
Hepatitis215.7.0Varchar2(20)Hepatitis B 2 Date. Migrated from [Students.hepatitis2].
Hepatitis315.7.0Varchar2(20)Hepatitis B 3 Date. Migrated from [Students.hepatitis3].
Hepatitis415.7.0Varchar2(20)Hepatitis B 4 Date. Migrated from [Students.hepatitis4].
Hepatitis_a15.7.0Varchar2(20)Hepatitis A Status. Migrated from [Students.hepatitis_a].
Hepatitis_a115.7.0Varchar2(20)Hepatitis A 1 Date. Migrated from [Students.hepatitis_a1].
Hepatitis_a215.7.0Varchar2(20)Hepatitis A 2 Date. Migrated from [Students.hepatitis_a2].
Hib15.7.0Varchar2(20)Hib Immunization Status. Migrated from [Students.hib].
Hib115.7.0Varchar2(20)Hib1 Date. Migrated from [Students.hib1].
Hib215.7.0Varchar2(20)Hib2 Date. Migrated from [Students.hib2].
Hib315.7.0Varchar2(20)Hib3 Date. Migrated from [Students.hib3].
Hib415.7.0Varchar2(20)Hib4 Date. Migrated from [Students.hib4].
Homeless15.7.0Varchar2(5)Homeless. Migrated from [Students.ID_Homeless].
Immigrant15.7.0Varchar2(5)Immigrant. Migrated from [Students.ID_Immigrant].
ImmigrantEntry15.7.0DateImmigrant Entry. Migrated from [Students.ID_ImmigrantEntry].
Immune_Status15.7.0Varchar2(20)Immune Status. Migrated from [Students.ID_Immune_Status].
IMM_Conditional15.7.0Number(1,0)Immunization Conditional. Migrated from [Students.ID_IMM_Conditional].
IMM_Conditional_DTaP15.7.0Number(1,0)IMM Conditional DTaP. Migrated from [Students.ID_IMM_Conditional_DTaP].
IMM_Conditional_HepA15.7.0Number(1,0)IMM Conditional HepA. Migrated from [Students.ID_IMM_Conditional_HepA].
IMM_Conditional_HepB15.7.0Number(1,0)IMM Conditional HepB. Migrated from [Students.ID_IMM_Conditional_HepB].
IMM_Conditional_MMR15.7.0Number(1,0)IMM Conditional MMR. Migrated from [Students.ID_IMM_Conditional_MMR].
IMM_Conditional_Polio15.7.0Number(1,0)IMM Conditional Polio. Migrated from [Students.ID_IMM_Conditional_Polio].
IMM_Conditional_VAR15.7.0Number(1,0)IMM_Conditional_VAR. Migrated from [Students.ID_IMM_Conditional_VAR].
Inf115.7.0Varchar2(20)Influenza 1 Date. Migrated from [Students.Inf1].
Inf215.7.0Varchar2(20)Influenza 2 Date. Migrated from [Students.Inf2].
IRI_90Perc15.7.0Number(1,0)IRI 90Perc. Migrated from [Students.ID_IRI_90Perc].
KSchedcode15.7.0Varchar2(5)KSchedcode. Migrated from [Students.ID_KSchedcode].
Language_Code15.7.0Number(11,0)Language Code. Migrated from [Students.ID_Language_Code].
Legal_Name15.7.0Varchar2(100)Legal Name. Migrated from [Students.ID_Legal_Name].
LEPEntdate15.7.0DateLEP Entry date. Migrated from [Students.ID_LEPEntdate].
LEPExitDate15.7.0DateLEP Exit Date. Migrated from [Students.ID_LEPExitDate].
Medical_Considerations15.7.0Varchar2(400)Medical Considerations. Migrated from [Students.Medical_Considerations].
Med_other115.7.0Varchar2(20)Med other1. Migrated from [Students.med_other1].
Med_other215.7.0Varchar2(20)Med other2. Migrated from [Students.med_other2].
Med_other315.7.0Varchar2(20)Med other3. Migrated from [Students.med_other3].
Med_other415.7.0Varchar2(20)Med other4. Migrated from [Students.med_other4].
Med_other515.7.0Varchar2(20)Med other5. Migrated from [Students.med_other5].
militaryConnected16.8.0Varchar2(3)Military Connected Student
Mmr15.7.0Varchar2(5)Measles, Mumps, Rubella Immunization Status (MMR). Migrated from [Students.mmr].
Mmr115.7.0Varchar2(20)Measles, Mumps, Rubella 1 Date. Migrated from [Students.mmr1].
Mmr215.7.0Varchar2(20)Measles, Mumps, Rubella 2 Date. Migrated from [Students.mmr2].
Mmr315.7.0Varchar2(20)Measles, Mumps, Rubella 3 Date. Migrated from [Students.mmr3].
Name_of_Language15.7.0Varchar2(40)Name of Language. Migrated from [Students.ID_Name_of_Language].
No_Grade14.8.2 Number(10,0)No grade field.
Parent_Country_of_Birth15.7.0Varchar2(5)Parent Country of Birth. Migrated from [Students.ID_Parent_Country_of_Birth].
PH_Code15.7.0Number(1,0)PH Code. Migrated from [Students.ID_PH_Code].
PLOE15.7.0Varchar2(5)PLOE. Migrated from [Students.ID_PLOE].
Polio15.7.0Varchar2(20)Polio (IPV, OPV) Status. Migrated from [Students.polio].
Polio115.7.0Varchar2(20)Polio (IPV, OPV) 1 date. Migrated from [Students.polio1].
Polio215.7.0Varchar2(20)Polio (IPV, OPV) 2 date. Migrated from [Students.polio2].
Polio315.7.0Varchar2(20)Polio (IPV, OPV) 3 date. Migrated from [Students.polio3].
Polio415.7.0Varchar2(20)Polio (IPV, OPV) 4 date. Migrated from [Students.polio4].
Polio515.7.0Varchar2(20)Polio (IPV, OPV) 5 date. Migrated from [Students.polio5].
PPV115.7.0Varchar2(20)Meningococcal 1 date. Migrated from [Students.PPV1].
PPV215.7.0Varchar2(20)Meningococcal 2 date. Migrated from [Students.PPV2].
PrivateSchoolStudent15.7.0Varchar2(5)Private School Student. Migrated from [Students.ID_PrivateSchoolStudent].
Proof_of_Age15.7.0Varchar2(5)Proof of Age. Migrated from [Students.ID_Proof_of_Age].
PSRS15.7.0Number(11,0)PSRS. Migrated from [Students.ID_PSRS].
PVC115.7.0Varchar2(20)Pneumococcal conjugate 1 Date. Migrated from [Students.PVC1].
PVC215.7.0Varchar2(20)Pneumococcal conjugate 2 Date. Migrated from [Students.PVC2].
PVC315.7.0Varchar2(20)Pneumococcal conjugate 3 Date. Migrated from [Students.PVC3].
PVC415.7.0Varchar2(20)Pneumococcal conjugate 4 Date. Migrated from [Students.PVC4].
RankOutOfOverride15.7.0Number(11,0)Rank Out Of Override. Migrated from [Students.ID_RankOutOfOverride].
RankOverride15.7.0Number(11,0)Rank Override. Migrated from [Students.ID_RankOverride].
Release_Info15.7.0Varchar2(5)Release Info. Migrated from [Students.ID_Release_Info].
ResponsibleParentGuardian15.7.0Varchar2(50)Responsible Parent Guardian. Migrated from [Students.ID_ResponsibleParentGuardian].
Ride_Bike15.7.0Varchar2(5)Ride Bike. Migrated from [Students.Ride_Bike].
SpecialEd15.7.0Varchar2(5)Special Ed. Migrated from [Students.ID_SpecialEd].
State_of_Birth15.7.0Varchar2(5)State of Birth. Migrated from [Students.ID_State_of_Birth].
Suffix15.7.0Varchar2(16)Suffix. Migrated from [Students.ID_Suffix].
Tb115.7.0Varchar2(20)Tb1 date. Migrated from [Students.tb1].
Tb215.7.0Varchar2(20)Tb2 date. Migrated from [Students.tb2].
Tb315.7.0Varchar2(20)Tb3 date. Migrated from [Students.tb3].
Td15.7.0Varchar2(20)Td/Tdap Status. Migrated from [Students.td].
Td115.7.0Varchar2(20)Td/Tdap 1 Date. Migrated from [Students.td1].
Td215.7.0Varchar2(20)Td/Tdap 2 Date. Migrated from [Students.td2].
Td315.7.0Varchar2(20)Td/Tdap 3 Date. Migrated from [Students.td3].
Td415.7.0Varchar2(20)Td/Tdap 4 Date. Migrated from [Students.td4].
Td515.7.0Varchar2(20)Td/Tdap 5 Date. Migrated from [Students.td5].
TDPeer15.7.0Varchar2(5)TDPeer. Migrated from [Students.ID_TDPeer].
Title115.7.0Varchar2(5)Title1. Migrated from [Students.ID_Title1].
Tutoring15.7.0Varchar2(5)Tutoring. Migrated from [Students.ID_Tutoring].
TutorSubj115.7.0Varchar2(12)TutorSubj1. Migrated from [Students.ID_TutorSubj1].
TutorSubj215.7.0Varchar2(12)TutorSubj2. Migrated from [Students.ID_TutorSubj2].
TutorSubj315.7.0Varchar2(12)TutorSubj3. Migrated from [Students.ID_TutorSubj3].
TutorSubj415.7.0Varchar2(12)TutorSubj4. Migrated from [Students.ID_TutorSubj4].
TutorSubj515.7.0Varchar2(12)TutorSubj5. Migrated from [Students.ID_TutorSubj5].
US_Citizen15.7.0Varchar2(5)US Citizen. Migrated from [Students.ID_US_Citizen].
Var115.7.0Varchar2(20)Varicella 1 Date. Migrated from [Students.var1].
Var215.7.0Varchar2(20)Varicella 2 Date. Migrated from [Students.var2].
Varicella15.7.0Varchar2(20)Varicella Status (Chickent Pox). Migrated from [Students.varicella].
Walk_Home15.7.0Varchar2(5)Walk Home. Migrated from [Students.Walk_Home].
Weight_data15.7.0Varchar2(150)Weight data. Migrated from [Students.weight_data].
EarnedIndCert17.9.0Varchar2(5)Earned Industry Certification (Y/N).
ResSchoolID18.3.0Number(4,0)

Resident School ID

nativeLanguage18.8.0Varchar2(3)Native Language
IMM_Conditional_Men22.5.3Number(1,0)Conditionally Admitted - Meningococcal
OpenEnrolled23.9.2.0Varchar2(3)Open Enrolled



JavaScript errors detected

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

If this problem persists, please contact our support.