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 |