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 |