Texas Reports in PowerSchool
The following reports are included in Texas reporting.
The report description table includes the following elements:
- Report Name – Name of the report as seen in PowerSchool.
- Description – The purpose of the report.
- Due Date / Cycle – The timeframe during which the report is submitted to the state.
Report Name | Description | Due Date / Cycle |
| State Reports | ||
Use this report to generate the state transcript at either the district or school level. (TX16) | On-demand | |
Use this report to generate the state transcript at either the district or school level for up to 10 students, or for a selected grade level. (TX16) Note: This report is the same as the AAR except for the ability to run by student numbers, or by grade level. | On-demand | |
This report is used to create the staff responsibility records for the Fall Collection. It can also be used to print a report of all records for the selected school year. (TX74) | On-demand PEIMS Fall Submission | |
Use this report for a listing of students for the campus summary at either the district or school level. (TX23) | Monthly | |
Use this extract to submit student data to the Texas Record Exchange at either the district or school level. (TX24) | Each six week report period | |
Use this extract to submit student data to the Texas Record Exchange at either the district or school level for up to ten students. (TX24) Note: This report is the same as the TREx Extract except for the ability to run by student numbers. | Each six week report period | |
| Withdrawal Form | Withdrawal form used by many Texas schools to send with a student at the time of withdrawal from their current school. | On-demand |
| Unique ID Extracts | ||
This report is used to create an extract of any current staff that has a blank State Prior ID. The extract is sent to the state to have a unique staff identifier assigned. Quick Import is used when the file is returned to the district from the state to populate the field within PowerSchool. (TX35) | On-demand | |
This report is used to create an extract of any student that has a blank Unique Student Identifier. The extract is sent to the state to have a unique student identifier assigned. Quick Import is used when the file is returned to the district from the state to populate the field within PowerSchool. (TX34) | On-demand | |
| Unique ID Enrollment Event Tracking | Each school district submits the Unique ID with Enrollment Events batch file to the state TSDS system on a weekly basis. The Unique ID Enrollment Event Tracking reports new and updated student enrollment and withdrawal records, and grade level assignments. This extract replaces the previous PET (Pupil Enrollment Tracking) Extract and integrates enrollment tracking with the TSDS Unique ID system. | Weekly |
| TSDS PEIMS Interchanges | ||
The interchange schema for Education Organization can be used to exchange organizational information about a state’s education agencies, from campus to Local Education Agency to Education Service Center to State Education Agency. In addition, the interchange (optionally) supports the definition of the educational offerings provided by campuses, specifically the courses taught, the sections in each course offered and the class period and location of those sections, and the alternative/supplemental programs offered. (TX39) | PEIMS Fall,Summer, and Extended Year Submissions | |
The interchange schema for Education Organization Calendar information is used to exchange LEA-wide or campus-specific school calendars that define the instructional, in-service, holidays, weather days, etc. (TX40) | PEIMS Summer Sumbission | |
The interchange schema for Finance information is used to exchange financial data such as actual, budget and shared services arrangement actual. (TX62) | PEIMS Fall Sumbission | |
The interchange schema for the Master Schedule is for education organization’s education course offerings schedule. (TX42) | PEIMS Summer Sumbission | |
The interchange schema for Shared Services Arrangement is used to exchange the education organization to which another education organization (fiscal agent) provides services. (TX41) | PEIMS Fall Submission | |
The interchange schema for Staff Association information can be used to exchange a wide variety of personnel, demographic, employment, assignment, teaching, and attendance information about the staff of education organizations. PowerSchool currently only extracts the Teacher Section Association. The rest of the information should be collected in a human resource program. (TX45) | PEIMS Fall and Summer Submissions | |
The interchange schema for Student information can be used when only student identification, characteristic, and demographic information is required to be exchanged. The Student information includes identifiers, name, sex, ethnicity and race, birth data, and contact information. In addition, flags are included for economically disadvantaged, school food service eligibility, and limited English proficiency. Information is included regarding the student’s home situation, language(s), displacement status, and disabilities (TX57) | PEIMS Fall, Summer, and Extended Year Submissions | |
The interchange schema for Student Attendance information can be used to exchange daily attendance or class-level attendance. The interchange schema can be used in cases where just absences are reported, or where both attendance and absences are reported. (TX48) | PEIMS Summer Submission | |
The interchange schema for Student Discipline can be used to exchange discipline and discipline actions. The exchange may be used to exchange student discipline data for student records or longitudinal analysis or used to exchange anonymous discipline data. (TX47) | PEIMS Summer Submission | |
The interchange schema for Student Enrollment information can be used to exchange campus enrollments and/or enrollments in specific class sections. (TX44) | PEIMS Fall, Summer, and Extended Year Submissions | |
The interchange schema for Student Program information can be used to exchange students’ participation in programs. The interchange includes extensions for Bilingual, English as a Second language (ESL), Extended Year Services (ESY), Special Education, Career and Technical Education (CTE), Supplemental Services, and Title I Part A programs. This exchange is used for both TSDS and PEIMS. (TX55) | PEIMS Fall, Summer, and Extended Year Submissions | |
The interchange schema for Student Restraint is used to exchange the student restraint events. (TX57) | PEIMS Summer Submission | |
| TX Interchange Student Transcript | The interchange schema for Student Transcript information can be used to exchange a wide range of grade information. The schema can be used to exchange a complete academic record, select transcript information or graduation associated with a student. (TX56) | PEIMS Summer and Extended Year Submissions |
| ECDS Interchanges | ||
TX Interchange Student Assessment | The interchange schema for Student Assessment information is used to exchange information about the assessments taken by students, including the assessment, grade level, administration date, and score result. This interchange is used in the TSDS Early Childhood Data System (ECDS) Collection. | ECDS Submission |
This interchange includes information for any school not excluded from state reporting. It is the interchange schema for Student-Parent information including the student demographic information and student identifiers. The parent information captures the relationship between the student and the parent as well as flags for which parent is the primary contact. (TX43) | ECDS Submission | |
| Special Programs | ||
This report can be run to only list students at risk, as well as to auto-code students who need to be added to or removed from the at risk population. (TX71) | On-demand | |
This is a report of students who have taken, are taking or are planning to take Career and Tech classes. This report can be used as verification for the PEIMS Career and Tech Indicator reported in PEIMS. (TX73) | On-demand | |
| PEIMS Economic Disadvantaged Verification Report | Use this report to create a CSV or PDF of students who qualify as economic disadvantaged. (TX72) | On-demand |
This report is used to create a CSV or PDF of students in a specific special program as of the date selected with all of the codes for that specific program. This report is 10 reports in one as the output is different depending on the special program that is selected at the time the program is run. (TX72) | On-demand | |
| Student Program Indicator Roster | The Student Program Indicator Roster report provides a list of students by school with basic identifying information, along with key program indicators to support participant verification by district and school personnel. School totals for each indicator are provided, along with a grand total for the district when run for multiple schools. Students who are actively enrolled on the specified Effective Date are included. | On-demand |
| Student Program Indicator Roster with Eco Dis | The Student Program Indicator Roster with Eco Dis report provides a list of students by school with basic identifying information, along with key program indicators to support participant verification by district and school personnel. This report includes students participating in Economic Disadvantaged programs. School totals for each indicator are provided, along with a grand total for the district when run for multiple schools. Students who are actively enrolled on the specified Effective Date are included. | On-demand |
Data Verification and Supporting Reports | ||
| Class ID/Unique Section Code Verification Report | This report is used to verify section and manually entered stored grade records referenced in the Summer PEIMS validation edits for the Master Schedule, Staff, Student Enrollment, and Student Transcript Interchanges. The report produces a CSV file containing the class IDs and other key information. | On-demand |
The Copy Class Rank and GPA Data report copies data from the [ClassRank] table to the Texas state extended fields for all selected students. It populates values on the student's Class Rank tab. It also generates a CSV file to help administrators verify data between the [ClassRank] and [S_TX_STU_X] tables. In the report parameters, the administrator can specify whether to copy data and create a verification report, or only create the verification report to manually verify data. Note: The report does not calculate or update any data; it simply copies data from the source table to the extended table. | On-demand | |
| Duplicate Class ID Report | This report identifies duplicate class IDs. | On-demand |
| Education Organization Calendar Verification Report | The Education Organization Calendar Verification report extracts calendar, minutes, and waivers data for verification. | On-demand |
The Incident Management Verification Report extracts all Discipline records entered in Incident Management that are, or may be, state reportable. This report can be used as verification for the PEIMS TX Interchange Student Discipline Extension, and will allow districts to identify records with missing or incorrect data entry that may cause the records to be omitted from the Discipline Interchange file. All key incident management fields, including the Texas-specific discipline fields, are extracted in.CSV format for the date range specified at runtime. In addition, a series of test checks are applied against specific data elements; these test checks appear in the final columns of the report. Any data element test column displaying a value of “fail” indicates that the record does not meet the minimum data entry requirements for inclusion in the Student Discipline Interchange. Users should verify each item flagged as failing the test check, and then update or correct the data entry as needed in all Incident Management records that are reportable to the state. The Incident Management Verification Report is PowerSchool report TX78. | On-demand | |
The Manual Entry Stored Grades Verification Report is designed to aid in the verification that all necessary elements required for state reporting are populated in manual entry stored grade records. Depending on the scenario, these records may be reported in the PEIMS Summer Submission, and are also reported on the AAR and in TREx. For each included school and student, the report selects stored grades records where the Section ID is0, and outputs the results in .csv format. The report can be filtered in Excel to identify missing or potentially incorrect data entry. The Manual Entry Stored Grades Verification Report is PowerSchool report TX81. | On-demand | |
| Potential Dropouts | This report creates a PDF file that identifies potential dropouts by school for the current or previous school years. | On-demand |
| This report creates a CSV file that identifies and verifies graduation-related data for students included as prior year Graduates in the Fall Submission Student Enrollment Interchange, School Leaver Extension, and Graduation Program Extension complexes, or prior year non-FHSP graduates who have earned at least one Post Secondary Certification. | On-demand | |
| The Student PEIMS Leaver Record Verification report creates a CSV file that identifies and verifies the related data for students included as Leavers, including prior year graduates, in the Fall Submission Student Enrollment Interchange, School Leaver Extension. | On-demand | |
| Texas Graduation Profile Report | Use the Texas Graduation Profile report to review student graduation status and related data elements as reported in the PEIMS Graduation Program complex, the AAR report, and the TREx Extract. | On-demand |
| Texas Individual Graduation Profile Report | Use the Texas Individual Graduation Profile report to review individual student graduation status and related data elements as reported in the PEIMS Graduation Program complex, the AAR report, and the TREx Extract. | On-demand |
| Enrollment Withdrawal Audit Report | This report outputs a PDF that lists each enrollment record that falls within the user-specified date range along with any modifications made to those records. The original record is always included in the report, regardless of whether or not modifications have been made. Additional rows are output for each change or set of changes to the record as logged in the audit tables. The audit columns identify the prior and new field values, the user who made the update, the IP address from which it was logged, and the date and time of the modifications. Users may specify additional parameters to limit the results to changes made by selected users or IP addresses, or to changes made within a specified date or time range. | On-demand |
| Enrollment Withdrawal Verification Report | This report outputs a PDF that lists each enrollment record that falls within the user-specified date range along with any modifications made to those records. The original record is always included in the report, regardless of whether or not modifications have been made. Additional rows are output for each change or set of changes to the record as logged in the audit tables. The audit columns identify the prior and new field values, the user who made the update, the IP address from which it was logged, and the date and time of the modifications. Users may specify additional parameters to limit the results to changes made by selected users or IP addresses, or to changes made within a specified date or time range. | On-demand |
| Third Party Extracts | ||
This report creates a zip file with the four extracts required to exchange data between PowerSchool and Eduphoria. (TX70) | On-demand | |
This report extracts the student demographic records foreSPED. (TX58) | On-demand | |
This report extracts the latest student special education information (163 Records) plus the student name, date of birth and SSN/State ID number. (TX59) | On-demand | |
This report is used to create an extract of students enrolled in PE sections for the year specified. This extract is sent to Fitnessgram 10 to upload to their software that allows districts to send their physical fitness data for students to the state. (TX46) | On-demand | |
| This report is used to create an 80 character length record for each Staff Responsibility record created in the system. The report is used by certain finance systems to generate 040 records for the Fall Collection. (TX75) | PEIMS Fall Submission | |
This report is used to create an 80 character length record for each 305 created by the Master Schedule. The report is used by certain finance systems to generate 040 records for the Summer Collection. (TX68) | PEIMS Summer Submission | |
Electronic Attendance Auditing | ||
The Attendance Audit reports audit data related to attendance All Present indicator selection and modification, including the identification of the person logging the attendance into the system, the IP from which it was logged, and the date and time of the modifications. (TX63) | On-demand | |
Attendance All Present Audit Report (PowerTeacher Single User) | The Attendance Audit reports audit data related to attendance All Present indicator selection and modification, including the identification of the person logging the attendance into the system, the IP from which it was logged, and the date and time of the modifications. This report is displayed on the admin side but is run from PowerTeacher. (TX64) | On-demand |
The Electronic Attendance Audit reports audit data related to attendance entry and modification, including the identification of the person logging the attendance into the system, the IP from which it was logged, and the date and time of the modifications. (TX66) | On-demand | |
Electronic Attendance Audit Report (PowerTeacher Single User) | The Electronic Attendance Audit reports audit data related to attendance entry and modification, including the identification of the person logging the attendance into the system, the IP from which it was logged, and the date and time of the modifications. This report is displayed on the admin side but is run from PowerTeacher. (TX67) | On-demand |
Section Attendance Status reports all sections in a school that has not taken attendance for a particular day. It is a means to track and verify that initial attendance for a section has been taken on the calendar day of the school day for which the attendance occurred. (TX65) | On-demand | |
Civil Rights Data Collection Refer to Civil Rights Data Collection (CRDC) 2020-2021 for CRDC report information. | ||
| 2017-2018 CRDC Report | The Civil Rights Data Collection (CRDC) is a mandatory data collection, authorized under the statutes and regulations implementing Title VI of the Civil Rights Act of 1964, Title IX of the Education Amendments of 1972, Section 504 of the Rehabilitation Act of 1973, and the Department of Education Organization Act (20 U.S.C. 3413). The regulations implementing these provisions can be found at 34 CFR 100.6(b); 34 CFR 106.71; and 34 CFR 104.61. | CRDC |
| CRDC Incident Management Verification Report | The CRDC Incident Management Verification Report allows districts to validate Incident Management records included in the CRDC report for questions related to Discipline, Offenses, Arrests, and Harassment/Bullying. | CRDC |
| Legacy Reports | ||
| Custom Reports | This feature enables the user to load custom iReports using PowerSchool data, and run those reports from within PowerSchool. PowerSchool does not support the creation of the custom reports. After creating an iReport using iReports version 3.7.0, to enable the report to be run with the PowerSchool environment, it must first be uploaded to the server. | On-demand |