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 |