Regular Payroll 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 Regular Payroll Records - 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 TRS Eligible Compensation | The sum of eligible compensation for all reported employees. | 17-27 | 11 | 99999999999 | The valid value is the sum of eligible compensation for all reported employees. | Required |
Total Performance Pay Gross | The sum of performance pay for all reported employees | 28-38 | 11 | 99999999999 | The valid value is the sum of performance pay for all reported employees | Required |
Total Gross Compensation | The sum of total gross compensation for all reported employees. | 39-49 | 11 | 99999999999 | The valid value is the sum of total gross compensation for all reported employees. | Required |
Total Member Contributions | The sum of contributions for all reported employees. | 50-60 | 11 | 99999999999 | The valid value is the sum of contributions for all reported employees. | Required |
Total Member TRS-Care Contributions | The sum of member insurance contributions for all reported employees. | 61-71 | 11 | 99999999999 | The valid value is the sum of member insurance contributions for all reported employees. | Required |
Total RE TRS-Care Contributions | The sum of reporting employer TRS-Care contributions for all reported employees. | 72-82 | 11 | 99999999999 | The valid value is the sum of reporting employer TRS-Care contributions for all reported employees. | Required |
Total Service Credit Purchase Deductions | The sum of service credit purchase deductions for all reported employees. | 83-93 | 11 | 99999999999 | The valid value is the sum of service credit purchase deductions for all reported employees. | Required |
Total Eligible Compensation Paid from Federal Funds/Private Grants | The sum of eligible compensation paid from Federal funds for all reported employees. | 94-104 | 11 | 99999999999 | The valid value is the sum of eligible compensation paid from Federal funds for all reported employees. | Required |
Total Federal Fund/Private Grant Contributions | The sum of Federal fund/private grant contributions for all reported employees. | 105-115 | 11 | 99999999999 | The valid value is the sum of Federal fund/private grant contributions for all reported employees. | Required |
Total Federal TRS-Care Contribution | The sum of Federal TRS-Care contributions for all reported employees. | 116-126 | 11 | 99999999999 | The valid value is the sum of Federal TRS-Care contributions for all reported employees. | |
Total RE Payment for New Member Contribution | The sum of reporting employer payments for new member contributions for all reported employees. | 127-137 | 11 | 99999999999 | The valid value is the sum of reporting employer payments for new member contributions for all reported employees. | Required |
Total Public Education Employer Contribution | The sum of reporting employer contributions for all reported employees. | 138-148 | 11 | 99999999999 | The valid value is the sum of reporting employer contributions for all reported employees. | Required |
Total State Minimum Compensation | The sum of state minimum compensation for all reported employees. Only applicable to Independent School Districts and Charter Schools. Field should be padded with zeroes for all other RE Types. | 149-159 | 11 | 99999999999 | The valid value is the sum of the state minimum compensation for all reported employees. | Required |
Total Statutory Minimum Contribution | The sum of statutory minimum contributions for all reported employees. Only applicable to Independent School Districts and Charter Schools. Field should be padded with zeroes for all other RE Types. | 160-170 | 11 | 99999999999 | The valid value is the sum of statutory minimum contributions for all reported employees. | Required |
Total TRS Eligible Compensation Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 171-171 | 1 | Not applicable | Valid values:
| Required |
Total TRS Eligible Compensation Adjustment | The net difference between the amount originally reported and the correct amount of eligible compensation for all reported employees. | 172-182 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of eligible compensation for all reported employees. | Required |
Total Performance Pay Gross Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 183-183 | 1 | Not applicable | Valid values:
| Required |
Total Performance Pay Gross Adjustment | The net difference between the amount originally reported and the correct amount of performance pay for all reported employees. | 184-194 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of performance pay for all reported employees. | Required |
Total Gross Compensation Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 195-195 | 1 | Not applicable | Valid values:
| Required |
Total Gross Compensation Adjustment | The net difference between the amount originally reported and the correct amount of total gross compensation for all reported employees. | 196-206 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of total gross compensation for all reported employees. | Required |
Total Member Contributions Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 207-207 | 1 | Not applicable | Valid values:
| Required |
Total Member Contributions Adjustment | The net difference between the amount originally reported and the correct amount of member contributions for all reported employees. | 208-218 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of member contributions for all reported employees. | Required |
Total Member TRS-Care Contributions Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 219-219 | 1 | Not applicable | Valid values:
| Required |
Total Member TRS-Care Contributions Adjustment | The net difference between the amount originally reported and the correct amount of member insurance contributions for all reported employees. | 220-230 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of member insurance contributions for all reported employees. | Required |
Total RE TRS-Care Contributions Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 231-231 | 1 | Not applicable | Valid values:
| Required |
Total RE TRS-Care Contributions Adjustment | The net difference between the amount originally reported and the correct amount of reporting employer TRS-Care contributions for all reported employees. | 232-242 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of reporting employer TRS-Care contributions for all reported employees. | Required |
Total Service Credit Purchase Deductions Adjustment | The net difference between the amount originally reported and the correct amount of service credit purchase deductions for all reported employees. | 243-253 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of service credit purchase deductions for all reported employees. | Required |
Total Eligible Compensation Paid from Federal Funds/Private Grants Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 254-254 | 1 | Not applicable | Valid values:
| Required |
Total Eligible Compensation Paid from Federal Funds/Private Grants Adjustment | The net difference between the amount originally reported and the correct amount of eligible compensation paid from Federal funds for all reported employees. | 255-265 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of eligible compensation paid from Federal funds for all reported employees. | Required |
Total Federal Fund/Private Grant Contributions Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 266-266 | 1 | Not applicable | Valid values:
| Required |
Total Federal Fund/Private Grant Contributions Adjustment | The net difference between the amount originally reported and the correct amount of Federal fund/private grant contributions for all reported employees. | 267-277 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of Federal fund/private grant contributions for all reported employees. | Required |
Total Federal TRS-Care Contribution Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 278-278 | 1 | Not applicable | Valid values:
| Required |
Total Federal TRS-Care Contribution Adjustment | The net difference between the amount originally reported and the correct amount of Federal TRS-Care contributions for all reported employees. | 279-289 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of Federal TRS-Care contributions for all reported employees. | Required |
Total RE Payment for New Member Contribution Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 290-290 | 1 | Not applicable | Valid values:
| Required |
Total RE Payment for New Member Contribution Adjustment | The net difference between the amount originally reported and the correct amount of reporting employer payments for new member contributions for all reported employees. | 291-301 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of reporting employer payments for new member contributions for all reported employees. | Required |
Total Public Education Employer Contribution Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 302-302 | 1 | Not applicable | Valid values:
| Required |
Total Public Education Employer Contribution Adjustment | The net difference between the amount originally reported and the correct amount of reporting employer contributions for all reported employees. | 303-313 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of reporting employer contributions for all reported employees. | Required |
Total State Minimum Compensation Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 314-314 | 1 | Not applicable | Valid values:
| Required |
Total State Minimum Compensation Adjustment | The net difference between the amount originally reported and the correct amount of state minimum compensation for all reported employees. Only applicable to Independent School Districts and Charter Schools. Field should be padded with zeroes for all other RE Types. | 315-325 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of state minimum compensation for all reported employees. | Required |
Total Statutory Minimum Contribution Adjustment Sign | Indicates whether the adjustment for this amount is a net negative or positive. | 326-326 | 1 | Not applicable | Valid values:
| Required |
Total Statutory Minimum Contribution Adjustment | The net difference between the amount originally reported and the correct amount of statutory minimum contributions for all reported employees. Only applicable to Independent School Districts and Charter Schools. Field should be padded with zeroes for all other RE Types. | 327-337 | 11 | 99999999999 | The valid value is the net difference between the amount originally reported and the correct amount of statutory minimum contributions for all reported employees. | Required |