Skip to main content

PowerSchool ERP Texas

PowerSchool ERP Texas

Main

Main

Release Notes

2025

December 2025 Escalation Release - 22.4.52.1, 23.10.27.1, 25.7.6.1
December 2025 Release - 22.4.52, 23.10.27, 25.7.6
December 2025 Release - 22.4.51, 23.10.26, 25.7.5
November 2025 Escalation Release - 22.4.50.2, 23.10.25.2, 25.7.4.2
November 2025 Escalation Release - 22.4.50.1, 23.10.25.1, 25.7.4.1
November 2025 Release - 22.4.50, 23.10.25, 25.7.4
October 2025 Escalation Release - 22.4.49.2, 23.10.24.2, 25.7.3.2
October 2025 Release - 22.4.49, 23.10.24, 25.7.3
September 2025 Escalation Release - 22.4.48.1, 23.10.23.1
September 2025 Release - 22.4.48, 23.10.23, 25.7.2
August 2025 Release - 25.7.1
August 2025 Release - 22.4.47, 23.10.22
June 2025 Release - 22.4.45, 23.10.20, 25.7.0.5
May 2025 Release - 22.4.44, 23.10.19, 25.7.0
April 2025 Release - 22.4.43, 23.10.18, 25.7.0
March 2025 Release - 22.4.42, 23.10.17
February 2025 Escalation Release - 22.4.41.1
February 2025 Escalation Release - 23.10.16.1
February 2025 Release - 22.4.41, 23.10.16
January 2025 Release - 22.4.40, 23.10.15

2024

December 2024 Release - 22.4.39, 23.10.14
December 2024 Escalation Release - 20.11.77, 22.4.38.2, 23.10.13.2
November 2024 Escalation Release - 20.11.76.1, 22.4.38.1, 23.10.13.1
November 2024 Release - 22.4.38, 23.10.13
October 2024 Escalation Release - 20.11.75.1, 22.4.37.1, 23.10.12.1
October 2024 Release - 20.11.75, 22.4.37, 23.10.12
September 2024 Release - 20.11.74, 22.4.36, 23.10.11
August 2024 Release - 20.11.73, 22.4.35, 23.10.10
July 2024 Release - 20.11.72, 22.4.34, 23.10.9
June 2024 Release - 20.11.71, 22.4.33, 23.10.8
May 2024 Release - 20.11.70, 22.4.32, 23.10.7
April 2024 Release - 20.11.69, 22.4.31, 23.10.6
March 2024 Release - 20.11.68, 22.4.30, 23.10.5
February 2024 Release - 20.11.67, 22.4.29, 23.10.4
January 2024 Release - 20.11.66, 22.4.28, 23.10.3

2023

November 2023 Release - 23.10.1
November 2023 Escalation Release - 20.11.64.1
November 2023 Escalation Release - 22.4.26.1
November 2023 Release - 20.11.64, 22.4.26
October 2023 Release - 22.4.25
September 2023 Release - 20.11.62, 22.4.24
August 2023 Release - 20.11.61, 22.4.23
July 2023 Release - 19.4.79, 20.11.60, 22.4.22
June 2023 Escalation Release - 22.4.21.1
June 2023 Release - 19.4.78, 20.11.59, 22.4.21
May 2023 Major Release - 19.4.77, 20.11.58, 22.4.20
April 2023 Minor Release - 20.11.57, 22.4.19
April 2023 Major Release - 22.4.18
March 2023 Minor Release - 20.11.55, 22.4.17
March 2023 Major Release - 19.4.73, 20.11.54, 22.4.16
February 2023 Major Release - 19.4.71, 20.11.52, 22.4.14
January 2023 Minor Release - 19.4.70, 20.11.51, 22.4.13
January 2023 Major Release - 19.4.69, 20.11.50, 22.4.12

2022

December 2022 Major Release - 19.4.67, 20.11.48, 22.4.10
November 2022 Escalation Release - 19.4.66.1, 20.11.47.1, 22.4.9.1
November 2022 Minor Release - 19.4.66, 20.11.47, 22.4.9
November 2022 Major Release - 20.11.46.0
October 2022 Minor Release - 20.11.45.0
October 2022 Major Release - 20.11.44.0
September 2022 Minor Release - 20.11.43.0
September 2022 Major Release - 20.11.42.0
August 2022 Minor Release - 20.11.41.0
August 2022 Major Release - 20.11.40.0
July 2022 Major Release - 20.11.38.0
June 2022 Minor Release - 20.11.37
June 2022 Major Release - 20.11.36
May 2022 Minor Release - 20.11.35
April 29, 2022 Release
March 11, 2022 Release
February 25, 2022 Release
February 11, 2022 Release
January 28, 2022 Release
January 21, 2022 Release
January 07, 2022 Release

2021

