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 |
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. |