Employment for Retiree Records - ER25 - Record Layout and Data Mapping
For the latest file layout information, search for and refer to the current Report Formatting Guide for ISDs, Charter Schools, and Education Service Center Employers on the Teacher Retirement System of Texas (TRS) website.
The following table lists the field names, descriptions, positions, lengths, formats, data sources or valid values, and whether the field is required for the Employment for Retiree report - ER25 record.
Field Name | Description | Position | Length | Format | Data Source or Valid Values | Required or Optional |
|---|---|---|---|---|---|---|
Record Type Code | Indicates the type of Employment for the Retiree record. | 1-4 | 4 | Not applicable | The valid value is ER25. | Required |
Employee Identification Number | The retired employee’s Social Security number or ITIN (Individual Taxpayer Identification Number). | 5-13 | 9 | SSN Format: 999999999 | Retrieved from the Retiree SSN/ITIN field in the General section of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Date of Birth | The retired employee's date of birth. | 14-21 | 8 | MMDDYYYY | Retrieved from the Birth Date field on the Member tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Gender Code | The retired employee's gender. | 22-22 | 1 | Not applicable | Valid values:
Retrieved from the Gender field on the Member tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Last Name | The retired employee's last name. | 23-52 | 30 | Not applicable | Retrieved from the Last Name field on the Member tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
First Name | The retired employee's first name. | 53-77 | 25 | Not applicable | Retrieved from the First Name field on the Member tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
Middle Name | The retired employee's middle name. | 78-102 | 25 | Not applicable | Retrieved from the Middle Name field on the Member tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
Generation | The retired employee’s name suffix. | 103-106 | 4 | Not applicable | Valid values:
Retrieved from the Suffix field on the Member tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
Position Code | The retired employee's TRS position code. | 107-108 | 2 | Not applicable | Valid values:
Retrieved from the TRS Position Code field on the Position tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Employment Type | The retired employee's employment type. | 109-109 | 1 | Not applicable | Valid values:
Retrieved from the Employment Type field on the Position tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Hours Worked | The actual number of hours worked by the retired employee. | 110-112 | 3 | 999 | Retrieved from the Hours Worked field on the Retiree Time tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Days Worked | The actual number of days worked by the retired employee. Includes paid leave. | 113-114 | 2 | 99 | Retrieved from the Days Worked field on the Retiree Time tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Zero Days Reason Code | The reason for the value 0 in the Days Worked field. | 115-115 | 1 | Not applicable | Valid values:
Retrieved from the Zero Days Reason Code field on the Retiree Time tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Total Gross Compensation | The retired employee's total gross compensation. | 116-124 | 9 | 999999999 | Retrieved from the Total Gross field on the Retiree Share tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Pension Surcharge Contribution | The retired employee's member contribution amount. | 125-133 | 9 | 999999999 | Retrieved from the Member Contribution field on the Retiree Share tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
TRS-Care Surcharge Contribution | The amount of the retired employee's member contribution to TRS-Care. | 134-142 | 9 | 999999999 | Retrieved from the Member TRS-Care Contribution field on the Retiree Share tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
Beginning Date of Employment Type | The start date for the position. | 143-150 | 8 | MMDDYYYY | Retrieved from the Start Date field on the Position tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Ending Date of Employment Type | The end date for the position. | 151-158 | 8 | MMDDYYYY | Retrieved from the End Date field on the Position tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Paid through 3rd Party Entity? | Indicates whether a third party contracted the retired employee. | 159-159 | 1 | Not applicable | Retrieved from the Third Party field on the Member tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Adjusted Report Period | The month and year of the adjusted report. | 160-165 | 6 | MMYYYY | Retrieved from the Report Month and Report Year fields in the General section of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |