SASID MSR Extract

Introduction

This report produces a SASID MSR extract file for the State Assigned Student Identifier (SASID) Multiple Student Registration (MSR) System.

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 current school enrollment during the report date range.
The student must be flagged for inclusion in the SASID report.
The student must not be assigned a SASID, if specified when running the report.
The student's school enrollment during the reporting period must be assigned an entry code that matches one entered at report runtime, if specified when running the report.

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 students in the current selection. All students – 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 the 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 rmm-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.
Enter the school number to display in the file header (if left blank, the district number will be extracted)	Enter the school number in this field if submitting a file for a single school only. This will modify the header record to reflect the school number.
Restrict students to those without a SASID.	Select yes or no to further restrict student selection.
Restrict students to those between the specified dates with the following entry codes (comma-delimited list).	Enter the comma-delimited list of entry codes to further restrict student selection.
Date of Birth Format	Select one of the following options: D10 – mm/dd/yyyy D8M – mm/dd/yy D8Y – yy/mm/dd

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.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
DOE001	Locally Assigned Student ID	The Locally Assigned Student Identifier (LASIS) of the student. This field is extracted from the student number on the Demographics page. If a value is entered for the Alphanumeric LASID field (DOE001) on the SIMS Data Elements page, then that value is reported.	[S_MA_STU_X]LocalAssignedStudentID or [Students]Student_Number	Alpha-numeric	32
DOE003	Student First Name	The first name of the student. This field is extracted from the Demographics page. 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. This field is extracted from the Demographics page. If a value is entered on the SIMS Data Elements page (DOE004), that value is reported. 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. This field is extracted from the Demographics page. 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
DOE999	Student Legal Suffix	The student's legal suffix.	[StudentCoreFields]PSCore_Legal_Last_Name	Alpha-numeric	10
DOE006	Student Date of Birth	The date of birth for the student. This field is extracted from the Demographics page.	[Students]DOB	Date	10
DOE008	City/Town of Birth	The city/town of birth for the student. This field is extracted from the SIMS Data Elements page (DOE008).	[S_MA_STU_Demographic_X]BirthCity	Alpha-numeric	50
DOE009	Gender	The gender of the student. This field is extracted from the Demographics page unless box is checked to report a nonbinary gender. 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
DOE014	City/Town of Residence	The city/town of residence for the student. This field is extracted from the Demographics page. If a value is entered on the SIMS Data Elements page (DOE14) then that value is reported.	[S_MA_STU_Demographic_X]CityOfResidence [Students]City (converted to numeric city code)	Alpha-numeric	3

Back to Top