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 |