Special Education Snapshot Extract | PowerSchool SIS Compliance

Contents

Introduction

The Special Education Snapshot extract is used to track students with verified disabilities. The extract is generated in a comma-delimited format.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The Special Education Fact extract includes student records from the [Students] table that meet the following criteria:

Students who are not excluded from state reporting.
Students who are enrolled in a school not excluded from state reporting.
Students whose school enrollment Exit Date is after the current date.
Students whose school enrollment Entry Date is on or before the current date.
Students whose school enrollment Exit Date is after the Entry Date.
Students with a verified disability.

Report Input

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

Field	Description
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
Select Schools	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. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Notes: If your district uses Sub-District functionality, see Report Input for Sub-District Functionality. The All Schools option is only available when running the report from the District Office.
Reporting Period	Select one of the following: Fall Monthly/EOY
Data Report will be Run	Enter the snapshot date for the report based on the type of submission. For example, 10/01/yyyy for Fall submission and 6/30/yyyy for EOY submission.

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.

Element #	Data Element	Description	[Table]FieldName
1	District Code	NDE Number for the district.	[Prefs]Name=districtnumber [Prefs]Value
2	Location Code	The alternate school number is extracted, if populated on the Edit School page. Otherwise, the school number is extracted.	[Schools]Alternate_School_Number [Schools]School_Number [Students]SchoolID=[Schools]School_Number [ReEnrollments]SchoolID=[Schools]School_Number
3	School Year	This value is automatically extracted as June 30^th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms.	[Terms]LastDay
4	Social Security Number	Not collected.	N/A
5	Student ID	State issued identification number.	[Students]State_StudentNumber
6	Last Name Short	Not collected.	N/A
7	First Name Short	Not collected.	N/A
8	Middle Initial	Not collected.	N/A
9	Current Grade Level	Not collected.	N/A
10	Special Education Teacher Name	Not collected.	N/A
11	Primary Disability	See Primary Disability Codes for valid values.	[S_NE_STU_SPED_X]Primary_Disability
12	Secondary Disability	Not collected.	N/A
13	Last IEP Date	Not collected.	N/A
14	Last Evaluation Date	Not collected.	N/A
15	Service Level	Not collected.	N/A
16	Related Services	See Related Service Codes for valid values.	[S_NE_STU_SPED_X]Related_Services
17	Services Provided	Not collected.	N/A
18	Special Education Teacher ID	Not collected.	N/A
19	Annual Review Date	Not collected.	N/A
20	Triennial Review Date	Not collected.	N/A
21	Expected Diploma Type	Not collected.	N/A
22	2^nd Language Exempt	Not collected.	N/A
23	Alternate Assessment	Not collected.	N/A
24	Instruction Language	Not collected.	N/A
25	Communication Mode	Not collected.	N/A
26	Braille Instruction	Not collected.	N/A
27	Special Transportation	Not collected.	N/A
28	Extended School Year	Not collected.	N/A
29	Home Schooled	Not collected.	N/A
30	Programs Code	Not collected.	N/A
31	Primary Service Code	Not collected.	N/A
32	Primary Placement Type	Valid values: 0 – Not applicable 1 – Nonpublic Placement	[S_NE_STU_SPED_X]Primary_Placement_Type
33	Special Ed Entry Date	This value is extracted using the format YYYY-MM-DD.	[S_NE_STU_SPED_X]Sped_Entry_Reason
34	Special Ed Exit Date	This value is extracted using the format YYYY-MM-DD.	[S_NE_STU_SPED_X]Sped_Exit_Date
35	Snapshot Date	This value is extracted in the format YYYY-MM-DD.	N/A
36	IEP Compliance	Not collected.	N/A
37	Funding Primary Disability Code	Not collected.	N/A
38	Disability Primary Cause Code	Not collected.	N/A
39	Living Setting Code	Not collected.	N/A
40	Hearing Impairment Level Code	Not collected.	N/A
41	Vision Impairment Level Code	Not collected.	N/A
42	Tertiary Disability Code	Not collected.	N/A
43	Quaternary Disability Code	Not collected.	N/A
44	Primary Setting Code	See Primary Setting Codes for valid values.	[S_NE_STU_SPED_X]Sped_Inst_Setting
45	Transition Status Code	Not collected.	N/A
46	Primary Service Provider	Not collected.	N/A
47	School Aged Indicator	Y – Yes N – No This is the only field in the Nebraska Student and Staff Record System (NSSRS) that uses Y (Yes) and N (No).	[S_NE_STU_SPED_X]School_Aged
	Filler
50	Program Special Ed Percentage	This value is extracted as an integer. For example, 25% is extracted as 25.	[S_NE_STU_SPED_X]Prog_Sped_Percent
51	Filler
52	Primary Exit Reason Code	See Primary Exit Reason Codes for valid values.	[S_NE_STU_SPED_X]Sped_Exit_Reason