SIMS Data Collection

Use

Choose one of the following:

• Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
• District Wide – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The District Wide option is only available when running the report from the District Office.

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.

Report Start Date

Enter the report start date.

Report End Date

Enter the report end date.

4-digit District Code and 4-digit School Code

Enter the district code and/or school code for the extract file name.

Restrict students to those flagged for inclusion in the SIMS Report

Choose No or Yes from the pop-up menu to indicate whether to only include students flagged for inclusion in the SIMS report.

Exclude students without a SASID

Choose Yes or No from the pop-up menu to indicate whether to exclude students without a SASID.

Special Education Students to Include

Select one of the following from the pop-up menu:

• Non-SPED & SPED Students
• Non-SPED Students Only
• SPED Students Only

Date of Birth Format

Select one of the following options:

• D10 – mm/dd/yyyy
• D8M – mm/dd/yy
• D8Y – yy/mm/dd

DOE001

Locally Assigned Student ID

The locally assigned student ID. If a value is entered on the SIMS Data Elements page (DOE001), then that value is reported, otherwise, the value is extracted from the Demographics page.

[S_MA_STU_X]LocalAssignedStudentID

or

[Students]Student_Number

Alpha-Numeric

32

DOE002

State Assigned Student Identifier

The state assigned student ID. If a value is entered on the SIMS Data Elements page (DOE002), then that value is reported, otherwise, the value is extracted from the Demographics page.

[Students]State_StudentNumber

Alpha-Numeric

10

DOE003

Student First Name

The first name of the student.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_First_Name

[Students]First_Name

Alpha-Numeric

32

DOE004

Student Middle Name

The middle name of the student. If a value is entered on the SIMS Data Elements page (DOE004), that value is reported, otherwise, the value is extracted from the Demographics page.

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Middle_Name

[S_MA_STU_Demographic_X]LongMiddleName

[Students]Middle_Name

Alpha-Numeric

32

DOE005

Student Last Name

The last name of the student

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Last_Name 

[Students]Last_Name

Alpha-Numeric

50

DOE006

Student Date of Birth

The date of birth for the student. Extracted from the Demographics page.

[Students]DOB

Date

10

DOE007

Date of Birth Format

The date of birth format, as selected when running the report.

Entered as a report parameter at report runtime.

Alpha-Numeric

3

DOE008

City/Town of Birth

The city/town of birth for the student. Extracted from the SIMS Data Elements page (DOE008).

[S_MA_STU_Demographic_X]BirthCity

Alpha-Numeric

50

DOE009

Gender

The gender of the student. Extracted from the Demographics page unless box is checked to report a nonbinary gender, in which case the field will pull the value N.

Note: If populated, the student's legal gender overrides the student's preferred gender.

[StudentCoreFields]PSCore_Legal_Gender

[Students]Gender

[S_MA_STU_Demographic_X]NonBinary_Gender_TF

Alpha-Numeric

1

DOE010

Race/Ethnicity

The student’s ethnicity. This field is calculated by concatenating the following fields from the Demographics page, Start Page > Student > Demographics:

• Ethnicity
• Race

[StudentRace]FedEthnicity

and

[StudentRace]RaceCd

Numeric

N/A

DOE011

Reason for Reporting

The reason for reporting code. Extracted from the SIMS Data Elements (DOE011) page.

[S_MA_STU_X]ReasonForReporting

Alpha-Numeric

2

DOE012

Enrollment Status at Time of Data Collection

The student’s enrollment status at the time of data collection. Extracted from the SIMS Data Elements (DOE012) page.

[S_MA_STU_X]EnrollStatusTimeOfCollection

Alpha-Numeric

2

DOE013

Reason for Enrollment

The reason for enrollment code. Extracted from the SIMS Data Elements page.

[S_MA_STU_X]ReasonForEnrollment

Alpha-Numeric

2

DOE014

City/Town of Residence

The student’s city/town of residence. If a value is entered on the SIMS Data Elements page (DOE014), then that value is reported, otherwise, the value is reported from the Demographics page.

[S_MA_STU_Demographic_X]CityOfResidence

[Students]City (converted to numeric city code)

Alpha-Numeric

3

DOE015

School Identification Number

The school identification number. Extracted from the School ID number entered on the SIMS Data Elements page. If that is blank, the District Number and School Number are 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.

[Students]Grade_Level or [ReEnrollments]Grade_Level

or

[Students]parttimestudent or [Students]tuitionpayer

Alpha-Numeric

2

DOE017

Days in Attendance

The number of days the student was present at the school during the reporting period.

Logic:

• If the Attendance field on the SAS tab is populated with an attendance value and the student is not a summer school graduate, dropout, or transfer, then the Days in Attendance value is a sum of all enrollment records for the active enrollment between report start date and report end date. If the student is a summer school graduate, dropout, or transfer, the SIMS report extracts 555.
• If the Attendance field on the SAS tab is blank, the SIMS report extracts attendance values for the enrolled student based on ADA/ADM.
• If the student is a summer school graduate, dropout, or transfer, the SIMS report extracts 555.

