Skip to main content
Skip table of contents

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


Data Type





Primary key that relates the extended table to the [Students] table.

BirthCity15.11.0Varchar2(50)The name of the city or town in which the student was born. Migrates from [Students]MA_BirthCity.
CityOfResidence15.11.0Varchar2(3)The three-digit code for the city or town where the student lives at the time of reporting. Migrates from [Students]MA_City.
CountryOfOrigin15.11.0Varchar2(3)The country from which an immigrant student has emigrated. Migrates from [Students]MA_CountryOrigin.




The Massachusetts proprietary race code calculated from the checked federal race codes and the Hispanic/Latino indicatorMigrates from [Students]MA_ERCode.

ImmigrantStatus15.11.0Varchar2(2)Indicates whether or not the student is considered to be an immigrant student under the federal definition. Migrates from [Students]MA_ImmgrStatus.
LEP1stYrInUS15.11.0Varchar2(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.
LEPProgramStatus15.11.0Varchar2(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.
LimitedEnglishProficiency15.11.0Varchar2(2)Indicates whether or not the student is an English Language Learner (ELL) student. Migrates from [Students]MA_EngProficiency.
LongMiddleName15.11.0Varchar2(32)The student's middle name if longer than the core middle name field can accommodate. Migrates from [Students]MA_middle_name.
NativeLanguage15.11.0Varchar2(3)Three digit code for the specific language or dialect first learned by the student. Migrates from [Students]MA_HomeLang.
NonBinary_Gender_TF16.8.0Number(1)Indicates the student identifies as transgender or not M/F (used in SIMS)
Homeless16.8.0varchar2(2)Indicates the student is homeless (currently only used for SIF)
DwellingArrangement17.8.0varchar2(50)Indicates the the value of Dwelling Arrangement
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.