eSPED Demographics
On this page:
Introduction
This report is for the extract required by eSPED for the student demographics. This is PowerSchool report TX58.
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 whether they are special education or not.
The selection criteria for Student Contacts excludes prior contacts where an End Date exists in the StudentContactDetail table.
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_Demo. 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 ID | Local Student Number |
2 | Student SSN | Student SSN/State Number |
3 | TSDS UID | State Unique ID Number |
4 | Student First Name | First name of the student |
5 | Student Last Name | Last name of the student |
6 | Student Generation Code | The description of the generation code |
7 | Student Address 1 | Physical address of the student |
8 | Student City | Physical city of the student |
9 | Student State | Physical state of the student |
10 | Student Zip Code | Physical zip code of the student |
11 | Student Address 1 Mail | Mailing address of the student |
12 | Student City Mail | Mailing city of the student |
13 | Student State Mail | Mailing state of the student |
14 | Student Zip Code Mail | Mailing zip code of the student |
15 | Student Home Phone | Student Home Phone |
16 | Student Date of Birth | Student Date of Birth |
17 | Student Ethnicity | Hispanic/Latino Code |
18 | Race Am Indian | 1 if the student is coded as American Indian |
19 | Race Asian | 1 if the student is coded as Asian |
20 | Race Black | 1 if the student is coded as Black |
21 | Race Native Hawaiian | 1 if the student is coded as Native Hawaiian |
22 | Race White | 1 if the student is coded as White |
23 | Student Home Language | Code for home language Note: If language entry is blank, this field is reported as 98. |
24 | School of Enrollment Code | County District Campus Number |
25 | School of Enrollment Name | Name of the school |
26 | Campus of Residence Code | County District Campus of enrolled school |
27 | Campus of Residence Name | Name of school of enrollment |
28 | Student Grade Level | Current grade level |
29 | Student Gender | Gender |
30 | Immigrant | Yes/No |
31 | Gifted | Yes/No |
32 | CATE | Yes/No |
33 | Migrant | Yes/No |
34 | Title 1 | Yes/No |
35 | Economic Disadvantaged | Code |
36 | ESL/Bilingual | Yes/No |
37 | Contact 1 Relationship | Father |
38 | Contact 1 Last Name | Father Last Name |
39 | Contact 1 First Name | Father First Name |
40 | Contact 1 Address 1 | Student's Physical Address |
41 | Contact 1 City | Student's City |
42 | Contact 1 State | Student's State |
43 | Contact 1 Zip | Student's Zip |
44 | Contact 1 Home Phone | Father's Home Phone |
45 | Contact 1 Work Phone | Father Day Phone |
46 | Contact 1 Occupation | Father Employer |
47 | Contact 2 Relationship | Mother |
48 | Contact 2 Last Name | Mother Last Name |
49 | Contact 2 First Name | Mother First Name |
50 | Contact 2 Address 1 | Student's Physical Address |
51 | Contact 2 City | Student's City |
52 | Contact 2 State | Student's State |
53 | Contact 2 Zip | Student's Zip |
54 | Contact 2 Home Phone | Mother's Home Phone |
55 | Contact 2 Work Phone | Mother Day Phone |
56 | Contact 2 Occupation | Mother Employer |
57 | 504 Indicator | Yes/No |
58 | EB | EB Status Code |
59 | EB Parental Permission | Code |
60 | At Risk | Yes/No |
61 | Withdrawal Reason | Description |
62 | Withdrawal Code | Exit Code |
63 | Withdrawal Date | Date |
64 | District Code | County District Code |
65 | Special Education Indicator | Yes/No based on Instructional Setting |
66 | Enrollment Date | Latest Enrollment Date |
67 | Language the Student Speaks | The language the student speaks Note: If language entry is blank, this field is reported as 98. |