S_MA_REN_Demographic_X (ver 15.9.5)
This table is an extension of the Reenrollments table and maintains student level demographic data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ReenrollmentsDCID | 15.9.5 | Number(10,0) | Primary key that relates the extended table to the [Reenrollments] table. |
| 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 [Reenrollments]MA_City. |
| CountryOfOrigin | 15.11.0 | Varchar2(3) | The country from which an immigrant student has emigrated. Migrates from [Reenrollments]MA_CountryOrigin. |
EthnicityRaceCode | 15.9.5 | Varchar2(2) | The Massachusetts proprietary race code calculated from the checked federal race codes and the Hispanic/Latino indicator. |
| 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 [Reenrollments]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 [Reenrollments]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 [Reenrollments]MA_BilingualStatus. |
| LmitedEnglishProficiency | 15.11.0 | Varchar2(2) | Indicates whether or not the student is an English Language Learner (ELL) student. Migrates from [Reenrollments]MA_EngProficiency. |
| Homeless | 16.8.0 | varchar2(2) | Indicates the student is homeless (currently only used for SIF) |
| BirthCity | 17.5.0 | Varchar2(50) | [Reenrollments]MA_BIRTHCITY |
| NativeLanguage | 17.5.0 | Varchar2(3) | [Reenrollments]MA_HOMELANG |