Employment for Retiree Records - ER27 - 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 - ER27 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 ER27. | 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 |
Original Position Code | The retired employee's previously reported TRS position code. | 107-108 | 2 | Not applicable | Valid values:
Retrieved from the TRS Position Code field in the Previously Reported to TEAM section of the Position tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Original Employment Type | The retired employee's previously reported employment type. | 109-109 | 1 | Not applicable | Valid values:
Retrieved from the Employment Type field in the Previously Reported to TEAM section of the Position tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Hours Worked Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 110-110 | 1 | Not applicable | Valid values:
| Optional |
Hours Worked Adjustment | The actual number of hours worked by the retired employee. | 111-113 | 3 | 999 | Retrieved from the Hours Worked field in the Net Adjustment section of the Retiree Time tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
Days Worked Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 114-114 | 1 | Not applicable | Valid values:
| Optional |
Days Worked Adjustment | The actual number of days worked by the retired employee. Includes paid leave. | 115-116 | 2 | 99 | Retrieved from the Days Worked field in the Net Adjustment section of the Retiree Time tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
Zero Days Reason Code | The reason for the value 0 in the Days Worked field. | 117-117 | 1 | Not applicable | Valid values:
Retrieved from the Zero Days Reason Code field in the Current Data section of the Retiree Time tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Total Gross Compensation Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 118-118 | 1 | Not applicable | Valid values:
| Optional |
Total Gross Compensation Adjustment | The net difference between the amount originally reported and the correct total gross compensation that would be TRS eligible, from the Payroll System/Register for the retiree. | 119-127 | 9 | 999999999 | Retrieved from the Total Gross field in the Net Adjustment section of the Retiree Share tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
Pension Surcharge Contribution Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 128-128 | 1 | Not applicable | Valid values:
| Optional |
Pension Surcharge Contribution Adjustment | The net difference between the amount originally reported and the correct amount of pension surcharge due, if any, based on the retiree's employment. | 129-137 | 9 | 999999999 | Retrieved from the Member Contribution field in the Net Adjustment section of the Retiree Share tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
TRS-Care Surcharge Contribution Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 138-138 | 1 | Not applicable | Valid values:
| Optional |
TRS-Care Surcharge Contribution Adjustment | The net difference between the amount originally reported and the correct amount of TRS-Care surcharge due, if any, based on the retiree's employment. | 139-147 | 9 | 999999999 | Retrieved from the Member TRS-Care Contribution field in the Net Adjustment section of the Retiree Share tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
Original Beginning Date of Employment Type | The previously reported start date for the position. | 148-155 | 8 | MMDDYYYY | Retrieved from the Start Date field in the Previously Reported to TEAM section of the Position tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Original Ending Date of Employment Type | The previously reported end date for the position. | 156-163 | 8 | MMDDYYYY | Retrieved from the End Date field in the Previously Reported to TEAM section of the Position tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
Original Paid through 3rd Party Entity? | Indicates whether a third party previously contracted the retired employee. | 164-164 | 1 | Not applicable | Valid values:
Retrieved from the Third Party field on the Member tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Required |
New Position Code | The retired employee's new TRS position code. | 165-166 | 2 | Not applicable | Valid values:
Retrieved from the TRS Position Code field in the Current Data section of the Position tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
New Employment Type | The retired employee's new employment type. | 167-167 | 1 | Not applicable | Valid values:
Retrieved from the Employment Type field in the Current Data section of the Position tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
New Beginning Date of Employment Type | The new start date for the position. | 168-175 | 8 | MMDDYYYY | Retrieved from the Start Date field in the Current Data section of the Position tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
New Ending Date of Employment Type | The new end date for the position. | 176-183 | 8 | MMDDYYYY | Retrieved from the End Date field in the Current Data section of the Position tab on the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
New Paid through 3rd Party Entity? | Indicates whether a third party has currently contracted the retired employee. | 184-184 | 1 | Not applicable | Valid values:
Retrieved from the Third Party field on the Member tab of the TX TEAM Report - Employment After Retirement (ER20/ER25/ER27) page. | Optional |
Adjusted Report Period | The month and year of the adjusted report. | 185-190 | 6 | MMDDYYYY | 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 |
Adjustment Reason Code | The reason for the adjustment. | 191-191 | 1 | Not applicable | Valid values: E = Edit previous ER20/ER25 D = Delete previous ER20/ER25 | Required |