S_MS_STU_X (ver 14.9.3)
This is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.9.3 | Number(10,0) | Primary Key |
PII_Disclose_Directory_Info | 14.9.3 | Varchar2(1) | Permission to Disclose Personally Identifiable 'Directory' Information |
| CRDC_LEP_YN | 14.11.0 | Varchar2(1) | Is this a student who is Limited English Proficient (LEP)? |
| CRDC_LEPPrograms_YN | 14.11.0 | Varchar2(1) | Is this a student enrolled in Limited English Proficient Programs? |
| CRDC_Gifted_YN | 14.11.0 | Varchar2(1) | Is this a student enrolled in gifted and talented programs? |
| ForeignExchangeInd | 15.8.2 | Varchar2(1) | Is this a student a foreign exchange student? |
| PGMilitaryInd | 15.8.2 | Varchar2(1) | Is this students guardian in the military? |
| PGMilitaryType | 15.8.2 | Varchar2(2) | The guardians type of military service. |
| AbsenceCause | 16.4.0 | Varchar2(255) | Migrated from [Students.ms_AbsenceCause]. |
| CalcGradeLvl | 16.4.0 | Number(11,0) | Migrated from [Students.MS_CalcGradeLvl]. |
| CEISInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_CEISInd]. |
| ElementaryInd | 16.4.0 | Varchar2(1) | Migrated from [Students.MS_ElementaryInd]. |
| GiftedInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_GiftedInd]. |
| GiftedType | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_GiftedType]. |
| GradeCode | 16.4.0 | Number(11,0) | Migrated from [Students.MS_GradeCode]. |
| GraduationType | 16.4.0 | Varchar2(10) | Migrated from [Students.ms_GraduationType]. |
| IEPInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_IEPInd]. |
| ImmigrantInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_ImmigrantInd]. |
| LEPInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_LEPInd]. |
| MigrantInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_MigrantInd]. |
| PathwayInd | 16.4.0 | Varchar2(2) | Migrated from [Students.MS_PathwayInd]. Note: As of 18.8.0 - the value has changed from Varchar2(1) to Varchar2(2) |
| Peergradelvl | 16.4.0 | Number(11,0) | Migrated from [Students.ms_peergradelvl]. |
| PrevSchoolAddr | 16.4.0 | Varchar2(100) | Migrated from [Students.ms_PrevSchoolAddr]. |
| PrevSchoolName | 16.4.0 | Varchar2(35) | Migrated from [Students.ms_PrevSchoolName]. |
| PromotionDate | 16.4.0 | Date | Migrated from [Students.ms_PromotionDate]. |
| PromotionInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_PromotionInd]. |
| RAddr | 16.4.0 | Varchar2(100) | Migrated from [Students.ms_RAddr]. |
| RDate | 16.4.0 | Date | Migrated from [Students.ms_RDate]. |
| RName | 16.4.0 | Varchar2(35) | Migrated from [Students.ms_RName]. |
| Section504 | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_504]. |
| SpecialEdInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_SpecialEdInd]. |
| State_ExcludeEnrollment | 16.12.1 | Number(1,0) | Migrated from [Students.State_ExcludeEnrollment]. |
| TeacherFirstName | 16.4.0 | Varchar2(20) | Migrated from [Students.ms_TeacherFirstName]. |
| TeacherLastName | 16.4.0 | Varchar2(20) | Migrated from [Students.ms_TeacherLastName]. |
| TransportCode | 16.4.0 | Varchar2(2) | Migrated from [Students.ms_TransportCode]. |
| VocationalInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_VocationalInd]. |
| IncludeAlias | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_IncludeAlias]. |
| AliasFName | 16.4.0 | Varchar2(20) | Migrated from [Students.ms_AliasFName]. |
| AliasLName | 16.4.0 | Varchar2(20) | Migrated from [Students.ms_AliasLName]. |
| AliasMName | 16.4.0 | Varchar2(20) | Migrated from [Students.ms_AliasMName]. |
| BirthCity | 16.4.0 | Varchar2(30) | Migrated from [Students.ms_BirthCity]. |
| BirthCounty | 16.4.0 | Varchar2(30) | Migrated from [Students.ms_BirthCounty]. |
| BirthState | 16.4.0 | Varchar2(2) | Migrated from [Students.ms_BirthState]. |
| BirthCertFileNum | 16.4.0 | Varchar2(40) | Migrated from [Students.ms_BirthCertFileNum]. |
| BirthCertVerify | 16.4.0 | Varchar2(4) | Migrated from [Students.ms_BirthCertVerify]. |
| CountyCode | 16.4.0 | Varchar2(2) | Migrated from [Students.ms_CountyCode]. |
| EmergAddress | 16.4.0 | Varchar2(60) | Migrated from [Students.ms_EmergAddress]. |
| EmergCity | 16.4.0 | Varchar2(50) | Migrated from [Students.ms_EmergCity]. |
| EmergEmployer | 16.4.0 | Varchar2(255) | Migrated from [Students.ms_EmergEmployer]. |
| EmergState | 16.4.0 | Varchar2(2) | Migrated from [Students.ms_EmergState]. |
| EmergWorkPhone | 16.4.0 | Varchar2(16) | Migrated from [Students.ms_EmergWorkPhone]. |
| EmergWorkPhoneExt | 16.4.0 | Varchar2(10) | Migrated from [Students.ms_EmergWorkPhoneExt]. |
| EmergZip | 16.4.0 | Varchar2(10) | Migrated from [Students.ms_EmergZip]. |
| ImmuneCertDate | 16.4.0 | Date | Migrated from [Students.ms_ImmuneCertDate]. |
| ImmuneCertVerify | 16.4.0 | Varchar2(4) | Migrated from [Students.ms_ImmuneCertVerify]. |
| Hispanic | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_Hispanic]. |
| TechPrepInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_TechPrepInd]. |
| ContEdAcademicInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_ContEdAcademicInd]. |
| ContEdPSVocInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_ContEdPSVocInd]. |
| ContEdVocInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_ContEdVocInd]. |
| AcademicPassingInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_AcademicPassingInd]. |
| IEPPassedInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_IEPPassedInd]. |
| PrePostTestInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_PrePostTestInd]. |
| CapstoneInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_CapstoneInd]. |
| DisabledInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_DisabledInd]. |
| DisadvantagedInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_DisadvantagedInd]. |
| NonTraditionalInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_NonTraditionalInd]. |
| SingleParentInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_SingleParentInd]. |
| DisphomemakerInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_DisphomemakerInd]. |
| SpecialPopInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_SpecialPopInd]. |
| GradEligibleInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_GradEligibleInd]. |
| UngradedInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_UngradedInd]. |
| MilitaryInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_MilitaryInd]. |
| NonEmpInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_NonEmpInd]. |
| OtherEmpInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_OtherEmpInd]. |
| TitleIEligInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_TitleIEligInd]. |
| TitleIFosterCareInd | 17.7.0 | Varchar2(1) | Is this a student in foster care? |
| TitleILangInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_TitleILangInd]. |
| TitleIMathInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_TitleIMathInd]. |
| TitleINeglectedInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_TitleINeglectedInd]. |
| TitleIReadInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_TitleIReadInd]. |
| TitleIScienceInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_TitleIScienceInd]. |
| TitleISocialInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_TitleISocialInd]. |
| TitleISupportInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_TitleISupportInd]. |
| TitleIhomelessInd | 16.4.0 | Varchar2(1) | Migrated from [Students.ms_TitleIhomelessInd]. |
| DiplomaEndorsement1 | 21.7.2 | Varchar2(5) | 2021-2022: Data Entry Updates for 2021-2022: Diploma Endorsement 1 |
| DiplomaEndorsement2 | 21.7.2 | Varchar2(5) | 2021-2022: Data Entry Updates for 2021-2022: Diploma Endorsement 2 |