eSPED Special Education Records
This report is for the extract required by eSPED for the student's latest special education information (same fields as on the 163 record). This is PowerSchool report TX59.
This report uses the State Reporting Platform format and requires that the All States Reporting Installer be applied as well as the latest PEIMS installer. This report is accessed using System Reports > State Reports and cannot be accessed using a Quick Link to State Reports.
Selection Criteria
Selection criteria determine which database records are used in the report. Any student that has been enrolled in the year being processed is included with their latest special education information if they are currently special ed.
Report Input
Each of the available run options and data fields for the report are described below.
Field | Description |
|---|---|
School Year | Choose the school year for the student enrollment data you want to include on the report. This value is used to determine certain naming conventions within the extract. |
Run Now | Select this option if the user wants to run the report immediately. |
Schedule | Select this option if the user wants to run this report on a scheduled basis. Once this option is selected the following choices are:
|
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.
Filename:
The file must be a comma, delimited file. No specific naming conventions have been required; however, the filename from PowerSchool reflects the County District Number_UserID_DateTime_SPED. If you want to review the data prior to submitting to the vendor, it is recommended that you follow the following steps:
- Open Excel.
- Click on the Data tab and select From Text.
- Navigate to the file that is downloaded from PowerSchool from the report queue, select it and click Import.
- Select Delimited and click Next.
- Select Comma from the delimiters and click Next.
- To prevent changing any of the formatting, make each column Text and click Finish.
- Click OK on the Import Data window.
It is highly recommended that you make any changes in the data and re-extract the file to prevent formatting changes prior to submitting to eSPED.
Detail Record Layout
All fields that are noted must be included.
Item # or Position | Data Element | Description |
|---|---|---|
1 | Student Last Name | Last name of the student |
2 | Student First Name | First name of the student |
3 | PEIMS ID | SSN/State ID number of the student |
4 | Date of Birth (Read-only) | Student Date of Birth |
5 | E0041 | Primary Disability Code (E0041) |
6 | E0834 | Secondary Disability Code (E0834) |
7 | E0835 | Tertiary Disability Code (E0835) |
8 | E0882 | Multiply Disabled Indicator Code (E0882) |
9 | E0832 | Child Count Funding Type Code (E0832) |
10 | E0900 | Early Childhood Intervention Code (E0900) |
11 | E0899 | PPCD Code (E0899) |
12 | E0833 | Regional Day School Program for the Deaf (E0833) |
13 | E0173 | Instructional Setting Code (E0173) |
14 | E0857 | Speech Therapy Indicator (E0857) |
15 | E1040 | Interpreting Services Type (E1040) |
16 | E0838 | Audiological Services Indicator Code (E0838) |
17 | E1077 | PPCD Service Location Code (E1077) |
18 | E0840 | Counseling Services Indicator Code (E0840) |
19 | E0841 | Medical Diagnostic Services Indicator Code (E0841) |
20 | E0843 | Occupational Therapy Indicator Code (E0843) |
21 | E0844 | Orientation/Mobility Training Indicator Code (E0844) |
22 | E0845 | Physical Therapy Indicator Code (E0845) |
23 | E0846 | Psychological Services Indicator Code (E0846) |
24 | E0847 | Recreation Indicator Code (E0847) |
25 | E0848 | School Health Services Indicator Code (E0848) |
26 | E0849 | Social Work Services Indicator Code (E0849) |
27 | E0851 | Transportation Indicator Code (E0851) |
28 | E0997 | Assistive Technology Indicator Code (E0997) |
29 | E0999 | Medically Fragile Indicator Code (E0999) |
30 | E1527 | RDSPD Provider (E1527) |