S_MT_STU_Demographics_X (ver 14.8.0)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
---|---|---|---|
StudentsDCID | 14.8.0 | Number (10,0) | Primary key that relates the extended table to the Students table. |
MilitaryDependentStatus | 14.8.0 | Varchar2 (1) | Indicates if the student is a dependent of an active military member. |
MigrantFlag | 15.7.0 | Number (1,0) | Indicates if the student or student's family are migrant workers. Migrates from [Students]MTMigrantFlag |
DateEnteredUS | 15.7.0 | Date | Indicates the date the student entered the US if not born in the US. Migrates from [Students]MT_DateEnteredUS |
HomelessInd | 15.7.0 | Number (1,0) | Indicates if the student or student's family is homeless. Migrates from [Students]MT_Homeless |
HomelessNightResidence | 15.7.0 | Varchar2 (2) | Code indicating a homeless student's current night time living/sleeping arrangements. Migrates from [Students]MT_HomelessNight |
Immigrant | 15.7.0 | Number (1,0) | Code indicating if the student is an immigrant to the US. Migrates from [Students]MT_Immigrant |
McKinneyVento | 15.7.0 | Number (1,0) | Indicates if the homeless student qualifies under McKinney-Vento Migrates from [Students]MT_McKinneyVento |
RaceEthnicityDetermination | 15.7.0 | Varchar2 (2) | Code indicating how the student's race and/or ethnicity were determined. Migrates from [Students]MT_Race_Determination |
NameSuffix | 15.7.0 | Varchar2 (4) | The student's name suffix such as Sr., Jr., II etc. Migrates from [Students]MT_Suffix |
StudentSingleParent | 15.7.0 | Number (1,0) | Indicates the CTE student is unmarried and has a custody of a child or is pregnant. Migrates from [Students]MT_StudentSingleParent |
UnaccompaniedYouth | 15.7.0 | Number (1,0) | Indicates the student is homeless and is not in the physical custody of a parent or guardian. Migrates from [Students]MT_Unaccompanied |
MissingChildPhotoOptIn | 20.0.0 | Varchar2 (1) | Field to set the photo-sharing opt-in so that, User can report the same to the state and missing children's photos can be easily shared with law enforcement agencies. |