December 10, 2021 Release
December 03, 2021 Release
November 12, 2021 Release
October 29, 2021 Release
February 5, 2021 Release
October 8, 2021 Release
September 24, 2021 Release
September 10, 2021 Release
August 27, 2021 Release
August 13, 2021 Release
July 9, 2021 Release
June 25, 2021 Release
June 11, 2021 Release
February 26, 2021 Release
January 22, 2021 Release

Overview

Setup

Full Account Structure (FAS)
Human Resources Profile - State

Employee Information

Actions

Ed-Fi Staff Extensions
TEA Staff Responsibilities
TEAM Defaults

Payroll Information - State Required

Personnel Information - Defined Pages

Defined Page 31998 - TRS Member Data
Defined Page 32001 - State Required II
Defined Page 32002 - State Required III

Reference Tables

Calendars
Certification Types
Deductions
Future Job Classes
Job Classes
Pay Codes
User-Defined - Medical Insurance

PEIMS Translation Entry

Expenditure Ledger
Revenue Ledger

Payroll Accrual

Update Future Pay Rates for Min/Mid/Max Calculations

Setup - Salary Increase Method

Setup - Salary Increase Method - Min/Mid/Max Profile
Setup - Salary Increase Method - Min/Mid/Max Pay Family/Grade Information

Setup - Salary Increase Method - Min/Mid/Max Salary Increase

Setup - Salary Increase Method - Min/Mid/Max Salary Increase - Mass Update

Setup - Salary Increase Method - Future Pay Rates

Setup - Salary Increase Method - Update Future Pay Rates

Update Future Pay Rates - Salary Increase Method Calculations

Setup - Percent Increase Method

Setup - Percent Increase Method - Min/Mid/Max Profile
Setup - Percent Increase Method - Min/Mid/Max Pay Family/Grade Information
Setup - Percent Increase Method - Future Pay Rates

Setup - Percent Increase Method - Update Future Pay Rates

Update Future Pay Rates - Percent Increase Method Calculations

Update Future Pay Rates Report - File Layout and Data Mapping

Budget Preparation

Organization Crosswalk

Deleting Organization Numbers and Working with Federal Funds

Account Crosswalk

State Submissions

Fund Accounting - State Submissions

Auditors File

Human Resources - State Submissions

Criminal History Report
Employer New Hire Report
Staff Salary Data Report (TEA)

Teacher Service Records (TEA)

Teacher Service Records (TEA) - Load Data
Teacher Service Records (TEA) - Load Data - TEA List
Teacher Service Records (TEA) - Maintain Data
Teacher Service Records (TEA) - Maintain Data - Purge Data
Teacher Service Records (TEA) - Create File

Teacher Service Records (TEA) - File Layout and Data Mapping

Teacher Service Record - File Layout
Teacher Service History - File Layout and Data Mapping

TX Quarterly Unemployment Report (TWC)

TX TEAM Report

TEAM Setups and Crosswalks

TEAM Setup
Position/Budget Code Crosswalk
Federal Grant/TRS Care Codes
Deduction Code Crosswalk
Position Defaults Crosswalk

TEAM Record Maintenance

Load TEAM Records

Docking Spreadsheet - File Layout

Maintain Demographics ED20 Or ED25 Records
Maintain Position ED40 Or ED45 Records
Maintain Termination ED90 Records

Maintain Payroll RP20 Or RP25 Records

Maintain Payroll RP20 Or RP25 Records - General section
Maintain Payroll RP20 Or RP25 Records - Member tab
Maintain Payroll RP20 Or RP25 Records - Employee Time tab
Maintain Payroll RP20 Or RP25 Records - Employee Share tab
Maintain Payroll RP20 Or RP25 Records - Employer Share tab
Maintain Payroll RP20 Or RP25 Records - Salary Distribution tab

Maintain Retirement ER20 ER25 ER27 Records

Maintain Retirement ER20 ER25 ER27 Records - General section
Maintain Retirement ER20 ER25 ER27 Records - Member tab
Maintain Retirement ER20 ER25 ER27 Records - Position tab
Maintain Retirement ER20 ER25 ER27 Records - Retiree Time tab
Maintain Retirement ER20 ER25 ER27 Records - Retiree Share tab
Maintain Retirement ER20 ER25 ER27 Records - Third Party Retiree
Maintain Retirement ER20 ER25 ER27 Records - Clear Resubmit Records

Mass Update Submitted to TRS
Actual Hours Upload
Purge TEAM Records

TEAM Reports

Create TEAM Reports

Regular Payroll Contribution Calculations

TEAM Reports - File Layouts and Data Mapping

Demographic Records - File Layout and Data Mapping

Demographic Records - Header Row - Record Layout and Data Mapping
Demographic Records - ED20 - Record Layout and Data Mapping
Demographic Records - ED25 - Record Layout and Data Mapping
Demographic Records - ED40 - Record Layout and Data Mapping
Demographic Records - ED45 - Record Layout and Data Mapping
Demographic Records - ED90 - Record Layout and Data Mapping