Note: Days in attendance is reported as a whole number only on the report. If the calculated value includes a partial day of .499 or below, the value is rounded down to the nearest whole day, and values of .500 or above are rounded up to the nearest whole day.

Sum of [StudentAttendanceSummary]DaysAttended

Or

[Att_AdaAdm_Defaults_All]DaysAttended

Or

Set to 555 if any of the following = 1 (Yes)
[S_MA_STU_X]SummerDropOut
[S_MA_REN_X]SummerDropOut or

[S_MA_STU_X]SummerGraduate
[S_MA_REN_X]SummerGraduate or

[S_MA_STU_X]SummerTransfer
[S_MA_REN_X]SummerTransfer

Numeric

3

DOE018

Days in Membership

The number of days the student is enrolled in the school during the reporting period.

Logic:

• If the Membership field on the SAS tab is populated with a membership value and the student is not a summer school graduate, dropout, or transfer, then the Days in Membership value is a sum of all enrollment records for the active enrollment between report start date and report end date.
• If the Membership field on the SAS tab is blank, the SIMS report extracts membership values for the enrolled student based on ADA/ADM.
• If the student is a summer school graduate, dropout, or transfer, the SIMS report extracts 555.
  
  
  

Sum of [StudentAttendanceSummary]MembershipValue

Or

[Att_AdaAdm_Defaults_All]MembershipValue

Or

Set to 555 if any of the following = 1 (Yes)
[S_MA_STU_X]SummerDropOut
[S_MA_REN_X]SummerDropOut or

[S_MA_STU_X]SummerGraduate
[S_MA_REN_X]SummerGraduate or

[S_MA_STU_X]SummerTransfer
[S_MA_REN_X]SummerTransfer

Numeric

3

DOE019

Low Income Status

The low-income status for the student. Extracted from the SIMS Data Elements page (DOE019).

[S_MA_STU_SIMS_X]LowIncomeStatus

Alpha-Numeric

2

DOE020

Title I Participation

The Title I participation status for the student. Extracted from the SIMS Data Elements (DOE020) page.

[S_MA_STU_SIMS_X]Title1Participation

Alpha-Numeric

2

DOE021

LEP Students, in their first year in U.S. Schools

The “LEP Students recently arrived to US schools” status. Extracted from the SIMS Data Elements (DOE021) page.

[S_MA_STU_Demographic_X]LEP1stYrInUS

Alpha-Numeric

2

DOE022

Immigrant Status

The immigrant status for the student. Extracted from the SIMS Data Elements (DOE022) page.

[S_MA_STU_Demographic_X]ImmigrantStatus

Alpha-Numeric

2

DOE023

Country of Origin

The Country of Origin for the student. Extracted from the SIMS Data Elements (DOE023) page.

[S_MA_STU_Demographic_X]CountryOfOrigin

Alpha-Numeric

3

DOE024

First Native Language

The First Native Language for the student. Extracted from the SIMS Data Elements (DOE024) page.

NCES Codes

Alpha-Numeric

3

DOE025

Limited English Proficiency

The Limited English Proficiency status for the student. Extracted from the SIMS Data Elements (DOE025) page.

[S_MA_STU_Demographic_X]LimitedEnglishProficiency

Alpha-Numeric

2

DOE026

English Language Learners Program Status

The English Language Learners Program status for the student. Extracted from the SIMS Data Elements (DOE026) page.

[S_MA_STU_Demographic_X]LEPProgramStatus

Alpha-Numeric

2

DOE027

Alternative Education Program

The eight digit Alternative Education location code for the school that the student is enrolled in. Extracted from the SIMS Data Elements (DOE027) page.

[S_MA_STU_SPED_X]AlternativeEducation

Alpha-Numeric

8

DOE028

Seal of Biliteracy

Indicates whether the student earned the State Seal of Biliteracy. Extracted from the SIMS Data Elements (DOE028) page.

If field value is:

• 0 - extracted as 00
• 1 - extracted as 01
• 2 - extracted as 02
• blank - extracted as 00
  

[S_STU_NCEA_X]SealofBiliteracy

Alpha-Numeric

1

DOE029

Military Family

The student’s status as a member of a military family. Extracted from the SIMS Data Elements (DOE029) Page.

[S_MA_STU_X]MilitaryStatus

Alpha-Numeric

2

DOE030

Non-Instructional Title I Targeted Assistance Services

Identifies students receiving targeted Title I assistance services that are non-instructional. Extracted from the SIMS Data Elements (DOE030) Page.

[S_MA_STU_SIMS_X]NonInstructionalTitle1Services

Alpha-Numeric

2

DOE031

Career & Technical Education - Competency Attainment

The Career & Technical Education status for the student. Extracted from the SIMS Data Elements (DOE031) page.

[S_MA_STU_CTE_X]TechnicalCompetencyAttain

Alpha-Numeric

3

DOE032

Special Education Placement-Ages 3-5

