S_MA_STU_SIMS_X (ver 15.8.0)
This table is an extension of the Students table and maintains student level data related to the SIMS report.
Column Name | Version | Data Type | Description |
---|---|---|---|
StudentsDCID | 15.8.0 | Number(10,0) | Primary key that relates the extended table to the [Students] table. |
IncludeInSIMSInd | 15.11.0 | Number(1,0) | Indicates whether or not you want to explicitly include the student in the SIMS report. Migrates from [Students]MA_DOERptFlag. |
LowIncomeStatus | 15.11.0 | Varchar2(2) | Indicates the student's eligibility for free or reduced cost lunches. Migrates from [Students]MA_IncomeStatus. |
NonInstructionalTitle1Services | 15.8.0 | Varchar2(2) | Used to identify students receiving targeted Title I assistance services that are non-instructional. Extracted on the SIMS report as DOE030. |
Title1Participation | 15.11.0 | Varchar2(2) | The student's participation type in the Title 1 program, if applicable. Migrates from [Students]MA_PIncomeStatus. |
Title1SchoolChoice | 15.11.0 | Varchar2(2) | Indicates the student's Title 1 School Choice status, if applicable. Migrates from [Students]MA_TitleI. |
UnexcusedAbsences | 15.11.0 | Varchar2(10) | The number of unexcused absences the student has to be published in the SIMS report based on truancies. Migrates from [Students]MA_DOE052. |
ELL_SLIFE | 16.8.0 | varchar2(2) | For SIMS - DOE041 - ELL SLIFE (English Language Learner Student with Limited or Interrupted formal Education) |
EvaluationDate | 18.8.0 | Date | For SIF - new date field labelled Evaluation Date. Not required for State Reporting. |
HighQualCarPathwaysProgTyp | 18.8.0 | varchar2(3) | For SIMS - DOE045 - High Quality Career Pathways Program Type |
HighQualCarPathwaysProgPart | 18.8.0 | varchar2(3) | For SIMS - DOE046 - High Quality Career Pathways Program Participation |
IndustryRecogCred1 | 18.8.3 | varchar2(3) | For SIMS - DOE047 - Industry Recognized Credentials |
IndustryRecogCred2 | 18.8.3 | varchar2(3) | For SIMS - DOE048 - Industry Recognized Credentials |
IndustryRecogCred3 | 18.8.3 | varchar2(3) | For SIMS - DOE049 - Industry Recognized Credentials |
EarlyChildhoodExperience | 18.8.3 | varchar2(2) | For SIMS - DOE050 - Early Childhood Experience |
ZipOverride | 19.9.1.0 | varchar2(5) | For SIMS - DOE051 - Zip Code override, if different from Home Zip. |
CivicsProjectCompleter | 20.9.3.0 | varchar2(3) | For SIMS - DOE053 - Civics Project Completer. |