Demographic Records - ED20 - 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 - ED20 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 ED20. | 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 - Demographic (ED20/ED25) 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 - Demographic (ED20/ED25) 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 - Demographic (ED20/ED25) 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 - Demographic (ED20/ED25) 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 - Demographic (ED20/ED25) 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 - Demographic (ED20/ED25) 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 - Demographic (ED20/ED25) page. | Optional |
Address Line 1 | The first line of the employee's street address. | 107-156 | 50 | Not applicable | Retrieved from the Address field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Required |
Address Line 2 | The second line of the employee's street address. | 157-206 | 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 | 207-256 | 50 | Not applicable | Not Applicable | Not Applicable |
City | The employee's city of residence. | 257-276 | 20 | Not applicable | Retrieved from the City field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Required |
State | The employee's state of residence. | 277-278 | 2 | Not applicable | Retrieved from the State field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Required |
ZIP5 | The employee's zip code. | 279-283 | 5 | 99999 | Retrieved from the Zip field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Required |
ZIP4 | The employee's zip code extension. | 284-287 | 4 | 9999 | Retrieved from the Zip field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
Province | The foreign province where the employee resides. | 288-307 | 20 | Not applicable | Retrieved from the Province field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
Country | The foreign country where the employee resides. | 308-311 | 4 | Not applicable | Retrieved from the Country field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
Postal Code | The foreign postal code for the employee's address. | 312-321 | 10 | Not applicable | Retrieved from the Foreign Postal Code field on the Address tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
Work Email Address | The employee's email address. | 322-421 | 100 | name@domain.com | Retrieved from the Email Address field on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |
Primary Phone Number | The employee's home phone number. | 422-431 | 10 | 9999999999 | Retrieved from the Home Phone field on the Member tab of the TX TEAM Report - Demographic (ED20/ED25) page. | Optional |