The Special Education Placement status for the students, ages 3 thru 5. Extracted from the SIMS Data Elements (DOE032) page.

[S_MA_STU_SPED_X]SPED3to5Placement

Alpha-Numeric

2

DOE033

High School Completer Plans

The Post Graduate Plan for the student. Extracted from the SIMS Data Elements (DOE033) page.

[S_MA_STU_X]PostGradPlans

Alpha-Numeric

3

DOE034

Special Education Placement-Ages 6-21

The Special Education Placement status for the students, ages 6 through 21. Extracted from the SIMS Data Elements (DOE034) page.

[S_MA_STU_SPED_X]SPED6to21Placement

Alpha-Numeric

2

DOE035

Career & Technical Education-Type of Program

The type of Career & Technical program the student is enrolled in. Extracted from the SIMS Data Elements (DOE035) page.

[S_MA_STU_CTE_X]ProgramType

Alpha-Numeric

3

DOE036

Special Education-Nature of Disability

The nature of the special education disability for the student. Extracted from the SIMS Data Elements (DOE036) page.

[S_MA_STU_SPED_X]PrimaryDisability

Alpha-Numeric

3

DOE037

Graduate completed Mass Core Curriculum

The status of the graduate student. Extracted from the SIMS Data Elements (DOE037) page.

[S_MA_STU_X]GradCompleteCoreCurriculum

Alpha-Numeric

2

DOE038

Special Education Level of Need

The level of need for special education students. Extracted from the SIMS Data Elements (DOE038) page.

[S_MA_STU_SPED_X]LevelOfNeed

Alpha-Numeric

3

DOE039

504 Plan Status

An indication of whether or not a student was in a 504 plan at any point during the school year. Extracted from the SIMS Data Elements (DOE039) page

[S_MA_STU_SPED_X]Sec504PlanStatus

Alpha-Numeric

2

DOE040

Special Education Evaluation Results

The special education evaluation results for the student. Extracted from the SIMS Data Elements (DOE040) page.

[S_MA_STU_SPED_X]SPEDEvaluationResults

Alpha-Numeric

2

DOE041

ELL SLIFE

An indication of whether or not a student is an English Language Learner Student with Limited or Interrupted Formal Education.

[S_MA_STU_SIMS_X]ELL_SLIFE

 [S_MA_REN_SIMS_X]ELL_SLIFE

Alpha-Numeric

2

DOE042

Career & Technical Education - Special Populations

The career & technical education – special populations status for career and technical education students. Extracted from the SIMS Data Elements (DOE042) page.

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

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

[S_MA_STU_CTE_X]CTENonChapter74Participation derived from [S_MA_GEN_SP_X]NonChap74ProgramInd

and

[S_MA_GEN_SP_X]NonChap74ProgramCode

Alpha-Numeric

4

DOE045

[S_MA_STU_SIMS_X]HighQualCarPathwaysProgTyp

Alpha-Numeric

2

DOE046

High Quality Career Pathways Program Participation

The type of industry in which the student works through this career pathway program. Extracted from the SIMS Data Elements (DOE046) page.

For valid values, see the Appendix.

Note: The "Value too Large for column” error will no longer be generated as the report is updated to include students that have a DOE046 value of 4 digits.

[S_MA_STU_SIMS_X]HighQualCarPathwaysProgPart

[S_MA_REN_SIMS_X]HighQualCarPathwaysProgPart

Alpha-Numeric

2

DOE047

The industry-recognized credential that the student earned. Extracted from the SIMS Data Elements (DOE047) page.

For valid values, see the Appendix.

[S_MA_STU_SIMS_X]IndustryRecogCred1

[S_MA_REN_SIMS_X]IndustryRecogCred1

Alpha-Numeric

3

DOE048

The second industry-recognized credential  that the student earned. Extracted from the SIMS Data Elements (DOE048) page.

For valid values, see the Appendix.

[S_MA_STU_SIMS_X]IndustryRecogCred2

[S_MA_REN_SIMS_X]IndustryRecogCred2

Alpha-Numeric

3

DOE049

Industry Recognized Credentials

The third industry-recognized credential  that the student earned. Extracted from the SIMS Data Elements (DOE049) page.

For valid values, see the Appendix.

[S_MA_STU_SIMS_X]IndustryRecogCred3

[S_MA_REN_SIMS_X]IndustryRecogCred3

Alpha-Numeric

3

DOE050

[S_MA_STU_SIMS_X]EarlyChildhoodExperience

[S_MA_REN_SIMS_X]EarlyChildhoodExperience

Alpha-Numeric

3

DOE051

The student's zip code from the SIMS Tab > Zip Code Override field, if populated; otherwise, extracted from the student's home address zip code.

[S_MA_STU_SIMS_X]ZipOverride

[Students]Zip

DOE052

Student Truancy

The number of truancies for the student.

Calculated from attendance tracking notification.

[S_MA_STU_SIMS_X]UnexcusedAbsences

Alpha-Numeric

3