SIMS Student Data Update Report

Introduction

Use the SIMS Student Data Update Report to populate the state fields needed for the SIF agent that produces the Student Information Management System (SIMS) Data Collection Extract.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] table based on the following criteria:

The student must not be excluded from state reporting.
The student must have a school enrollment during the report data range.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for records in the current selection. All records – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05.
Start Date	Enter the report start date.
End Date	Enter the report end date.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Each blank field in the student’s record is populated with the default value listed in the Description column.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
DOE011	Reason for Reporting	The reason for reporting student data. This value is reported from the SIMS Data Element page. The default value is 01.	[S_MA_STU_X]ReasonForReporting	Numeric	2
DOE012	Enrollment Status at Time of Data Collection	The student’s enrollment status at the time of the data collection. This value is reported from the SIMS Data Element page. The default value is 01.	[S_MA_STU_X]EnrollStatusTimeOfCollection	Numeric	2
DOE013	Reason for Enrollment	The student’s reason for enrollment. This value is reported from the SIMS Data Element page. The default value is 01.	[S_MA_STU_X]ReasonForEnrollment	Numeric	2
DOE015	School Identification Number	The school identification number for the student. If the value is not populated on the SIMS Data Element page, then the District Number and Alternate School Number values are populated. If the Alternate School Number is blank, then the student’s School ID is reported.	[S_MA_STU_X]OverrideSchoolCode or [Prefs]Value where [Prefs]Name =districtnumber + [Schools]Alternate_School_Number or [Students]SchoolID	Alpha numeric	8
DOE016	Grade Level	The student’s grade level for their current enrollment. If the Part-Time Student Indicator is selected on the SIMS Data Elements page, KP is reported. If the Full-Time Kindergarten Tuition Payer is selected on the SIMS Data Elements page, KT is extracted. The Part-time Student default value is 0. The Tuition Payer default value is 0.	[Students]Grade_Level or [ReEnrollments]Grade_Level or [Students]parttimestudent or [Students]tuitionpayer	Alpha-Numeric	2
DOE019	Low Income Status	The student’s low income status. The default value is 00.	[S_MA_STU_SIMS_X]LowIncomeStatus	Alpha-Numeric	2
DOE020	Title I Participation	The student’s Title I participation status. The default value is 00.	[S_MA_STU_SIMS_X]Title1Participation	Alpha-Numeric	2
DOE021	LEP Students in their first year in U.S. Schools	The student’s LEP (recently arrived to U.S. schools) status. The default value is 00.	[S_MA_STU_Demographic_X]LEP1stYrInUS	Alpha-Numeric	2
DOE022	Immigrant Status	The student’s immigrant status. The default value is 00.	[S_MA_STU_Demographic_X] ImmigrantStatus	Alpha-Numeric	2
DOE023	Country of Origin	The student’s country of origin. The default value is 500.	[S_MA_STU_Demographic_X] CountryOfOrigin	Alpha-Numeric	3
DOE024	First Native Language	The student’s first native language. The default value is 267.	[S_MA_STU_Demographic_X] NativeLanguage	Alpha-Numeric	3
DOE025	Limited English Proficiency	The student’s LEP status. The default value is 00.	[S_MA_STU_Demographic_X] LimitedEnglishProficiency	Alpha-Numeric	2
DOE026	English Language Learners Program Status	The student’s ELL program status. The default value is 00.	[S_MA_STU_Demographic_X] LEPProgramStatus	Alpha-Numeric	2
DOE027	Alternative Education Program	The student’s AEP status. The default value is 00000000.	[S_MA_STU_SPED_X]AlternativeEducation	Alpha-Numeric	8
DOE028	Title I School Choice	The student’s Title I school choice status. The default value is 00.	[S_MA_STU_SIMS_X]Title1SchoolChoice	Alpha-Numeric	2
DOE031	Career & Technical Education – Technical Competency Attainment	The student’s career & technical education – technical competency attainment status. The default value is 500.	[S_MA_STU_CTE_X] TechnicalCompetencyAttain	Alpha-Numeric	3
DOE032	Special Education Placement-Ages 3-5	The student’s special education placement (for students ages 3 through 5). The default value is 00.	[S_MA_STU_SPED_X]SPED3to5Placement	Alpha-Numeric	2
DOE033	Post-Graduate	The student’s post-graduate plans. The default value is 500.	[S_MA_STU_X]PostGradPlans	Alpha-Numeric	3
DOE034	Special Education Placement-Ages 6-21	The student’s special education placement status (for students ages 6 through 21). The default value is 00.	[S_MA_STU_SPED_X]SPED6to21Placement	Alpha-Numeric	2
DOE035	Career & Technical Education - Type of Program	The student’s career and technical education program. The default value is 500.	[S_MA_STU_CTE_X]ProgramType	Alpha-Numeric	3
DOE036	Special Education-Nature of Primary Disability	The student’s primary disability. The default value is 500.	[S_MA_STU_SPED_X]PrimaryDisability	Alpha-Numeric	3
DOE037	Graduate, completed Mass Core Curriculum	The student’s graduate status. The default value is 00.	[S_MA_STU_X] GradCompleteCoreCurriculum	Alpha-Numeric	2
DOE038	Special Education – Level of Need	The student’s special education level of need. The default value is 500.	[S_MA_STU_SPED_X]LevelOfNeed	Alpha-Numeric	3
DOE040	Special Education Evaluation Results	The student’s special education evaluation results. The default value is 00.	[S_MA_STU_SPED_X] SPEDEvaluationResults	Alpha-Numeric	2
DOE042	Career & Technical Education-Special Populations	The student’s special population status. The default value is 500.	[S_MA_STU_CTE_X]CTESpecialPopulations	Alpha-Numeric	3
DOE043	Career & Technical Education-Chapter 74 Participation	The program code for a Chapter 74 vocational program for career and technical students. The student must be enrolled in a special program that is marked as “This is a Chapter 74 program” at the district level. Set to 500 if the student is not enrolled in a Chapter 74 program.	[S_MA_STU_CTE_X] CTEChapter74Participation derived from [S_MA_GEN_SP_X]Chap74ProgramInd and [S_MA_GEN_SP_X]Chap74ProgramCode	Alpha-Numeric	6
DOE044	Career & Technical Education- Non-Chapter 74 Participation	The program code for a Non-Chapter 74 vocational program for career and technical students. The student must be enrolled in a special program that is marked as “This is a Non-Chapter 74 Program” at the district level. Set to 500 if the student is not enrolled in a Non-Chapter 74 program.	[S_MA_STU_CTE_X] CTENonChapter74Participation derived from [S_MA_GEN_SP_X]NonChap74ProgramInd and [S_MA_GEN_SP_X]NonChap74ProgramCode	Alpha-Numeric	4
DOE052	Student Truancy	The number of truancies assigned to the student during the reporting period.	[Truancies]HowMany [S_MA_STU_SIMS_X]UnexcusedAbsences	Numeric	N/A
DOE010	Race/Ethnicity	The student’s ethnicity. This field is calculated based on the Federal race/ethnicity codes assigned to the student on the Demographics page.	[S_MA_STU_Demographic_X] EthnicityRaceCode	Numeric	N/A

Back to Top