FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide

Issued: Dec. 16, 2005
Updated: Aug. 31, 2018 – View Changes

FPP R.020

Uniform Statewide Payroll/Personnel System (USPS) provides the information on payroll, staffing, employee benefits activity, and personnel actions required by the management and accounting functions of state agencies.

Additionally, some reports update and clear data accumulators or transmit data to various entities, such as the Employees’ Retirement System (ERS) and the Texas Workforce Commission (TWC).

This guide will help you understand and use the reports generated by USPS. This guide presents report information in alphanumerical order, from Report 003 to Report 3012.

You will find the following information for each report:

  • Overview and report criteria, providing general information for selecting and requesting the report you need. Includes sort, parameter and database information.
  • Report headings, defining the information printed under each heading on the report. Use this section to interpret the data on the report.
  • A copy of the report (if printed output was available).

USPS Reports by Number

Report Last Updated
Report 003 – Payroll Deduction Register 08/1999
Report 006 – Benefits Profile 01/2012
Report 010 – Payroll and Deduction Register 01/2011
Report 014 – Deductions Not Taken Register 02/2008
Report 017 – Generated Defined Contribution Deductions 02/2008
Report 019 – USPS Subsystem Extract (no report) 02/2008
Report 021 – Employees Within Deduction 02/2008
Report 022 – Special Payment 02/2008
Report 024 – Statement of Earnings 09/2009
Report 026 – Direct Deposit Transmission Report 02/2008
Report 032 – Generated Nightly Insurance Deductions & Imputed Income 02/2008
Report 036 – Employees Eligible for COBRA Coverage 08/1999
Report 038 – Annual Retirement Fee Deductions 08/1999
Report 039 – Tax Liability Report 02/2008
Report 050 – HR Extract Rebuild 02/2008
Report 053 – Hourly Adjustment Process for Actual Time Worked 07/2008
Report 056 – Quarterly Composite Tax Report 05/2013
Report 058 – Form 941 Worksheet 12/2013
Report 068 – W-2 Forms Report 01/2013
Report 071 – Bureau of Labor Statistics Report on Employment and Payroll 02/2008
Report 074 – Period-End Clear Control Totals 02/2008
Report 080 – Warrant Number Report 02/2008
Report 082 – Payment Edit Reports to Treasury 02/2008
Report 083 – W-2 Posting Report 12/2012
Report 085 – W2 Tape Report 08/1999
Report 090 – Payroll Deposit Advice 02/2008
Report 094 – Subdeduction Detail 07/2009
Report 096 – Employee Union Deductions 02/2008
Report 097 – Monthly Longevity/Hazardous Duty Report 02/2008
Report 129 – Child Support/Spousal Maintenance Sub-Deductions 07/2009
Report 150 – Veterans Preference Report 08/2099
Report 153 – Position Payment Posting Report 02/2008
Report 154 – TRS Contributions Report for Warrants 02/2008
Report 155 – ERS SSN Corrections for Active Retirement Contributions 02/2008
Report 156 – Vacation & Sick Leave Accrual Exceptions 07/2008
Report 157 – College Savings Plan Detail 05/2009
Report 158 – Leave Rollover Exception Listing 08/2010
Report 162 – Payroll and Deduction Register – Detail 03/2013
Report 163 – Employee Profile – TAD 10/2011
Report 165 – Staffing Forecast Report 06/2000
Report 166 – Employee by Salary Group 01/2004
Report 168 – Active Employee Listing 10/2011
Report 170 – Promoted Employees for Period 08/1999
Report 171 – Employees with D.C.P. Balances 01/2012
Report 172 – Separated Employees with D.C.P. Balances 01/2012
Report 174 – D.C.P. Contribution/Loan Activity 01/2012
Report 175 – Defined Contribution Transmittal Letter 01/2012
Report 177 – Employees with 401(k), Roth 401(k) and 401(k) Loan Contributions 01/2012
Report 181 – Adjustment Register 01/2011
Report 182 – Warrant Register 03/2013
Report 183 – Update Register 01/2011
Report 184 – Texas Protects Detail Report 02/2008
Report 185 – Pay Period Summary Totals 12/2013
Report 189 – Payroll Detail Report 09/2013
Report 190 – Consolidated History Detail 09/2013
Report 192 – State Matching Money 09/2013
Report 194 – Prepaid Tuition Detail Report 02/2008
Report 195 – Deductions Not Taken 02/2008
Report 196 – Posting Report 02/2011
Report 197 – Personnel Changes 02/2008
Report 199 – FLSA O.T./Comp Time Activity 07/2008
Report 503 – Work Authorizations Expiring Within 120 days of xx/xx/xxxx 02/2008
Report 506 – Position Rollover Update Listing or Position Rollover Edit Listing 06/2000
Report 507 – Assignment Rollover Edit Listing or Assignment Rollover Update Listing 08/2007
Report 508 – Active Positions 02/2008
Report 509 – Management to Staff Ratio Report 05/2007
Report 514 – Active Employees Labor Code Distribution as of MM/DD/CCYY 10/2005
Report 515 – Leave Accounting Batch Upload Error Listing 07/2006
Report 516 – Maintenance Transaction Interface Error Report 06/2000
Report 517 – Fiscal Year Mass Change Batch Upload Error Listing 08/1999
Report 523 – PCA/Index Validation 07/2001
Report 525 – Functional Job Class Listing 05/2007
Report 526 – Electronic Approval Report 06/2000
Report 527 – Employee History Out of Balance with Year-to-Date Totals 02/2008
Report 531– Employees by Job Classification 08/2006
Report 533 – Job Class Listing 07/2001
Report 534 – Pay Table Listing 07/2001
Report 535 – Organization Table Listing 06/2000
Report 536 – USPS Warrant Held Register – Standalone 08/1999
Report 537 – Employee Leave Summary 08/2012
Report 538 – Credit Union Report 07/2001
Report 539 – American Disability Act Report 08/1999
Report 540 – Staffing Summary Report 02/2008
Report 541 – Statewide Employee List by Name or Statewide Employee List by SSN 07/2001
Report 543 – Terminated Employees 10/2011
Report 545 – Rollover of Imputed Income 07/2001
Report 546 – Merit Increases 07/2009
Report 547 – Batch Transaction Interface Error Report 07/2001
Report 548 – Batch Transaction Interface Load 08/1999
Report 549 – USPS Overpayment Report 06/2000
Report 550 – HR Daily Rebuild 06/2000
Report 551 – PCA/Index Special Pay Override 09/2013
Report 553 – Agency Service Awards 11/2006
Report 554 – State Service Awards 11/2006
Report 555 – Notice of Termination 07/2001
Report 556 – Terminated Employees with Court-Ordered Payments 06/2000
Report 557 – Leave Payment Audit 12/2009
Report 558 – Generated Imputed Income Transactions 08/1999
Report 559 – Performance Appraisal 11/2007
Report 561 – Sick Leave Pool Activity 07/2008
Report 563 – Employee Leave Balances 08/2012
Report 565 – Employee Leave Accrued Report 09/2009
Report 567 – Fiscal Year End Excess Vacation Leave 07/2008
Report 569 – Proj. Annual Leave to Be Converted to Sick Leave at FYE 07/2008
Report 571 – Generated State-Paid Insurance 04/2009
Report 572 – Daily Insurance Adjustments Report 01/2016
Report 573 – Employee FMLA/Parental Leave Authorization 02/2011
Report 574 – Compensable Leave Report for Fiscal Year CCYY 12/2009
Report 575 – ERS Retiree Report/FMLA Report 05/2003
Report 576 – Fiscal Year Organization Code Rollover 07/2001
Report 577 – Fiscal Year Job Class/Functional Job Class Code Rollover 05/2003
Report 578 – Fiscal Year Pay Table Rollover 06/2000
Report 580 – Fiscal Year HN7 – PCA Rollover or Fiscal Year HMM – PCA Validation 09/2013
Report 594 – Payroll Transactions Generated 12/2009
Report 595 – Leave Payroll Reconciliation Report 12/2009
Report 597 – Actual/Forecasted Time Forfeitures as of MM/DD/CCYY 08/2012
Report 598 – Military Rollover Exception Listing 08/2012
Report 599 – Transmittal Letters for Third-Party Payees 11/2008
Report 604 – Exempt Job Class Listing 07/2001
Report 630 – Course Catalog 08/1999
Report 666 – Daily Warrant Transmittal Report 07/2001
Report 669 – Daily Warrant Held Register 08/1999
Report 674 – Month End Clear HØZ Change Listing 06/2000
Report 748 – Exempt Actual Exceeds Authorized 07/2001
Report 761 & 762 – FTE State Employee Quarterly 02/2008
Report 798 – New Hires and Transfers Report 10/2011
Report 841 – Employee Descriptive Reference 09/2007
Report 842 – Active Regular/Permanent Employees by Job Class 06/2000
Report 844 – SSN/Name XRef 03/2004
Report 850 – Projected Hazardous Duty Report 05/2004
Report 852 – Employee Job Description Information Report 08/1999
Report 855 – Projected Longevity Report 05/2004
Report 856 – Out Of State Employees 02/2008
Report 857 – Terminated Employees with Active Deductions 02/2008
Report 858 – Employee Skills Profile 08/1999
Report 860 – Employee Training Profile 08/1999
Report 862 – Location Table Listing 07/2001
Report 867 – Part-Time Employees 07/2005
Report 879 – ORP Employee Retirement Contribution Report 02/2008
Report 881 – Employees Who Are Receiving Retirement Benefits from TRS 02/2008
Report 882 – Employees Who Are Receiving Retirement Benefits from ERS 02/2008
Report 899 – Report Selection Information 08/1999
Report 901 – Warrant Signature List 02/2008
Report 902 – Employees on LWOP As of xx/xx/xxxx 02/2008
Report 904 – Pending USPS/USAS/TINS DD Cancel 04/2005
Report 911 – Position Control Lapsing Report 02/2008
Report 921 – TWC Quarterly Report – Wages by Employee 07/2001
Report 922 – TWC Quarterly Report – Wages by Document 05/2003
Report 923 – TWC Quarterly Report – Wages by County 07/2001
Report 926 – TWC Quarterly Report – Employees with Negative Total Wages 07/2001
Report 928 – TWC Quarterly Report – Discrepancy Report 07/2001
Report 940 – USPS User List 07/2008
Report 941 – USPS Users by Profile 07/2008
Report 943 – Potential Overtime Adjustment 03/2008
Report 945 – Reconciliation of Single Direct Deposit Transactions to USAS 07/2009
Report 946 – Payroll Addenda – Vendor Payments Generated 07/2009
Report 947 – Transactions Held on Addenda Table – Aging 07/2009
Report 951 – ERS Daily Input File Diagnostic 04/2005
Report 956 – Retirement Type Discrepancy 09/2014
Report 957 – Commuter Spending Account Updates 01/2016
Report 958 – Job Classifications Affected by FXX Legislative Changes as of MM/DD/CCYY 09/2007
Report 959 – Benefits Totals Reported to ERS 01/2016
Report 961 – Agency Accounting Control Totals 09/2013
Report 962 – Employees Not Being Paid 04/2009
Report 967 – Adjustment Deductions for Terms and LWOP’s 07/2001
Report 970 – Treasury Cancellations 07/2001
Report 971 – Cancellation Activity Report 03/2013
Report 974 – Insurance Salary Transactions 07/2001
Report 976 – FYE Reset of TexFlex Health Care/Dependent Care 08/1999
Report 978 – ERS Transmitted DCP Election Changes 02/2016
Report 980 – Applicant Review by Posting and Applicant Review by Posting Summary 07/2001
Report 981 – Applicant Review by Job Category and Applicant Review by Job Category Summary 072001
Report 982 – Applicant Review by Classification and Applicant Review by Classification Summary 07/2001
Report 983 – Applicant Flow Summary 07/2001
Report 984 – Interview Schedule 07/2001
Report 987 – Applicant Tracking Veterans Report 08/1999
Report 988 – Posting Notice 07/2001
Report 989 – Summary Of USAS Processing 08/1999
Report 991 – Insurance Rollover Premium Calculation Errors 08/1999
Report 992 – TRS Service Purchase Deductions 07/2001
Report 993 – Employee Insurance Information 12/2011
Report 995 – USAS/USPS Balancing Report 01/2012
Report 996 – Update Contribution Summary 02/2008
Report 997 – Payroll Voucher 02/2008
Report 998 – Payroll Deduction Transactions 03/2013
Report 999 – Daily Insurance Change Report 12/2011
Report 1001 – Input Transaction List 06/2000
Report 1002 – Deleted Pending Transactions 06/2000
Report 1003 – Released Pending Transactions 06/2000
Report 1004 – Transaction Balance Report 06/2000
Report 1005 – Company Batch Summary 06/2000
Report 1006 – HR:M Change Listing 08/1999
Report 1008 – Pay/Labor History Update 08/1999
Report 1009 – Employee Diagnostics Listing 06/2000
Report 1010 – HR:M Change Listing by Type 08/1999
Report 1012 – Company Diagnostics and Assumptions Listing 07/2001
Report 1017 – Updated Pending Transactions 06/2000
Report 1019 – Millennium Online Processing Summary 08/1999
Report 1021 – HR:M Database Transfer Summary 08/1999
Report 2001 – CTL List and Payroll Calculation Report 06/2000
Report 2002 – Reports Being Generated (Class 0) 06/2000
Report 2007 – Recycled Pending Transactions 08/1999
Report 2009 – Reports Being Generated (Class 1) 08/1999
Report 3011 – Employee Compensation Information 08/1999
Report 3012 – Employee Compensation Information 08/1999
Changes to this Document
08/31/2018 ACR 60309 affected Report 515.
05/05/2017 Updated Report 058 – Form 941 Worksheet.
07/26/2016 Deleted report 180.
02/08/2016 ACR 60015 affected Report 978.
01/29/2016 ACR 60076 created Report 957 and affected Report 572 and Report 959.
09/02/2014 ACR 44753 created Report 956 and ACR 44681 affected Report 959.
12/12/2013 ACR 43926 affected Report 058 and Report 185.
09/03/2013 ACR 44024 affected Report 185, Report 189, Report 190, Report192, Report 959 and Report 961.
05/31/2013 ACR 43850 affected Report 56 and Report 58.
05/01/2013 Deleted report 033.
03/15/2013 ACR 42802 affected Report 162, Report 182, Report 189, Report 971 and Report 998.
01/08/2013 Updated Report 068 per W-2 changes.
12/14/2012 ACR 30661 and ACR 30981 affected Report 083.
08/31/2012 ACR 41639 created Report 598.
01/30/2012 ACR 30661 affected Report 006, Report 171, Report 172, Report 174, Report 175, Report 177 and Report 995. Report 173 and Report 176 were retired.
01/03/2012 ACR 30981 affected Report 006, Report 185, Report 190, Report 959, Report 993 and Report 999.
Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy