S_MA_STU_Demographic_X (ver 15.11.0)
This table is an extension of the Students table and maintains student level demographic data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 15.11.0 | Number(10,0) | Primary key that relates the extended table to the [Students] table. |
| BirthCity | 15.11.0 | Varchar2(50) | The name of the city or town in which the student was born. Migrates from [Students]MA_BirthCity. |
| CityOfResidence | 15.11.0 | Varchar2(3) | The three-digit code for the city or town where the student lives at the time of reporting. Migrates from [Students]MA_City. |
| CountryOfOrigin | 15.11.0 | Varchar2(3) | The country from which an immigrant student has emigrated. Migrates from [Students]MA_CountryOrigin. |
EthnicityRaceCode | 15.11.0 | Varchar2(2) | The Massachusetts proprietary race code calculated from the checked federal race codes and the Hispanic/Latino indicator. Migrates from [Students]MA_ERCode. |
| ImmigrantStatus | 15.11.0 | Varchar2(2) | Indicates whether or not the student is considered to be an immigrant student under the federal definition. Migrates from [Students]MA_ImmgrStatus. |
| LEP1stYrInUS | 15.11.0 | Varchar2(2) | Indicates whether or not the student is an English Language Learner (ELL) student in their first year of schooling in the US. Migrates from [Students]MA_LEPinUS. |
| LEPProgramStatus | 15.11.0 | Varchar2(2) | Code indicating of the type of English Language Education Program in which the student is enrolled at the time of reporting. Migrates from [Students]MA_BilingualStatus. |
| LimitedEnglishProficiency | 15.11.0 | Varchar2(2) | Indicates whether or not the student is an English Language Learner (ELL) student. Migrates from [Students]MA_EngProficiency. |
| LongMiddleName | 15.11.0 | Varchar2(32) | The student's middle name if longer than the core middle name field can accommodate. Migrates from [Students]MA_middle_name. |
| NativeLanguage | 15.11.0 | Varchar2(3) | Three digit code for the specific language or dialect first learned by the student. Migrates from [Students]MA_HomeLang. |
| NonBinary_Gender_TF | 16.8.0 | Number(1) | Indicates the student identifies as transgender or not M/F (used in SIMS) |
| Homeless | 16.8.0 | varchar2(2) | Indicates the student is homeless (currently only used for SIF) |
| DwellingArrangement | 17.8.0 | varchar2(50) | Indicates the the value of Dwelling Arrangement |