The following table contains the SIMS fields provided by the Massachusetts Department of Education, the associated title, and the location in the PowerSchool database where the field is found.
|
MA Field |
Title |
PS DB Location |
|---|---|---|
|
DOE001 |
Locally Assigned Student Identifier (LASID) |
[Students] Student_Number |
|
DOE002 |
State Assigned Student Identifier (SASID) |
[Students] State_StudentNumber |
|
DOE003 |
First Name |
[StudentCoreFields] PSCore_Legal_First_Name, then [Students] First_Name |
|
DOE004 |
Middle Name |
[S_MA_STU_Demographic_X] LongMiddleName, then [StudentCoreFields] PSCore_Legal_Middle_Name, then [Students] Middle_Name |
|
DOE005 |
Last Name |
[StudentCoreFields] PSCore_Legal_Last_Name, then [Students] Last_Name |
|
DOE006 |
Date of Birth |
[Students] DOB |
|
DOE007 |
Date of Birth Format |
Hardcoded |
|
DOE008 |
City/Town of Birth |
[S_MA_STU_Demographic_X] BirthCity |
|
DOE009 |
Gender |
[S_MA_STU_Demographic_X] NonBinary_Gender_TF, then [Students] Gender |
|
DOE010 |
Race/Ethnicity |
[S_MA_STU_Demographic_X] EthnicityRaceCode – The SIF Agent also requires that the race checkboxes are set. |
|
DOE011 |
Reason for Reporting |
[S_MA_STU_X] ReasonForReporting OR [S_MA_REN_X] ReasonForReporting |
|
DOE012 |
Enrollment Status at Time of Data Collection |
[S_MA_STU_X] EnrollStatusTimeOfCollection OR [S_MA_REN_X] EnrollStatusTimeOfCollection |
|
DOE013 |
Reason for Enrollment |
[S_MA_STU_X] ReasonForEnrollment OR [S_MA_REN_X] ReasonForEnrollment |
|
DOE014 |
City/Town of Residence — Student |
[S_MA_STU_Demographic_X] CityOfResidence OR
|
|
DOE015 |
School Identification Number |
[S_MA_STU_X] OverrideSchoolCode OR [S_MA_REN_X] OverrideSchoolCode – It is best to leave blank this field blank. |
|
DOE016 |
Grade Level |
[Students] Grade_Level
|
|
DOE017 |
Days in Attendance |
Auto calculated |
|
DOE018 |
Days in Membership |
Auto calculated |
|
DOE019 |
Low-Income Status |
[S_MA_STU_SIMS_X] LowIncomeStatus |
|
DOE020 |
Title I Participation |
[S_MA_STU_SIMS_X] Title1Participation |
|
DOE021 |
ELL Students in their First Year in U.S. Schools |
[S_MA_STU_Demographic_X] LEP1STYRINUS |
|
DOE022 |
Immigrant Status |
[S_MA_STU_Demographic_X] ImmigrantStatus |
|
DOE023 |
Country of Origin |
[S_MA_STU_Demographic_X] CountryOfOrigin |
|
DOE024 |
First (Native Language) |
[S_MA_STU_Demographic_X] NativeLanguage |
|
DOE025 |
English Language Learner |
[S_MA_STU_Demographic_X] LimitedEnglishProficiency |
|
DOE026 |
English Language Learners Program Status |
[S_MA_STU_Demographic_X] LEPProgramStatus |
|
DOE027 |
Program Code |
[S_MA_STU_SPED_X] AlternativeEducation |
|
DOE028 |
DISCONTINUED |
|
|
DOE029 |
Member of Military Family |
[S_MA_STU_X] MilitaryStatus |
|
DOE030 |
Non-Instructional Title I Targeted Assistance Services |
[S_MA_STU_SIMS_X] NonInstructionalTitle1Services |
|
DOE031 |
Career/Vocational Technical Education (CVTE) — Competency Attainment |
[S_MA_STU_CTE_X] TechnicalCompetencyAttain |
|
DOE032 |
Special Education Placement, ages 3–5 |
[S_MA_STU_SPED_X] SPED3To5Placement |
|
DOE033 |
High School Completer Plans |
[S_MA_STU_X] PostGradPlans |
|
DOE034 |
Special Education Placement, ages 6–21 |
[S_MA_STU_SPED_X] SPED6To21Placement |
|
DOE035 |
Career/Vocational Technical Education — Type of Program |
[S_MA_STU_CTE_X] ProgramType OR
|
|
DOE036 |
Special Education - Nature of Primary Disability |
[S_MA_STU_SPED_X] PrimaryDisability |
|
DOE037 |
Graduate, Completed Massachusetts Core Curriculum |
[S_MA_STU_X] GradCompleteCoreCurriculum |
|
DOE038 |
Special Education - Level of Need |
[S_MA_STU_SPED_X] LevelOfNeed |
|
DOE039 |
504 Plan Status |
[S_MA_STU_SPED_X] SEC504PlanStatus |
|
DOE040 |
Special Education - Evaluation Results |
[S_MA_STU_SPED_X] SPEDEvaluationResults |
|
DOE041 |
English Learner Student with Limited or Interrupted Formal Education (SLIFE) |
[S_MA_STU_SIMS_X] ELL_SLIFE |
|
DOE042 |
Career/Vocational Technical Education — Special Populations |
[S_MA_STU_CTE_X] CTESpecialPopulations |
|
DOE043 |
Career/Vocational Technical Education — Chapter 74–Approved Vocational Technical Education Program Participation |
Auto calculated based on the Special Program enrollments. |
|
DOE044 |
Career/Vocational Technical Education — Non-Chapter 74 Career and Technical Education Program Participation |
Auto calculated based on the Special Program enrollments. |
|
DOE045 |
DISCONTINUED |
|
|
DOE046 |
DISCONTINUED |
|
|
DOE047 |
DISCONTINUED |
|
|
DOE048 |
DISCONTINUED |
|
|
DOE049 |
DISCONTINUED |
|
|
DOE050 |
DISCONTINUED |
|
|
DOE051 |
DISCONTINUED |
|
|
DOE052 |
Unexcused Student Absences |
Auto calculated based on ATN setup. |
|
DOE053 |
Civics Project Completer |
[S_MA_STU_SIMS_X]CivicsProjectCompleter |