Demographic Records - ED25 - 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 - ED25 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 ED25. | Required |
Original Employee Identification Number | The employee's original 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 in the Previously Reported to TEAM section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Required |
Original Date of Birth | The employee's original date of birth. | 14-21 | 8 | MMDDYYYY | Retrieved from the Birth Date field in the Previously Reported to TEAM section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Required |
Original Gender Code | The employee's original gender. | 22-22 | 1 | Not applicable | Valid values:
Retrieved from the Gender field in the Previously Reported to TEAM section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Required |
Original Last Name | The employee's original last name. | 23-52 | 30 | Not applicable | Retrieved from the Last Name field in the Previously Reported to TEAM section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Required |
Original First Name | The employee's original first name. | 53-77 | 25 | Not applicable | Retrieved from the First Name field in the Previously Reported to TEAM section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
Original Middle Name | The employee's original middle name. | 78-102 | 25 | Not applicable | Retrieved from the Middle Name field in the Previously Reported to TEAM section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
Original Generation | The employee’s original name suffix. | 103-106 | 4 | Not applicable | Valid values:
Retrieved from the Suffix field in the Previously Reported to TEAM section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Employee Identification Number | The employee's new Social Security number or TRS member ID number. | 107-115 | 9 | SSN Format: 999999999 TRS Temporary ID format: XX9999999 | Retrieved from the Social Security/TRS ID field in the Current Data section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Date of Birth | The employee's new date of birth. | 116-123 | 8 | MMDDYYYY | Retrieved from the Birth Date field in the Current Data section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Gender Code | The employee's new gender. | 124-124 | 1 | Not applicable | Valid values:
Retrieved from the Gender field in the Current Data section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Last Name | The employee's new last name. | 125-154 | 30 | Not applicable | Retrieved from the Last Name field in the Current Data section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New First Name | The employee's new first name. | 155-179 | 25 | Not applicable | Retrieved from the First Name field in the Current Data section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Middle Name | The employee's new middle name. | 180-204 | 25 | Not applicable | Retrieved from the Middle Name field in the Current Data section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Generation | The employee’s new name suffix. | 205-208 | 4 | Not applicable | Valid values:
Retrieved from the Suffix field in the Current Data section on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Address Line 1 | The first line of the employee's street address. | 209-258 | 50 | Not applicable | Retrieved from the Address field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Address Line 2 | The second line of the employee's street address. | 259-308 | 50 | Not applicable | Retrieved from the Address field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
Not Used | Not Applicable | 309-358 | 50 | Not applicable | Not Applicable | Not Applicable |
New City | The employee's new city of residence. | 359-378 | 20 | Not applicable | Retrieved from the City field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New State | The employee's new state of residence. | 379-380 | 2 | Not applicable | Retrieved from the State field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New ZIP5 | The employee's new zip code. | 381-385 | 5 | 99999 | Retrieved from the Zip field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New ZIP4 | The employee's new zip code extension. | 386-389 | 4 | 9999 | Retrieved from the Zip field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Province | The new foreign province where the employee resides. | 390-409 | 20 | Not applicable | Retrieved from the Province field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Country | The new foreign country where the employee resides. | 410-413 | 4 | Not applicable | Retrieved from the Country field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Postal Code | The new foreign postal code for the employee's address. | 414-423 | 10 | Not applicable | Retrieved from the Foreign Postal Code field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Work Email Address | The employee's new email address. | 424-523 | 100 | name@domain.com | Retrieved from the Email Address field on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
New Primary Phone Number | The employee's new home phone number. | 524-533 | 10 | 9999999999 | Retrieved from the Home Phone field on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |