Eduphoria

The Eduphoria Report provides the four extracts that are needed to send data from PowerSchool to Eduphoria. (TX70)

Selection Criteria

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

Student Selection

All students who have been enrolled in the selected schools during the selected school year are included.

Report Input

Follow the list of steps to locate and generate the report.

On the Start Page, click State Reports. The Reports page appears.
Click Eduphoria. The Eduphoria report page appears.
Enter information in all of the required fields. For LEAs that have multiple schools in PowerSchool that report to the state as one school (use of the Alternate School Number), there is an option to report these as separate schools for Eduphoria (School Number) or report them as one school (Alternate School Number CDC).
Click Submit to generate the report.

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: Eduphoria.zip

The zip file contains four comma, delimited files.

Detail Record Layout EPCRS.csv

All fields that are noted must be included. This is the list of the courses and sections.

Item # or Position	Data Element	Description
1	SSN of Teacher	SSN of Teacher
2	Course Title	Course Title
3	Course Number	Course Number
4	Section Number	Section Number
5	Term	Term as reported as 1 and 2
6	Period	Period that the class meets
7	Campus Number	School Number
8	School Year	Year value for the fall part of the school year (i.e. 2016 for 16-17 school year)
9	Term Type	Set to 0

Detail Record Layout EPSCH.csv

All fields that are noted must be included. This is the list of the students and their enrolled courses.

Item # or Position	Data Element	Description
1	Student ID	Student Number
2	Course Number	Course Number
3	Section Number	Section Number
4	Term	Term as reported as 1 and 2
5	Campus Number	School Number
6	Term Type	Year value for the fall part of the school year (i.e. 2016 for 16-17 school year)

Detail Record Layout EPSTU.csv

All fields that are noted must be included. This is the roster of the students and their special programs.

Item # or Position	Data Element
1	Student ID	Student Number
2	Student SSN	Student SSN
3	Student First Name	Student First Name
4	Student Middle Name	Student Middle Name
5	Student Last Name	Student Last Name
6	Student Suffix	Generation Code Value
7	Gender	Gender
8	Race	Race
9	Date of Birth	Date of Birth
10	Grade	Grade
11	Campus Number	School Number
12	Advisor SSN	Left blank
13	Special Education	Identifies if the student is currently special education
14	GT	Identifies if the student is currently gifted and talented
15	Section 504	Left blank
16	At Risk	Identifies if the student is currently at risk.
17	Bilingual	Identifies if the student is currently bilingual.
18	ESL	Identifies if the student is currently ESL.
19	Career Tech	Identifies if the student is currently Career Tech.
20	Title I	Identifies if the student is currently Title I
21	LEP	Identifies if the student is currently LEP.
22	Economic Disadvantage	Identifies if the student is currently economically disadvantaged.
23	RTI Status	Left blank.
24	Ethnicity	Identifies if the student is Hispanic/Latino or not.

Detail Record Layout EPTCH.csv

All fields that are noted must be included. This is the list of the teachers.

Item # or Position	Data Element
1	SSN of the teacher	SSN of the teacher
2	SSN of the teacher	SSN of the teacher
3	First Name	First Name
4	Last Name	Last Name