Employment for Retiree Records - Header Row - 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 - header row record.
Field Name | Description | Position | Length | Format | Data Source or Valid Values | Required or Optional |
|---|---|---|---|---|---|---|
TRS Assigned Reporting Employer (RE) Number | The employer's four-digit, TRS-assigned ID number. | 1-4 | 4 | 9999 | Retrieved from the District ID field on the TX TEAM Report - Setup page. | Required |
Report Period | The month and year of the report. | 5-10 | 6 | MMYYYY | Retrieved from the Report Month and Report Year fields on the Texas TEAM Report page. | Required |
Total Number of Detail Records | The number of records included in the report. | 11-16 | 9 | 999999999 | The valid value is the number of records included in the report. | Required |
Total Gross Compensation | The sum of total gross compensation from ER20 records for all reported retirees. | 17-27 | 11 | 99999999999 | The valid value is the sum of total gross compensation from ER20 records for all reported retirees. | Required |
Total Pension Surcharge Contribution | The sum of pension surcharge contributions for all reported retirees. | 28-38 | 11 | 99999999999 | The valid value is the sum of pension surcharge contributions for all reported retirees. | Required |
Total TRS-Care Surcharge Contribution | The sum of TRS-Care surcharge contributions for all reported retirees. | 39-49 | 11 | 99999999999 | The valid value is the sum of TRS-Care surcharge contributions for all reported retirees. | Required |
Total Gross Compensation Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 50-50 | 1 | Not applicable | Valid values:
| Required |
Total Gross Compensation Adjustment | The sum of total gross compensation from ER25 and ER27 records for all reported retirees. | 51-61 | 11 | 99999999999 | The valid value is the sum of total gross compensation from ER25 and ER27 records for all reported retirees. | Required |
Total Pension Surcharge Contribution Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 62-62 | 1 | Not applicable | Valid values:
| Required |
Total Pension Surcharge Contribution Adjustment | The sum of pension surcharge contributions for all reported retirees. | 63-73 | 11 | 99999999999 | The valid value is the sum of pension surcharge contributions for all reported retirees. | Required |
Total TRS-Care Surcharge Contribution Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 74-74 | 1 | Not applicable | Valid values:
| Required |
Total TRS-Care Surcharge Contribution Adjustment | The sum of TRS-Care surcharge contributions for all reported retirees. | 75-85 | 11 | 99999999999 | The valid value is the sum of TRS-Care surcharge contributions for all reported retirees. | Required |