Regular Payroll Records - RP20 - 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 - RP20 record.
Field Name | Description | Position | Length | Format | Data Source or Valid Values | Required or Optional |
|---|---|---|---|---|---|---|
Record Type Code | Indicates the type of regular payroll record. | 1-4 | 4 | Not applicable | The valid value is RP20. | Required |
Employee Identification Number | The employee's Social Security number or TRS member ID number. | 5-13 | 9 | SSN Format: 999999999 TRS Temporary ID format: XX9999999 | Retrieved from the Social Security/TRS ID field on the Member tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Date of Birth | The employee's date of birth. | 14-21 | 8 | MMDDYYYY | Retrieved from the Birth Date field on the Member tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Gender Code | The employee's gender. | 22-22 | 1 | Not applicable | Valid values:
Retrieved from the Gender field on the Member tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Last Name | The employee's last name. | 23-52 | 30 | Not applicable | Retrieved from the Last Name field on the Member tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
First Name | The employee's first name. | 53-77 | 25 | Not applicable | Retrieved from the First Name field on the Member tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Optional |
Middle Name | The employee's middle name. | 78-102 | 25 | Not applicable | Retrieved from the Middle Name field on the Member tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Optional |
Generation | The 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 - Payroll (RP20/RP25) page. | Optional |
Position Code | The employee's TRS position code. | 107-108 | 2 | Not applicable | Valid values:
Retrieved from the TRS Position Code field in the General section of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Hours Worked | The actual number of hours worked by the employee. | 109-111 | 3 | 999 | Retrieved from the Hours Worked field on the Employee Time tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Hours Scheduled | The number of hours the employee is scheduled to work in a week. | 112-113 | 2 | 99 | Retrieved from the Hours Scheduled field on the Employee Time tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Days Worked | The actual number of days worked by the employee. Includes paid leave. | 114-115 | 2 | 99 | Retrieved from the Days Worked field on the Employee Time tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Zero Days Reason Code | The reason for the value 0 in the Days Worked field. | 116-116 | 1 | Not applicable | Valid values:
Retrieved from the Zero Days Reason Code field on the Employee Time tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Eligible TRS Gross Compensation | The employee's regular TRS-eligible compensation. | 117-125 | 9 | 999999999 | Retrieved from the Eligible TRS Gross field on the Employee Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Performance Pay Gross | The amount for the employee's pay performance. | 126-134 | 9 | 999999999 | Retrieved from the Performance Pay Gross field on the Employee Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Optional |
Total Gross Compensation | The employee's total gross compensation. | 135-143 | 9 | 999999999 | Retrieved from the Total Gross field on the Employee Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Member Contribution | The employee's member contribution amount. | 144-152 | 9 | 999999999 | Retrieved from the Member Contribution field on the Employee Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Member TRS-Care Contribution | The amount of the employee's member contribution to TRS-Care. | 153-161 | 9 | 999999999 | Retrieved from the Member TRS-Care Contribution field on the Employee Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
RE TRS-Care Contribution | The reporting entity's contribution to TRS-Care. | 162-170 | 9 | 999999999 | Retrieved from the RE TRS-Care Contribution field on the Employer Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Required |
Service Credit Purchase Deduction | The employee's purchasing credit deduction amount. | 171-179 | 9 | 999999999 | Retrieved from the Service Credit Purchase Deduction field on the Employee Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Optional |
Service Credit Tax Shelter Flag | Indicates the type of payroll deduction for service credit. | 180-180 | 1 | Not applicable | Valid values:
Retrieved from the Service Credit Tax Shelter Flag field on the Employee Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Optional |
Eligible Compensation Paid from Federal Funds/Private Grants | The amount of eligible compensation for the reporting period, if any, paid from Federal funds or private grants. | 161-189 | 9 | 999999999 | Not applicable | Optional |
Federal Fund/Private Grant Contribution | The state's contribution for compensation paid from federal funds or private grants. | 190-198 | 9 | 999999999 | Retrieved from the Federal Contribution field on the Employer Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Optional |
Federal TRS-Care Contribution | The state's TRS-Care contribution for compensation paid from federal funds or private grants. | 199-207 | 9 | 999999999 | Retrieved from the Federal TRS-Care Contribution field on the Employer Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Optional |
RE Payment for New Member Contribution | The state's new TRS member contribution for compensation paid during the first ninety days. | 208-216 | 9 | 999999999 | Retrieved from the New Member Contribution field on the Employer Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Optional |
RE Public Education Employer Contribution | The reporting entity's contribution for Non-OASDI (Old Age, Survivors, and Disability Insurance) member compensation. | 217-225 | 9 | 999999999 | Retrieved from the Non-OASDI Member Contribution field on the Employer Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Optional |
State Minimum Compensation | The current adjusted state minimum compensation. | 226-234 | 9 | 999999999 | Retrieved from the Adjusted State Minimum Compensation field on the Employer Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Optional |
Statutory Minimum Contribution | The state's contribution on compensation paid above the adjusted state minimum. | 235-243 | 9 | 999999999 | Retrieved from the Statutory Minimum Contribution field on the Employer Share tab of the TX TEAM Report - Payroll (RP20/RP25) page. | Optional |