Demographic Records - ED90 - 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 Demographic Records - ED90 record.
Field Name | Description | Position | Length | Format | Data Source or Valid Values | Required or Optional |
|---|---|---|---|---|---|---|
Record Type Code | Indicates the type of demographic record. | 1-4 | 4 | Not applicable | The valid value is ED90. | 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 - Termination (ED90) 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 - Termination (ED90) 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 - Termination (ED90) 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 - Termination (ED90) 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 - Termination (ED90) 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 - Termination (ED90) 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 - Termination (ED90) page. | Optional |
Termination Date | The date of the employee's last workday. | 107-114 | 8 | MMDDYYYY | Retrieved from the Last Day Worked field on the Member tab of the TX TEAM Report - Termination (ED90) page. | Required |
Termination Reason Code | The reason for termination. | 115-115 | 1 | Not applicable | Valid values:
Retrieved from the Termination Code field on the Member tab of the TX TEAM Report - Termination (ED90) page. | Required |
Final Payroll Transaction Report Period | The employee's last day of work, as indicated on their final payroll. | 116-121 | 6 | MMDDYYYY | Retrieved from the Final Payroll Date field on the Member tab of the TX TEAM Report - Termination (ED90) page. | Optional |
Annualized Eligible TRS Compensation | The annualized, eligible TRS compensation. | 122-130 | 9 | 999999999 | Retrieved from the TRS Compensation field on the Member tab of the TX TEAM Report - Termination (ED90) page. | Required |