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