Regular Payroll Records - File Layout and Data Mapping

Regular Payroll Records - Header Row - Record Layout and Data Mapping
Regular Payroll Records - RP20 - Record Layout and Data Mapping
Regular Payroll Records - RP25 - Record Layout and Data Mapping

Employment for Retiree - File Layout and Data Mapping

Employment for Retiree Records - Header Row - Record Layout and Data Mapping
Employment for Retiree Records - ER20 - Record Layout and Data Mapping
Employment for Retiree Records - ER25 - Record Layout and Data Mapping
Employment for Retiree Records - ER27 - Record Layout and Data Mapping

Create Charging Records

Charging Report - File Layout and Data Mapping
Charging Variance Report - File Layout and Data Mapping

Unique ID Report

Unique ID Report (TEA) - File Layout

Update Service Years

PEIMS

Data Exchange (Ed-Fi)

Financial

Financial Information

Financial Information - File layouts and data mapping

Actual Information - File layout and data mapping
Budget Information - File layout and data mapping

Shared Service Arrangements (011)
Shared Service Arrangements-Actual (033)

Other

Account Translations

Account Translations - File Layout and Data Mapping

DEX Audit Report
Profile

Staff - PEIMS

Contracted Instructional Staff

Ed-Fi Batch Staff Extensions

Import Ed-Fi Batch Staff Extensions Records

Ed-Fi Batch Staff Extensions - File Layout and Data Mapping

Ed-Fi Batch Staff Extensions - Load Data
Ed-Fi Batch Staff Extensions - Post
Ed-Fi Batch Staff Extensions - Purge Data

Ed-Fi Staff Extensions - PEIMS

Import Ed-Fi Staff Extensions Records

Ed-Fi Staff Extensions - File Layout and Data Mapping

Staff Information

Staff Information - Load Data

Staff Information - Load Data - Included Substitutes
Staff Information - Load Data - Schedule Load
Staff Information - Load Data - Run Load

Staff Information - Create Files
Staff Information - Purge Data
File layout - Contracted professional staff information

Staff Information - File Layouts and Data Mapping

Demographic report - File Layout and Data Mapping
Payroll Accounting report - File Layout and Data Mapping
Staff Responsibilities report - File Layout and Data Mapping
Staff Extensions report - File Layout and Data Mapping
Complete report - File Layout and Data Mapping

TEA Staff Responsibilities - PEIMS

Import TEA Staff Responsibilities

TEA Staff Responsibilities - File Layout and Data Mapping

Reference Tables - PEIMS

Activity
Auxiliary Role ID
Career and Technology Indicator
Days of Week
Degree
Generation
Grade Level
Instructional Setting
Multi-Service Indicator
Population
Program of Study
Programs
School
Shared Service Arrangement Types
Staff Classification
Staff Service
Subject Area
Weeks of Month

PowerSchool Data Exchange (DEX) for Texas

Data Exchange (DEX) Prerequisites
Data Exchange (DEX) Setup

Data Exchange (DEX) Configuration

Configure
Download
Mapping
Settings
Diagnostics

Initial Data Synchronization
Publish Data
Review Data
Data Exchange Conventions and Common Tasks

Ed-Fi Field Mapping

Ed-Fi - Finance - Field Mapping

Entity: BudgetExt
Entity: PayrollExt
Entity: PriorYearActualExt
Entity: SharedServiceArrangementExt

Ed-Fi - Staff - Field Mapping

Entity: ContractedInstructionalStaffFTEExt
Entity: Staff
Entity: StaffEducationOrganizationAssignmentAssociation
Entity: StaffEducationOrganizationEmploymentAssociation
Entity: StaffSchoolAssociation

Troubleshooting Common Errors and Dependencies
Appendix A – Ed-Fi Entities, Categories, and Resources
Appendix B – Ed-Fi Response Codes
Appendix C - Entity Relationship Diagrams (ERDs)

Procedures

Terminate Employees

Set Up Termination (ED90) Codes
Process Early Terminations
Terminate an Employee
Termination (ED90) Record Generation

Texas Fiscal Year-End Processing

Breadcrumbs

Home
Texas State Reporting Help
PowerSchool Data Exchange (DEX) for Texas

On this Page

Appendix C - Entity Relationship Diagrams (ERDs)

The following images show the TX PEIMS database fields used in DEX/Ed-Fi reporting and the entity relationships.

Image showing database table structure and key field relationships for database tables used by the Texas Ed-Fi process.

Image showing database table structure and key field relationships for database tables used by the Texas Ed-Fi process.

Image showing database table structure and key field relationships for database tables used by the Texas Ed-Fi process.

Privacy Statement

Copyright PowerSchool. All Rights Reserved.
Powered by Scroll Sites & Atlassian Confluence