Skip to content

Statewide Terminations Reported to Employees Retirement System

Issued: Oct. 23, 2007
Updated: Oct. 23, 2007

FPP F.034


View entire document


Questions about the application of terminations to ERS Online or other retirement or insurance-related questions should be directed to the ERS Benefits Analysts at

For questions on data in the file/report, contact:

Mainframe Production Support — USPS, SPRS, HRIS Help Desk (512) 463-4008

CAPPS Authorized Support Staff Help Desk (512) 463-CAPP (2277)

Contact lists: USPS; SPRS; HRIS; CAPPS Agency Support


Applicable to

State agencies and institutions of higher education


The Texas Comptroller of Public Accounts provides a file to the Employees Retirement System (ERS) with all terminations processed in the Uniform Statewide Payroll/Personnel System (USPS) or reported to either the Standardized Payroll/Personnel Reporting System (SPRS) or the Human Resource Information System (HRIS). ERS uses the file to update ERS Online.

Changes made to termination dates or termination reason codes are also submitted to ERS. The net effect of changes to originally processed termination dates or reason codes made during that reporting period will appear on the file/report. This also applies to back-outs and termination reversals made during the same reporting period. Corrections made in subsequent reporting periods will be reported on the next file/report produced.

back to top

Statewide Terminations File Layout

Item No. Field Name Start Position Format Length Field Description
1 AGY-Agency-No. 1 Char 3 The agency number assigned by the Texas Comptroller of Public Accounts.
2 AGY-SSN 4 Char 9 Participant’s Social Security Number.
3 AGY-Empl-Last-Name 13 Char 35 Participant’s last name.
4 AGY-Empl-First-Name 48 Char 20 Participant’s first name.
5 AGY-Empl-Middle-Init 68 Char 1 Participant’s middle initial.
6 AGY-Eff-Dt 69 Char 8 The actual date that the employee terminates. Format: ‘CCYYMMDD’
7 AGY-Reason-Code 77 Char 3 The reason for the transaction. Valid values: TER=Terminated, DEA=Death
8 AGY-Process-Date-Time 80 Char 26 Transaction timestamp. Format: ‘CCYY-MM-DD-HH.MM.SS.NNNNNN’
9 AGY-Backout-Code 106 Char 1 B=Indicates transaction has been reversed; otherwise value will be blank.
10 AGY-System-Received-From 107 Char 4 Valid values are: SPRS, HRIS, USPS.
11 AGY-USPS-Orgcode 111 Char 11 Filler for HRIS, SPRS.
12 Filler 122 Char 79 For possible future use.

back to top

Statewide Terminations Reported to ERS

This report identifies all termination records reported to ERS for the period. The report is sorted in Social Security number order, and will be generated each Monday night (or the next business day if Monday falls on an official holiday).

 REPORT:   SWRIERS-01                                        STATE OF TEXAS                                    RUN DATE: 10/23/2007
                                                        STATEWIDE REPORTING GROUP                               RUN TIME: 22:08:29
                                                  STATEWIDE TERMINATIONS REPORTED TO ERS                                   PAGE: 1

                                                                                                          REASON        BACKOUT     
    SSN           EMPLOYEE NAME                                              EFF DATE    PROCESS DATE      CODE           IND       
-----------   --------------------------------------------------------      ----------   ------------      ----           ---

XXX-XX-XXXX   FIRST NAME MI LAST NAME                                       10/12/2007    10/16/2007        TER                     

XXX-XX-XXXX   FIRST NAME MI LAST NAME                                       10/16/2007    10/17/2007        TER                     
XXX-XX-XXXX   FIRST NAME MI LAST NAME                                       10/12/2007    10/16/2007        TER             B
XXX-XX-XXXX   FIRST NAME MI LAST NAME                                       10/15/2007    10/17/2007        DEA