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_Date | 15.7.0 | Date | Admission Date. Migrated from [Students.ID_Admission_Date]. |
Admission_Status | 15.7.0 | Varchar2(5) | Admission Status. Migrated from [Students.ID_Admission_Status]. |
AliasName | 15.7.0 | Varchar2(100) | Alias Name. Migrated from [Students.ID_AliasName]. |
atRiskA | 16.8.0 | Number(1,0) | At-Risk Indicator A (Boolean flag) |
atRiskB | 16.8.0 | Number(1,0) | At-Risk Indicator B (Boolean flag) |
atRiskC | 16.8.0 | Number(1,0) | At-Risk Indicator C (Boolean flag) |
atRiskD | 16.8.0 | Number(1,0) | At-Risk Indicator D (Boolean flag) |
atRiskE | 16.8.0 | Number(1,0) | At-Risk Indicator E (Boolean flag) |
atRiskF | 16.8.0 | Number(1,0) | At-Risk Indicator F (Boolean flag) |
atRiskG | 16.8.0 | Number(1,0) | At-Risk Indicator G (Boolean flag) |
atRiskH | 16.8.0 | Number(1,0) | At-Risk Indicator H (Boolean flag) |
atRiskI | 16.8.0 | Number(1,0) | At-Risk Indicator I (Boolean flag) |
atRiskJ | 16.8.0 | Number(1,0) | At-Risk Indicator J (Boolean flag) |
atRiskK | 16.8.0 | Number(1,0) | At-Risk Indicator K (Boolean flag) |
atRiskL | 16.8.0 | Number(1,0) | At-Risk Indicator L (Boolean flag) |
atRiskM | 16.8.0 | Number(1,0) | At-Risk Indicator M (Boolean flag) |
atRiskN | 16.8.0 | Number(1,0) | At-Risk Indicator N (Boolean flag) |
BaseSchoolId | 15.7.0 | Varchar2(8) | Base SchoolId. Migrated from [Students.ID_BaseSchoolId]. |
BorderId | 15.7.0 | Varchar2(15) | BorderId. Migrated from [Students.ID_BorderId]. |
BorderStudent | 15.7.0 | Varchar2(5) | Border Student. Migrated from [Students.ID_BorderStudent]. |
BusRider | 15.7.0 | Varchar2(5) | Bus Rider. Migrated from [Students.ID_BusRider]. |
CalendarID | 15.7.0 | Varchar2(30) | Calendar ID. Migrated from [Students.ID_CalendarID]. |
Citizenship_Code | 15.7.0 | Varchar2(8) | Citizenship Code. Migrated from [Students.ID_Citizenship_Code]. |
City_of_Birth | 15.7.0 | Varchar2(60) | City of Birth. Migrated from [Students.ID_City_of_Birth]. |
Concentrator | 15.7.0 | Varchar2(5) | Concentrator. Migrated from [Students.ID_Concentrator]. |
Counselor | 15.7.0 | Varchar2(18) | Counselor. Migrated from [Students.ID_Counselor]. |
Country | 15.7.0 | Varchar2(5) | Country. Migrated from [Students.ID_Country]. |
Country_of_Birth | 15.7.0 | Varchar2(160) | Country of Birth. Migrated from [Students.ID_Country_of_Birth]. |
Country_of_Citizenship | 15.7.0 | Varchar2(160) | Country of Citizenship. Migrated from [Students.ID_Country_of_Citizenship]. |
County_of_Residence | 15.7.0 | Varchar2(5) | County of Residence. Migrated from [Students.ID_County_of_Residence]. |
DateOfEntryIntoUSA | 15.7.0 | Date | Date Of Entry Into USA. Migrated from [Students.DateOfEntryIntoUSA]. |
Dpt | 15.7.0 | Varchar2(20) | Diphtheria, Tetanus, Pertussis Immunization status (DTaP, DTP, DT). Migrated from [Students.dpt]. |
Dtp1 | 15.7.0 | Varchar2(20) | Diphtheria, Tetanus, Pertussis Immunization 1 Date. Migrated from [Students.dtp1]. |
Dtp2 | 15.7.0 | Varchar2(20) | Diphtheria, Tetanus, Pertussis Immunization 2 Date. Migrated from [Students.dtp2]. |
Dtp3 | 15.7.0 | Varchar2(20) | Diphtheria, Tetanus, Pertussis Immunization 3 Date. Migrated from [Students.dtp3]. |
Dtp4 | 15.7.0 | Varchar2(20) | Diphtheria, Tetanus, Pertussis Immunization 4 Date. Migrated from [Students.dtp4]. |
Dtp5 | 15.7.0 | Varchar2(20) | Diphtheria, Tetanus, Pertussis Immunization 5 Date. Migrated from [Students.dtp5]. |
ECDecLate | 15.7.0 | Number(11,0) | ECDecLate. Migrated from [Students.ID_ECDecLate]. |
ECDecTim | 15.7.0 | Varchar2(5) | ECDecTim. Migrated from [Students.ID_ECDecTim]. |
ECEligDec | 15.7.0 | Varchar2(5) | ECEligDec. Migrated from [Students.ID_ECEligDec]. |
ECLateRea | 15.7.0 | Varchar2(5) | ECLateRea. Migrated from [Students.ID_ECLateRea]. |
ECLROther | 15.7.0 | Varchar2(500) | ECLROther. Migrated from [Students.ID_ECLROther]. |
ECRefAgency | 15.7.0 | Varchar2(5) | ECRefAgency. Migrated from [Students.ID_ECRefAgency]. |
ECTransDate | 14.4.2 | Date | Date for Early Childhood Transition. |
Eightin6 | 15.7.0 | Varchar2(5) | 8in6 status. Migrated from [Students.ID_8in6]. |
Enrollment_Status | 15.7.0 | Varchar2(5) | Enrollment Status. Migrated from [Students.ID_Enrollment_Status]. |
ErlyComp | 14.8.2 | Varchar2(1) | Y/N for Early Completer status. |
ExcludeStudEnrlReporting | 15.7.0 | Number(1,0) | Exclude Student from Enrollment Reporting. Migrated from [Students.ID_ExcluedStudEnrlReporting]. |
ExitCode_Set_Date | 15.7.0 | Date | Exit Code Set Date. Migrated from [Students.ID_ExitCode_Set_Date]. |
Expulsion_Cause | 15.7.0 | Varchar2(60) | Expulsion Cause. Migrated from [Students.ID_Expulsion_Cause]. |
Expulsion_Date | 15.7.0 | Date | Expulsion Date. Migrated from [Students.ID_Expulsion_Date]. |
Expulsion_Rdate | 15.7.0 | Date | Expulsion Rdate. Migrated from [Students.ID_Expulsion_Rdate]. |
Eye_data | 15.7.0 | Varchar2(150) | Eye data. Migrated from [Students.eye_data]. |
Five04 | 15.7.0 | Varchar2(5) | 504 Status. Migrated from [Students.ID_504]. |
Former_Legal_Name | 15.7.0 | Varchar2(100) | Former Legal Name. Migrated from [Students.ID_Former_Legal_Name]. |
FYILAPart | 15.7.0 | Varchar2(5) | FYILAPart. Migrated from [Students.ID_FYILAPart]. |
FYILAPerf | 15.7.0 | Varchar2(5) | FYILAPerf. Migrated from [Students.ID_FYILAPerf]. |
FYIMathPerf | 15.7.0 | Varchar2(5) | FYIMathPerf. Migrated from [Students.ID_FYIMathPerf]. |
FYISciPerf | 15.7.0 | Varchar2(5) | FYISciPerf. Migrated from [Students.ID_FYISciPerf]. |
Gearup | 15.7.0 | Varchar2(5) | Gearup. Migrated from [Students.ID_Gearup]. |
Gifted | 15.7.0 | Varchar2(5) | Gifted. Migrated from [Students.ID_Gifted]. |
GradeEC | 15.12.0 | Number(10,0) | Early Childhood. |
GraduationDate | 15.7.0 | Date | Graduation Date. Migrated from [Students.ID_GraduationDate]. |
Hearing_data | 15.7.0 | Varchar2(150) | Hearing data. Migrated from [Students.hearing_data]. |
Height_data | 15.7.0 | Varchar2(150) | Height data. Migrated from [Students.height_data]. |
Hepatitis | 15.7.0 | Varchar2(20) | Hepatitis B Status. Migrated from [Students.hepatitis]. |
Hepatitis1 | 15.7.0 | Varchar2(20) | Hepatitis B 1 Date. Migrated from [Students.hepatitis1]. |
Hepatitis2 | 15.7.0 | Varchar2(20) | Hepatitis B 2 Date. Migrated from [Students.hepatitis2]. |
Hepatitis3 | 15.7.0 | Varchar2(20) | Hepatitis B 3 Date. Migrated from [Students.hepatitis3]. |
Hepatitis4 | 15.7.0 | Varchar2(20) | Hepatitis B 4 Date. Migrated from [Students.hepatitis4]. |
Hepatitis_a | 15.7.0 | Varchar2(20) | Hepatitis A Status. Migrated from [Students.hepatitis_a]. |
Hepatitis_a1 | 15.7.0 | Varchar2(20) | Hepatitis A 1 Date. Migrated from [Students.hepatitis_a1]. |
Hepatitis_a2 | 15.7.0 | Varchar2(20) | Hepatitis A 2 Date. Migrated from [Students.hepatitis_a2]. |
Hib | 15.7.0 | Varchar2(20) | Hib Immunization Status. Migrated from [Students.hib]. |
Hib1 | 15.7.0 | Varchar2(20) | Hib1 Date. Migrated from [Students.hib1]. |
Hib2 | 15.7.0 | Varchar2(20) | Hib2 Date. Migrated from [Students.hib2]. |
Hib3 | 15.7.0 | Varchar2(20) | Hib3 Date. Migrated from [Students.hib3]. |
Hib4 | 15.7.0 | Varchar2(20) | Hib4 Date. Migrated from [Students.hib4]. |
Homeless | 15.7.0 | Varchar2(5) | Homeless. Migrated from [Students.ID_Homeless]. |
Immigrant | 15.7.0 | Varchar2(5) | Immigrant. Migrated from [Students.ID_Immigrant]. |
ImmigrantEntry | 15.7.0 | Date | Immigrant Entry. Migrated from [Students.ID_ImmigrantEntry]. |
Immune_Status | 15.7.0 | Varchar2(20) | Immune Status. Migrated from [Students.ID_Immune_Status]. |
IMM_Conditional | 15.7.0 | Number(1,0) | Immunization Conditional. Migrated from [Students.ID_IMM_Conditional]. |
IMM_Conditional_DTaP | 15.7.0 | Number(1,0) | IMM Conditional DTaP. Migrated from [Students.ID_IMM_Conditional_DTaP]. |
IMM_Conditional_HepA | 15.7.0 | Number(1,0) | IMM Conditional HepA. Migrated from [Students.ID_IMM_Conditional_HepA]. |
IMM_Conditional_HepB | 15.7.0 | Number(1,0) | IMM Conditional HepB. Migrated from [Students.ID_IMM_Conditional_HepB]. |
IMM_Conditional_MMR | 15.7.0 | Number(1,0) | IMM Conditional MMR. Migrated from [Students.ID_IMM_Conditional_MMR]. |
IMM_Conditional_Polio | 15.7.0 | Number(1,0) | IMM Conditional Polio. Migrated from [Students.ID_IMM_Conditional_Polio]. |
IMM_Conditional_VAR | 15.7.0 | Number(1,0) | IMM_Conditional_VAR. Migrated from [Students.ID_IMM_Conditional_VAR]. |
Inf1 | 15.7.0 | Varchar2(20) | Influenza 1 Date. Migrated from [Students.Inf1]. |
Inf2 | 15.7.0 | Varchar2(20) | Influenza 2 Date. Migrated from [Students.Inf2]. |
IRI_90Perc | 15.7.0 | Number(1,0) | IRI 90Perc. Migrated from [Students.ID_IRI_90Perc]. |
KSchedcode | 15.7.0 | Varchar2(5) | KSchedcode. Migrated from [Students.ID_KSchedcode]. |
Language_Code | 15.7.0 | Number(11,0) | Language Code. Migrated from [Students.ID_Language_Code]. |
Legal_Name | 15.7.0 | Varchar2(100) | Legal Name. Migrated from [Students.ID_Legal_Name]. |
LEPEntdate | 15.7.0 | Date | LEP Entry date. Migrated from [Students.ID_LEPEntdate]. |
LEPExitDate | 15.7.0 | Date | LEP Exit Date. Migrated from [Students.ID_LEPExitDate]. |
Medical_Considerations | 15.7.0 | Varchar2(400) | Medical Considerations. Migrated from [Students.Medical_Considerations]. |
Med_other1 | 15.7.0 | Varchar2(20) | Med other1. Migrated from [Students.med_other1]. |
Med_other2 | 15.7.0 | Varchar2(20) | Med other2. Migrated from [Students.med_other2]. |
Med_other3 | 15.7.0 | Varchar2(20) | Med other3. Migrated from [Students.med_other3]. |
Med_other4 | 15.7.0 | Varchar2(20) | Med other4. Migrated from [Students.med_other4]. |
Med_other5 | 15.7.0 | Varchar2(20) | Med other5. Migrated from [Students.med_other5]. |
militaryConnected | 16.8.0 | Varchar2(3) | Military Connected Student |
Mmr | 15.7.0 | Varchar2(5) | Measles, Mumps, Rubella Immunization Status (MMR). Migrated from [Students.mmr]. |
Mmr1 | 15.7.0 | Varchar2(20) | Measles, Mumps, Rubella 1 Date. Migrated from [Students.mmr1]. |
Mmr2 | 15.7.0 | Varchar2(20) | Measles, Mumps, Rubella 2 Date. Migrated from [Students.mmr2]. |
Mmr3 | 15.7.0 | Varchar2(20) | Measles, Mumps, Rubella 3 Date. Migrated from [Students.mmr3]. |
Name_of_Language | 15.7.0 | Varchar2(40) | Name of Language. Migrated from [Students.ID_Name_of_Language]. |
No_Grade | 14.8.2 | Number(10,0) | No grade field. |
Parent_Country_of_Birth | 15.7.0 | Varchar2(5) | Parent Country of Birth. Migrated from [Students.ID_Parent_Country_of_Birth]. |
PH_Code | 15.7.0 | Number(1,0) | PH Code. Migrated from [Students.ID_PH_Code]. |
PLOE | 15.7.0 | Varchar2(5) | PLOE. Migrated from [Students.ID_PLOE]. |
Polio | 15.7.0 | Varchar2(20) | Polio (IPV, OPV) Status. Migrated from [Students.polio]. |
Polio1 | 15.7.0 | Varchar2(20) | Polio (IPV, OPV) 1 date. Migrated from [Students.polio1]. |
Polio2 | 15.7.0 | Varchar2(20) | Polio (IPV, OPV) 2 date. Migrated from [Students.polio2]. |
Polio3 | 15.7.0 | Varchar2(20) | Polio (IPV, OPV) 3 date. Migrated from [Students.polio3]. |
Polio4 | 15.7.0 | Varchar2(20) | Polio (IPV, OPV) 4 date. Migrated from [Students.polio4]. |
Polio5 | 15.7.0 | Varchar2(20) | Polio (IPV, OPV) 5 date. Migrated from [Students.polio5]. |
PPV1 | 15.7.0 | Varchar2(20) | Meningococcal 1 date. Migrated from [Students.PPV1]. |
PPV2 | 15.7.0 | Varchar2(20) | Meningococcal 2 date. Migrated from [Students.PPV2]. |
PrivateSchoolStudent | 15.7.0 | Varchar2(5) | Private School Student. Migrated from [Students.ID_PrivateSchoolStudent]. |
Proof_of_Age | 15.7.0 | Varchar2(5) | Proof of Age. Migrated from [Students.ID_Proof_of_Age]. |
PSRS | 15.7.0 | Number(11,0) | PSRS. Migrated from [Students.ID_PSRS]. |
PVC1 | 15.7.0 | Varchar2(20) | Pneumococcal conjugate 1 Date. Migrated from [Students.PVC1]. |
PVC2 | 15.7.0 | Varchar2(20) | Pneumococcal conjugate 2 Date. Migrated from [Students.PVC2]. |
PVC3 | 15.7.0 | Varchar2(20) | Pneumococcal conjugate 3 Date. Migrated from [Students.PVC3]. |
PVC4 | 15.7.0 | Varchar2(20) | Pneumococcal conjugate 4 Date. Migrated from [Students.PVC4]. |
RankOutOfOverride | 15.7.0 | Number(11,0) | Rank Out Of Override. Migrated from [Students.ID_RankOutOfOverride]. |
RankOverride | 15.7.0 | Number(11,0) | Rank Override. Migrated from [Students.ID_RankOverride]. |
Release_Info | 15.7.0 | Varchar2(5) | Release Info. Migrated from [Students.ID_Release_Info]. |
ResponsibleParentGuardian | 15.7.0 | Varchar2(50) | Responsible Parent Guardian. Migrated from [Students.ID_ResponsibleParentGuardian]. |
Ride_Bike | 15.7.0 | Varchar2(5) | Ride Bike. Migrated from [Students.Ride_Bike]. |
SpecialEd | 15.7.0 | Varchar2(5) | Special Ed. Migrated from [Students.ID_SpecialEd]. |
State_of_Birth | 15.7.0 | Varchar2(5) | State of Birth. Migrated from [Students.ID_State_of_Birth]. |
Suffix | 15.7.0 | Varchar2(16) | Suffix. Migrated from [Students.ID_Suffix]. |
Tb1 | 15.7.0 | Varchar2(20) | Tb1 date. Migrated from [Students.tb1]. |
Tb2 | 15.7.0 | Varchar2(20) | Tb2 date. Migrated from [Students.tb2]. |
Tb3 | 15.7.0 | Varchar2(20) | Tb3 date. Migrated from [Students.tb3]. |
Td | 15.7.0 | Varchar2(20) | Td/Tdap Status. Migrated from [Students.td]. |
Td1 | 15.7.0 | Varchar2(20) | Td/Tdap 1 Date. Migrated from [Students.td1]. |
Td2 | 15.7.0 | Varchar2(20) | Td/Tdap 2 Date. Migrated from [Students.td2]. |
Td3 | 15.7.0 | Varchar2(20) | Td/Tdap 3 Date. Migrated from [Students.td3]. |
Td4 | 15.7.0 | Varchar2(20) | Td/Tdap 4 Date. Migrated from [Students.td4]. |
Td5 | 15.7.0 | Varchar2(20) | Td/Tdap 5 Date. Migrated from [Students.td5]. |
TDPeer | 15.7.0 | Varchar2(5) | TDPeer. Migrated from [Students.ID_TDPeer]. |
Title1 | 15.7.0 | Varchar2(5) | Title1. Migrated from [Students.ID_Title1]. |
Tutoring | 15.7.0 | Varchar2(5) | Tutoring. Migrated from [Students.ID_Tutoring]. |
TutorSubj1 | 15.7.0 | Varchar2(12) | TutorSubj1. Migrated from [Students.ID_TutorSubj1]. |
TutorSubj2 | 15.7.0 | Varchar2(12) | TutorSubj2. Migrated from [Students.ID_TutorSubj2]. |
TutorSubj3 | 15.7.0 | Varchar2(12) | TutorSubj3. Migrated from [Students.ID_TutorSubj3]. |
TutorSubj4 | 15.7.0 | Varchar2(12) | TutorSubj4. Migrated from [Students.ID_TutorSubj4]. |
TutorSubj5 | 15.7.0 | Varchar2(12) | TutorSubj5. Migrated from [Students.ID_TutorSubj5]. |
US_Citizen | 15.7.0 | Varchar2(5) | US Citizen. Migrated from [Students.ID_US_Citizen]. |
Var1 | 15.7.0 | Varchar2(20) | Varicella 1 Date. Migrated from [Students.var1]. |
Var2 | 15.7.0 | Varchar2(20) | Varicella 2 Date. Migrated from [Students.var2]. |
Varicella | 15.7.0 | Varchar2(20) | Varicella Status (Chickent Pox). Migrated from [Students.varicella]. |
Walk_Home | 15.7.0 | Varchar2(5) | Walk Home. Migrated from [Students.Walk_Home]. |
Weight_data | 15.7.0 | Varchar2(150) | Weight data. Migrated from [Students.weight_data]. |
EarnedIndCert | 17.9.0 | Varchar2(5) | Earned Industry Certification (Y/N). |
ResSchoolID | 18.3.0 | Number(4,0) | Resident School ID |
nativeLanguage | 18.8.0 | Varchar2(3) | Native Language |
IMM_Conditional_Men | 22.5.3 | Number(1,0) | Conditionally Admitted - Meningococcal |
OpenEnrolled | 23.9.2.0 | Varchar2(3) | Open Enrolled |